{"id":1284,"date":"2010-02-15T13:55:38","date_gmt":"2010-02-15T18:55:38","guid":{"rendered":"http:\/\/www.daviddalka.com\/createvalue\/?p=1284"},"modified":"2010-04-12T16:32:32","modified_gmt":"2010-04-12T21:32:32","slug":"local-search-marketing-keyword-content-strategy-porters-of-racine-appendix","status":"publish","type":"post","link":"https:\/\/www.daviddalka.com\/createvalue\/2010\/02\/15\/local-search-marketing-keyword-content-strategy-porters-of-racine-appendix\/","title":{"rendered":"Local Search Marketing Keyword Content Strategy: Porters of Racine Appendix"},"content":{"rendered":"<p>While doing research for my Porters of Racine post in Google&#8217;s keyword external, I noticed that the keyword sets were large and that the keyword data for Kenosha furniture, Milwaukee furniture and Wisconsin furniture had interesting attributes. These keyword sets were not changed except to remove any query with the term terms implying outdoor furniture or terms that included terms like used, cheap, etc. It also only includes the top queries, not the long tail low volume ones.<\/p>\n<p>The first thing one notices is as the geographic search qualifier term covers a larger geographic area the quantity of searches in the head containing a branded term fell for these furniture terms.<br \/>\nWisconsin Furniture Monthly Search Queries<br \/>\nAttribute\t38119\t95.4%<br \/>\nBranded\t  1818\t 4.6%<\/p>\n<p>Milwaukee Furniture Monthly Search Queries<br \/>\nAttribute\t14014\t83.6%<br \/>\nBranded\t  2757\t16.4%<\/p>\n<p>Kenosha Furniture Monthly Search Queries<br \/>\nAttribute\t  2070\t78.7%<br \/>\nBranded\t   560\t        21.3%<\/p>\n<p>Does anyone know of anyone who has studied this issue on a larger basis across many geographies and industries? It makes sense to me I don&#8217;t yet have enough data to elaborate on it further at this time. It would make sense though as when you are looking to travel farther you are less clear of the path and that when you are doing a hyper-local search you could be influenced by such queues as seeing the physical location and word of mouth marketing factors. If you&#8217;ve noticed similar trends, please let me know about it with via a follow on post or private email.<\/p>\n<p>The following is the keyword data I used in the analysis so you can see how I classified the attribute versus branded data:<br \/>\nWisconsin Furniture Keywords\t Monthly Searches Attribute\/Branded<br \/>\nwisconsin furniture\t                       22200\tAttribute<br \/>\nwisconsin furniture stores\t                3600\tAttribute<br \/>\nfurniture in wisconsin\t                        3600\tAttribute<br \/>\nwisconsin furniture store\t                1600\tAttribute<br \/>\nwisconsin amish furniture\t                1600\tAttribute<br \/>\nfurniture stores in wisconsin\t                1300\tAttribute<br \/>\nashley furniture wisconsin\t                1000\tBranded<br \/>\nwisconsin office furniture\t                1000\tAttribute<br \/>\nwisconsin wood furniture\t                 590\tAttribute<br \/>\nwisconsin furniture company\t                 480\tAttribute<br \/>\namerican furniture wisconsin\t                 480\tBranded<br \/>\nwisconsin furniture outlet\t                 390\tAttribute<br \/>\nfurniture store in wisconsin\t                 390\tAttribute<br \/>\namish furniture in wisconsin\t                 390\tAttribute<br \/>\nwisconsin furniture manufacturers\t         210\tAttribute<br \/>\noak furniture wisconsin\t                         170\tAttribute<br \/>\nrustic furniture wisconsin\t                 170\tAttribute<br \/>\ncolders furniture wisconsin\t                 170\tBranded<br \/>\nfurniture manufacturer wisconsin\t         140\tAttribute<br \/>\nunfinished furniture wisconsin\t                 140\tAttribute<br \/>\nashley furniture in wisconsin\t                 110\tBranded<br \/>\namish furniture stores in wisconsin\t          91\tAttribute<br \/>\nbest craft furniture wisconsin\t                  58\tAttribute<br \/>\namerican furniture store wisconsin\t          58\tBranded<br \/>\nTotal Wisconsin Furniture\t               39937<\/p>\n<p>Milwaukee Furniture Keywords\tMonthly Searches\tAttributes\/Brand<br \/>\nmilwaukee furniture\t\t\t      22200\tAttribute<br \/>\nmilwaukee furniture stores\t\t       2900\tAttribute<br \/>\nfurniture in milwaukee\t\t\t       2900\tAttribute<br \/>\nmilwaukee furniture store\t\t       1300\tAttribute<br \/>\nfurniture sale milwaukee\t\t               1300\tAttribute<br \/>\nmilwaukee office furniture\t\t       1300\tAttribute<br \/>\nfurniture stores in milwaukee\t\t       1000\tAttribute<br \/>\nmilwaukee furniture outlet\t\t        480\tAttribute<br \/>\nmilwaukee bedroom furniture\t\t        480\tAttribute<br \/>\nashley furniture milwaukee\t\t        480\tBranded<br \/>\namerican furniture milwaukee\t\t        480\tBranded<br \/>\ncolders furniture milwaukee\t\t        480\tBranded<br \/>\nfurniture store in milwaukee\t\t        210\tAttribute<br \/>\nboston store furniture milwaukee\t        210\tAttribute<br \/>\nrubins furniture milwaukee\t\t        210\tBranded<br \/>\nrubin&#8217;s furniture milwaukee\t\t        170\tBranded<br \/>\nfurniture stores milwaukee area\t\t170\tAttribute<br \/>\nsteinhafels furniture milwaukee\t\t170\tBranded<br \/>\ncontemporary furniture milwaukee\t        170\tAttribute<br \/>\nbaby furniture milwaukee\t\t        170\tAttribute<br \/>\nwood furniture milwaukee\t\t        170\tAttribute<br \/>\nantique furniture milwaukee\t\t        170\tAttribute<br \/>\nhome furniture milwaukee\t\t        140\tAttribute<br \/>\noffice furniture resources milwaukee\t        140\tAttribute<br \/>\nbachman furniture milwaukee\t\t        110\tBranded<br \/>\nleather furniture milwaukee\t\t        110\tAttribute<br \/>\nwayside furniture milwaukee\t\t        110\tBranded<br \/>\nbiltrite furniture milwaukee\t\t        110\tAttribute<br \/>\nunfinished furniture milwaukee\t\t        110\tAttribute<br \/>\nnational business furniture milwaukee\t110\tAttribute<br \/>\nrubens furniture milwaukee\t\t         91\tBranded<br \/>\nmilwaukee furniture company\t\t         91\tAttribute<br \/>\namish furniture milwaukee\t\t         91\tAttribute<br \/>\nfurniture stores in milwaukee area\t         91\tAttribute<br \/>\ncolder&#8217;s furniture milwaukee\t\t         91\tBranded<br \/>\nscandinavian furniture milwaukee\t         91\tAttribute<br \/>\ncolders furniture store milwaukee\t         73\tBranded<br \/>\nbuilt rite furniture milwaukee\t\t         73\tBranded<br \/>\namerican furniture store milwaukee\t         73\tBranded<br \/>\nmilwaukee furniture dolly\t\t         73\tBranded<br \/>\nboston store furniture gallery milwaukee    73\tBranded<br \/>\nTotal Milwaukee Furniture\t\t       38971<\/p>\n<p>Kenosha Furniture Keywords\tMonthly Searches\tAttribute\/Branded<br \/>\nkenosha furniture\t                               1900\tAttribute<br \/>\nkenosha furniture stores\t                480\tAttribute<br \/>\ntotal furniture kenosha\t                        390\tBranded<br \/>\nfurniture stores in kenosha\t                170\tAttribute<br \/>\nashley furniture kenosha\t                170\tBranded<br \/>\nTotal Kenosha Furniture\t                       3110<\/p>\n","protected":false},"excerpt":{"rendered":"<p>While doing research for my Porters of Racine post in Google&#8217;s keyword external, I noticed that the keyword sets were large and that the keyword data for Kenosha furniture, Milwaukee furniture and Wisconsin furniture had interesting attributes. These keyword sets were not changed except to remove any query with the term terms implying outdoor furniture [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[12,2,19],"tags":[98,96,97,95,94],"class_list":["post-1284","post","type-post","status-publish","format-standard","hentry","category-change-management","category-search-engine-marketing","category-search-engine-optimization","tag-fine-furniture","tag-kenosha","tag-milwaukee","tag-racine","tag-wisconsin"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.daviddalka.com\/createvalue\/wp-json\/wp\/v2\/posts\/1284","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.daviddalka.com\/createvalue\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.daviddalka.com\/createvalue\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.daviddalka.com\/createvalue\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.daviddalka.com\/createvalue\/wp-json\/wp\/v2\/comments?post=1284"}],"version-history":[{"count":0,"href":"https:\/\/www.daviddalka.com\/createvalue\/wp-json\/wp\/v2\/posts\/1284\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.daviddalka.com\/createvalue\/wp-json\/wp\/v2\/media?parent=1284"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.daviddalka.com\/createvalue\/wp-json\/wp\/v2\/categories?post=1284"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.daviddalka.com\/createvalue\/wp-json\/wp\/v2\/tags?post=1284"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}