Google has just added a new feature to export your data in bulk, on an ongoing basis, from Google Search Console to Google’s BigQuery. Daniel Waisberg from Google said on Twitter, “I have been dreaming about this for a long time, so excited to see it live.”
You can initiate a daily export of all your Google Search Console property performance data to BigQuery using this new feature. This is a daily export and includes all the daily data used by Google Search Console to generate the Search Console performance reports you see in the web interface. The data is exported to Google BigQuery, where you can run SQL queries for advanced data mining and other data analytics.
Google said that this feature is useful for large sites with many brand or other unusual queries that are beyond the 50,000 daily row limit of the API, and performance data for large sites, which can reach gigabytes within months.
“To configure a new report, you’ll need to prepare your BigQuery account to receive the data and set up your details in the Search Console settings. Check the Help Center for a step-by-step guide,” Google wrote.
Note, the anonymized queries are not included in this export. More details on Search Console export options over here.
Forum discussion at Twitter.
Update: On February 28th, Google opened up this feature to all:
We're happy to let you know that Bulk data exports are now available to everyone. Enjoy! 📊📈 https://t.co/AdSVgSekQz
— Google Search Central (@googlesearchc) February 28, 2023
We're happy to let you know that Bulk data exports are now available to everyone. Enjoy! 📊📈 https://t.co/AdSVgSekQz
The content at the Search Engine Roundtable are the sole opinion of the authors and in no way reflect views of RustyBrick ®, Inc
Copyright © 1994-2023 RustyBrick ®, Inc. Web Development All Rights Reserved.
This work by Search Engine Roundtable is licensed under a Creative Commons Attribution 3.0 United States License. Creative Commons License and YouTube videos under YouTube’s ToS.
