{"id":10152,"date":"2026-08-23T08:26:00","date_gmt":"2026-08-23T06:26:00","guid":{"rendered":"https:\/\/www.lukaswojcik.com\/blog\/?p=10152"},"modified":"2026-11-18T12:38:56","modified_gmt":"2026-11-18T11:38:56","slug":"combining-data-in-looker-studio-avoiding-incorrect-totals-and-duplicate-rows","status":"publish","type":"post","link":"https:\/\/www.lukaswojcik.com\/blog\/en\/digital-analytics\/combining-data-in-looker-studio-avoiding-incorrect-totals-and-duplicate-rows\/","title":{"rendered":"Combining Data in Looker Studio: Avoiding Incorrect Totals and Duplicate Rows"},"content":{"rendered":"<p>Data blending combines tables from several sources in a chart. A join links their rows using matching values, such as the same date and campaign ID. Plausible totals can still be wrong when a join repeats values, drops unmatched keys or combines incompatible metrics. A reliable review checks both individual keys and totals.<\/p>\n\n<p>Three stages matter: each table is grouped by its selected dimensions, the resulting rows are joined, and the chart can aggregate the joined result again. Table filters, date ranges and chart filters must also be checked. The final number is not determined by the join type alone.<\/p>\n\n<figure class=\"lw-diagram\"><img decoding=\"async\" src=\"https:\/\/www.lukaswojcik.com\/blog\/wp-content\/uploads\/diagrams\/dia-10152-blend-tutorial-20261024-en.png?v=20261113\" width=\"1120\" height=\"580\" loading=\"lazy\" alt=\"One row per key is only the beginning: input filters, join matches and chart aggregation all affect the result.\"><figcaption>One row per key is only the beginning: input filters, join matches and chart aggregation all affect the result.<\/figcaption><\/figure>\n\n<h2>1. Define what one row represents<\/h2>\n\n<p>Before choosing fields, the intended row should be written down: one day, one campaign per day, or one order. The join key must represent that level of detail. A composite key can contain separate date and campaign fields; concatenation is unnecessary.<\/p>\n\n<p>If one date row contains 100 sessions and matches three campaign rows, the join produces three copies of that session value. A later SUM produces 300. The factor is three only for keys with exactly three matches. Across keys, the total depends on both metric values and match counts.<\/p>\n\n<p>One-to-many joins are not inherently invalid: a campaign total can intentionally accompany daily detail. The total must then be labelled and aggregated appropriately. AVG or MAX is not a universal deduplication rule and can lose contributions from other campaigns. Reducing both inputs to one row per key is a straightforward option when the chart requires a one-to-one comparison.<\/p>\n\n<h2>2. Choose a join for the reporting question<\/h2>\n\n<p>Left outer retains left-side rows and attaches matches from the right. Right outer reverses that choice. Inner retains matching pairs only. Full outer also retains unmatched rows from either side. Cross combines every row with every other row and requires no key.<\/p>\n\n<p>Full outer does not prevent repeated values and does not create dates absent from both inputs. A calendar with one row per required date can anchor left joins, provided all joins use that calendar date and later filters do not remove unmatched rows. In a full outer result, the displayed date may need IFNULL(left_date, right_date).<\/p>\n\n<p>Multiple joins are evaluated in order; later joins operate on earlier results. The first physical table is not the entire left input of every subsequent join. A blend supports at most five tables, including a calendar. Several independent charts can use separate blends; a chart needing more inputs may need upstream preparation.<\/p>\n\n\n\n<!-- lw-flux-illu 10152-a2 -->\n<figure class=\"lw-illu\"><img src=\"https:\/\/www.lukaswojcik.com\/blog\/wp-content\/uploads\/illustrationen\/flux-10152-a2-v8.webp\" width=\"1120\" height=\"630\" loading=\"lazy\" decoding=\"async\" alt=\"All saucers stay in the row, even the empty one, while cups without a saucer stand aside. A LEFT JOIN in a database works the same way: every row of the first table stays, and only matching rows are added.\"><figcaption>All saucers stay in the row, even the empty one, while cups without a saucer stand aside. A LEFT JOIN in a database works the same way: every row of the first table stays, and only matching rows are added.<\/figcaption><\/figure>\n\n\n<h2>3. Check keys and effective input rows<\/h2>\n\n<p>Date and date-time fields need compatible types and an explicit reporting timezone. Midnight conversion can place the same event on different days. LOWER and TRIM can normalize campaign labels only when the business meaning permits it. Distinct identifiers must not be merged merely because their formatting looks similar.<\/p>\n\n<p>A key can be prepared in the source or in a supported table-level calculated field. Calculations inside an individual blend table can reference only that table\u2019s fields. Calculations combining fields from different tables belong after the blend, for example in the chart.<\/p>\n\n<p>Record Count commonly counts underlying source records, not the number of pre-aggregated join rows. A one-to-one daily join can therefore show a count greater than one. A diagnostic table should expose every selected dimension, count rows per complete key and inspect missing keys. A connector timeout can produce an error; a blank chart alone does not identify the cause.<\/p>\n\n<h2>4. Name fields clearly without changing their meaning<\/h2>\n\n<p>Aliases such as sessions_a and sessions_b make formulas easier to review. The actual source field must still be selected correctly. Identical display names do not by themselves prove that the software silently calculated a wrong sum.<\/p>\n\n<p>Source metrics can be reaggregated after blending. SUM is suitable for additive values at the intended level; it is not a repair for duplicated rows or distinct-user counts. Automatic aggregation should be understood before being replaced. Two charts can reuse a blend at different levels when the metrics support that change.<\/p>\n\n<h2>5. Separate users, events and ratios<\/h2>\n\n<p>Adding user counts from regional properties counts property memberships, not necessarily distinct people. Likewise, daily distinct-user counts do not establish a monthly distinct count: one person visiting on Monday and Tuesday appears in both daily counts but should count only once for the month. Counts are additive only when the populations are known to be disjoint. Event exports alone do not solve identity across properties: deduplication needs a valid, consistently scoped identifier and a defined identity policy.<\/p>\n\n<p>For two non-overlapping sources with compatible definitions, a rate can be computed from summed components. In the following example, converted_sessions counts sessions with at least one qualifying outcome. Replacing that numerator with the number of events changes the meaning to events per session and may exceed 100 percent.<\/p>\n\n<p>Missing values are not automatically zero. A failed import, an unmatched key and a confirmed day without activity have different meanings. The formula below deliberately leaves incomplete data unresolved; zero substitution belongs only where the source contract establishes zero activity.<\/p>\n\n<figure style=\"--cbb-digits:2\" class=\"cbb cbb--wrap cbb--numbers wp-block-code-beautifier-block-code\" data-lang=\"plain\"><figcaption class=\"cbb-head\"><span class=\"cbb-lang\">Text<\/span><span class=\"cbb-actions\"><button type=\"button\" class=\"cbb-button cbb-button--wrap\" data-cbb-action=\"wrap\" aria-pressed=\"true\" title=\"Wrap long lines\"><svg aria-hidden=\"true\" focusable=\"false\" width=\"16\" height=\"16\" viewBox=\"0 0 16 16\"><path d=\"M2 4h12M2 8h9.5a2.5 2.5 0 0 1 0 5H8m0 0 1.5-1.5M8 13l1.5 1.5M2 12h3\" fill=\"none\" stroke=\"currentColor\" stroke-width=\"1.5\" stroke-linecap=\"round\" stroke-linejoin=\"round\"\/><\/svg><span class=\"cbb-sr\">Wrap long lines<\/span><\/button><button type=\"button\" class=\"cbb-button cbb-button--copy\" data-cbb-action=\"copy\" aria-label=\"Copy code\" data-cbb-status-done=\"Code copied to the clipboard.\" data-cbb-status-failed=\"Copying failed. The code is selected for copying with Ctrl+C or \u2318+C.\" data-cbb-status-noselect=\"Copying failed.\"><svg aria-hidden=\"true\" focusable=\"false\" width=\"16\" height=\"16\" viewBox=\"0 0 16 16\"><rect x=\"5.5\" y=\"5.5\" width=\"8\" height=\"8.5\" rx=\"1.5\" fill=\"none\" stroke=\"currentColor\" stroke-width=\"1.5\"\/><path d=\"M10.5 3.5V3A1.5 1.5 0 0 0 9 1.5H4A1.5 1.5 0 0 0 2.5 3v6.5A1.5 1.5 0 0 0 4 11h.5\" fill=\"none\" stroke=\"currentColor\" stroke-width=\"1.5\"\/><\/svg><span class=\"cbb-button-label\">Copy<\/span><\/button><\/span><\/figcaption><pre class=\"cbb-pre\" tabindex=\"0\" role=\"region\" aria-label=\"Code example: Text\"><code class=\"cbb-code language-plain\" style=\"counter-reset:cbb-line 0;\"><span class=\"cbb-line\">CASE\n<\/span><span class=\"cbb-line\">  WHEN SUM(\n<\/span><span class=\"cbb-line\">    CASE\n<\/span><span class=\"cbb-line\">      WHEN sessions_a IS NULL OR sessions_b IS NULL\n<\/span><span class=\"cbb-line\">        OR converted_sessions_a IS NULL\n<\/span><span class=\"cbb-line\">        OR converted_sessions_b IS NULL\n<\/span><span class=\"cbb-line\">      THEN 1 ELSE 0\n<\/span><span class=\"cbb-line\">    END\n<\/span><span class=\"cbb-line\">  ) &gt; 0 THEN NULL\n<\/span><span class=\"cbb-line\">  ELSE\n<\/span><span class=\"cbb-line\">    (SUM(converted_sessions_a) + SUM(converted_sessions_b))\n<\/span><span class=\"cbb-line\">    \/ NULLIF(SUM(sessions_a) + SUM(sessions_b), 0)\n<\/span><span class=\"cbb-line\">END<\/span><\/code><\/pre><span class=\"cbb-status\" role=\"status\"><\/span><\/figure>\n\n<p>This chart formula assumes one complete row per shared key in both inputs, disjoint populations, aligned periods and nonnegative session counts. Field names are example aliases. Any incomplete joined row leaves the result empty; a separate completeness check must also detect dates or keys absent from both sources. The numeric output is a fraction, displayed as a percentage.<\/p>\n\n<h2>6. Test with counterexamples<\/h2>\n\n<p>Suppose A has 100 sessions and 10 outcomes, while B has 900 sessions and 9 outcomes. The combined rate is 19\/1000 = 1.9%. If A matches once and B three times, a SUM after the join gives 37\/2800, about 1.32%. A numerator and denominator from the same source do not preserve the overall rate when match counts differ between keys.<\/p>\n\n<p>Equal grand totals are not proof of correctness. Original values A=100 and B=100 total 200; a result containing A twice and omitting B also totals 200. The comparison must include key coverage and individual values. Larger or smaller totals are clues, not unique diagnoses: dates, filters, metric scope and source updates can also differ.<\/p>\n\n<p>A useful acceptance check compares identical date ranges, filters and metric definitions in the original source and the blend, then inspects representative keys, unmatched keys and zero-denominator cases. All joined rows must be evaluated at the intended chart aggregation.<\/p>\n\n<div class=\"lw-faq\"><h2>Questions and answers<\/h2>\n\n<h3>Does a missing right-hand value become safe when the chart displays zero?<\/h3>\n\n<p>No. Display formatting does not establish a real zero. Match coverage and source completeness should be shown separately, and a ratio should remain unavailable if essential input is unknown.<\/p>\n\n<h3>Why can an extra dimension change a total?<\/h3>\n\n<p>An extra dimension can split a pre-aggregated row into several rows that share the join key. This can repeat a value from the other side. It need not change the number of rows when the new dimension has only one value per key; the actual data determines the effect.<\/p>\n\n<h3>What happens when a chart needs six sources?<\/h3>\n\n<p>The five-table limit applies to one blend, not to the entire report. Separate charts may use separate blends. If all six inputs are required in one calculation, an upstream joined table or view can provide one prepared source. A calendar also occupies a table slot.<\/p>\n\n<\/div>\n\n<div class=\"lw-quellen\"><h2>Sources<\/h2><ul><li><a href=\"https:\/\/docs.cloud.google.com\/data-studio\/how-blends-work\" target=\"_blank\" rel=\"noopener noreferrer\">Google: Tables, join types and conditions<\/a><\/li><li><a href=\"https:\/\/docs.cloud.google.com\/data-studio\/blending-tips-and-advanced-concepts\" target=\"_blank\" rel=\"noopener noreferrer\">Google: Order, pre-aggregation and filters<\/a><\/li><li><a href=\"https:\/\/docs.cloud.google.com\/data-studio\/about-calculated-fields\" target=\"_blank\" rel=\"noopener noreferrer\">Google: Calculated fields<\/a><\/li><li><a href=\"https:\/\/docs.cloud.google.com\/data-studio\/nullif\" target=\"_blank\" rel=\"noopener noreferrer\">Google: NULLIF<\/a><\/li><li><a href=\"https:\/\/docs.cloud.google.com\/data-studio\/ifnull\" target=\"_blank\" rel=\"noopener noreferrer\">Google: IFNULL<\/a><\/li><li><a href=\"https:\/\/docs.cloud.google.com\/data-studio\/trim\" target=\"_blank\" rel=\"noopener noreferrer\">Google: TRIM<\/a><\/li><li><a href=\"https:\/\/docs.cloud.google.com\/data-studio\/lower\" target=\"_blank\" rel=\"noopener noreferrer\">Google: LOWER<\/a><\/li><\/ul><\/div>","protected":false},"excerpt":{"rendered":"<p>Data blending groups each input, joins matching rows and can aggregate the result again. Examples explain repeated values, missing keys, distinct-user counts and weighted rates, including why equal totals alone do not prove correctness.<\/p>\n","protected":false},"author":1,"featured_media":33668,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[91297,91258,91353,91252],"class_list":["post-10152","post","type-post","status-publish","format-standard","hentry","category-digital-analytics","tag-data-quality","tag-google-analytics-4","tag-looker-studio","tag-web-analytics"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.1 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Combining Data in Looker Studio: Avoiding Incorrect Totals and Duplicate Rows | Lukas Wojcik<\/title>\n<meta name=\"description\" content=\"How a blend works \u2014 aggregate first, join second \u2014 what the five join types do, and why one extra dimension can multiply every number in the report.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.lukaswojcik.com\/blog\/en\/digital-analytics\/combining-data-in-looker-studio-avoiding-incorrect-totals-and-duplicate-rows\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Combining Data in Looker Studio: Avoiding Incorrect Totals and Duplicate Rows | Lukas Wojcik\" \/>\n<meta property=\"og:description\" content=\"How a blend works \u2014 aggregate first, join second \u2014 what the five join types do, and why one extra dimension can multiply every number in the report.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.lukaswojcik.com\/blog\/en\/digital-analytics\/combining-data-in-looker-studio-avoiding-incorrect-totals-and-duplicate-rows\/\" \/>\n<meta property=\"og:site_name\" content=\"Lukas Wojcik - Blog\" \/>\n<meta property=\"article:published_time\" content=\"2026-08-23T06:26:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-11-18T11:38:56+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.lukaswojcik.com\/blog\/wp-content\/uploads\/2026\/11\/flux-voll8-10152-10152.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"630\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Lukas Wojcik\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Lukas Wojcik\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"7 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.lukaswojcik.com\\\/blog\\\/en\\\/digital-analytics\\\/combining-data-in-looker-studio-avoiding-incorrect-totals-and-duplicate-rows\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.lukaswojcik.com\\\/blog\\\/en\\\/digital-analytics\\\/combining-data-in-looker-studio-avoiding-incorrect-totals-and-duplicate-rows\\\/\"},\"author\":{\"name\":\"Lukas Wojcik\",\"@id\":\"https:\\\/\\\/www.lukaswojcik.com\\\/blog\\\/#\\\/schema\\\/person\\\/895f7604f9b6b71aad9bba33af28d0f9\"},\"headline\":\"Combining Data in Looker Studio: Avoiding Incorrect Totals and Duplicate Rows\",\"datePublished\":\"2026-08-23T06:26:00+00:00\",\"dateModified\":\"2026-11-18T11:38:56+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.lukaswojcik.com\\\/blog\\\/en\\\/digital-analytics\\\/combining-data-in-looker-studio-avoiding-incorrect-totals-and-duplicate-rows\\\/\"},\"wordCount\":1282,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.lukaswojcik.com\\\/blog\\\/#\\\/schema\\\/person\\\/895f7604f9b6b71aad9bba33af28d0f9\"},\"image\":{\"@id\":\"https:\\\/\\\/www.lukaswojcik.com\\\/blog\\\/en\\\/digital-analytics\\\/combining-data-in-looker-studio-avoiding-incorrect-totals-and-duplicate-rows\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.lukaswojcik.com\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/11\\\/flux-voll8-10152-10152.png\",\"keywords\":[\"Data Quality\",\"Google Analytics 4\",\"Looker Studio\",\"Web Analytics\"],\"articleSection\":[\"Digital Analytics\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.lukaswojcik.com\\\/blog\\\/en\\\/digital-analytics\\\/combining-data-in-looker-studio-avoiding-incorrect-totals-and-duplicate-rows\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.lukaswojcik.com\\\/blog\\\/en\\\/digital-analytics\\\/combining-data-in-looker-studio-avoiding-incorrect-totals-and-duplicate-rows\\\/\",\"url\":\"https:\\\/\\\/www.lukaswojcik.com\\\/blog\\\/en\\\/digital-analytics\\\/combining-data-in-looker-studio-avoiding-incorrect-totals-and-duplicate-rows\\\/\",\"name\":\"Combining Data in Looker Studio: Avoiding Incorrect Totals and Duplicate Rows | Lukas Wojcik\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.lukaswojcik.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.lukaswojcik.com\\\/blog\\\/en\\\/digital-analytics\\\/combining-data-in-looker-studio-avoiding-incorrect-totals-and-duplicate-rows\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.lukaswojcik.com\\\/blog\\\/en\\\/digital-analytics\\\/combining-data-in-looker-studio-avoiding-incorrect-totals-and-duplicate-rows\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.lukaswojcik.com\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/11\\\/flux-voll8-10152-10152.png\",\"datePublished\":\"2026-08-23T06:26:00+00:00\",\"dateModified\":\"2026-11-18T11:38:56+00:00\",\"description\":\"How a blend works \u2014 aggregate first, join second \u2014 what the five join types do, and why one extra dimension can multiply every number in the report.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.lukaswojcik.com\\\/blog\\\/en\\\/digital-analytics\\\/combining-data-in-looker-studio-avoiding-incorrect-totals-and-duplicate-rows\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.lukaswojcik.com\\\/blog\\\/en\\\/digital-analytics\\\/combining-data-in-looker-studio-avoiding-incorrect-totals-and-duplicate-rows\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.lukaswojcik.com\\\/blog\\\/en\\\/digital-analytics\\\/combining-data-in-looker-studio-avoiding-incorrect-totals-and-duplicate-rows\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.lukaswojcik.com\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/11\\\/flux-voll8-10152-10152.png\",\"contentUrl\":\"https:\\\/\\\/www.lukaswojcik.com\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/11\\\/flux-voll8-10152-10152.png\",\"width\":1200,\"height\":630,\"caption\":\"Combining Data in Looker Studio: Avoiding Incorrect Totals and Duplicate Rows\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.lukaswojcik.com\\\/blog\\\/en\\\/digital-analytics\\\/combining-data-in-looker-studio-avoiding-incorrect-totals-and-duplicate-rows\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.lukaswojcik.com\\\/blog\\\/de\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Combining Data in Looker Studio: Avoiding Incorrect Totals and Duplicate Rows\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.lukaswojcik.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.lukaswojcik.com\\\/blog\\\/\",\"name\":\"Lukas Wojcik - Blog\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.lukaswojcik.com\\\/blog\\\/#\\\/schema\\\/person\\\/895f7604f9b6b71aad9bba33af28d0f9\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.lukaswojcik.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/www.lukaswojcik.com\\\/blog\\\/#\\\/schema\\\/person\\\/895f7604f9b6b71aad9bba33af28d0f9\",\"name\":\"Lukas Wojcik\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.lukaswojcik.com\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/07\\\/lw-x2.jpg\",\"url\":\"https:\\\/\\\/www.lukaswojcik.com\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/07\\\/lw-x2.jpg\",\"contentUrl\":\"https:\\\/\\\/www.lukaswojcik.com\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/07\\\/lw-x2.jpg\",\"width\":424,\"height\":636,\"caption\":\"Lukas Wojcik\"},\"logo\":{\"@id\":\"https:\\\/\\\/www.lukaswojcik.com\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/07\\\/lw-x2.jpg\"},\"sameAs\":[\"https:\\\/\\\/www.lukaswojcik.com\\\/blog\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Combining Data in Looker Studio: Avoiding Incorrect Totals and Duplicate Rows | Lukas Wojcik","description":"How a blend works \u2014 aggregate first, join second \u2014 what the five join types do, and why one extra dimension can multiply every number in the report.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.lukaswojcik.com\/blog\/en\/digital-analytics\/combining-data-in-looker-studio-avoiding-incorrect-totals-and-duplicate-rows\/","og_locale":"en_US","og_type":"article","og_title":"Combining Data in Looker Studio: Avoiding Incorrect Totals and Duplicate Rows | Lukas Wojcik","og_description":"How a blend works \u2014 aggregate first, join second \u2014 what the five join types do, and why one extra dimension can multiply every number in the report.","og_url":"https:\/\/www.lukaswojcik.com\/blog\/en\/digital-analytics\/combining-data-in-looker-studio-avoiding-incorrect-totals-and-duplicate-rows\/","og_site_name":"Lukas Wojcik - Blog","article_published_time":"2026-08-23T06:26:00+00:00","article_modified_time":"2026-11-18T11:38:56+00:00","og_image":[{"width":1200,"height":630,"url":"https:\/\/www.lukaswojcik.com\/blog\/wp-content\/uploads\/2026\/11\/flux-voll8-10152-10152.png","type":"image\/png"}],"author":"Lukas Wojcik","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Lukas Wojcik","Est. reading time":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.lukaswojcik.com\/blog\/en\/digital-analytics\/combining-data-in-looker-studio-avoiding-incorrect-totals-and-duplicate-rows\/#article","isPartOf":{"@id":"https:\/\/www.lukaswojcik.com\/blog\/en\/digital-analytics\/combining-data-in-looker-studio-avoiding-incorrect-totals-and-duplicate-rows\/"},"author":{"name":"Lukas Wojcik","@id":"https:\/\/www.lukaswojcik.com\/blog\/#\/schema\/person\/895f7604f9b6b71aad9bba33af28d0f9"},"headline":"Combining Data in Looker Studio: Avoiding Incorrect Totals and Duplicate Rows","datePublished":"2026-08-23T06:26:00+00:00","dateModified":"2026-11-18T11:38:56+00:00","mainEntityOfPage":{"@id":"https:\/\/www.lukaswojcik.com\/blog\/en\/digital-analytics\/combining-data-in-looker-studio-avoiding-incorrect-totals-and-duplicate-rows\/"},"wordCount":1282,"commentCount":0,"publisher":{"@id":"https:\/\/www.lukaswojcik.com\/blog\/#\/schema\/person\/895f7604f9b6b71aad9bba33af28d0f9"},"image":{"@id":"https:\/\/www.lukaswojcik.com\/blog\/en\/digital-analytics\/combining-data-in-looker-studio-avoiding-incorrect-totals-and-duplicate-rows\/#primaryimage"},"thumbnailUrl":"https:\/\/www.lukaswojcik.com\/blog\/wp-content\/uploads\/2026\/11\/flux-voll8-10152-10152.png","keywords":["Data Quality","Google Analytics 4","Looker Studio","Web Analytics"],"articleSection":["Digital Analytics"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.lukaswojcik.com\/blog\/en\/digital-analytics\/combining-data-in-looker-studio-avoiding-incorrect-totals-and-duplicate-rows\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.lukaswojcik.com\/blog\/en\/digital-analytics\/combining-data-in-looker-studio-avoiding-incorrect-totals-and-duplicate-rows\/","url":"https:\/\/www.lukaswojcik.com\/blog\/en\/digital-analytics\/combining-data-in-looker-studio-avoiding-incorrect-totals-and-duplicate-rows\/","name":"Combining Data in Looker Studio: Avoiding Incorrect Totals and Duplicate Rows | Lukas Wojcik","isPartOf":{"@id":"https:\/\/www.lukaswojcik.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.lukaswojcik.com\/blog\/en\/digital-analytics\/combining-data-in-looker-studio-avoiding-incorrect-totals-and-duplicate-rows\/#primaryimage"},"image":{"@id":"https:\/\/www.lukaswojcik.com\/blog\/en\/digital-analytics\/combining-data-in-looker-studio-avoiding-incorrect-totals-and-duplicate-rows\/#primaryimage"},"thumbnailUrl":"https:\/\/www.lukaswojcik.com\/blog\/wp-content\/uploads\/2026\/11\/flux-voll8-10152-10152.png","datePublished":"2026-08-23T06:26:00+00:00","dateModified":"2026-11-18T11:38:56+00:00","description":"How a blend works \u2014 aggregate first, join second \u2014 what the five join types do, and why one extra dimension can multiply every number in the report.","breadcrumb":{"@id":"https:\/\/www.lukaswojcik.com\/blog\/en\/digital-analytics\/combining-data-in-looker-studio-avoiding-incorrect-totals-and-duplicate-rows\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.lukaswojcik.com\/blog\/en\/digital-analytics\/combining-data-in-looker-studio-avoiding-incorrect-totals-and-duplicate-rows\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.lukaswojcik.com\/blog\/en\/digital-analytics\/combining-data-in-looker-studio-avoiding-incorrect-totals-and-duplicate-rows\/#primaryimage","url":"https:\/\/www.lukaswojcik.com\/blog\/wp-content\/uploads\/2026\/11\/flux-voll8-10152-10152.png","contentUrl":"https:\/\/www.lukaswojcik.com\/blog\/wp-content\/uploads\/2026\/11\/flux-voll8-10152-10152.png","width":1200,"height":630,"caption":"Combining Data in Looker Studio: Avoiding Incorrect Totals and Duplicate Rows"},{"@type":"BreadcrumbList","@id":"https:\/\/www.lukaswojcik.com\/blog\/en\/digital-analytics\/combining-data-in-looker-studio-avoiding-incorrect-totals-and-duplicate-rows\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.lukaswojcik.com\/blog\/de\/"},{"@type":"ListItem","position":2,"name":"Combining Data in Looker Studio: Avoiding Incorrect Totals and Duplicate Rows"}]},{"@type":"WebSite","@id":"https:\/\/www.lukaswojcik.com\/blog\/#website","url":"https:\/\/www.lukaswojcik.com\/blog\/","name":"Lukas Wojcik - Blog","description":"","publisher":{"@id":"https:\/\/www.lukaswojcik.com\/blog\/#\/schema\/person\/895f7604f9b6b71aad9bba33af28d0f9"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.lukaswojcik.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/www.lukaswojcik.com\/blog\/#\/schema\/person\/895f7604f9b6b71aad9bba33af28d0f9","name":"Lukas Wojcik","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.lukaswojcik.com\/blog\/wp-content\/uploads\/2026\/07\/lw-x2.jpg","url":"https:\/\/www.lukaswojcik.com\/blog\/wp-content\/uploads\/2026\/07\/lw-x2.jpg","contentUrl":"https:\/\/www.lukaswojcik.com\/blog\/wp-content\/uploads\/2026\/07\/lw-x2.jpg","width":424,"height":636,"caption":"Lukas Wojcik"},"logo":{"@id":"https:\/\/www.lukaswojcik.com\/blog\/wp-content\/uploads\/2026\/07\/lw-x2.jpg"},"sameAs":["https:\/\/www.lukaswojcik.com\/blog"]}]}},"_links":{"self":[{"href":"https:\/\/www.lukaswojcik.com\/blog\/wp-json\/wp\/v2\/posts\/10152","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.lukaswojcik.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.lukaswojcik.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.lukaswojcik.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.lukaswojcik.com\/blog\/wp-json\/wp\/v2\/comments?post=10152"}],"version-history":[{"count":8,"href":"https:\/\/www.lukaswojcik.com\/blog\/wp-json\/wp\/v2\/posts\/10152\/revisions"}],"predecessor-version":[{"id":33787,"href":"https:\/\/www.lukaswojcik.com\/blog\/wp-json\/wp\/v2\/posts\/10152\/revisions\/33787"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.lukaswojcik.com\/blog\/wp-json\/wp\/v2\/media\/33668"}],"wp:attachment":[{"href":"https:\/\/www.lukaswojcik.com\/blog\/wp-json\/wp\/v2\/media?parent=10152"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.lukaswojcik.com\/blog\/wp-json\/wp\/v2\/categories?post=10152"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.lukaswojcik.com\/blog\/wp-json\/wp\/v2\/tags?post=10152"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}