User Tag List

Thanks Thanks:  0
Likes Likes:  0
Results 1 to 7 of 7
  1. #1
    Member Since
    May 2013
    Location
    Costa Mesa, Ca
    Posts
    211
    Thanks (Received)
    0
    Likes (Received)
    0
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Local Keyword Generator

    Hey All,

    Just put together this Google Sheets script to make localization of keywords easier. Hopefully you find it useful:

    The Local Keyword Generator Tool - Local SEO Guide
    Dan Leibson
    Vice President of Local & Product
    Local SEO Guide Inc.
    @danleibson
    + Dan Leibson

  2. #2
    Member Since
    Jun 2012
    Location
    SoCal
    Posts
    14,627
    Thanks (Received)
    177
    Likes (Received)
    203
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Re: Local Keyword Generator

    Thanks for sharing Dan!
    Linda Buquet .:. Forum Founder, Google Local Specialist

    If you benefit from advice here... Please pay the community back by sharing on social OR helping someone else at the forum. Thank you!

    Don't Miss Important News & Tips! Subscribe to Daily Email Digest Here

    Note: Due to mulitple RSI injuries, pardon short replies. Typos? Blame it on "Dragon".

  3. #3
    Member Since
    Sep 2014
    Location
    San Marcos, CA
    Posts
    536
    Thanks (Received)
    18
    Likes (Received)
    31
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: Local Keyword Generator

    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!

  4. #4
    Member Since
    May 2013
    Location
    Costa Mesa, Ca
    Posts
    211
    Thanks (Received)
    0
    Likes (Received)
    0
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: Local Keyword Generator

    Quote Originally Posted by Tim Colling View Post
    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 by DanLeibson; 08-12-2016 at 06:46 AM.
    Dan Leibson
    Vice President of Local & Product
    Local SEO Guide Inc.
    @danleibson
    + Dan Leibson

  5. #5
    Member Since
    Nov 2015
    Location
    Nashville, TN
    Posts
    2
    Thanks (Received)
    0
    Likes (Received)
    0
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: Local Keyword Generator

    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?

  6. #6
    Member Since
    Jul 2012
    Location
    Denver, CO
    Posts
    441
    Thanks (Received)
    7
    Likes (Received)
    15
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: Local Keyword Generator

    This is great, Dan! Another essential part of local search made more time efficient.
    Free Local Checklist
    51Blocks - "White Label" Google Places & Website Development/Hosting - Will Pay Good $$ for Wordpress website hosting referrals
    Wordpress Site Speed Problems? Site speed optimization is part of our hosting - 90's on Google PageSpeed Insights

  7. #7
    Member Since
    May 2013
    Location
    Costa Mesa, Ca
    Posts
    211
    Thanks (Received)
    0
    Likes (Received)
    0
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: Local Keyword Generator

    Thanks Mike!

    @ Adam, not quite sure what you mean. Can you clarify?
    Dan Leibson
    Vice President of Local & Product
    Local SEO Guide Inc.
    @danleibson
    + Dan Leibson

Similar Threads

  1. 51 Blocks: New Schema Generator
    By Dustybones in forum Local SEO Tools & Software
    Replies: 12
    Last Post: 01-28-2016, 09:40 PM
  2. Replies: 0
    Last Post: 01-28-2016, 01:36 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •