Skip to content

The advanced SEO formula that helped me rank for 477,000 keywords

--Advertisements --

 Seo neil Patel

Can you guess how many keywords I am classifying?

Well, you will probably say 477,000 because I used this number in the title of this article. ?

And that's right, look at the screen capture of Ahrefs. It shows the number of keywords for which I rank.

 ahrefs tags

 ahrefs keywords

-- Advertisements --

But what's crazy is that I'm in a super-competitive niche … Digital Marketing .

So, you wonder how I did it?

Well, it starts with a good search for keywords.

Seeing most traders start their keyword search with tools like SEMrush or Ubersuggest and they type in a keyword like "SEO". You then get a list with hundreds of keyword suggestions with cost-per-click and competition data.

 ubersuggest seo

 Sewing up seo

-- Advertisements --

And once you have a list of keywords that you like, you probably do what most marketers do, such as inserting them into your website or creating content around keywords.

Does this process seem familiar to you?

Well, of course, because that's what everyone has learned to do.

But what is wrong with that?

This process is like gambling … there is no guarantee that you will rank for these new keywords. And even worse, these keywords may not generate leads, sales, or revenue.

But fortunately I have a process for you that will not only help you rank thousands of keywords, but also make sure that this new traffic turns into leads, sales, and other revenue.

-- Advertisements --

Here is the 5-step process that helped me rank 477,000 keywords.

Step 1: Focus on pages that generate income

Going after the right keywords will not guarantee you success.

If you classify a page that does not convert properly, you will get more traffic, but your earnings will not increase.

Of course, you can focus on optimizing the conversion rate and trying to fix it over time, but it's better to drive traffic to the pages that are already generating revenue.

If you have not set up goal tracking, watch the video below as it will teach you how.


-- Advertisements --

Assuming you have defined it correctly, look for the pages that generate your income.

 google conversions

 google conversion

You can see from the image above, I've sorted the results by conversions.

You now have a list of pages you can focus on. But it is not as easy as choosing the first page and starting from it.

For example, your homepage might be an "extract" page, which, of course, will not help if you put it above.

-- Advertisements --

Instead, you should focus on:

  • product pages
  • Service pages
  • Content pages

Once you have a final list of pages, you must take these URLs and search them in your Google Search Console.

Step # 2: Sign in to the Google Search Console.

Once in Google Search Console, you will need to click on "Traffic Search> Search Analysis".

This will lead you to a report that looks like this.

 first pages

 main pages

-- Advertisements --

You will then want to click on the "Pages" option to sort the results in order of priority.

At this point, you will need to browse your list of pages and find them in Google Search Console.

Once you have found one of the pages, click on the URL then select "Queries" at the top.

This will give you an overview of the specific terms that drive traffic to your high conversion pages.

 Keywords page

 Keywords page

-- Advertisements --

Now, upload the data in CSV format and open it with Excel.

Once you load it, it should look like this.



I want you to sort data by impressions first. Search for keywords that generate the highest number of impressions because these keywords can generate the most traffic.

If you think these keywords are relevant to your product or service you offer, be sure to include them in the title tag of your website.

-- Advertisements --

You will not be able to add any keywords to your title tag because it is limited to about 60 characters, but the addition of some of the most popular terms will ensure that you will get rates of higher clicks. , which will increase your overall search rank.

See also  Facebook Local is your social network on Yelp, Foursquare

Once you have adjusted your title tag, let's do the same with your meta description.

Meta descriptions can be longer these days. Google agrees with about 300 characters. So, do not hesitate to sprinkle a few more words, but make sure your meta description still flows in a readable sentence.

And before going back to the Excel sheet, let's develop your content by adding some of the keywords that you will not rank at the top of page 1 but who should.

You can do this by adding more content to your page, or if you can insert the keywords without inserting them (make sure your content circulates and provides value).

Let's go back to Excel now. You should see a filter icon that looks like this:

-- Advertisements --

 excellent filter

 excellent filter

Select column E, as this will select all keywords based on their rank. Then click on the "sort & filter" button, then select "filter".

