get_campaign_downstream_roi
Compare campaign ROI across three measurement layers: platform conversions, traffic metrics, and revenue. Includes MTA attribution comparison with date and campaign filters.
Instructions
Compare campaign performance across three measurement layers using the v_reporting_campaign_roi BigQuery view:
• Platform layer — ad-network pixel conversions and platform CPA
• Traffic layer — paid sessions, unique visitors, and web conversion events via GA4
• Revenue layer — CRM leads, MQLs, Closed-Won count, pipeline ARR, and revenue ROAS
Also includes MTA attribution comparison (attributed ROAS vs. platform delta).
This view aggregates all-time metrics per campaign (no date windowing inside the view). Use start_date/end_date to filter on when campaign spend activity started/ended. Results are capped at 150 rows. Requires PAID_MEDIA_GCP_PROJECT and PAID_MEDIA_BQ_DATASET.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| end_date | No | ||
| platform | No | ||
| start_date | No | ||
| campaign_id | No |