I need to create a script or program that will help me automate my keyword research process using https://adwords.google.com/KeywordPlanner.
Below are the primary steps involved:
1) On the 1st screen, I want to be able to input the city and state.
2) On the 2nd screen, what I would like to happen automatically is for the city that was previously indicated in tab 1, to be used as the basis for all keyword research. And then I would indicate which keyword group categories I want to perform keyword research for, based on a database where I could add and remove keywords. I also want the option to categorize and sub-categorize keywords, to help me easily find keyword groups to use. For example: a potential category could be Dentist, the Topic could be Cosmetic Dentistry, the sub-topic could be Invisalign, and then I would add a list of relevant keywords like Invisalign, Invisalign Cost, What is Invisalign, and Clear Braces (there will be a need for at least category > topic > sub-topic > keyword group).
So an example would be if Los Angeles is listed as the location, and then I indicated I want to do keyword research for that geo-target combined with all keywords listed in the "Bad Breath" keyword group (which would be found at Dentist > Dentistry > Oral Hygiene > Bad Breath), your software would then concatenate all of the keywords in that list in normal and reversed order (i.e. los angeles bad breath cause, bad breath cause los angeles, bad breath causes los angeles, los angeles bad breath causes, etc.).
Once the list of geo-targeted keywords is compiled, I want the software to run the keywords through the "Search for new keywords using a phrase, website or category" feature found at https://adwords.google.com/KeywordPlanner, but at the state level. Which means that the keywords would reflect Los Angeles, but the region in the tool would select California as the target location in Adwords.google.com. It'd also be great to have the option to include a URL to use for the "Your landing page" field.
3) Then I want the tool to automatically download and export as a CSV document all of the relevant keyword ideas data provided. Keep in mind that when I do keyword research, I'll want the ability to research numerous keyword groups for a website, so it's important the keyword data be segregated so that it's easier to go through the data and find useful keywords to target which are only specific to each keyword group.
4) Once the above is done, I need to manually review the keyword data for each keyword group and make a determination on which keywords I would like to track/target. If you can help automate the process of filtering the keywords based on specific conditions I state for each search (such as being able to filter the list and only see keywords that include the related geo-target in them, or any of the same keywords used in the searched keyword group, or even just any keyword relevant to what I type in), that could help speed up the process tremendously. Finally, I would like to export the chosen data as indicated on the "Final List" tab found at https://docs.google.com/spreadsheets/d/10EeZxvdlkdYKEdGsAPuodXn0IU3Op3PbHjGoyJAZ6H8/edit?usp=sharing. Keep in mind that for the landing page, I would want it to reflect the URL I input in step 2 above, otherwise I can populate it manually if I chose not to indicate one during the keyword research process.