sel logo
Search Engine Land » SEO » Google Search Console adds daily bulk data exports to BigQuery
Google is rolling out a feature over the next week that will allow you to automate a daily bulk export of your Search Console performance data to BigQuery. This will allow you to run complex queries over your data to an external storage service, where you can do deeper analysis in a more automated fashion, Google announced.
The export. Google said you could configure an export in Google Search Console “to get a daily data dump into your BigQuery project.” This includes all of your Search Console performance data but not the anonymized queries. The daily data row limit does not impact this data, so you can extract more data using this method.
The cool part is not just the reduction of data limits but also that this is an ongoing daily export that can be automated.
Who this helps. Google said this is likely more helpful for larger sites with larger datasets. “This data export could be particularly helpful for large websites with tens of thousands of pages, or those receiving traffic from tens of thousands of queries a day (or both!),” Google wrote.
How to export. Google created a help document to walk you through how to export your data to BigQuery, it is somewhat technical, and you may need assistance from a developer or programmer. The higher-level stages of this work as follows:
This export is daily, and the first time it will start within 48 hours. If the export simulation fails, you should receive an immediate alert on the issue detected; here’s a list of possible export errors.
The data. Google provided a quick description of the three tables that will be available to you:
BigQuery. BigQuery is Google’s fully managed, serverless data warehouse that enables scalable analysis over petabytes of data. It is a service that supports querying using ANSI SQL. It also has built-in machine learning capabilities.
Why we care. The more data you have access to in your own platform, the more you can do with analysis of your search performance. That means you can slice and dice your data in ways you probably could not prior. This should allow you to develop new ideas to improve your site and user experience.
Also, third-party data tools may find useful ways to build out new reports with this. Google said, “We hope that by making more Google Search data available, website owners and SEOs will be able to find more content opportunities by analyzing long-tail queries. It’ll also make it easier to join page-level information from internal systems to Search results in a more effective and comprehensive way.”
Postscript. This is now available to everyone as of February 28, 2023.
We’re happy to let you know that Bulk data exports are now available to everyone. Enjoy! 📊📈 https://t.co/AdSVgSekQz
Postscript 2. Google now expanded this feature to allow multiple properties to export to one Google Cloud project:
Following feedback from the community, today we’re updating bulk data exports to allow multiple GSC properties to export to one Cloud project. To do so, you need to customize your dataset name when setting up your export to have a unique dataset name for each export. https://t.co/AdSVgSeSG7
Related stories
New on Search Engine Land
About the author
Related topics
Get the daily newsletter search marketers rely on.
See terms.
Learn actionable search marketing tactics that can help you drive more traffic, leads, and revenue.
March 15-16, 2023: SMX Munich
Online Aug. 16-17: SMX Master Classes
Online Nov. 14-15: SMX Next
Start training now: SMX Advanced
Discover time-saving technologies and actionable tactics that can help you overcome crucial marketing challenges.
April 15-17, 2020: San Jose
Become a Data Champion By Mastering Marketing Analytics Automation
Why Consent and Compliance Matter With Programmatic Ads
From Zero to Hero: Apply Pillar-Based Marketing to Your SEO and Digital Campaigns to Drive Revenue
Enterprise Marketing Attribution and Performance Management Platforms: A Marketer’s Guide
Enterprise Account-Based Marketing Platforms: A Marketer’s Guide
Enterprise Marketing Work Management Platforms: A Marketer’s Guide
The Content Marketer’s Funnel
Meet your new AI-powered marketing assistant!
Get the must-read newsletter for search marketers.
Topics
Our events
About
Follow us
© 2023 Third Door Media, Inc. All rights reserved.
Third Door Media, Inc. is a publisher and marketing solutions provider incorporated in Delaware, USA, with an address 88 Schoolhouse Road, PO Box 3103, Edgartown, MA 02539. Third Door Media operates business-to-business media properties and produces events. It is the publisher of Search Engine Land the leading Search Engine Optimization digital publication.

source