Name

1-Start Here

1. Getting Set Up

2. Identifying Your True Competitors

3. Creating a Master List of Everything Your Competition Ranks For

4. Planning Your Marketing Funnel Around Easy-To-Rank-For Keywords

5. Creating an Expert-Level Content Strategy

6. Estimating ROI in SEO and Content Marketing

BONUS- Find the Keywords Your Competitors Share (that you're missing out on)

How to Get Help & Make Requests.png

SEO Keyword Research Course Intro.mp4

1.1 Installing Our Google Sheets Template.mp4

1.2 A Note on Trials.mp4

1.3 Ahrefs Keyword Research Overview.mp4

PUBLIC - SEO Keyword Research Blank Template.xlsx

2.1 Ask Your Client Directly using these questions.mp4

2.2 Use Sparktoro to Find Sites Your Audience Trusts.mp4

2.3 Use Ahrefs to Find Competing Domains.mp4

3.1 Exporting Relevant SEO Data Per Each Competitor.mp4

3.2 Adding the Data to Google Sheets Removing Duplicates and Organizing.mp4

3.3 Stylizing Formatting and Making the Data Readable.mp4

3.4 How to Interpret The Master List and put it to good use.mp4

4.1 Importing Your Master List Into Ahrefs to Make it Filterable.mp4

4.2 Applying Informational Intent Filters and Exporting Back Into Google Sheets.mp4

4.3 Applying Commercial Intent Filters and Exporting Back Into Google Sheets.mp4

4.4 Organizing the Data and Making Each Tab Readable.mp4

hwyh-funnel-image(1).jpg

How to Plan a Topic Cluster Using Your Completed Spreadsheet.mp4

TopicClusters-03.png

What Topic Clusters Are and Why They're Important for Growing Your Traffic.png

Using the ROI Calculator.mp4

How to Do A Content Gap Analysis.mp4