My Step-By-Step Blueprint For Learning and Mastering Google Analytics 4 (GA4)
Get the FREE e-book on Google Analytics 4 – GA4 (126 Pages)
Yes I want the FREE ebook
Last Updated: May 24, 2022
A negative transaction (also known as a reversal transaction) is one that is associated with negative sales amount and/or other negative metrics like negative tax, negative shipping.
So if the following was your original transaction:
Google Analytics does not automatically reverse an ecommerce transaction, in the event the transaction is later declined or cancelled.
So if someone has placed an order on your website and later he cancelled the order or his order did not go through for some reason, Google Analytics will still report that order and the corresponding sale generated from that order.
There is a common misconception that reversing a transaction means removing the transaction. But, unfortunately, this is not true.
When you reverse a transaction in Google Analytics, it does not remove it. GA simply deduct a particular amount from the revenue total. So what is removed is the revenue/sales associated with the reversal transaction. No other information associated with the transaction is removed.
For example, let’s say user ‘A’ placed an order of $200 on Monday and the total website sales on Monday were $500.
Now if you reverse the transaction (placed by user ‘A’) on Monday, then the total sales amount for Monday would be reported to be: $500 – $200 = $300
If you reverse the transaction on say Tuesday, then
the total sales amount for Monday would remain $500
the total sales amount for Tuesday would be: Total website sales for Tuesday – $200
So if the original transaction occurred on Monday and you reversed it on Tuesday then make sure that you are analyzing a date range that includes both Monday and Tuesday.
Google, in fact, recommends doing the reversal on the same day as the original transaction.
But there is one big caveat. Although you have reversed the ecommerce transaction, the transaction count will not change.
For example, let’s say user ‘A’ placed an order of $200 on Monday and on the same day he cancelled the order.
Now let us suppose you also reversed the transaction on Monday. Though you have removed the sales amount associated with the cancelled order, you have not removed the transaction count.
In fact, you have increased the transaction count by one.
GA will report two orders (one regular transaction, one negative transaction) for Monday. When in fact, it should have reported zero orders for Monday.
A typical big ecommerce website gets a lot of cancelled and declined orders on a daily basis. So if the developers are consistently placing negative transactions to remove the sales amount associated with cancelled and declined orders then your transaction count can greatly skew over time.
That’s why it becomes very important to identify negative transactions and discount them from your analysis.
How to identify negative transactions in GA reports
Now the question becomes, how do you identify these negative transactions in GA reports?
Well, they appear with this unholy symbol in the ‘Ecommerce Overview’ report:
Here how this symbol appears in the context of ‘Ecommerce Overview’ report:
Follow the steps below to identify any negative transactions in your ecommerce reports:
Step-2: Navigate to ‘Conversions’ > ‘Ecommerce’ > ‘Overview’ report
Step-3: Change the data range to the last month.
Step-4: Select ‘Revenue’ from the drop-down menu and remove the ‘Ecommerce Conversion Rate’ metric:
Step-5: Click on the ‘Hourly’ button:
Step-6: Search for negative sales in the data trend:
Step-7: Hover your mouse over the data point which is below $0 to find the date when this negative sale occurred:
So in my case, the negative sale occurred on Dec 26, 2018
Note: Here the sales are reported as $0.00 because the transaction was reversed on the same day. If the transaction was reversed on some other day and no order was placed on that day, you may see the negative sales amount being reported.
Step-8: Set the date range of the report to the day when the negative sales were recorded by GA. In my case that would be Dec 26, 2018.
Step-9: Now add the ‘Transactions’ metric to the ‘Ecommerce Overview’ report:
The ‘Ecommerce Overview’ report should now look like the one below:
If you hover your mouse over the unholy symbol, you should be able to see the negative sales amount associated with the transaction along with the total number of negative transactions:
So what we can conclude from this report?
On December 26, 2018, 5 orders/transactions were placed on the website. Out of the five transactions, there was one cancelled order, three negative transactions, and one fulfilled order.
So in total, there was only one legitimate transaction on Dec 26th.
The first transaction of $398 took place at 5 am. This order was later cancelled. So the developer placed a negative transaction to remove the sales associated with the cancelled order.
However, instead of placing one negative transaction, he placed three negative transactions. And these three negative transactions resulted in net sales of -$398. This happened because the developer did not place the negative transactions correctly.
He probably did the following:
Placed 1st negative transaction of -$398 around 12 pm (to remove $398 in sales from the cancelled order)
Placed 2nd negative transaction of -$398 (probably he did not wait for 20-30 min to see any changes in the ecommerce overview report).
Placed 3rd negative transaction of $398 (to remove the negative impact of extra negative transactions).
So the net sales from three negative transactions = -$398 -$398 + $398 = -$398
The net sales from one cancelled order and three negative transactions = $398 – $398 = $0
Then someone placed a new order of $398 around 4 pm
So now the net sales from one cancelled order, three negative transactions and one order = $0 + $398 = $398. That’s why GA is reporting $398 in net sales but at the same time reporting 5 transactions.
So in total, there was only one legitimate transaction on Dec 26th.
That’s how you can skew up your ecommerce data if you are not careful with placing negative transactions. This is the kind of insight you can get by identifying negative transactions.
"How to use Digital Analytics to generate floods of new Sales and Customers without spending years figuring everything out on your own."
Here’s what we’re going to cover in this training…
#1 Why digital analytics is the key to online business success.
#2 The number 1 reason why most marketers are not able to scale their advertising and maximize sales.
#3 Why Google and Facebook ads don’t work for most businesses & how to make them work.
#4 Why you won’t get any competitive advantage in the marketplace just by knowing Google Analytics.
#5 The number 1 reason why conversion optimization is not working for your business.
#6 How to advertise on any marketing platform for FREE with an unlimited budget.
#7 How to learn and master digital analytics and conversion optimization in record time.
My best selling books on Digital Analytics and Conversion Optimization
Maths and Stats for Web Analytics and Conversion Optimization
This expert guide will teach you how to leverage the knowledge of maths and statistics in order to accurately interpret data and take actions, which can quickly improve the bottom-line of your online business.
Master the Essentials of Email Marketing Analytics
This book focuses solely on the ‘analytics’ that power your email marketing optimization program and will help you dramatically reduce your cost per acquisition and increase marketing ROI by tracking the performance of the various KPIs and metrics used for email marketing.
Attribution Modelling in Google Analytics and BeyondSECOND EDITION OUT NOW!
Attribution modelling is the process of determining the most effective marketing channels for investment. This book has been written to help you implement attribution modelling. It will teach you how to leverage the knowledge of attribution modelling in order to allocate marketing budget and understand buying behaviour.
Attribution Modelling in Google Ads and Facebook
This book has been written to help you implement attribution modelling in Google Ads (Google AdWords) and Facebook. It will teach you, how to leverage the knowledge of attribution modelling in order to understand the customer purchasing journey and determine the most effective marketing channels for investment.
About the Author
Himanshu Sharma
Founder, OptimizeSmart.com
Over 15 years of experience in digital analytics and marketing
Author of four best-selling books on digital analytics and conversion optimization
Nominated for Digital Analytics Association Awards for Excellence
Runs one of the most popular blogs in the world on digital analytics
Consultant to countless small and big businesses over the decade
Learn and Master Google Analytics 4 (GA4) - 126 pages ebook
We use cookies on our website to give you the most relevant experience by remembering your preferences and repeat visits. By clicking “Accept”, you consent to the use of ALL the cookies.
This website uses cookies to improve your experience while you navigate through the website. Out of these, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may affect your browsing experience.
Necessary cookies are absolutely essential for the website to function properly. These cookies ensure basic functionalities and security features of the website, anonymously.
Cookie
Duration
Description
cookielawinfo-checkbox-analytics
11 months
This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Analytics".
cookielawinfo-checkbox-functional
11 months
The cookie is set by GDPR cookie consent to record the user consent for the cookies in the category "Functional".
cookielawinfo-checkbox-necessary
11 months
This cookie is set by GDPR Cookie Consent plugin. The cookies is used to store the user consent for the cookies in the category "Necessary".
cookielawinfo-checkbox-others
11 months
This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Other.
cookielawinfo-checkbox-performance
11 months
This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Performance".
viewed_cookie_policy
11 months
The cookie is set by the GDPR Cookie Consent plugin and is used to store whether or not user has consented to the use of cookies. It does not store any personal data.
Functional cookies help to perform certain functionalities like sharing the content of the website on social media platforms, collect feedbacks, and other third-party features.
Performance cookies are used to understand and analyze the key performance indexes of the website which helps in delivering a better user experience for the visitors.
Advertisement cookies are used to provide visitors with relevant ads and marketing campaigns. These cookies track visitors across websites and collect information to provide customized ads.
Analytical cookies are used to understand how visitors interact with the website. These cookies help provide information on metrics the number of visitors, bounce rate, traffic source, etc.