Why Blend GA4 and BigQuery Data in Looker Studio?

Looker Studio’s native GA4 connector gives you access to aggregated, sampled data through the standard GA4 reporting interface. It is fast to set up and covers the basics well. But the moment you want to combine GA4 behavioral data with data that lives outside GA4—such as CRM revenue figures, advertising spend from multiple platforms, or raw BigQuery exports—you hit a wall. The native GA4 connector cannot join to your BigQuery tables. That is where Looker Studio’s blended data source feature becomes essential.

A blended data source in Looker Studio lets you merge two or more data sources using a common key, similar to a SQL JOIN. By blending your GA4 connector with a BigQuery data source, you unlock the ability to display GA4 traffic metrics side by side with unsampled BigQuery conversion data, ad spend from your own cost import tables, or any other data you have warehoused. The result is a single dashboard that tells the complete story—without requiring your marketing team to toggle between multiple tools or manually merge spreadsheets.

When to Use a Blend vs. a Single BigQuery Source

Before building a blend, it is worth considering whether you actually need one. If all the data you want to visualize already exists in BigQuery—including GA4 events exported via the native BigQuery Export—you can often create a single BigQuery data source in Looker Studio that queries everything in one SQL statement. A single source is simpler, faster, and easier to maintain than a blend.

Blends are most valuable when you need to combine a native GA4 connector (for its ease of use and real-time data) with a BigQuery source that contains supplementary data not available in GA4. Examples include: combining GA4 session data with your BigQuery cost import table to calculate cost-per-session by channel; merging GA4 user acquisition data with your CRM’s customer lifetime value data joined on email address; or comparing GA4 reported conversions against server-side conversion data to measure the gap that ad blockers create. In these scenarios, a blend is the right tool.

Step 1: Prepare Your BigQuery Table

Before building the blend in Looker Studio, make sure your BigQuery data is structured for joining. The most important requirement is a shared dimension that exists in both the GA4 data and the BigQuery data. The most common join keys are date (for daily aggregations), session ID (for session-level joins), and user_pseudo_id (for user-level joins).

If you are joining on date to display daily metrics side by side, your BigQuery table should have a column named something like date or event_date in the format YYYY-MM-DD or a DATE type. GA4’s native connector exposes a “Date” dimension that Looker Studio formats as YYYYMMDD by default, but you can reformat it to YYYY-MM-DD in the connector settings. Ensure the formats match before attempting the blend or you will get zero rows in the joined output.

Create a BigQuery view or table that pre-aggregates the data you want to show in Looker Studio. For example, if you want to show daily ad spend alongside GA4 sessions, create a view like:

CREATE OR REPLACE VIEW `your_project.your_dataset.daily_ad_spend` AS
SELECT
  FORMAT_DATE('%Y-%m-%d', date) AS report_date,
  campaign_name,
  SUM(cost) AS total_spend,
  SUM(clicks) AS total_clicks,
  SUM(impressions) AS total_impressions
FROM
  `your_project.your_dataset.campaign_costs`
GROUP BY
  report_date, campaign_name;

Step 2: Add Both Data Sources to Looker Studio

Open Looker Studio and create a new report. Click “Add data” in the toolbar. Add your GA4 property using the “Google Analytics” connector. Select your account, property, and the date range you want. Click “Add to Report.” Now click “Add data” again and this time select “BigQuery.” Authenticate with your Google account if prompted. Navigate to your project, then your dataset, and select the view or table you prepared in Step 1. Click “Add to Report.” Your report now has two data sources available.

Step 3: Create the Blended Data Source

In your Looker Studio report, click “Resource” in the top menu, then “Manage blended data,” then “Add a blend.” You will see a panel with multiple “Join another table” slots. In the first slot, select your GA4 data source. In the second slot, select your BigQuery data source. Now choose the Join Key—the dimension that connects the two sources. If you are joining by date, select “Date” from GA4 and your report_date field from BigQuery. Set the join type: Left Outer Join keeps all GA4 rows and brings in matching BigQuery data where available. Inner Join only shows rows that have matching data in both sources.

Next, select which dimensions and metrics you want from each source. From GA4 you might bring in: Date, Session Source/Medium, Sessions, Engaged Sessions, and Conversions. From BigQuery you might bring in: total_spend, total_clicks, and total_impressions. Click “Save” to create the blend. Looker Studio will create a new combined data source that appears in your report’s data source list as a blend.

Step 4: Build the Blended Dashboard Chart

Add a table or chart to your report and change its data source to the new blend. You now have access to fields from both sources in a single visualization. A useful starting chart is a table with these columns: Date, Session Source/Medium, Sessions (from GA4), Conversions (from GA4), Total Spend (from BigQuery), Cost Per Session (a calculated field: Total Spend / Sessions), and Cost Per Conversion (Total Spend / Conversions).

To create calculated fields in a blend, click the blend data source’s pencil icon to edit it, then click “Add a Field.” Type a formula combining fields from both sources. For Cost Per Conversion: total_spend / Conversions. Looker Studio will calculate this on the fly using the blended data, giving you a cost-per-conversion figure that was impossible to get from the GA4 connector alone (because the GA4 connector has no knowledge of your ad spend data).

Common Join Problems and How to Fix Them

The most common problem with Looker Studio blends is a date format mismatch. GA4’s native connector returns dates as YYYYMMDD (an 8-digit number like 20260417). If your BigQuery table stores dates as YYYY-MM-DD strings or as DATE types, the join will fail silently—you will see metrics from one source but nulls from the other. Fix this by casting the date in your BigQuery SQL: FORMAT_DATE('%Y%m%d', report_date) AS report_date to match GA4’s format, or by using Looker Studio’s date formatting options to change how GA4 presents the Date dimension.

Another common issue is granularity mismatch. If GA4 data is at the session level (one row per session) and your BigQuery data is at the daily level (one row per day), a direct join will create a many-to-one relationship that inflates metrics. Always pre-aggregate your BigQuery data to the same grain as the GA4 dimensions you are joining on. If you want to join by date AND source/medium, your BigQuery aggregation must also group by date and source/medium.

Advanced Use Case: GA4 vs BigQuery Conversion Discrepancy Dashboard

One of the most powerful applications of a GA4 + BigQuery blend is building a dashboard that compares GA4-reported conversions against server-side conversions tracked in BigQuery. This lets you quantify exactly how many conversions GA4 misses due to ad blockers and cookie consent refusals.

To build this, create a BigQuery view that counts server-confirmed purchase events per day, pulled from your GA4 BigQuery Export (which captures events that the browser GA4 tag may have missed if fired server-side). Blend this view with your GA4 native connector, joining on date and transaction ID where possible. Create a calculated field: Discrepancy Rate = (BigQuery Conversions - GA4 Conversions) / BigQuery Conversions. Display this as a scorecard and a trend line to show your stakeholders exactly what percentage of revenue GA4 is under-reporting and whether your server-side implementation is closing that gap over time.

Conclusion

Looker Studio’s blended data source feature bridges the gap between GA4’s user-friendly interface and BigQuery’s unlimited analytical power. By mastering blends, you can build dashboards that combine the real-time convenience of the GA4 connector with the accuracy and depth of BigQuery—giving your team a single source of truth that requires no manual data wrangling. Start with a simple date-based blend of GA4 sessions and BigQuery ad spend, get comfortable with join keys and calculated fields, and you will find yourself building increasingly sophisticated dashboards that answer questions no single-source connector can touch.