I'm looking to automate what I'm currently doing manually for seo / niche research using the Google Adwords Keyword Planner tool and manual google searches. Or, if you can simply point me to an existing product/service that can do both of these tasks in the same tool, I'll pay you just for finding it for me. The primary goal is to have a tool that both: identifies the total number of searches each keyword phrase gets on Google per month, within a specific set of US cities, and also shows the number of "Google Reviews" each keyword phrase (in each US city identified) has.
There are 2 primary search fields:
1) First I would need to identify which US cities I'd like to search in (task usually done in Google Keyword Planner Tool)
2) Next I would input keyword search phrases info a field which I want to learn the number of searches per month (within the US cities identified). This is also a task that is normally done in the google keyword planner tool.
1) I would be shown a table displaying the total number of searches each keyword phrase gets per month within the US cities I had input. (this feature is already available in many SEO research software options today)
2) I need to also see the number of listings/companies that appear with "Google Reviews" when each "keyword phrase [city] [state]" combination would be googled. (This is the tough part that I don't think exists in any software to date).
Here's an end-to-end example:
Let's say I want to do keyword research on the keyword phrase "plumbers" and I'm interested in looking in Chicago, IL and Naperville, IL. In the "keyword phrases" field I'd enter, "plumbers" and in the "Cities" field I'd enter: "Chicago,il" and "Naperville, IL" (the field would need to either have a drop-down of all cities within each state, or, it would have to auto-finish/understand what cities I'm typing in and then set those cities as chosen).
Next, I'd press a button to initiate the search and the results would look something like this:
"Plumbers" gets 5125 searches per month in Chicago, IL and there are 3 Google Review listings with star ratings of 8,13, and 22."
Or ideally displayed in a table (see attached mockup).
I want a tool that can show me 1) Monthly google searches and Google Reviews data for specific keyword phrases within specific US cities.
NOTE: Since I can technically use the Google Keyword planner tool to do the 1st step, I'd be open to just having the capability of having a tool that can only do the 2nd step (if that were much easier and cost effective). This simplified tool would just need to take my keyword phrase + us cities chosen and display the number of Google Reviews per "keyword phrase [city] [state]" combination.
Please let me know if you can build this and what it would take. I've attached a few screen shots to illustrate what I'm going for.
10 freelanceria on tarjonnut keskimäärin 581 $ tähän työhön
Dear client I am highly interested to do this project. I will make you happy.I don’t need any upfront or milestone payment. Pay me when you will happy. Looking forward. Thanks