As marketers we spend an important part of the working day checking stats on various tools that we’re using. It’s tedious process as we need to login into each individual platform. Also, if you’re doing marketing KPI reports for your business or clients, a lot of times you find yourself copy/pasting data from tools like Google Search Console to Google Sheets. This implies hours of manual work each week which would definitely be better spent on other tasks.
KPIBees offers a better approach to KPI maintenance: it enables you to pull data automatically for Google Search Console, and other marketing tools, to Google Sheets with just a few clicks! The KPIBees Google Sheet Add-on provides a user interface within Google Sheets that enables you to query the Google Search Console API directly within the sheet, and pasting the result starting with your selected spreadsheet cell. This feature grants you the power to build powerful marketing reports within minutes!
Another problem that KPIBees solves is that you can use the add-on to surpass the limitation of 16 months data retention policy that Search Console has. Using this add-on your data can be kept historically and never lost!
An important thing to note about the KPIBees’ Search Console integration is that it goes beyond the limit of 5k limit that Search Console API has in place through a smart system that performs multiple queries in background for each given query.
To get started, please follow the next steps:
STEP 2
STEP 3
Access the add-on in any of your spreadsheets by going to the Add-ons toolbar.
STEP 4
Click on the Google Search Console integration.
STEP 5
Authorize KPIBees to access your Google Search Console account. Then you need to name your query, select the desired Fields to fetch to the spreadsheet – see more information about the parameters that you can use.
STEP 6
Once you run the query, the result is outputted starting with your selected spreadsheet cell.
STEP 7
You can add as many Google Search Console queries as you want from multiple accounts or website and even other data sources! These queries can be edited or refreshed from the Manage Queries menu at any point in the future.
STEP 8
When you’re done with your query setup you can set automated refresh triggers with email or Slack notifications! This ensures that your data is always up to date when you’re coming back to the spreadsheet. Talk about efficiency!
Let’s go over the query options that are offered by the Google Search Console API so that you can make the fullest out of the Search Console integration.
The Search Console Property represents the website that you want to use in the query. At the moment you can have a single website in the query. If you have an interesting use case of needing more than 1 website in query, please let us know, we’re interested in the use case!
This parameter establishes how the aggregation of the results is done. There are a couple of possibilities:
Google Search Console results are divided in several categories depending on the traffic type, such as:
Google Spreadsheets
