Looker Studio Blend & Join Planner

Save tool

A blend in Looker Studio does not add tables, it joins them. If the right side holds more than one row per key, every row on the left is repeated and its metrics are counted several times. The arithmetic below shows that before the chart does.

Left table

Name Rows Distinct values of the join key

Right table

Name Rows Distinct values of the join key

Join type

Share of left keys found on the right, in percent

Metric of the left table (sum)

Join fields

Articles that explain this

Analysing Cookie Consent in GA4: Building Reports with BigQuery and Looker Studio Tutorials
Analysing Google Ads and Meta Ads Together: Building a Looker Studio Dashboard Tutorials
Combining Data in Looker Studio: Avoiding Incorrect Totals and Duplicate Rows Digital Analytics

Other tools

GA4 Anomaly Detector
GA4 Channel Grouping & Unassigned Debugger
GA4 Thresholding and Behavioural Modelling Checker
GA4 Bot Detector
JSON-LD Structured Data Generator & Checker
GA4 Measurement Protocol JSON Validator: see every fault at once
GA4 Advisor & runReport Verifier
Report Date Coverage Checker
GA4 Parameter Analyser
GA4 Measurement Protocol Payload Builder

All 145 tools

Combining Data in Looker Studio: Avoiding Incorrect Totals and Duplicate Rows
Analysing Cookie Consent in GA4: Building Reports with BigQuery and Looker Studio
Analysing Google Ads and Meta Ads Together: Building a Looker Studio Dashboard
Automated Data Quality Alerts for GA4 with Looker Studio & BigQuery
Unassigned Visits in GA4: Finding and Fixing Missing Channel Attribution
Grouping GA4 Visits by Origin: Understanding Sources, Media and Channel Rules
Why GA4 Reports Have Missing Data: Privacy Thresholds, Sampling and Other Limits
Counted or Estimated? Understanding Four Kinds of Number in Conversion Reports
How GA4 Estimates Missing Visits: Requirements and Limits of Behavioural Modelling
GA4 Hostname Filters: Testing, Spam Limits and Historical Analysis

Looker Studio Blend & Join Planner

Toolbox feedback

Articles that explain this

Other tools

Related articles

Privacy · Newsletter

Looker Studio Blend & Join Planner

Articles that explain this

Other tools

Related articles

Fresh ideas in your inbox