I need a simple tool.
It has to perform the following actions:
1. To Pull keyword data from Google Adwords API (based on a sample input from the user). The data should include: Keywords and number of monthly searches.
2. After it pulls the keyword data, to check the ranking of a particular site for each of the pulled keywords. This should be done by scraping. The user will input the site at the beginning.
3. To create a report that would show the list of keywords, their respective monthly search volumes and the current ranking for the webiste.
The input from the user will be:
- Site URL
- Sample keywords
- Targetted Language
- Targeted Country/Countries
- Targeted Google (e.g. .com, .[url removed, login to view], .de etc)
This will be an automated keyword research. Please keep the bids reasonable. This is a simple tool that will work with an API and will scrape Google results after that.
Bear in mind that there s possibility for Google to show captchas. The user must be able to see them and input/solve them in order to avoid process interruption.
Forgot to mention that the end report should be in .xlsx file and it should have a header and footer of our company (will provide the images).
The queries for the Google scraping should be made as variables so we could test different intensity (in order to avoid too many captchas).