Python Script for Fetching Keyword Search Quantity and Related Terms using Google API -- 2
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 5 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
Country1, Country 2, ... Country 20
Search Quantity for year 2022 by Country
Search Quantity for year 2023 by Country
Top 5 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
to help you can find similar code on these 2 links.
https://github.com/rdowns26/seo_keyword_research_tools
https://github.com/grumpyp/related-keywords-search-volume
https://developers.google.com/google-ads/api/docs/keyword-planning/generate-historical-metrics
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 5 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
Country1, Country 2, ... Country 20
Search Quantity for year 2022 by Country
Search Quantity for year 2023 by Country
Top 5 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
to help you can find similar code on these 2 links.
https://github.com/rdowns26/seo_keyword_research_tools
https://github.com/grumpyp/related-keywords-search-volume
https://developers.google.com/google-ads/api/docs/keyword-planning/generate-historical-metrics