Reverse an Ecommerce Transaction in Analytics
-
I am looking for help on using Googles Reverse an Ecommerce Transaction in Analytics work flow documented here: https://support.google.com/analytics/answer/1037443?hl=en&ref_topic=1037062
Essentially an incorrect transaction was processed that was for such a large number that it is really messing up reporting. I have never used Googles outlined process and from my research it looks like it might not reverse the transaction for the date it was placed but ad a negative amount to offset it on the date submitted. This will still work for year of year reporting but it will mess up the data for two different days in one month. If someone who had done this before has any insight please chime in thanks!
Here is a support thread about the reverse transaction messing up a different days data.
-
Hi Jared,
Thanks for the heads up re the applied date. I will look out for the improved Google solution.
-
Dean,
Thanks for your reply! It seems that not many people are familiar with this scenario. Currently I have been using the advanced filter for reporting. However other Managers within the company use GA for some minor reporting and are not familiar with using it so I was hoping to apply the reverse an ecommerce transaction method.
Before implementing the reverse an eCommerce transaction method I discussed the scenario with my Adwords rep who talked with some GA engineers, and confirmed what I had feared which is the reverse transaction will be applied to whatever day it is uploaded not to the day the faulty transaction took place. Which means I will have two days with terribly bad data. Especially because at best a transaction like this will not be found in GA until the next day.
They did state that this has been a very common complaint and that GA is working on a solution to make the process much easier and so that it can apply to back data.
-
The Reverse an Ecommerce Transaction in Analytics work flow show work fine as it mentions that you should check you are using the same transaction ID for the transaction and item-form data as the one you used for the original purchase. therefore reversing that single transaction.
However they also mention that cancelling a transaction does not remove it. Both the original transaction and the cancelled transaction are included in the transaction count so basically you can only zero the transaction value.
You could also apply an advanced filter to your report excluding the offending transaction ID which would be a simpler solution.
Got a burning SEO question?
Subscribe to Moz Pro to gain full access to Q&A, answer questions, and ask your own.
Browse Questions
Explore more categories
-
Moz Tools
Chat with the community about the Moz tools.
-
SEO Tactics
Discuss the SEO process with fellow marketers
-
Community
Discuss industry events, jobs, and news!
-
Digital Marketing
Chat about tactics outside of SEO
-
Research & Trends
Dive into research and trends in the search industry.
-
Support
Connect on product support and feature requests.
Related Questions
-
Google Analytics Numbers Are Weird
Hi, I'm having a strange problem from past one month. My website gets about 10k pageviews a month with an average bounce rate of 50%. Lately, I observed a strange thing. The avg time on page of visitors from selected countries is less than 1 second and the bounce rate is zero!! How is this possible? This is happening from past one month and it would be really helpful if you guys could tell me what exactly is happening?? Ive attached a screenshot for better understanding. website url : https://www.specbee.com/ fIAXXgF 3zQuBAN
Reporting & Analytics | | ganesh10 -
Universal Google analytics e-commerce tracking code?
Hi Mozzers, I have never setup a universal google analytics e-commerce tracking code before and my concern is what exactly do I need to add on the cart thank you page? Can someone send me a sample of code I need to be adding? What kind of customization does it require? The more details you can provide the better! Thanks!
Reporting & Analytics | | Ideas-Money-Art0 -
% Change - Google analytics - how to calculate?
Hi All,
Reporting & Analytics | | JohnPalmer
I have two dates with two different numbers I want to calculate the "% Change" like google analytics, The numbers of June 2015 - 127,931 sessions
The numbers of June 2014 - 90914 sessions please tell me what is the %Change. Best. J0 -
How do I cancel a scheduled Dashboard report in Google Analytics?
I created a few Dashboards in Google Analytics and scheduled them to be emailed for the next 6 months. Now I want to cancel those scheduled emails and am not finding those Dashboard reports/emails anywhere so I can cancel them. Do you know how to stop these emails from being sent?
Reporting & Analytics | | cindyt-170380 -
Behavior Flow vs. All Pages report in Google Analytics
In the interest of determining why our ecommerce site isn't converting, I've been spending some quality time with GA. I've suspected that our front page is part of the problem, especially where our organic traffic is concerned (we get a good deal of referral traffic from a link on an OEM's site). According to the Behavior Flow report under the Behavior section of GA, organic traffic to our home page is hemorrhaging (roughly 60% bounce rate). But when I went to the All Pages report (Behavior > Site Content > All Pages) and looked at organic traffic to our home page, then looked at the Medium as a secondary dimension, I'm getting a bounce rate of 35%. Why the massive discrepancy? Can somebody assist?
Reporting & Analytics | | ufmedia0 -
Google Analytics Not Tracking 100% of Visits?
Hi all, We're having an issue with Analytics where we are getting different figures from what Silver Pop are saying. For example email campaign A sent via Silver Pop, with Google Analytics tracking code show's 50 unique clicks in Silver Pop. Looking at Google Analytics there are only 10 visits from that campaign. So I thought it could be something with the tracking, but there wasn't a significant rise in web visits = either Google Analytics is not recording visits properly or Silver Pop figures are wrong. I'm more inclined to think that it's something to do with Google Analytics. Has anyone come across something similar? Where one system is showing you X amount of visits but the figures on Google Analytics don't add up? A few quick things already covered: Double checked the links have been tracked properly, but this doesn't explain the low increase in web visits generally We've double checked that Google Analytics tracking code is properly installed (and it is / was at the time of send). Any help would be much appreciated! Thanks guys.
Reporting & Analytics | | RKHStaff1 -
How do I best segment tablets on Google Analytics
I would like to find a way to best segment out my tablet traffic to measure performance; however I'm finding that there are road blocks. It doesn't seem that device operating systems or screen resolutions have clear cut differences in the tablet/mobile versions. Has anyone here found a good way to create a "tablet" segment in Google Analytics? Right now I'm having to lean on solely the ipad traffic to get indicators of tablet performance. Thanks!
Reporting & Analytics | | lvstrickland0 -
Analytics goal funnel regular expression not working
Hi Guys can anyone point me in the right direction. My funnels used to work fine until our app team decided to add variables in a directory structure instead of a query string. I need to be able to track page steps that now look like this Step 1 = /Reservation/Search/Var1/Var2
Reporting & Analytics | | apolloseo
Step 2 = /Reservation/Quote/Var1/Var2 I've set up this but it's not working Step 1 = /Reservation/Search.*
Step 2 = /Reservation/Quote.* What am I doing wrong?0