Posts By: Tori Cushing

Analyzing Page Titles with Screaming Frog [VIDEO]

Analyzing Page Titles with Screaming Frog [VIDEO]

I’m sure many of you have read Brian LaFrance’s latest post on how Google looks at your page titles. If you haven’t checked it out yet. Do ett! In this tutorial, I will show you how to take your page titles and give them a make over! Screaming Frog is an incredible tool to do… Read more »

Google Analytics & Screaming Frog – How to Series – Part 2

Google Analytics & Screaming Frog – How to Series – Part 2

At the end of this tuTORIal you will know how to export Screaming Frog data, Google Analytics data, and then bring them together based on whichever value you choose. I will be covering: VLOOKUPs Basic Formatting Conditional Formatting Find and Replace tool Navigating in Google Analytics Navigating in Screaming Frog Check out part 1 of… Read more »

How to Use Screaming Frog with Excel

How to Use Screaming Frog with Excel

If you haven’t used Screaming Frog, you are missing out. Screaming Frog is a tool that scrapes your site and identifies common SEO issues. It then presents them in a way that is easy to export and edit in Excel. I know, my dream tool. You can get started with Screaming Frog for free! Or you… Read more »

Excel 105: PivotCharts Tutorial [Video]

Excel 105: PivotCharts [Video]

In my last post I discussed creating Pivot Tables on Mac and PC. Today we will take the next step in Excel,  PivotCharts! Ironically, I find that charts are much easier to work with. But, only if the PivotTable is set up correctly to start with. So, if you missed the creating pivot tables post… Read more »

Excel Tool to Automatically Format Your CSV Export

Excel Tool to Automatically Format Your CSV Export

Have you exported a csv from AuthorityLabs and looked at it like, “What now?”. Don’t worry, every marketer has had this moment before. That’s where we come in! Now all you have to do is copy and paste the data you want to format into the template and run the macro we developed. What are… Read more »

Excel 104: Pivot Tables on Mac and PC [Video]

Excel 104: Pivot Tables on Mac and PC [Video]

My first impression of a Pivot Table: They are scary, confusing monsters that always make your data look funky. Once I got over the intimidation of them: They are the magical, unicorn warriors of the Excel world. The main thing that Pivot Tables do is … pivot … your data. Just like you would while trying to… Read more »