One of the important things we do after setting up enhanced ecommerce tracking in Google Analytics is to verify the ecommerce data. Verifying data means to make sure the transactions data is accurate. One of the things we test while verifying ecommerce data is to look for duplicate transactions.
There are multiple reasons which causes duplicate transactions in Google Analytics. One of the reason is when a user can access the order confirmation page without actually purchasing a product or when a user can refresh the order confirmation page.
In this article, I will show you how to easily find duplicate transactions in Google Analytics with custom reports.
Finding Duplicate Transactions
To do this, open your google analytics account and follow the steps below:
Navigate to customization and click custom report
Click on the new custom report button
Enter the title of report as Duplicate Transactions
Select the report type as Flat Table
Click on the add dimension button and select the dimension as Transaction ID
Click on the add metric button and select metric as Transactions
Click on the save button.
Now, there are two ways to identify multiple transactions. First is by displaying the transactions in descending order and second is by applying the filter.
To display the transactions in descending order, click on the transactions header. The arrow will turn downwards as shown in the below image.
As you can see the order id with 18565 has two transactions.
The second way to track duplicate transactions is by applying a filter. To do this, click on the advanced link on top of the report table.
Apply the filter to only display transactions greater than 1.
Conclusion
You should always verify for duplicate transactions whenever you verify ecommerce data. Otherwise, your data will not be accurate and clean to make business decisions. In our next article, I will be explaining how to fix the duplicate transactions.