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
-
Query on google analytic benchmarking report
Hi All, First I select My Industry Vertical - ABCD then I select Region - US ( all region) then size by daily session - 10000-99999 finally reports appears "Blank" but when I decrease daily session from 10000-99999 to 1000-4999 or less then report is perfect. So what does it mean? My Avg daily session is 70k to 80k. So how to analysis benchmarking in this case? Thanks!
Reporting & Analytics | | pragnesh96390 -
How does Google Maps/G+ traffic show up in Analytics?
Hi Moz Community, I've been trying to figure out how traffic from Google Maps (and G+) shows up in Google Analytics and am struggling to find a good answer online. If someone finds a business through Google Maps and then clicks on the website in the Maps listing, does that show up as a referral from Google Maps? Our site shows virtually zero traffic from Google Maps even though we have a number of listing. Two related questions: if someone clicks through to a G+ page from a Maps result and then visits our website from the G+ page, does that show up in Analytics as a referral from G+? Is traffic from Google Maps or G+ ALSO counted as organic traffic? (Would it be possible to accidentally double-count a visit as both organic and a referral from Maps/G+? Thanks everybody!
Reporting & Analytics | | JohnGroves0 -
Google Analytics - how do you find out Unique Visitors ?
Hi Im trying to find out unique visitors per annum in GA, is this possible, is it simply users ? i know they changed definitions recently cheers dan
Reporting & Analytics | | Dan-Lawrence0 -
Google Analytics Page Metrics and Redirects
Hi All- Context: A site has been redesigned. Pages were renamed in the process. Problem: It's very hard to compare before and after metrics because the page URLs are not the same. Question: Anyone know how to do this in Google Analytics? I'm hoping there's some simple trick I just don't know about. D
Reporting & Analytics | | DonnaDuncan0 -
No Google Analytics code on page BUT reporting is active
How could Google Analytics be reporting data if my pages don't have the GA code on them? Mike
Reporting & Analytics | | Mike_c0 -
Will benchmarking only be available in universal analytics or all analytics?
With the announcement of benchmarking in Google Analytics I was wondering if I would have to upgrade to universal analytics or will it be available to everyone?
Reporting & Analytics | | EcommerceSite0 -
Best top 5 actionable insights from Google Analytics
Buongiorno from 14 degrees C cloudy wetherby UK 🙂 With a whole gamut of books out there are written around the topic of "Actionable Web analytics" where you have to wade through chapters of how to suck eggs and how to get analytics part of your business culture (whatever! most clients who look after their websites are entry level Marketing Execs who pay the digital agencies to do the thinking for them) I'd like to cut to the chase and list out say a top 5 of actionable insights a client would actually give the time of day for so heres my top five, whats yours? 1. Landing page bounce - showing them the £5k landing page designed with no conversion thinking is turning off customers
Reporting & Analytics | | Nightwing
2. Synching up PPC campaigns to analytics and showing them how much money they are waisting
3. Goal funnels - Showing them there 20 step shopping conversion funnel gets abandoned at step 3
4. Non brand keyword traffic (although a stack of this gets blocked by "not provided" Big groan...)
5. Event tracking on there 10 page carousel anner showing them no one clicks on banners 2 - 10 So under the strict label of "Actionable data only" from Google analytics whats your best insights you share with clients in the hope that they may actually give data reports the time of day! Grazie tanto,
David1 -
Analytics bounce rate change
Hi mozzers, I have a little riddle. A few weeks ago the bounce rate on one of our website dropped 90% - from 45 % average to 5 % average. We haven't changed much in the code of the site, layout or anything else. The traffic is pretty stable too. Anyone can guess why? Or have experienced something similar? xOvrb.jpg
Reporting & Analytics | | ThomasHgenhaven0