Google Adds Ongoing Bulk Data Export From Search Console to Google BigQuery

Feb 21, 2023 - 7:44 am 1 by

Google Search Console Star API

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.

click for full size

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:

 

Popular Categories

The Pulse of the search community

Follow

Search Video Recaps

 
Google Core Update Coming, Ranking Volatility, Bye Search Notes, AI Overviews, Ads & More - YouTube
Video Details More Videos Subscribe to Videos

Most Recent Articles

Search Forum Recap

Daily Search Forum Recap: July 22, 2024

Jul 22, 2024 - 10:00 am
Google

Google Tests Link Icon Citations For AI Overviews

Jul 22, 2024 - 7:51 am
Google

Google Testing Save Button For AI Overviews

Jul 22, 2024 - 7:41 am
Bing Ads

New Microsoft Advertising Brand Lists For Performance Max Campaigns

Jul 22, 2024 - 7:31 am
Google

Google Knowledge Panels Using AI-Generated Images

Jul 22, 2024 - 7:21 am
Bing Search

Bing Tests Related Searches At Top - Below Search Bar

Jul 22, 2024 - 7:11 am
Previous Story: Google: Existing Sites Won't Drop In Rankings Just Because Its An Exact Match Domain