Connecting Search Console

  1. Open Connections from the account menu.
  2. Click Connect next to Search Console.
  3. Sign in with your Google account and grant access.
  4. Select your verified site property (requires owner or full access).
  5. Click Enable to start syncing.

Available Data

TableKey Columns
Search Performancequery_date, query, page, country, device, clicks, impressions, ctr, position
URL Inspectioninspected_date, url, index_verdict, coverage_state, robotstxt_state, indexing_state, page_fetch_state, last_crawl_time, crawled_as, google_canonical, user_canonical, mobile_verdict, rich_results_verdict
Site Infosite_url, permission_level, last_synced_at

Key Metrics

  • CTR — Stored as a decimal (0-1), not a percentage. 0.05 = 5%.
  • Position — Lower is better. Position 1 = top of search results.
  • Index Verdict — PASS means the page is indexed, FAIL means it's not.

Example Questions

  • "What are our top search queries by clicks?"
  • "Show me average position trend for the last 90 days"
  • "Which pages have the most impressions but low CTR?"
  • "How many pages are indexed vs not indexed?"
  • "Show me crawl errors from the last week"

GA4 vs Search Console Data

  • GA4 "google" traffic includes ALL Google traffic (organic, paid, YouTube, Gmail, Discover).
  • Search Console only counts organic search clicks.
  • These numbers will not match — this is expected.
  • For organic search analysis, Search Console is more accurate.

Notes

  • You must have owner or full user access to the Search Console property.
  • CTR values are 0-1 decimals (multiply by 100 for percentage).
  • BigQuery uses INTERVAL N DAY (singular) — not DAYS or MONTHS.