Creating Looker Studio blended data sources combining GA4 and Google Ads unlocks unified reporting that neither platform provides alone. Instead of switching between GA4’s engagement data and Google Ads’ cost and conversion data, blended sources let you visualize ROAS, CPL, and session-to-conversion rates in a single dashboard. This step-by-step guide covers the complete setup process.
What Are Blended Data Sources?
Blended data sources in Looker Studio merge two or more data connections using a common join key—typically date, campaign name, or both. When you blend GA4 and Google Ads data, you combine GA4’s post-click behavior data (sessions, engagement, conversions) with Google Ads’ paid data (impressions, clicks, cost, CTR). This produces a unified dataset that shows the complete paid search funnel in one view.
Step-by-Step Setup
Step 1: In Looker Studio, open your report and click “Add data.” Add your GA4 property as the first data source. Step 2: Add Google Ads as your second data source—connect via your Google account and select the correct account/campaign. Step 3: Click on any chart, then in the right panel click “Blend data.” Select both data sources. Step 4: Set the join key—use Date as the primary join dimension for time-series analysis, or use Campaign Name for campaign-level comparison. Step 5: Set join type to Left Outer (keeps all GA4 rows even if no matching Ads data exists).
| Join Key | Best For | Limitation |
|---|---|---|
| Date | Daily trend analysis | Can’t break down by campaign |
| Campaign Name | Campaign comparison | Names must match exactly |
| Date + Campaign | Full granularity | Requires consistent naming |
Key Calculated Fields for Blended Reports
Once your Looker Studio blended data sources GA4 Google Ads blend is configured, create calculated fields for the most important unified metrics. ROAS: Revenue (GA4) ÷ Cost (Google Ads). CPL: Cost ÷ Conversions. Conversion Rate: Conversions ÷ Sessions × 100. These fields combine data from both sources in a single formula—the power of blending made tangible.
// Looker Studio calculated fields for blended GA4 + Google Ads:
// ROAS (Return on Ad Spend)
SUM(Revenue) / SUM(Cost)
// Cost Per Session
SUM(Cost) / SUM(Sessions)
// Paid Conversion Rate
SUM(Conversions) / SUM(Sessions) * 100
// Revenue Per Click
SUM(Revenue) / SUM(Clicks)FAQ
Why do blended metrics sometimes show N/A? N/A appears when the join key doesn’t find matching rows in both sources. Check that your campaign names or dates exist in both GA4 and Google Ads data for the selected date range. Can I blend more than two data sources? Yes—Looker Studio supports up to 5 data sources in a single blend. Will blended data slow down my dashboard? Yes, blends increase query time. Cache your data sources and use date range filters to limit data volume for faster loads.
Conclusion
Mastering Looker Studio blended data sources combining GA4 and Google Ads transforms your reporting from fragmented channel views to a unified performance picture. By joining on date or campaign name, adding calculated ROAS and CPL fields, and building cross-channel funnels, you can answer the questions that matter most: which campaigns drive quality traffic, which convert efficiently, and where to invest your next budget dollar.