Search Console Big Query Export Setup Guide

If you would like to enrich the Search Term data collected from your Google Search Console with additional parameters, like for example the option to filter your data on “Country”, you need to export your Google Search Console data to BigQuery first. This document serves as a step by step guide to enrich Search Console data with BigQuery.

Additional information can be found at Google Support.

In Google Cloud Console #

1. Open Google Cloud Console
2. Switch to the project you want to export the data to. If you don’t have any projects, you should create a new one.
3. Enable BigQuery for the project
   1. Using the sidebar, navigate to APIs & Services -> Enabled APIs & Services
   2. If BigQuery is not enabled, click + ENABLE APIS AND SERVICES and enable BigQuery API and BigQuery Storage API.
4. Grant permission to Search Console to export data to the project.
   1. Using the sidebar, navigate to IAM and Admin. Make sure it says Permissions for project [your project].
   2. Click + GRANT ACCESS, then Add principals.
   3. In New Principals paste the following service account name: “search-console-data-export@system.gserviceaccount.com”.
   4. Grant it two roles: BigQuery Job User and BigQuery Data Editor.
   5. Click Save.

In Search Console #

1. Open Search Console.
2. Go to Settings -> Bulk data export.
3. Select the property you want to export from.
4. Copy the project ID from Google Cloud Console into the Cloud project ID field.
5. Choose a dataset name to export to. This will _always_ start with “searchconsole”, but you may wish to append to it for organizational reasons.
6. Select a location for your dataset. Note that this cannot be easily changed.
7. Click Continue to confirm choices. It should end up looking something like this: