DSP Feeds
ad_id, impressions
clicks, spend_usd
Social Ads
campaign_id
engagements, cost
CRM Data
customer_id
conversions, LTV
SELECT
s.campaign_id,
SUM(d.spend_usd),
COUNT(c.conv_id)
FROM ad_feeds s
JOIN crm_events c
ON s.uid = c.uid
GROUP BY 1;
Status: ACTIVE
Latency: 12ms
Rows: 1,240,800
CAMPAIGN ROILIVE
| Channel | Spend | ROAS |
|---|
| Programmatic | $14.2k | 3.8x |
| Paid Social | $28.5k | 4.1x |
| Search Ads | $9.1k | 2.9x |
ATTRIBUTIONMTA
| Touchpoint | Convs | Share |
|---|
| First Touch | 1,420 | 35% |
| Last Touch | 1,890 | 47% |
| Linear Mid | 730 | 18% |