I have seen the most illogical keywords that people come up with, and mainly because they are trying to put in everything they can think of that hopefully ranks their site higher in the search engines. This is pure folly to do as it is over-optimizing. Another thing is actually search engine optimizing with keywords that people will actually search for, rather than just putting a bunch of garbage.
In the case of targeting local SEO, it becomes apparent that “Deck Coating Irvine, California” may help, but unfortunately, using it exactly like that in your page or blog post title, and within your article to humans is just illogical. Even if a person were to put in their title “Deck Coating in Irvine, California”, you would still do pretty good in the search, especially if you are going out there and promoting it on Facebook, Twitter, and Youtube. Of course, you can put in your meta and your tags the “deck coating irvine california” and that might help too.
However, it is important to sound logical to your readers and to even potential readers stumbling upon your article in the search engines. They may believe your command of the English language is sub par.
If you really are carefully optimizing your site, regardless whether it is for a business, a blog site, or both, you have to think like a human and not the search engine when optimizing. Most people have used a search engine at some point to find something out there. This is not like in the 1980s when you might be putting in a command for DOS and get an error syntax for putting the wrong words in.
In the case you are not sure on what you should be optimizing for, but have a clue who your competition is, look at their site and seek out their Alexa rank, just as a quick look. On their Alexa rank page, there is a section for keywords people look for and land on their site. Optimize with articles that would compete with theirs, and yet sound logical to your readers.
How have you been optimizing your website?