Eight Steps to Cleaner Data in Google Analytics

Image for post
Image for post

1. Secure your Site

2. Tag your Sources

Image for post
Image for post
Default Channel Grouping showing Other channel with misplaced traffic
Image for post
Image for post
Referral source showing missing Medium tag
Image for post
Image for post
New channel to sort paid social campaigns

3. Update Organic Search

Image for post
Image for post
Misplaced organic search traffic sitting in Referral channel
Image for post
Image for post
Example: Organic Search Source filter

4. Normalize your Data on the Fly

Image for post
Image for post
Example: New filter to normalise all campaign names in lowercase
Image for post
Image for post
Example: New filter to normalize path paths to lowercase
Image for post
Image for post
Example: Search and Replace filter to combine all Facebook traffic as a single source
Image for post
Image for post
Example: How to normalise data in Google Tag Manager

5. Exclude Internal Traffic

Image for post
Image for post
Example: IP address exclusion filter

6. Block the Bots & Spiders

Image for post
Image for post
Example: Basic bot filtering in Google Analytics

Exorcise your Ghosts

Image for post
Image for post
Example: Filter to remove ghost spam

ISP Organisation Networks

Image for post
Image for post
Example: Filter to remove bots from common Internet Service Providers

Watch your Language

Image for post
Image for post
Example of bot traffic with language disguised as c
Image for post
Image for post
Example of bot traffic with special messages
Image for post
Image for post
Example: Filter to remove language spam

Eliminate Fake Referral Spam

Image for post
Image for post
Example: Referral Source Report in Google Analytics with Bounce Rate filter set to 100%
Image for post
Image for post
Example: Custom Report in Google Analytics with Bounce Rate filter set to 100%
Image for post
Image for post
Example: Exclusion filter to remove fake referral spam
Image for post
Image for post
Example: A segment template to filter historical data using scripts provided by Carlos Escalera
Image for post
Image for post
Example: Side by side of data with Clean segment applied

7. Remove Anomalies

Image for post
Image for post
Example: Month over month comparison with data containing anomalies
Image for post
Image for post
Example: Source of anomaly showing high number of Transactions & low Avg. Order Value
Image for post
Image for post
Example: True month over month comparison with anomalies removed

8. Remove Duplicate Transactions

Image for post
Image for post
Example: A custom report to check for duplicate transactions

Ecommerce & Data Driven Executive and Mentor @ Founders Institute Vancouver & Futurepreneur Canada

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store