You will see a table that appears. Deselect numbers of 1, 2 or 3.

You must also deselect any number of 11 or more. This will show you all the keywords listed on page 1 that are not in position 1, 2 or 3.

 Result of the filter of Excel

-- Advertisements --

 Result of the filter of Excel

These are the keywords that have the most potential since the top 3 positions generate respectively 20.5%, 13.32% and 13.14% of clicks. You want to be in the top three places because that's where the majority of clicks occur.

By having a list of keywords that are in position 4, 5, 6, 7, 8, 9 and 10 … you can now focus on moving them.

You've already done the hard part that's happening on page 1. You do not need much more work to reach the top 3 places (at least for most keywords).

You must take all relevant keywords for your page and see if you can merge them into your content or your headers without ruining the user's experience.

This may mean that you will have to rewrite your content and double it.

-- Advertisements --

Or if you have a product or service page that you are trying to rank higher, this may mean that you can not include all the keywords as this will ruin the user experience and will hurt your conversion rate include a few more).

Over time, you will find that your rankings will climb slowly for keywords that will yield more revenue.

Step # 3: Add to in Similar Tags

Do you know what I like at Google? They are really generous when it comes to giving marketing data. From Google Analytics to Google Search Console … Google has incredible tools!

Another product that I like (technically it's more a feature) is that Google shows you all the keywords in relation to those for which you are already ranking.

This is going to be a manual grind, but it's worth it.

Sign in to the Google Search Console and see the top 10 keywords for which you are ranking. You can get this data by clicking on "Traffic Search> Google Analytics Search".

-- Advertisements --

 analyze the traffic

 search analyze the traffic

Make sure you exclude all terms associated with the brand and compile a list of your 10 most important terms.

Now go to Google, type each of these keywords manually and scroll down to where it says "keywords related keywords".

 associated Keywords

 Associated Keywords

-- Advertisements --

Google gives you a list of other popular terms that people type. What is beautiful in this list is that these keywords are already related to the one for which you are ranking and that they are usually much easier to rank.

So, for, I'm already ranked for the term "SEO".

So, Google tells me that in addition to the word "SEO", people are also looking for:

  • What is seo and how does it work
  • Definition of seo

  • What is seo marketing
  • how to make seo
  • seo wiki
  • seo google
  • seo tutorial
  • company seo
See also  The United States Supreme Court states that police need a guarantee to access the location of the cell phone

As you can see, I've already incorporated some of these phrases to the page of my site that is already positioning itself for SEO.

You should do the same thing. This is an easy way to rank the most relevant keywords, increase your traffic and possibly your revenue.

-- Advertisements --

If you do this for your 10 most important keywords, you will have an additional list of 80 keywords (8 keywords per term).

And by incorporating these terms into your site (only when it makes sense, do not spam) you will be quickly ranked on page 1 for dozens of other terms.

If you want to go crazy like me, you can do it for 1000 terms, which will give you suggestions for 80 000 additional keywords!

But again, do not force and ruin your user experience. This will hurt your conversion rate. You only need to add keywords when they are natural and have meaning to the user.

And with a bit of luck, you've selected keywords in the pages that generate your income (do not forget step 1!). The last thing you want is to spend time to increase your rankings and find that your income will not increase.

Step # 4: Go After the Fruit at Hand

Have you noticed that there is a huge difference in traffic between the pages of your site that rank on page 2 compared to the content ranking on page 1?

-- Advertisements --

Like most marketers, you probably do not notice it because your pages that rank on page 2 of Google do not get a lot of traffic … which makes you forget .

It's sad but true.

So, let's fix it!

Log in to SEMrush, type in your domain name and click on "Organic Research> Positions".

 post of semrush

 post of semrush

-- Advertisements --

You will want to search for all the terms for which you are numbered 11 or 12.

You can do this using the filter setting (just copy the settings in the screen capture below).

 semrush filters

 semrush filters

You will have a list of keywords that are almost on the first page.

Now, make sure these keywords point to the pages that are responsible for your sales, leads, and earnings (go back to step 1 if you do not know how).

-- Advertisements --

 Keywords of semrush

 Keywords of semrush

For keywords that do not generate sales or leads, you can ignore them at this time.

For any of those that point to pages that generate sales or leads, perform a Google search for each of these keywords.

Now compile a list of web pages that rank above you.

Take these URLs and plug them into Ahrefs. Once you have plugged in each URL, click on "Backlinks" in the left navigation bar.

-- Advertisements --

This will show you a list of sites related to your competition.

 links of ahrefs

 ahrefs links

I want you to contact each of these sites and ask for a link. Here is an e-mail template that you can use (you will need to modify it to fit your site).

Hi [Insert website owners name]

I noticed that you are linking to [insert competing web page] since [insert the URL of on their website linking to the competition]. Did you know that the page you are linking to is not the best resource for readers of your website?

-- Advertisements --

He is missing [insert multiple points on what that competing page lacks].

If you want to provide an even better experience to the readers of your website, you should consider linking to [insert your URL that you want to rank higher] as it did [194591003].

To yours,

[Insert your name]

You will find that after emailing hundreds of sites of which only 3% to 5% will link you, assuming that your page is comparable to the competition.

If you can not get at least 3% to go back, it means that you have not done a good job by changing the email template or that your page is zero compared to your competitors. ?

-- Advertisements --

I know it's a tedious job, but it's a great way to increase your traffic.

Think of this statistic when you make the link … 91% of searches never go to page 2. Or as my sales team says, page 2 is the perfect place to bury a corpse .

Step # 5: Attract the buyers before they are ready to buy

Another reason why I love Google, is that they have this neat tool called Google Correlate.

 google correlate

 google correlate

What Google Correlate shows you is search templates. In other words, they show you what your customers are typing in weeks or even months before they become customers.

-- Advertisements --

And if you want to sell your users, you can use Google Correlate to see what your customers have entered weeks or months after they've become customers.

This will help you determine the products or services to offer assuming you want income from upselling.

Here's how it works … say you sell beard oil . You type "beard oil" in Google Correlate and you can see what people are typing before they become customers.

 Beard oil less 3

 Beard oil less 3

As you can see some of the keywords that people type are …

-- Advertisements --
  • Beard oil
  • Beard oils
  • Flannel outfits
  • trek farley
  • culture pullover
  • beard products
  • Best Beard Oil
  • crop top pullover
  • acne studios
  • What is the beard

For the results, I selected "-3" weeks.

I'm looking at what people typed 3 weeks before looking in bearded oil. That's why I put a "-" sign before the number 3 to see what they typed before looking for my main keyword.

If you want to attract more customers and retain those who might be interested in beard-based products, I would create content around the best outfits with beard oil or flannel that go well with the beard.

That's what I got from Google Correlate data.

And if I wanted to know what products to create in order to induce my customers to beard oil, I would do the same search on Google Correlate but I would use a positive number such as "2 weeks".

 Beard Oil

-- Advertisements --

 Beard Oil

From the above data, I would consider offering balm to the beard as an upsell because there seems to be a strong correlation.

The cool part about Google Correlate is that you can do it for any keyword and sort the results by the country you are targeting.


I know that my keyword research method is pain in lacrosse, but it works.

Think of it this way …

It is difficult to create content on new topics because there is no guarantee that a new page of your website will rank for competitive terms.

-- Advertisements --

But if you take web pages that already have traction and you improve them using the techniques I've described above, that's a guaranteed way to generate more traffic from research.

Now, if you want to create content focused on new keywords, you should do it!

I'm not saying that creating new content is a bad idea … devil, I do it all the time .

But consider creating new content after modifying your existing pages that are already generating your traffic and sales.

And when you leave after new terms, do not forget to use Google Correlate as this will help you get the right kind of traffic (and your competition will not do it).

So what do you think of my search for keywords and my SEO process that I used to rank thousands of keywords?

-- Advertisements --