1.9K members online now
1.9K members online now
Use AdWords conversion tracking and reporting to measure your results. Have a question about Google Analytics? Post it here, on the Google Analytics Community!
Guide Me

Percentage of Location based seaches

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Hi all,


I once read that now, 80% of Google searches are made with location in mind or are location based.

That includes queries that contain words like "near me", "local", "closest" as well as "new york", "france", etc.


I would like to test this on my own national campaign and see how many queries are location based.

I know my campaign has a lot of local searches, generally people using their town or city within the query.


I have a Search Query Report of nearly 3,000 terms but am unsure how I can go about sorting/filtering this data.

All I need here is simply the amount of queries that contain a location or "near me" type terms. 


However, as the locations are so many and varied, it is hard (impossible) to filter.


There must be a quick , possibly automated, way to find this data.
Any ideas are much appreciated!




1 Expert replyverified_user
Marked as Best Answer.
Accepted by topic author Sachin M
September 2015

Re: Percentage of Location based seaches

Top Contributor Alumni
# 2
Top Contributor Alumni

Good afternoon.


As far as I know, there is no AdWords-based functionality to produce a report like this. 


I sometimes want to filter search queries this way, myself. Depending on the size of the search query list, there are a couple of different methods I use.


With a small list of only about 3k, you could use a spreadsheet's search-and-replace function to find the terms you're interested in and change the font or add a bright-color "fill" to the cell. That would make picking out the important terms simple. 


Or, if you're good with more advanced spreadsheet functions, I know that in Excel you can set up a function that searches a column for specific words or phrases and copies them to another column. Then you could "sort" by the new column and see the relevant search queries.


Just my $0.02.

Google AdWords Top Contributor