In Feb 2023, Google announced a new feature called ‘Bulk Data Export’ that allows you to schedule a daily export of your Search Console data to your BigQuery project.
By using the Search Console Bulk Data Export feature, I am able to unlock millions of new organic search keywords in my BigQuery project.
Table of Contents
- Limitations of Google Search Console Keywords data
- Prerequisites for sending Search Console data to BigQuery
- How to set up a new bulk data export?
Limitations of Google Search Console Keywords data
GA4 hardly provides any keyword data on its own. The organic keywords data provided by Google Search Console User Interface (UI) is also limited.
Following are the top limitations of the search console with regard to the keywords data:
1) With or without filters applied, the maximum number of rows of data viewable at a time in the Search Console UI is 1,000 rows.
2) Search Console UI reports only top data rows and not all data rows.
3) Search Console keeps data for the last 16 months. But when I started exporting search console data to BigQuery, in just a couple of weeks, I got access to approx. 6.9 million organic search keywords:
The Search Console BigQuery integration allows access to more keyword data than Search Console UI ever will.
If you are not exporting search console data to BigQuery, you are missing out big time.
Prerequisites for sending Search Console data to BigQuery
Before you can send Google Search Console data to your BigQuery project: