Analytics

How to Find Duplicate Transactions in Google Analytics

See how to create a report in Google Analytics that shows your total % of duplicate transactions.

Brad Redding

Brad Redding is the Founder & CEO of Elevar. Specializing in analytics, tracking, GTM, and conversion optimization.

Have you received a Google Analytics audit that shows you have duplicate transactions being recorded?

Or do you want to see how accurate your Google Analytics transaction data is and ensure there isn’t any double counting occurring?

Chances are if you’re on a major eCommerce platform like Shopify, Magento, BigCommerce, or others then you are afflicted with duplicate transaction hits being sent to Google Analytics.

Here is how to create a report to view duplicate transactions in Google Analytics:

Step 1: Create New Report in GA with Transactions & Transaction ID:

Inside of Google Analytics > Customization > Create Custom Report >

Add “Transactions” as metric and “Transaction ID” as dimension:

duplicate transaction report in google analytics

Step 2: Filter Report for Transactions > 1

Once you’ve saved this new report then you can click the Advanced option to filter the report by transactions > 1:

set filter for transactions greater than 1

Step 3: View Total % of Duplicate Transactions within Timeframe

Once you apply the filter then you’ll see a list of all transaction IDs and the total # of transaction hits sent to GA:

view percentage of dupe transactions

That’s it – you now have a report that shows the total % of duplicate transactions within your Google Analytics account.

In this example 5% is extremely high.

You might be asking: why do these exist and how do I fix them?

Unfortunately it’s not an easy answer that applies to all stores.

For example if you are sending cancellation hits to Google Analytics then you will have multiple transactions for a single transaction ID which may be legitimate.

If I find a way to fix this across all eCommerce stores within a platform I’ll be sure to update here 🙂

Related Articles:

More Marketing & Analytics Tips

Join our email where we share our best marketing and analytics tips.

We respect your inbox.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may also like