September 27, 2016 in Tips by

The other day Google stopped providing an estimate of search volume for each keyword. Now, for most 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. Remember:

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

WordCamp Greenville 2019

You might have heard David speak at WordCamp Greenville (SC) in 2019.

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?