# Search Console bulk export

Category: [Analytics & Measurement](https://seo-geo-glossary.com/en/glossary/category/analytics-measurement/) › [Search Console](https://seo-geo-glossary.com/en/glossary/category/analytics-measurement/search-console/) · Also known as: BigQuery

The **Search Console bulk export** is a Google feature that schedules a daily export of a property's performance data to BigQuery, Google's cloud data warehouse. Once the data is there, it can be queried with SQL and kept beyond the window the Search Console interface shows.

## How does the export work?

Google describes the export as containing all performance data available for the property, with the exception of anonymized queries. It runs daily. According to Google's setup guide, the first export arrives within 48 hours of setup. The export creates three tables: `searchdata_site_impression` for property-level data, `searchdata_url_impression` for URL-level data and `ExportLog` for export status.

The reference also describes a field `is_anonymized_query`. Rare queries are flagged with it, and the query field is then null. Google's pages are not fully consistent on whether such rows appear in the export, so check the tables before relying on totals.

The export only collects data going forward. For data from before the setup, Google's setup guide points to the Search Console API or the reports, and Google's John Mueller said in 2023 that no historical export is planned.

## How much more data does the export contain?

A single-day comparison by searchVIU (2023) showed that the gap grows with site size. For a large site, the export held about 160,500 distinct queries and 19,212 URLs, while the interface stopped at 1,000 rows and the API query used in the test returned 5,000. For a small site with 119 URLs and 1,437 queries, the API and the export returned the same numbers. On that day, 88% of the large site's queries had just one impression.

## Example

A team wants to compare clicks by page template over two years. The interface covers a limited window. Starting the export now and querying the BigQuery tables later builds that longer record from day one. (Invented example.)

## Related terms

- [Google Search Console](https://seo-geo-glossary.com/en/glossary/google-search-console/index.md)
- [Performance report](https://seo-geo-glossary.com/en/glossary/performance-report/index.md)
- [Search Console API](https://seo-geo-glossary.com/en/glossary/search-console-api/index.md)
- [Anonymized queries](https://seo-geo-glossary.com/en/glossary/anonymized-queries/index.md)
- [Search Console property](https://seo-geo-glossary.com/en/glossary/search-console-property/index.md)

## More on the searchVIU blog

- [Get more detailed Google Search Console data using the new BigQuery export](https://www.searchviu.com/en/google-search-console-export-data-to-bigquery/)

## Sources

- [Bulk data export overview – Search Console Help](https://support.google.com/webmasters/answer/12918484)
- [Set up a bulk data export – Search Console Help](https://support.google.com/webmasters/answer/12917675)
- [Table guidelines and reference – Search Console Help](https://support.google.com/webmasters/answer/12917991)
- [Google: No Plans For Historical Data With Search Console Bulk Data Export – Search Engine Roundtable (May 2023, secondary)](https://www.seroundtable.com/historical-data-google-search-console-to-bigquery-bulk-data-export-35388.html)
- [Search Console Data Export to BigQuery – happtiq (secondary)](https://www.happtiq.com/blog/search-console-data-export-to-bigquery)
- [Get more detailed Google Search Console data using the new BigQuery export – searchVIU blog (2023)](https://www.searchviu.com/en/google-search-console-export-data-to-bigquery/)

---

Last updated: October 8, 2026
URL: https://seo-geo-glossary.com/en/glossary/search-console-bulk-export/