The Advanced SEO Formula That Helped Me RANK IN SERACH ENGINES FOR 477,000 Keywords

David Linder

David Linder

MSc in Marketing from the University of Salford. Facebook Certified Planning Professional Facebook Certified Buying Professional
11 min read

seo neil patel

Can you guess just how many keywords I rank in serach engines for?

Well, you’re probably going to state 477,000 because I used that number in the title of the post. 😉

And it’s true, just consider the screenshot from Ahrefs. It shows the amount of keywords I rank in serach engines for.

ahrefs keywords

But what’s crazy is that I’m in a brilliant competitive niche… digital marketing.

So, are you currently wondering how I did so it?

Well, it starts with proper key word research.

See most marketers start their key word research with tools like SEMrush or Ubersuggest plus they enter a keyword like “SEO”. Afterward you get yourself a list back with a huge selection of keyword suggestions with cost per click and competition data.

ubersuggest seo

And when you have a listing of keywords you prefer, you almost certainly do what most marketers do, that is to start out inserting them into your site or creating content round the keywords.

Does this technique problem?

Well, needless to say, it can because that’s what everyone has been teaching one to do.

But what’s wrong with this particular?

This process is similar to gambling… there’s no guarantee that you’ll rank in serach engines for these new keywords. And also worse, those keywords might not generate you any leads, sales, or revenue.

But thankfully, I’ve a process for you personally that won’t only assist you to rank for a large number of keywords, nonetheless it will also make sure that this new-found traffic converts into leads, sales, and much more revenue.

Here’s the 5-step process that helped me rank in serach engines for 477,000 keywords.

Step #1: Concentrate on the pages that drive revenue

Going following the right keywords won’t guarantee you success.

If you rank a full page that isn’t converting well, you’ll have more traffic, however your revenue won’t rise.

Sure, it is possible to eventually concentrate on conversion rate optimization and make an effort to fix that as time passes, nevertheless, you are better off driving traffic to pages which are already generating you revenue.

If you haven’t setup goal tracking, watch the video below since it will educate you on how.

Assuming you set it correctly, let’s search for the pages which are driving your revenue.

google conversions

You can easily see from the image above, I sorted the outcomes by conversions.

You will have a listing of pages to spotlight. Nonetheless it isn’t as easy as just picking the very best page and going from there.

For example, your top page is actually a “check out” page, which, needless to say, won’t do worthwhile in the event that you rank it higher.

Instead, you need to concentrate on:

  • Product pages
  • Service pages
  • Content pages

Once you’ve got a final set of pages, you’ll desire to take those URLs and appearance them up in your Google Search Console.

Step #2: Log into Google Search Console

Once you’re in Google Search Console, you’ll desire to select, “Search Traffic > Search Analysis”.

This will cause you to a written report that looks something similar to this.

top pages

You’ll then desire to go through the “Pages” option since it will sort the outcomes by top pages.

At this aspect, you’ll need to proceed through your set of pages and discover them within Google Search Console.

Once you discover among the pages, go through the URL and select “Queries” at the very top.

This will provide you with a synopsis of the precise terms that generate traffic to your high converting pages.

page keywords

Now let’s download the info in CSV format and open it with Excel.

Once you load it up, it will look something similar to this.


I want one to first sort the info by impressions. Search for the keywords which are generating the best impression count as those keywords have the potential to operate a vehicle probably the most traffic.

If you are feeling those keywords are highly relevant to your service or product that you will be offering, be sure you include them within the title tag of one’s website.

You won’t have the ability to add all the keywords to your title tag because it is bound to roughly 60 characters, but adding some of the hottest terms will make sure that you are likely to get higher click-through rates, that may increase your overall search engine rankings.

Once you’ve adjusted your title tag, let’s do exactly the same together with your meta description.

Meta descriptions could be longer nowadays. Google is ok with roughly 300 characters. So, feel absolve to sprinkle in some more keywords, but ensure that your meta description still flows in a readable sentence.

And before we make contact with the Excel sheet, let’s expand your articles by adding in a few of the keywords you don’t rank high through to page 1 but should.

You can perform this with the addition of more content to your page, or when you can insert the keywords without “stuffing” them in (just ensure that your content flows and value).

