How to Remove or Modify Google Analytics eCommerce Transaction

Share on linkedin
LinkedIn
Share on twitter
Twitter
Share on facebook
Facebook
Share on whatsapp
WhatsApp

If you are having an eCommerce site and google analytics is connected with the site then you might have noticed that the following orders with their transaction are recorded in Google Analytics. 

In order to maintain the records, sometimes you have to remove the order with the transaction of all the canceled order/test order/ unfilled order in google analytics. 

In this, we will be learning how to remove or modify Google Analytics ecommerce transaction reports. For this, we will be using Google Analytics Measurement Protocol Hit Builder

This tool is easy to use and easy to understand and you don’t need any developer for this. 

Steps to Remove or Modify Google Analytics ecommerce Transaction

Step 1. You should have edit permission at account/property level. 

Step 2. To remove/modify the transaction in google analytics, you need Transaction ID and other metrics from Google Analytics.

You can find the Transaction ID by navigation to Google Analytics > Conversion > Ecommerce > Sales Performance

ga sales performance

You need this ID, when we will be using measurement protocol Hit Builder. 

Step 3. Then Navigate to https://developers.google.com/analytics/devguides/collection/protocol/v1/devguide#ecom

Step 4. Click on the link “Measurement Protocol Hit Builder” Link which is under the Transaction Hit.

Transaction Hit

Step 5. New Window will open, then you have to “Click on Authorize” to use the tool.

Hit summary Dummy

Scroll down to “Hit Parameter Details” and you will see Prefill Data in it. You have to change the data except for the Version value “v”. 

Hit Parameter details GA

v=1 // Version (The Value of this will be 1)
&tid=UA-XXXXX-Y // Tracking ID of Google Analytics.
&t=transaction // Transaction hit type (pageview, event, items)
&ti=154760 // transaction ID. This is Required
&tr=1000.00 // Transaction revenue.
&ts=543.00 // Transaction shipping.
&tt=12.00 // Transaction tax.
&cu=USD // Currency code.

Step 6. Press the “Hit Validate” if it is valid then Send hit to Google Analytics.

Hit Validate Data

Step 7. Wait for 5 to 10 minutes then check your “Sales Performance” report in Google Analytics.

Sales Performance Report Transaction

In the above case, we have added the transaction in Google Analytics.

Sign up to my Newsletter

Subscribe to my newsletter and receive the best tips for facebook Marketing.

In the same way you can remove the transaction from Google Analytics

Hit parameter details

Transaction Revenue → Then you have to write Minus Sign before the Amount like we have done (-1000)

Transaction Shipping → In this we will do the same thing Minus Sign before the amount.

After you validate and hit the data to Google Analytics you will see the Amount will be deducted from the Sales Performance Report.

Let’s Take an Example

Let’s say, you have made a transaction and on the same day you have removed the transaction from Google Analytics, then you won’t see any entry in the Google Analytics.

Means if Transaction is made on 1 January and It has Removed on the same day, then there will no entry of this transaction.

But if you have removed that transaction after a few weeks or months, then you will see a new entry on that date for the reversed transaction.

Means if Transaction is made on 1 January and you removed the transaction on 1 March then a new entry will be created for this and you will see negative transactions in Google Analytics.

This Google Analytics Measurement Protocol Hit Builder is powerful and can make things easy for you but if you did something wrong then it can skew your data in Google Analytics.

Sign up to my Newsletter

Subscribe to my newsletter and receive the best tips for facebook Marketing.

Get free Google Analytics Checklist

Enter your email address below and get the checklist directly in your mail.