How to send data from Google Search Console to BigQuery

This is some text inside of a div block.
May 2, 2024

How can I send data from Google Search Console to BigQuery?

Using the Bulk Data Export feature in Google Search Console, you can send data to your BigQuery project daily. This process requires a Google Cloud Platform account with billing enabled, an active BigQuery project with billing enabled, and access to an active Google Search Console account with "owner" permission. Additionally, your search console account must be collecting search data for your website.

  • Google Cloud Platform account: This is a suite of cloud computing services that runs on the same infrastructure that Google uses internally for its end-user products. You need to have billing enabled on this account to use BigQuery.
  • BigQuery project: This is where you'll store your data. It's a fully-managed, serverless data warehouse that enables super-fast SQL queries using the processing power of Google's infrastructure. Billing must also be enabled on this project.
  • Google Search Console account: This is a free service offered by Google that helps you monitor, maintain, and troubleshoot your site's presence in Google Search results. You need "owner" permission on this account to send data to BigQuery.

What steps do I need to take to configure a new report?

To configure a new report, you need to prepare your BigQuery account to receive the data, enable the BigQuery API for your project, give permission to your Search Console service account, provide your Google Cloud project ID, and choose a dataset location.

  • Prepare your BigQuery account: This involves setting up your BigQuery project and dataset, and ensuring that billing is enabled.
  • Enable the BigQuery API: This allows your project to interact with the BigQuery service.
  • Give permission to your Search Console service account: This ensures that your Search Console account can send data to your BigQuery project.
  • Provide your Google Cloud project ID: This is a unique identifier for your project in the Google Cloud Console.
  • Choose a dataset location: This is the geographical location where your dataset is stored.

How can I export data from Google Search Console?

You can export data from Google Search Console in a CSV file, Google Sheets, or Excel format. This allows you to analyze your data in a format that is most convenient for you.

Keep reading

See all