Posts By: Tori Cushing

How to Format Your ‘Now Provided’ Report – Part 1 [VIDEO]

format-now-provided-feature-2

Many of you have tried out of new Now Provided report. If you haven’t the Now Provided report pulls together AuthorityLabs ranking data, Google Analytics data, and a few other data points to show you how many pages are receiving organic traffic and a list of the keywords that those pages rank for. Now the million… Read more »

Site Audit: Indexing Tips & Tricks with Screaming Frog [VIDEO]

Site Audit: Indexing Tips & Tricks with Screaming Frog [VIDEO]

Knowing how to do a site audit is an extremely useful tool for any marketer. But if you’re like me, intimidation can creep in big time while starting these audits. I’m here to help with that! I pulled several key points from Annielytics’ Site Audit Checklist and from Jeremy Rivera’s Simple DIY Site Audit post. Thank you for the inspiration,… Read more »

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 »