Tim Colling

Moderator
Local Search Expert
LocalU Member
Joined
Sep 3, 2014
Messages
1,282
Reaction score
704
I hope I'm not being dense, but I cannot get the tool to work. I'm using Chrome and I'm logged into my primary Google account. When I open that spreadsheet, I cannot change the values entered in the city or keywords cells. They cannot be edited. What might I be doing wrong?

Thanks!
 

DanLeibson

LocalU Faculty
Joined
May 17, 2013
Messages
229
Reaction score
142
I hope I'm not being dense, but I cannot get the tool to work. I'm using Chrome and I'm logged into my primary Google account. When I open that spreadsheet, I cannot change the values entered in the city or keywords cells. They cannot be edited. What might I be doing wrong?

Thanks!

Hey Tim,

If you read the blog post, you will have to make a copy of the sheet ;)

I'm not giving anyone edit access to the original.
 
Last edited:

Adam Bowie

Member
Joined
Nov 15, 2015
Messages
2
Reaction score
0
Hey Dan - this is AWESOME! Really appreciate you sharing this!!

Is there anything we need to be aware of when using it? I have created a copy and run the sheet a few times. Is there any reason I should not be in my main Google account when running the queries, etc?
 

mborgelt

Member
Joined
Jul 22, 2012
Messages
479
Reaction score
155
This is great, Dan! Another essential part of local search made more time efficient.
 

DanLeibson

LocalU Faculty
Joined
May 17, 2013
Messages
229
Reaction score
142
Thanks Mike!

@ Adam, not quite sure what you mean. Can you clarify?
 
Similar threads
Thread starter Title Forum Replies Date
chrism Local Competitor Keyword Stuffing/Similar Words In GMB Spam on Google 8
Gsmithmike The most accurate Tool to show Local Search Result for Geo Targeting keywords? Local SEO Tools & Software 3
JoyHawkins How Do You Do Local SEO Keyword Research? Local Content 15
Blake Denman Local Keyword Research Local Search 1
Oliver Keates GMB Local Keyword Ranking Tool Google My Business & Google Maps 5
rosie.brightlocal Local SEO Keyword Game Break Room: Chat and Off Topic 0
J Inserting local keyword in H1 Local Search 3
Gsmithmike Best Tool To Check Keyword Ranking Locally? Local Search 4
S Listing disappeared in local 3 pack for major keyword Google My Business & Google Maps 3
H Keyword research and determining what is a local term or not. . . Local Search 7
J In Local Pack for most keywords but NOT main keyword , any advice please Help & Support for Google Local 7
James Watt New Keyword Research Tool with cool local features Local SEO Tools & Software 1
Jared Residental Solar Panels -- Not A Localized Keyword? Local Search 2
L ✔ The Most Amazing Local Keyword & Content Idea Tool EVER! Local Content 14
Linda Buquet ✔ The Most Amazing Local Keyword & Content Idea Tool EVER! Local Content 14
E Keyword Research for Blog posts and local content Local Content 4
E Keyword Research for Blog posts and local content Local Content 4
T Local SEO, National Website, Ranking for Multiple Keywords Consultant's Corner 1
Linda Buquet Surprise! Google Top 100 Most Expensive Keywords - Lots of Local Nuggets in Here Local Search 9
ruslan.barabolkin Guaranteed Keywords to bring up in Local Pack Local Search 9
Linda Buquet ▶ KEYWORDS: New Internet Trivia TV Game Show - For Local Search Nerds :-) Break Room: Chat and Off Topic 0
Gsmithmike What is the best way to check local ranking for a keyword? Local Search 26
Linda Buquet How to Use Google Trends for Local Keyword Research Local Search 0
foxxr Local Keyword Research Process Local Search 5
Optimize Prime A Case Study on Local Search Keywords & Traffic Local Search 9
ColoradoChris Help with Using Keywords for Local results Local Search 8
ColoradoChris Google plus local - added keyword, but now does NAP hurt me? Google My Business & Google Maps 23
Linda Buquet Targeting The Long Tail In Google Local Search w/ Keyword Research Local Search 2
Margaret Ornsby Re: Noob question about local keywords Recycle Bin 0
Bishop Noob question about local keywords Local Search 13
V Adding Keywords in Local Directories Local Search 7
Linda Buquet Fine Tune Local Keyword Research with Google Trends Local Search 1
D Local Keyword Research Methods Local Search 1
B Google + Local Page Not Showing Up For Multiple Keywords? Help & Support for Google Local 7
Daniel C Berman Say Goodbye To Non-branded Keyword Traffic If You?re In The Local Carousel Google My Business & Google Maps 3
Daniel C Berman Keywords that Return Local Results Google Local 101 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
B How To Rank For Multiple Local Keywords? Local Search 2
J Re: Keyword vs Keyword+Location - how are you running local search queries ? Recycle Bin 4
R Re: LOCAL Keyword Research Tools and Tricks Recycle Bin 0
G How would you get a client G+Local listing to rank for multiple keywords? Google My Business & Google Maps 8
M G+ Local Listing Getting Impressions and Ranks for Unknown/Unwanted Keywords Help & Support for Google Local 5
Linda Buquet LOCAL Keyword Research Tools and Tricks Local SEO Tools & Software 32
MiriamEllis Keyword or City First in Local SEO Local Search 8
rossicone Location Keywords in Google Local+ Listing Local Search 1
rich_marlatt Do the number of backlinks from a domain have any impact on local SEO? Local Search 2
zach.todd What do you look for in a local website audit? Organic SEO 7
Professor M New Local European Local listing removals Process Google My Business & Google Maps 1
D Can you set an end-date for Local Services Ads? Paid Search and Local Service Ads 1

Similar threads

Login / Register

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

Most UpVoted Answers

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