Hi Miriam, thanks for taking the time to respond so fully - very much appreciated. Just a few questions though:

1. Lets say I am house cleaning company servicing numerous locations within London, lets say Mayfair (and have no physical location there). I will therefore wish to appear in the organic rankings for all manner of searches associated "house cleaning + Mayfair" "home cleaners + Mayfair" "domestic services + Mayfair" etc etc. There are likely to be hundreds of variations. Lets assume I get the URL structure and tech seo right, within my page content, should I be gunning for say the top 10 keywords on this list, with "Mayfair" appended, so something like _"...we offer a full range of house cleaning services in Mayfair..." _or, should I assume that Google will realise this page is clearly about Mayfair and not bother trying to add Mayfair to each keyword (just gut feel that if the word Mayfair is in title tags, meta description and H1, then peppering the page with further references to Mayfair may seem unnatural and spammy)?

2. Once I have worked out the answer as to how to structure this page content, I assume I should then focus on getting relevant high authority links to the Mayfair landing page, using natural language. If this is the case, and if some high ranking site is willing (I realise that this would be an ideal situation), might it be best to actually suggest linking text to them, so that their link to our page contains the text _house cleaning services in Mayfair _thereby targeting the exact content on our page?

By the way, I tried your tool, but couldn't work out how to actually add (using the above example) Mayfair into cell A4 and then keywords I want to localise into cell A10.

Many thanks!

Hi, hoping to get some suggestions on strategy in terms of building out my site as I'm a bit overwhelmed. We provide home services throughout hundreds of locations - some major cities, others smaller yet affluent towns where demand is sufficient, though have no physical presence in the majority. My question is really regarding ranking organically (given local listings will be so difficult). I am new to Moz and have been using the Keyword Explorer to generate a long list of keywords, which I've refined to those which offer the most opportunity. Do I simply now take this list and append [city_name] to each keyword/phrase?

If so, working in [list_of_keywords] + [city] into hundreds of location pages is surely going to be a nightmare to make unique, and most likely a horrible user experience. All my customers really want to see is: that we service their area, some info on how we operate, that we are trustworthy (reviews/site quality etc) clear pricing/information (across mobile/desktop) and an easy way of contacting us. If I was searching for a lawn care service in Manchester for example, I couldn't care less about anything else other than the above information. So is padding out pages with content like 'Things to do in Manchester' etc. really the way forward? Would I be better off focusing on building relationships/links with other local complimentary businesses/influencers rather than building out tons of content (on the assumption of course that what content is there is high quality, contains a smattering of keyword + city, and optimised very well)?

Any help hugely appreciated!

Hi, hoping to get some suggestions on strategy in terms of building out my site as I'm a bit overwhelmed. We provide home services throughout hundreds of locations - some major cities, others smaller yet affluent towns where demand is sufficient, though have no physical presence in the majority. My question is really regarding ranking organically (given local listings will be so difficult). I am new to Moz and have been using the Keyword Explorer to generate a long list of keywords, which I've refined to those which offer the most opportunity. Do I simply now take this list and append [city_name] to each keyword/phrase?

If so, working in [list_of_keywords] + [city] into hundreds of location pages is surely going to be a nightmare to make unique, and most likely a horrible user experience. All my customers really want to see is: that we service their area, some info on how we operate, that we are trustworthy (reviews/site quality etc) clear pricing/information (across mobile/desktop) and an easy way of contacting us. If I was searching for a lawn care service in Manchester for example, I couldn't care less about anything else other than the above information. So is padding out pages with content like 'Things to do in Manchester' etc. really the way forward? Would I be better off focusing on building relationships/links with other local complimentary businesses/influencers rather than building out tons of content (on the assumption of course that what content is there is high quality, contains a smattering of keyword + city, and optimised very well)?

Any help hugely appreciated!