Search Console06:00
Written to 
fs_queries_by_day
Search Console to BigQuery
Queries, pages, clicks and position in your own dataset, on a schedule. Fixed date ranges let you load past months too, which Google's bulk export can't.
30 days of Plus, free, no card. Then one report keeps refreshing weekly.
Search ConsoleSearch Console06:01
Written to fs_pages_by_device
Search Console06:02
Written to fs_country_clicks
What lands in BigQuery
- Date, query, page, country, device and search appearance, with clicks, impressions, CTR and average position.
- Web search results.
- Finalised data only, so today is never included.
- Include Date and history builds up. Each run replaces only its own dates.
Search Console has a free bulk export to BigQuery, with storage and query costs on your Google Cloud bill past a free usage level. It starts from the day you set it up, with no history, and leaves out anonymised queries.
Connect your Google account from the Fresh Sheets sidebar and pick your site.
Which plans send to BigQuery
Pro and Max, and the free 30 days. Sending to BigQuery uses no extra refreshes: one run counts once, wherever it lands.
FAQ
Questions
Bulk export or Fresh Sheets?
Bulk export if you want everything from today onwards, raw. Fresh Sheets if you want a report you've shaped, with past dates included.
Why isn't today in the table?
Fresh Sheets only reads data Google has finalised, so figures don't shift after they land.
Other sources to BigQuery
Advertising
Send your Search Console data to BigQuery
BigQuery is included in the free 30 days, then on Pro and Max.