Set up the Search Console bulk data export to BigQuery on large sites

The Search Console interface exports at most 1,000 rows, and the Search Analytics API and the Looker Studio connector return up to 50,000 rows per day per site per search type. The bulk data export to BigQuery is the most complete query dataset available. Anonymized queries are always left out of report tables and are left out whenever a filter is applied, so filtered rows do not add up to the chart totals; in the export they stay as rows with an empty query.

Turn on the daily bulk data export in Search Console settings to a BigQuery project the team owns, set table expiration to fit the budget, and query the searchdata_site_impression and searchdata_url_impression tables. Keep anonymized rows in totals but exclude them (is_anonymized_query, or query = '') when ranking top queries, and tell any LLM or dashboard that analyses the data to do the same.

Automatisch entschieden, sobald Sie Google verbinden: die Search Console und, wo es passt, Merchant Center oder BigQuery.

Ein Zustimmungsdialog gewährt lesenden Zugriff auf die Search Console. Merchant Center und BigQuery werden nur bei Bedarf separat angefragt, und Regensbot liest dort nur. Stichproben aus der URL-Prüfung und Search Analytics ergänzen Googles eigene Sicht auf Ihre Seiten.

So funktionieren die UrteileWas Sie verbinden