September 27, 2016 in Tips by

A while ago Google stopped providing an estimate of search volume for each keyword. Now, for free or smaller customers, they are providing a range of search volumes. I don’t know about you, but this is throwing off my entire keyword research process. I need the number of estimated searches, to pick the best keyword.

That’s why I wrote a couple Excel formulas.

The first one gives you the minimum average monthly searches for exact matches on a given keyword. This is probably for the “glass-half-empty” crowd.

=VALUE(SUBSTITUTE(SUBSTITUTE(LEFT(D2,FIND(CHAR(208),D2)-1),”K”,”000″),”M”,”000000″))

The second excel formula tells you the maximum average monthly searches for exact matches on a keyword. Use this if you’re a glass-half-full kind of person.

=VALUE(SUBSTITUTE(SUBSTITUTE(RIGHT(D2,LEN(D2)-FIND(CHAR(208),D2)),”K”,”000″),”M”,”000000″))

In both these formulas, we’re referencing the ASCII value of 208, which is the dash the Keyword Planner is giving us.

Is this the end of keyword research?

Nah. Whether you’re doing SEO or PPC, this is still useful:

So, keyword research might be a little less specific, but it’s still achievable with Grouped Data in the Google Ads Keyword Planner.

WordCamp Austin 2020

Did you hear David speak at WordCamp Austin?

Learn why we're reliable.
Read our other credentials.


The Bottom Line

You need to reach people in your industry.

Reliable Acorn will help you create a custom digital marketing strategy that does just that.

Ready to Talk?