HoosierBuff

Member
Joined
Dec 12, 2013
Messages
316
Reaction score
86
Hi all,

I have a new client in the office furniture space. They are a local player, and for many searches google will show a national set of results "desk chair" and others show a local snack pack in the results, and more local results.

In doing my research, I want to find their biggest opportunties. The searches that are national in nature aren't much of an opportunity. Sure, a person could add a modifier "desk chairs near nashville, tn", but, that will be thinner. The searches that automatically turn on the 3 pack are better opportunities (I think).

So, in looking over 100's of potential keywords, I'm trying to figure out which ones are local, and which ones are not. Manually typing them in is time consuming. Does anyone have a way of doing this easily? Am I thinking about this incorrectly?
 

heckler

Member
Joined
Oct 28, 2014
Messages
282
Reaction score
78
We track 10,000+ KWs and with some basic math create a %-chance that a given query would produce a local box.

I suspect you could do something similar with just about any rank-checking service that will provide you with the raw SERP files. Should be pretty straight forward for a few 100 KWs. The downside is you have to re-run this every so often because Google is constantly pushing buttons and pulling levers, but at least it would give you a straight-edge (for a period of time).

The other option (not paying someone) is to fire up a python scraper with a bunch of proxies and keep firing away until you have what you need. With using a rank-checking service though you can likely perform this analysis across multiple user-agents easier.

There already may be some of this data in the wild, but I'm not aware of it.
 

Eric Rohrback

Moderator
Joined
Oct 3, 2012
Messages
1,021
Reaction score
343
We track 10,000+ KWs and with some basic math create a %-chance that a given query would produce a local box.

So you're using an equation to predict local box/map pack or to predict local intent in the client's area?
 

heckler

Member
Joined
Oct 28, 2014
Messages
282
Reaction score
78
So you're using an equation to predict local box/map pack or to predict local intent in the client's area?

Both really. It helps us predict which KWs are more than likely going to pop a local box; which, we figure is a 'local intent' query and gear the site content at those terms/topics/'ideas' based on a client's service offering.

We don't look specifically at 1 metro, we look at 100's of them and classify them based on populations.
 

Eric Rohrback

Moderator
Joined
Oct 3, 2012
Messages
1,021
Reaction score
343
I'm looking at different ways to do keyword research, so i'm really interested in the methodology. Could you explain how you're doing this in a little more detail? What kind of variables go into the math equation, and how are you tagging the % of traffic as local intent?
 

DanLeibson

LocalU Faculty
Joined
May 17, 2013
Messages
229
Reaction score
142
So just FYI, SEMrush will tell you the % of a domains keywords that trigger specific SERP features e.g. Answer Box, Packs and also tell you what those keywords are, what there search volumes are etc.
 
Joined
Oct 25, 2013
Messages
752
Reaction score
286
If I remember right, Moz's new keyword tool they came out with two months ago (or rather, the updates on their old tool) lets you search through your list of keywords, and it'll organize them (among other ways) by which trigger different SERP features. Sounds like exactly what you're looking for, though I'm sure it's not the only tool that does it.
 

mblumenthal

1
LocalU Faculty
Joined
Oct 11, 2012
Messages
102
Reaction score
110
As a note, on long tail searches, ehether a pack is triggered is a variable based on signals Google is getting from third party local sites as to what is "important". Thus a phrase that triggers a pack in one area might not in another. I have tested triggering packs and been successful.
 
