GA4 Report Cleaner
Paste a GA4 or Looker Studio export and merge rows that are the same campaign written differently, with merged totals, an original-to-clean list and a Looker Studio field.
Builders prevent bad tagging in new links, but the damage is already in old reports: one campaign split across Spring_Sale, spring-sale and SPRING-SALE. This tool reads a pasted or uploaded export, groups rows that match once capitals, spaces and separators are ignored, adds up only the columns that can be added, and hands back a clean table plus the mapping to apply it elsewhere.
Case study
Problem
GA4 treats Spring_Sale, spring-sale and SPRING-SALE as different values. One campaign shows up as three rows, each looking much smaller than the whole, and nobody sees its real size until someone merges them by hand.
Approach
Detect the label columns from the header, reduce each label to an identity that ignores capitals, spaces and separators, group on it, and report the groups that contain more than one spelling. Alias short source names such as fb to facebook.
Key decisions
- Add up only columns that are additive. Summing engagement rate would produce a wrong number that looks right.
- Never touch GA4. The tool says plainly that it cleans a copy of the report; the fix for the cause is consistent tagging.
- Genuinely different names are left alone. Merging spring-sale with spring-promo would hide real differences.
On measurable results
No usage data yet. This is a self-initiated tool, not a deployed one.
Highlights
- Fully client-side: the report is read in the browser and never uploaded
- Sums only additive columns and says which rate and average columns it left out, instead of adding numbers that cannot be added
- Outputs a merged table, an original-to-clean list and a Looker Studio calculated field
- Understands GA4 exports, including the comment lines GA4 writes above the table
Open now · reply within 24 hours
Need something like this built?
I take on freelance and contract frontend work, remote, for clients worldwide.
Prefer email? hello@devstash.me
What happens next
- 1
You write
A few lines on the goal, the deadline and where the traffic comes from.
- 2
I reply within 24 hours
With questions, or a quote if the scope is already clear.
- 3
We agree the scope
A written scope and a fixed quote before any work starts.