Google Search Console

How to fetch data from a Google Search Console account

Aydin Ismailov avatar
Written by Aydin Ismailov
Updated over a week ago

This step-by-step guide will show you how to set up and manage a Google Search Console Integration.

Basic Requirements

In order to successfully integrate Google Search Console with Mediatool, you must:

  • Have a Google Search Console account

  • Have permission to access the relevant site(s)

Step 1: Authorize the Integration

The first step in the setup process is to allow Google to share data with your Mediatool account.

  1. log-in to your Mediatool account

  2. navigate to the Settings section of whichever organization, or subsidiary, that you would like to integrate.,

  3. under the section titled External Data, click on Integrations.

  4. click on the button titled Manage or Add under the Google Search Console option.

From there you'll be redirected to Google and asked to allow Mediatool access to your Google Search Console and related insights. The response you select must be Yes in order for the integration to work.

Step 2: Select a Date Range

Choose a Date you want to start fetching your data from. All data from your selected date until the moment the integration is saved will be fetched., The data will be automatically fetched every 24 hours between 01:00 and 03:00 GMT.

Note: When setting up a new integration, it's very common to save and then re-run the integration many times in order to test, and then finalize the measures and splits that you'd like to fetch. To avoid longer wait times than necessary, we recommend selecting the most recent Date possible (that has data associated with it) while you're testing the integration. This will reduce the total amount of data fetched and allow for quicker load times while you decide on a finalized data structure.

Step 3: Select an Account

After choosing the date, select which Google Search Console Account(s) you want to fetch data from. The available options will appear in a drop-down menu for you to choose from. You have the ability to choose more than one account.

Step 4: Measures and Splits

When setting up this part of your integration, it's important to understand the difference between a Measure and a Split, so that you can determine a data structure that is catered to your specific needs.

Measures are quantitative metrics that you want to measure. The value of any metric will be displayed as a number.

Splits are the dimensions that each of your chosen Measures will then be categorized. A Split will be displayed as a separate column for each measure.

For example, if you want the ability to create a visualized chart on your spend by platform, ‘Spend’ would be the Measure, and ‘Platform’ would be the Split. To best visualize how measures and splits will be represented in the raw data, feel free to view this video.

For both Measures and Splits, you will have to enter two inputs in the Mediatool Settings:

(a) First, the Measure or Split, as is defined by Google Search Console. The options that populate in the dropdown are limited to those supported by Google.

If your desired measure or split is not displaying as an option in this dropdown, it is not supported with the Google Search Console API.

(b) Second, the Measure or Split, as you (or your account administrator) have defined them in Mediatool. The options that populate in the dropdown are limited to those created as Fields and/or Tags in your Mediatool account settings.

To add a Measure or Split that doesn't currently exist in your Mediatool account settings, select Create a New Mediatool Equivalent in the dropdown, input the new name of this equivalent and it will be added as a Field in the account settings.

Step 5: Save Connection

Once you have selected all the Measures and Splits and are ready to fetch the data you've selected, click Save Connection. While you wait for the data to fetch, you can navigate to other pages within the Mediatool app or leave Mediatool altogether.

When a green arrow appears next to the Integration, the data has been fetched and is ready to be used in Reports.

Step 6: Check the Raw Data

We recommend taking a look at the raw data that has been fetched from the integration to make sure that your measures and splits are funnelling into Mediatool correctly

To do this:

  1. Navigate to the Results section

  2. Select the Sheet View tab, and then the Google Search Console tab, which will display either in the bottom left or bottom right of the Sheet View.

  3. Refresh your window

This is where all data from your various integrations are stored. The raw data cannot be manually edited. If you want to make changes to the measures and splits being captured, head back to the Integration Settings page, adjust and save.

Step 7: Create a Report

Data isn't worth very much if you don't make it understandable and actionable. Put your data to work and gain valuable insights by creating a dedicated report for your integration, or add it to one of your existing reports. For more information on how; visit our help center article on Reports.

Did this answer your question?