Python Script for Fetching Keyword Search Quantity and Related Terms using Google API
Budget: $10 – $30 USD
Project Description:
We are seeking a seasoned Python developer with experience in Google APIs to design a script for Windows that will extract both the search volume of a list of keyword terms for their top 20 countries and the top related keywords for each term.
Functionality:
Extract the search volume of multiple keyword terms (sourced from an Excel file) in their respective top 20 countries.
Concurrently fetch the top related keywords for each term.
Technical Requirements:
Python Version: The script must be developed for Python 3.
Operating System: The script should run efficiently on Windows.
Input: An Excel file with a list of 14,000 keyword terms.
Output: An Excel or CSV file, structured with the following columns:
Keyword Term
Country
Search Quantity
Top Related Keywords (comma-separated or similar)
Performance and Robustness:
The script should be optimized for efficiency, especially given the potential Google API rate limits.
Strong error handling is essential, particularly for issues tied to the Google API (e.g., quota exceeded, timeouts).
The script should include debug messages for each step, displayed in the terminal.
Coding Standards:
Proper documentation and coding comments must be incorporated throughout.
The solution should be delivered sequentially, with periodic progress updates from the developer.
Skills and Experience Required:
Profound expertise in Python scripting and API integrations.
In-depth familiarity with the Google API and its related functionalities.
Comprehensive understanding of keyword research and SEO techniques.
Capability to manage, manipulate, and export data seamlessly.
Additional Notes:
Developers should provide examples of previous Python scripting projects, especially those involving the Google API.
Familiarity with Google API rate limits and effective strategies to avoid surpassing them will be considered a significant advantage.
Deadline: 7 to 12 days
We are seeking a seasoned Python developer with experience in Google APIs to design a script for Windows that will extract both the search volume of a list of keyword terms for their top 20 countries and the top related keywords for each term.
Functionality:
Extract the search volume of multiple keyword terms (sourced from an Excel file) in their respective top 20 countries.
Concurrently fetch the top related keywords for each term.
Technical Requirements:
Python Version: The script must be developed for Python 3.
Operating System: The script should run efficiently on Windows.
Input: An Excel file with a list of 14,000 keyword terms.
Output: An Excel or CSV file, structured with the following columns:
Keyword Term
Country
Search Quantity
Top Related Keywords (comma-separated or similar)
Performance and Robustness:
The script should be optimized for efficiency, especially given the potential Google API rate limits.
Strong error handling is essential, particularly for issues tied to the Google API (e.g., quota exceeded, timeouts).
The script should include debug messages for each step, displayed in the terminal.
Coding Standards:
Proper documentation and coding comments must be incorporated throughout.
The solution should be delivered sequentially, with periodic progress updates from the developer.
Skills and Experience Required:
Profound expertise in Python scripting and API integrations.
In-depth familiarity with the Google API and its related functionalities.
Comprehensive understanding of keyword research and SEO techniques.
Capability to manage, manipulate, and export data seamlessly.
Additional Notes:
Developers should provide examples of previous Python scripting projects, especially those involving the Google API.
Familiarity with Google API rate limits and effective strategies to avoid surpassing them will be considered a significant advantage.
Deadline: 7 to 12 days