Welcome to the Q&A Forum

I'd invest some time in becoming a power house social media user. It has an easy to understand metric (# of followers) that can be leveraged to get people interested in you.  If I retweet your message to my 15,000 followers, I'm doing something that could benefit you a lot. You might get your potential partners reaching to you.

Hi There! I'm hoping watching some of Rand's Whiteboard Friday's will give you a clearer sense of how to organize this, but, in brief: You should never assume Google knows the location of a business, nor the locations it serves. It is up to you to point that out via content and links, but not to go overboard. There is nothing worse than reading text like this: Our Chicago Housecleaning service help customers in Chicago keep their Chicago homes clean with good housekeeping practices special to Chicago customers. Not saying you'd write something like that, but if you start looking at local business websites, you'll run into agonies like this one. So, the answer is, no, when writing in natural language, you're not going to append your city name to every keyword you are focusing on. Highly recommend watching those WB Fridays for more on this. What you want to avoid here is unnatural links. Typically, people linking to you are not naturally going to use your preferred text. Highly recommend you read through this as you plan your link strategy: https://moz.com/blog/the-anatomy-of-a-link I reached out to Dan Leibson at Local SEO Guide and he said the problem you are encountering most likely stems from not first making a copy of the sheet. You might be trying to edit the original, instead, which Dan says folks sometimes do by accident. Here are the instructions: This tool is really simple to use: Make a copy of the sheet for you to use yourself (don’t ask me for edit access, I’m not going to give it to you) Put the city you want to localize for (or zip code) in cell A4 Put the keywords you want to localize in A10+ Click the “Generate Keywords” button Check the new tab that has the localized versions of all your keywords Hope this helps, and good luck!

Hey there! You may have a few different options. It's hard to know exactly how this site is set up without more details - for example, does each location have its own subfolder or subdomain? - but depending on what the structure of the site looks like you may be able to make individual campaigns. If that is not an option, you may find more success making campaigns for the overall site and simply tracking keywords in localized geographies, and choose competitors based on those specific locales. If you have further questions feel free to email us at help@moz.com with the site details!