Similar threads
Thread starter Title Forum Replies Date
JoyHawkins How Do You Do Local SEO Keyword Research? Local Content 15
Blake Denman Local Keyword Research Local Search 1
ntaylor360 Keyword Research Tool Local Search 3
JoyHawkins The Proper Way to do Keyword Research in 2016 Marketing 9
James Watt New Keyword Research Tool with cool local features Local SEO Tools & Software 1
Mark Warner Need A New Keyword Research Process and Software, Pls Help Local Search 0
E Keyword Research for Blog posts and local content Local Content 4
E Keyword Research for Blog posts and local content Local Content 4
Colan Nielsen Great Keyword Research Tip Local Search 6
Linda Buquet How to Use Google Trends for Local Keyword Research Local Search 0
foxxr Local Keyword Research Process Local Search 5
grasshoppersean Stuck on keyword research. Help please. Local Search 5
Linda Buquet Targeting The Long Tail In Google Local Search w/ Keyword Research Local Search 2
Linda Buquet Fine Tune Local Keyword Research with Google Trends Local Search 1
D Local Keyword Research Methods Local Search 1
Chris Ratchford Keyword Research via AdWords testing Organic SEO 8
Linda Buquet Hot for Local! NEW Google Keyword Planner - KW Research by City Local SEO Tools & Software 40
Linda Buquet 10 Local SEO Keyword Research Tips Local Search 0
R Re: LOCAL Keyword Research Tools and Tricks Recycle Bin 0
Linda Buquet LOCAL Keyword Research Tools and Tricks Local SEO Tools & Software 32
I Is there an uptick in keyword planner data being excluded for healthcare related terms? Paid Search and Local Service Ads 5
chrism Local Competitor Keyword Stuffing/Similar Words In GMB Spam on Google 8
D Keyword Targeting by "Location" vs "Near Me" Organic SEO 8
jross Homepage Focus Keyword? Local Search 3
RattlingTram Wild rank variations for plural v singular & same intent single keyword searches Ranking Puzzles 2
Ben Walsh Best keywords to use for geogrid ranking maps Ask a LocalU Expert [PRIVATE] (LocalU) 2
RattlingTram Map Pack Rankings for SAB with equal intent keywords Service Area Businesses 2
coachmarino Keywords in Name NAP, Categories, Dashboard Data 5
coachmarino DUP Keywords in Name Recycle Bin 0
Gsmithmike The most accurate Tool to show Local Search Result for Geo Targeting keywords? Local SEO Tools & Software 3
Andy Keyword stuffing - dentist NYC Spam on Google 3
Ben Walsh Keyword in meta title twice Ask a LocalU Expert [PRIVATE] (LocalU) 1
Y My rival manipulates google autocomplete and now whenever I write keywords on google his name appears Local Search 14
N DUP Main keywords Unexpectedly dropped Recycle Bin 4
MKubot One GMB Keyword Outlier Ask a LocalU Expert [PRIVATE] (LocalU) 2
M Google keyword planner vs Ahrefs Local Search 1
Y Sudden GMB Ranking Drop for all keywords Google My Business & Google Maps 7
Lachlan_Wells Is it time to rethink our definition of keyword stuffing? Google My Business & Google Maps 7
D Name of town/city in keyword phrase Recycle Bin 0
koji Name of town/city in keyword phrase Local Search 5
K Keywords in Review Response Local Reviews 5
eshad Keyword tracking for nearby towns Local Search 4
djbaxter The search could not be completed because the keywords were too short, too long, or too common. How To Guides 3
W Do keywords in Google My Business (GMB) reviews help ranking Local Reviews 3
Dana Franks Google putting home page title keyword on other pages Organic SEO 6
M Keyword in SERP-title as indicator for competition Organic SEO 2
S Stop words in title or not - for the main keyword? Local Search 2
H Keyword vs. Keywords plus GEO Local Search 1
B Best practice for flagging keyword-stuffed business names Recycle Bin 0
eshad Reviews not showing for businesses for certain keywords in maps? Local Reviews 6

Similar threads

Login / Register

Already a member?   LOG IN
Not a member yet?   REGISTER

Most UpVoted Answers

Trending: Most Viewed

LocalU Podcasts

  Promoted Posts

New advertising option: A review of your product or service posted by a Sterling Sky employee. This will also be shared on the Sterling Sky & LSF Twitter accounts, our Facebook group, LinkedIn, and both newsletters. More...
Google Product Exert


Top Bottom