Update: Bulk Google Traffic research sheet
We reduced prices for this sheet. Performing a single analysis (for up to 1K domains) only costs 12 API credits.
Use the Google traffic sheet to discover how many visitors a Website or specific URL gets form both the organic and the paid search results. See how many visitors your competitors get or use traffic data to estimate the value of a domain. The spreadsheet is designed to handle bulk requests, this means you can check up to 1000 results with just a single click.
The traffic statistics are calculated based on the position in search (organic and paid) taking into account SERP elements, CTR (Click-Trough-Rate)and monthly search volume for the corresponding keywords associated with the specified domain or URL.
The “Google traffic research sheet” is a pre-programmed spreadsheet that connects with the SEO Review Tools traffic API. This means you can work with the API without any programming knowledge.
How to use this sheet
- Make a copy of this spreadsheet
- Register for the API (the API comes with a 15 day free trial)
- Enter your API key
- Enter your Keyword
- Slect your country
- Hit the “Get results” button
The first time you use the sheet
Please note that I will NOThave access to your account and you will be the owner of the script running in your account. Becuse the Google authorisation screens can look pretty intimidating ;-))
- Google will ask for authorization, click “Continue”
- Select the account you want to use
- Google will show the “Google hasn’t verified this app” message, click “advanced”
- Click “Go to ImportJSON (unsafe)”.
- On the “ImportJSON wants to access your Google Account”, click “Allow”
If you have any additional question or suggestions, don’t hesitate to contact me.
Get the new Chrome Extension!
Updates