Justin Borge – TURNING SEARCHES INTO TRAFFIC

Description

TURNING SEARCHES INTO TRAFFIC

A course on Keyword Research and Content Strategy. Take our process and use it for yourself, use it for your business and your clients.

CONTENTS

Start Here 👋

Intro to Course
2 mins

How to Get Help & Make Requests

1. Getting Set Up 🚩

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.

Exporting (Relevant) SEO Data Per Each Competitor
8 mins

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
7 mins

Organizing the Data and Making Each Tab Readable
10 mins

5. Creating an Expert-Level Content Strategy 🧙***Marked As Spam***♂️

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.

Justin Borge – TURNING SEARCHES INTO TRAFFIC

• 1-Start Here

  • How to Get Help & Make Requests.png
  • SEO Keyword Research Course Intro.mp4

• 1. Getting Set Up

  • 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. Identifying Your True Competitors

  • 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. Creating a Master List of Everything Your Competition Ranks For

  • 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. Planning Your Marketing Funnel Around Easy-To-Rank-For Keywords

  • 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

• 5. Creating an Expert-Level Content Strategy

  • 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

• 6. Estimating ROI in SEO and Content Marketing

  • Using the ROI Calculator.mp4

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

  • How to Do A Content Gap Analysis.mp4

Sales Page: _https://academy.helpwithyourhustle.com/turning-searches-into-traffic-a-course-on-keyword-research-and-content-strategy