Data pipelines in minutes, 80+ sources to BigQuery, PostgreSQL, Redshift, and more

The query below joins normalized Meta Ads and GA4 data into a campaign performance table. Kondado replicates the raw tables automatically; you write the transformation:

-- Illustrative example. Table names follow Kondado's <source>_<table> pattern.
-- Confirm exact names at your destination after the first replication.
-- Replace <your_schema> with the schema configured at your pipeline destination.
SELECT
  m.date,
  m.campaign_name,
  m.spend,
  m.impressions,
  m.clicks,
  g.sessions,
  g.conversions,
  g.purchase_revenue,
  ROUND(m.spend / NULLIF(g.conversions, 0), 2) AS cost_per_conversion
FROM <your_schema>.metaads_campaign_performance m
LEFT JOIN <your_schema>.ga4_traffic_acquisition_daily g
  ON m.date = g.date
 AND m.utm_campaign = g.session_source_medium
WHERE m.date >= CURRENT_DATE - INTERVAL '30 days'
ORDER BY m.date DESC, m.spend DESC;

Illustrative example: joins Meta Ads spend with GA4 sessions and conversions per day. Adjust the join key (utm_campaign × session_source_medium or session_campaign, depending on how UTMs are parsed) and the interval (7d/30d/90d) to fit your analysis cycle.

Read SQL and transformation articles on the blog