REPORT CLEANER

One campaign, three rows?

Paste an export from GA4 or Looker Studio. Rows that are the same campaign written differently are merged, with totals and a list you can paste back into your sheet. Free, and nothing leaves your browser.

Copy the table from GA4 or Looker Studio, or choose the CSV you exported. It needs a column named like Session campaign, Session source / medium, source, medium or campaign, and may have numbers such as Sessions.

Clean names use

Why rows split and how to stop it: read the guide.

FAQ

Report cleaner questions

Why rows split, what is merged, and what stays the same in GA4.

6 questions

Why is one campaign split across several rows?

GA4 treats Spring_Sale, spring-sale and SPRING-SALE as three different values, so one campaign shows up as three rows and each looks smaller than the whole. The cleaner finds rows that match once capitals, spaces and separators are ignored.

Does it change my data in GA4?

No. GA4 keeps the values it received. The tool cleans your copy of the report and gives you the mapping, so your sheet or Looker Studio report can show merged rows. Fixing the cause means tagging links consistently.

What does it add up?

Columns that can be added: sessions, engaged sessions, new users, events, conversions, key events, views, clicks, impressions, cost, revenue, purchases, transactions and orders. Rates and averages, such as engagement rate, cannot be added. Total users and active users cannot either, because one person can appear under two spellings and would be counted twice. These are listed as left out.

How do I use the Looker Studio field?

Copy it, add a calculated field in your Looker Studio data source, paste the formula, and use that field instead of the original one in your charts. It maps each split spelling to the clean one.

Is my report uploaded anywhere?

No. The report is read in your browser and nothing is sent or stored. The example is made-up data.

Will it catch every kind of split?

It catches capitals, spaces, hyphens, underscores and dots, and common short source names such as fb, ig and li. Two genuinely different spellings, such as spring-sale and spring-promo, are different values and are left alone.

Free tool by Adesh Shukla — fully client-side, nothing you enter here is sent anywhere.