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.
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.
In both these formulas, we’re referencing the ASCII value of 208, which is the dash the Keyword Planner is giving us.
So, keyword research might be a little less specific, but it’s still achievable with Grouped Data in the AdWords Keyword Planner.
Reliable Acorn will help you create a custom digital marketing strategy that does just that.Ready to Talk?