Validate a Google Search Console Bulk Export in BigQuery
After setting up a bulk export, use a small slice of data to verify the project, dataset and date coverage. Build the dashboard on an aggregate query that respects the table's grain.
Worked example
Illustrative rollup of two rows for one page and date
2026-10-15 /catalog/lanterns → 3 clicks, 50 impressions 2026-10-15 /catalog/lanterns → 2 clicks, 30 impressions Grouping = Same URL and data_date, matching search type Expected totals = 5 clicks, 80 impressions, 6.25% CTR
Steps
- Use Google's setup guide to configure the destination and grant the required dataset export permissions. Record the chosen property, project and dataset.
- Check the export log and identify a date that has completed. For page-level reporting, inspect the URL impression table.
- Aggregate clicks and impressions by data date and URL, then calculate click-through rate from the resulting totals. Limit the query to a defined date range.
- Compare one URL with the same date, property and search type in Search Console. Record any differences in aggregation or coverage before sharing a dashboard.
What to check
- Check export completeness in the log. A missing partition should appear as unavailable in reporting.
- Keep anonymized-query handling explicit. A page rollup and a report that excludes anonymized rows can differ.