Your data, connected
Native BigQuery integration brings your Search Console and Analytics data into one view — with permanent retention and full granularity.
What connects
- Google Search Console via BigQuery: every query, every page, every country
- Google Analytics 4 via BigQuery: sessions, bounce rates, conversions per landing page
- Automated daily ETL at 6am UTC — yesterday's data flows in automatically
- No manual exports. No spreadsheet gymnastics.
- Domain-scoped BigQuery tables — multiple domains share one GCP project
- 180-day Supabase hot cache for fast dashboard queries
Keyword discovery
- GSC reveals queries driving traffic that you aren't tracking
- DeepLode surfaces them as opportunities with impressions, clicks, and avg position
- One-click to add any opportunity to tracking
- Revenue-weighted prioritization — high-impression untracked queries surface first
- Dismiss opportunities you don't want to track
- Bulk add actions with service line pre-classification
28,857
keyword opportunities found from our own Search Console data that we weren't tracking. Every untracked query is a revenue gap.
How it works
- 1
Upload service account key (stored encrypted in Supabase Storage)
- 2
Auto-discover GSC + GA4 datasets in your GCP project
- 3
Preview sample data to confirm it's the right domain
- 4
Activate — creates DeepLode tables in your BigQuery project
- 5
Daily sync runs automatically from 6am UTC onward
Data architecture
- Supabase for hot data (last 180 days, fast dashboard queries)
- BigQuery for cold data (permanent retention, deep analysis)
- AI agents query Supabase first, BigQuery for historical deep dives
- Multiple domains can share one GCP project