DSP Feeds
ad_id, impressions
clicks, spend_usd
Social Ads
campaign_id
engagements, cost
CRM Data
customer_id
conversions, LTV
SQL Engine
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
ChannelSpendROAS
Programmatic$14.2k3.8x
Paid Social$28.5k4.1x
Search Ads$9.1k2.9x
ATTRIBUTIONMTA
TouchpointConvsShare
First Touch1,42035%
Last Touch1,89047%
Linear Mid73018%