$499.00Original price was: $499.00.$29.00Current price is: $29.00.
(This course is available and delivery within one day!)We walk you through setting up the exact template we use for our paying clients, then give you a tour of how to use Ahrefs, the main tool we’ll be focusing on throughout the rest of the course.
We walk you through setting up the exact template we use for our paying clients, then give you a tour of how to use Ahrefs, the main tool we’ll be focusing on throughout the rest of the course.
Installing Our Google Sheets Template
•1 min
A Note on Free Trials
•2 mins
Ahrefs Keyword Research Overview
•13 mins
2. Identifying Your True Competitors
The first step in completing your spreadsheet is to identify the *right* competitors to analyze. We never skip these three methods.
Ask Your Client Directly (using these questions)
•6 mins
Use Sparktoro to Find Sites Your Audience Trusts
•3 mins
Use Ahrefs to Find Competing Domains
•2 mins
3. Creating a Master List of Everything Your Competition Ranks For
Once you’ve identified the right competitors to analyze, it’s time to export all their SEO data into an organized, searchable Master List. Find a term you want to rank for? Use the Master List to open the exact page on your competitors site to take notes on what you can do better.
Adding the Data to Google Sheets, Removing Duplicates and Organizing
•10 mins
Stylizing, Formatting, and Making the Data Readable
•6 mins
How to Interpret The Master List (and put it to good use)
•6 mins
4. Planning Your Marketing Funnel Around Easy-To-Rank-For Keywords
Reviewing the structure of a Marketing Funnel, then walking through the process of organizing each phase of yours based around traffic-driving keyword opportunities.
Importing Your Master List Into Ahrefs to Make it Filterable
•5 mins
Resource: Save this Funnel Image
•94.2 KB
Applying Informational Intent Filters and Exporting Back Into Google Sheets
•8 mins
Applying Commercial Intent Filters and Exporting Back Into Google Sheets
It’s one thing to come up with a bunch of data. It’s another thing to actually be confident interpreting said data, then knowing exactly how to put it to good use.
What Topic Clusters Are and Why They’re Important for Growing Your Traffic
How to Plan a Topic Cluster Using Your Completed Spreadsheet
•13 mins
6. Estimating ROI in SEO and Content Marketing
Forecasting ROI is often an abstract hurdle for SEO pros, while managing expectations is crucial for avoiding disappointed clients. Everyone needs to be on the same page about how long it might take to see substantial results and how those results can reasonably be forecasted (to justify the up-front investment).
In this section you’ll learn how we go about projecting future traffic, and most importantly, future earnings for the businesses we consult for. Be conservative in your estimates, demonstrate you know what you’re doing and leave room for them to be surprised by your successes down the road. It’s always better to under-promise and over-deliver than vice versa.
Using the ROI Calculator
•6 mins
BONUS: Find the Keywords Your Competitors Share (that you’re missing out on)
The Ahrefs Content Gap tool allows you to analyze and compare multiple websites against one another. The tool can show you (quite granularly) which keywords that Site A, Site, B, and Site C all share with one another that Site D…does not. You can also filter the keywords you discover by volume, difficulty, and cost per click.
It doesn’t take long to do if you know what you’re doing, but this kind of information can be extremely valuable to a business, and we know from first-hand experience that they’re willing to pay for it. (We charge $299 per report. Wouldn’t be surprised if we could charge more, but we feel guilty because it doesn’t take us very long to actually do).
Reviews
There are no reviews yet.