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 & Google Sheets
Hi guys, I'm looking to use google analytics google sheets extension to pull data into a google sheet with metrics from other tools e.g. semrush, moz, etc. From my understanding with google analytics google sheet extension its designed to run reports and doesn't really allow you to add other metrics. Basically what i'm trying to do is this: https://www.useloom.com/share/c1e42bfa60bd46fca2b1120018969ce8 Any suggestions/advice on how to do this would be great. Cheers.
Reporting & Analytics | | jayoliverwright0 -
In Google Analytic Experiment I want to Judge Performance of Page Along with Pageviews, Bounces, Transaction etc
Hi All, For my ecommerce site for mobile site category page I have redesign the page in 2 different ways so one original page and 2 new designs. Now I want to do A/B testing with google experiment. I want to measure performance of page via pageviews, bounce rate, exit rate, conversion rate, add to basket etc. Now in objective for this experiment I can select anyone thing either Pageviews, or bounces or transaction or goal. So my query is 1) I cannot select all objective together? 2) or for same page I have to create too many experiments by selecting each objective? 3) exit rate or add to basket objective is not in experiment list so? Thanks!
Reporting & Analytics | | dsouzac0 -
Goal Totals in Google Analytics
How do I get a cumulative tally of all the goals reached in google analytics? I've been using the percentages currently, but I was wondering if there was an easier way. Thanks
Reporting & Analytics | | OOMDODigital0 -
Google analytics question
Ok so in my traffic sources break down I have 3 sections: direct, organic, and referral. My question is under the referral tab I have recently noticed a new traffic source, my own website.... How is this possible? My top referring site is my own website.... Is this considered direct traffic or how is this being traced?
Reporting & Analytics | | jameswalkerson0 -
Google Analytics
Hi I added one google analytics account with a third party business as an admin, and I accidentally shared all the accounts of my clients. So this business have access to all my google analytics account. How do I remove them as an admin of all the GA accounts except the one they need? A step by step process is welcomed 🙂 Thank you,
Reporting & Analytics | | Ideas-Money-Art0 -
Tracking PDF Downloads in Google Analytics
Hi, I work on a site that allows users to download whitepapers after filling out a form. Once they do this they are redirected to a URL which is the PDF. We use Wordpress and these documents were uploaded to the media center. I've tried researching how to track these downloads in GA, since the code is not present on these pages, but have read a few different answers. Anyone have firsthand experience? Thanks!
Reporting & Analytics | | tinarose0 -
Analytics URL Tagging
For some reason I can't get Google Analytics to pick up my URL tags, am I doing something wrong? http://www.example.com/?utm_source=carscom&utm_campaign=3rdparty&utm_medium=referral
Reporting & Analytics | | kylesuss0 -
New Google Analytics Site Speed tool and excel
Hello, I was wondering if there is a good tool or method to pull the new Google Analytics Site Speed data into excel and use this document to track site speeds on a weekly basis for multiple clients? Any good articles or how-to's would be awesome!
Reporting & Analytics | | Hakkasan0