Now let’s return to Excel. You need to visit a filter icon that looks something similar to this:

excel filter

Select column E, as this can select all the keywords predicated on their rankings. Then go through the “sort & filter button” and select “filter”.

You’ll visit a table that arises. Unselect any numbers which are 1, 2, or 3.

You’ll also desire to unselect a range that’s 11 or greater. This can show you all the keywords ranking on page 1 that aren’t constantly in place 1, two or three 3.

excel filter results

These will be the keywords which have probably the most potential as the top 3 positions generate 20.5%, 13.32%, and 13.14% of the clicks respectfully. You intend to be in the very best 3 spots as that’s where a lot of the clicks are happening.

By, having a summary of keywords which are constantly in place 4, 5, 6, 7, 8, 9 and 10… now you can concentrate on moving them up.

You’ve already done the hardest part that is getting on page 1. It’s not that a lot more work to find yourself in the very best 3 spots (at the very least for some keywords).

You’ll desire to take all the keywords which are highly relevant to your page and see when you can blend them into your articles or headings without ruining an individual experience.

This may imply that you’ll need to re-write your articles and ensure it is double the distance.

Or for those who have something or service page you are attempting to rank higher, it could imply that you can’t include all the keywords since it will ruin an individual experience and hurt your conversion rate (nevertheless, you can probably add a few more).

Over time you’ll discover that your ratings will slowly climb for keywords which will generate more revenue.

Step #3: Add related keywords

You know what’s a very important factor I really like about Google? They’re really generous with regards to giving marketers data. From Google Analytics to Google Search Console… Google has some amazing tools!

Another product I really like (technically it’s more of an attribute) is that Google teaches you all the related keywords to the people you’re already ranking for.

This will probably be a manual grind, but it’s worthwhile.

Log into Google Search Console and appearance at the very top 10 keywords that you rank in serach engines for. You will get this data by simply clicking “Search Traffic > Search Analytics”.

search traffic analytics

Make sure you exclude any branded terms and compile a listing of your top 10 terms.

Now head to Google, enter each one of these keywords manually and scroll to underneath where it says, “related keywords”.

related keywords

Google offers you a listing of other popular terms that folks are typing. What’s beautiful concerning this list, is these keywords already are related to the main one you’re ranking for plus they are typically easier to rank in serach engines for.

So, for, I already rank in serach engines for the word “SEO.”

So Google is telling me that as well as the word “SEO,” folks are also looking for:

  • what is seo and how it works
  • seo definition
  • what is seo marketing
  • how to accomplish seo
  • seo wiki
  • seo google
  • seo tutorial
  • seo company

As you can observe I already integrated some of these phrases to the page on my website that already ranks for SEO.

You must do exactly the same. It’s a good way to rank in serach engines for more relevant keywords, increase your traffic, and, eventually, your revenue.

If you do that for your top 10 keywords, you’ll have yet another set of 80 keywords (8 keywords per term).

And by integrating these terms into your website (only once it seems sensible, don’t spam) you’ll quickly rank on page 1 for a large number of other terms.

If you would like to go crazy like me, you can certainly do this for 1,000 terms, that will then offer you suggestions for yet another 80,000 keywords!

But again, don’t force it and ruin your user experience. This can hurt your conversion rate. You need to only add keywords when it’s natural and is practical for an individual.

And hopefully, you selected keywords from pages which are driving your revenue (remember Step one 1!). The final thing you need is to spending some time upping your rankings and discover your revenue isn’t increasing.

Step #4: Follow the low-hanging fruit

Have you pointed out that there exists a massive difference in traffic between your pages on your own site that rank on page 2 when compared to content ranking on page 1?

Like most marketers, you almost certainly don’t see it because your pages that rank on page 2 of Google don’t get much traffic… which makes you just forget about them.

It’s sad but true.

So, let’s fix this!

Log into SEMrush, enter your domain name, and select “Organic Research > Positions”.

semrush position

You’ll desire to look for all the terms that you rank number 11 or 12 for.

You can perform this utilizing the filter setting (just copy the settings in the screenshot below).

semrush filters

You’ll have a summary of keywords which are almost on page one.

Now just make certain those keywords are pointing to pages which are in charge of driving your sales, leads, and revenue (get back to step one 1 in the event that you don’t learn how to do that).

