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.
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.
Step 5. New Window will open, then you have to “Click on Authorize” to use the tool.
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”.
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.
Step 7. Wait for 5 to 10 minutes then check your “Sales Performance” report in Google Analytics.
In the above case, we have added the transaction in Google Analytics.
Sign up to my Newsletter
In the same way you can remove the transaction from Google Analytics
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.