Sync Google Display & Video 360 Data to BigQuery
Detrics loads Google Display & Video 360 into Google BigQuery on the schedule you set. The tables arrive clean, the history keeps growing, and you can query everything from SQL, Looker Studio, or Claude. We run the pipeline so you don't have to.
*Free 30-minute consultation
SELECT
advertiser,
SUM(metric_impressions) AS metric_impressions,
SUM(metric_clicks) AS metric_clicks,
SUM(metric_total_conversions) AS metric_total_conversions
FROM `your_project.marketing_data.google_display_video_360_campaign_performance_daily`
WHERE date >= DATE_SUB(CURRENT_DATE(), INTERVAL 30 DAY)
GROUP BY advertiser
ORDER BY metric_impressions DESC
LIMIT 10Why send Google Display & Video 360 data to BigQuery?
Ad creatives that never expire
Creative URLs expire. Detrics archives your campaign images and videos permanently.
History without limits
Platform APIs cap how far back you can query. In BigQuery every Google Display & Video 360 sync is stored across its 2 tables, so you accumulate years of your own history.
One warehouse for everything
Join Google Display & Video 360 with the rest of your platforms in one place, no copy-pasting between sheets.
Ask Claude about it
With your data in BigQuery, Claude can answer business questions about Google Display & Video 360 in plain language.
Google Display & Video 360 tables in BigQuery
This is what Detrics creates for Google Display & Video 360: 2 preset tables with scheduled syncs, plus any custom one you define.
Campaign Performance
advertiser_overview_dailyDisplay campaign performance insights
campaign_performance_dailyAd inventory and placement metrics
From Google Display & Video 360 to your warehouse
Connect your account once. Detrics handles schemas, syncs, and backfills.
Connect your first datasource
Link any of 32+ marketing and ecommerce platforms in a couple of clicks.
Set up your destination
Point Detrics at your BigQuery project and dataset. We write the SQL and handle the setup for you.
Create your transfer
Choose what to sync and how often. Detrics builds and runs the pipeline for you.
Real-time data, forever
Your data lands in the warehouse and stays fresh automatically. We handle the syncing, the maintenance, and every API update for you.
In the demo we set everything up for you and save you hours.
Then ask Claude about it
With Google Display & Video 360 in BigQuery, the Detrics MCP server lets you run queries in plain language. MCP access is included with every BigQuery plan.
Detect anomalies in my Google Display & Video 360 spend over the past 14 days
Which Google Display & Video 360 campaigns should I pause this quarter?
What was my Google Display & Video 360 spend last month vs. the month before?
Every Google Display & Video 360 field, on demand
- Preset tables curated by our team
- Custom tables with any field combination
- Incremental syncs that only load new data
- Automatic backfill of up to 12 months of history
Get Google Display & Video 360 into your warehouse this week
*No credit card required
- Setup guided by our team, in your own GCP project
- Historical backfill included (up to 12 months)
- Query it from Looker Studio, Sheets, or Claude afterwards