semrush keywords

For the keywords that aren’t driving sales or leads, it is possible to ignore them for the present time.

For one the people pointing to pages which are driving sales or leads, perform Google seek out all of those keywords.

Now compile a listing of web pages which are ranking above you.

Take those URLs and plug them into Ahrefs. As soon as you plug in each URL, select “Backlinks” in the left navigation bar.

This will highlight a listing of sites linking to your rivals.

ahrefs links

I want one to speak to each of the websites and beg for a web link. Here’s a contact template you may use (you’ll need to modify it to suit your site).

Hey [Insert site owners name],

I pointed out that you’re linking to [insert competing web page] from [insert the URL of on the website linking to the competition]. Did you know the page you’re linking to isn’t the very best resource for the website readers?

It’s missing [insert multiple points on which that competing page lacks].

If you need to provide an better still experience for the website readers, you should look at linking to [insert your URL you want to rank higher] since it has [insert why your online page much better than the competition].


[Insert your name]

You’ll discover that after emailing a huge selection of sites that only 3% to 5% will link back assuming your page is related to your competition.

If you can’t reach least 3% to link back this means that you either didn’t execute a good job modifying the e-mail template or your page sucks in comparison to your rivals. 🙁

I know that is tedious work, but it’s the best way to increase your traffic.

Just look at this stat when doing the hyperlink outreach… 91% of searches never head to page 2. Or as my sales force says, page 2 may be the perfect spot to bury a dead body.

Step #5: Attract buyers before they’re prepared to buy

Another reason I really like Google is they have this neat tool called Google Correlate.

google correlate

What Google Correlate does is teaches you search patterns. Put simply, they demonstrate what your visitors are typing in weeks as well as months before they become customers.

And in order to upsell your users, you may use Google Correlate to see what your visitors enter weeks or months once they turn into a customer.

This can help you determine what services or products to provide assuming you need that upsell revenue.

Here’s how it works… let’s say you’re selling beard oil. You enter “beard oil” into Google Correlate and you will see what folks are typing in before they become customers.

beard oil minus 3

As you can view a few of the keywords folks are typing in are…

  • beard oil
  • beard oils
  • flannel outfits
  • trek farley
  • sweater crop
  • beard products
  • best beard oil
  • sweater crop top
  • acne studios
  • what is beard

To get those results I acquired, I selected “-3” weeks.

I am considering what people keyed in 3 weeks before they searched in beard oil. That’s why I put a “-” sign prior to the #3 3 to see what they keyed in before they sought out my main keyword.

If you wish to attract more customers and build brand loyalty with individuals who may be thinking about beard oil products, I’d create content round the best beard oil or flannel outfits that match beards.

That’s what I acquired from the Google Correlate data.

And easily wanted to find out what products to generate to be able to upsell my beard oil customers, I’d perform exactly the same explore Google Correlate but work with a positive number such as for example “14 days.”

beard oil

Based on the info above, I’d consider offering beard balm being an upsell as there appears to be a solid correlation.

The cool part about Google Correlate is that can be done this for just about any keyword and sort the outcomes by the united states you’re targeting.


I know my approach to keyword search is really a pain in the butt, nonetheless it works.

Just think about it this way…

Creating content on new topics is hard since there is no guarantee a fresh page on your own website will rank in serach engines for competitive terms.

But invest the webpages that curently have traction and you also improve them utilizing the techniques I described above, it’s a guaranteed solution to generate more search traffic.

Now if you wish to create content that targets new keywords, you should, you should achieve this!

I am not saying that creating new content is really a bad idea… heck, I really do everything the time.

But consider creating new content once you modify your existing pages which are already driving your traffic and sales.

And once you do follow new terms, don’t forget to utilize Google Correlate since it can help you gain the proper kind of traffic (as well as your competition isn’t carrying it out).

So, what do you consider of my key word research and SEO process that I used to rank in serach engines for a large number of keywords?

The post The Advanced SEO Formula That Helped Me RANK IN SERACH ENGINES FOR 477,000 Keywords appeared first on Neil Patel.

David Linder

David Linder

MSc in Marketing from the University of Salford. Facebook Certified Planning Professional Facebook Certified Buying Professional

Leave a Comment