Marketing
Digital Ads Command
Google Ads, Meta Ads, LinkedIn Ads, and GA4 should resolve into one paid-media operating surface. BigQuery will become the durable truth layer once the connectors are live.
Executive Layer
This is the shape the Google Ads / paid dashboard should follow once the data lands.
Spend
--
Waiting on connected account data
Impressions
--
Waiting on connected account data
Clicks
--
Waiting on connected account data
CTR
--
Waiting on connected account data
Avg CPC
--
Waiting on connected account data
Conversions
--
Waiting on connected account data
Cost / Conv
--
Waiting on connected account data
ROAS
--
Waiting on connected account data
BigQuery Truth Layer
Paid, analytics, and future offline-conversion joins should land here before we trust cross-channel conclusions.
ad_accounts
Daily grains + connector freshness + account ownership will land here.
campaign_daily_fact
Daily grains + connector freshness + account ownership will land here.
ad_group_daily_fact
Daily grains + connector freshness + account ownership will land here.
keyword_daily_fact
Daily grains + connector freshness + account ownership will land here.
landing_page_fact
Daily grains + connector freshness + account ownership will land here.
conversion_action_fact
Daily grains + connector freshness + account ownership will land here.
Paid Channel Comparison
Compare or hide networks once data is live. For now, this is the connector posture and the dashboard slots each one will fill.
Meta Ads
No ad metrics imported
Google Ads
No ad metrics imported
Google Analytics 4
No sessions imported
LinkedIn Ads
No campaign analytics imported
Google Ads Campaign View
This is the exact critical-field shape the digital ads view should render once Google Ads data is flowing.
| Campaign | Status | Channel Type | Budget | Spend | Impressions | Clicks | CTR | Avg CPC | Conversions | Conversion Rate | Cost / Conv | Conversion Value | ROAS |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Awaiting connected campaigns | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- |
Campaign Data Flow
Campaign objects stay in Marketing, performance rolls here, and the dashboards reference the same campaign identity.
Connector Guardrails
We should not pretend these numbers are live until the connectors, BigQuery load, and freshness checks are all visible.