Weird Math in GA Ecommerce Tracking
-
Hi everybody. I've recently discovered that I have a problem with the ecommerce tracking on a client's website. The client sells concert tickets at an average price of $10 per ticket. The custom ecommerce platform they use is kind of unusual; the same product often has different SKUs, but not always. This isn't associated with different seats, etc. In fact, I don't yet know why they've set it up that way.
The problem that I'm facing is this: the data in Analytics is calculating the "average price" of a SKU item as the total price. If, for example, the actual average price for a SKU item is $10 and four of those SKU items were sold, Analytics will tell me the average price is $40. This means that the total revenue for that SKU shows up as $40 x 4 = $160. Needless to say, this is enormously skewing the data. Here's a screenshot. Note, it's the same product: http://screencast.com/t/JyLQkb3jzz6s
The total revenue for ticket sales is way off because of this, and I'm not sure if it's a problem with the ecommerce tracking code in Analytics, or something that the ecomm platform is doing.
Have any of you experienced anything like this, and if so is it a fix in Analytics?
Thank you!
-
Thank you for all your help. The strange thing is that Analytics shows the proper quantity, but the wrong average price and total revenue. It does seem like the "unit price" is off. I think they're running _additem for the entire transaction, vs. each item within the transaction. So if someone buys 4 tickets (at $10 each), unit price is showing up as $40.
I'll reach out and see if this is the problem.
Thanks again! You've helped so much.
-
they should debug to check amount and qty have the right figures, and (it's a common mistake even if should not cause your problem) also check the code is not called more than once for the same sale
average price in analytics product performance page is calculate summing up the value you pass in the addItem as "unit price" and dividing by the sum of the value you pass as "quantity"
so if analytics is showing a wrong figure these values you pass to analytics must be wrong and you should cross check what figures your application is really sending to analytics
-
This is the email I've received back from the developers. They're really unfamiliar with implementing e-commerce tracking, so I'm hoping to get a little more feedback here!
http://screencast.com/t/yWQyzWrR
The first code fires when there's any transaction at all (they sell stuff other than tickets, and those other items are showing up fine in GA). And then the second code fires when tickets are purchased.
Thoughts?
-
Check the tracking code where the _addItem is done for the conversion value passed to analytics.
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
-
Universal Analytics Tracking code for Measuring Addition/Removal from Cart via GTM
Hello Experts, Can you please tell me Universal Analytics Tracking code for Measuring Addition/Removal from Cart via GTM? Any one tell me process and code? Thanks!
Reporting & Analytics | | bkmitesh0 -
E Commerce and cross domain tracking on universal analytics?
Hi Mozzers, I am running into an issue where my client's website ( can refer to domain.com) uses a third party checkout site called rezovation that we can refer to checkout.rezovation.com: I went through this doc here https://developers.google.com/analytics/devguides/collection/analyticsjs/cross-domain and https://developers.google.com/analytics/devguides/collection/analyticsjs/ecommerce (for universal analytics) and I still find it confusing so here are my questions: According to my understanding I need a customized GATC to link both domains checkout.rezovation.com and domain.com? If yes(above), do we setup one customized GATC for cross domain tracking on all pages from checkout.rezovation.com and domain.com? if it is the case can someone provide detail steps on how to set it up ( I am not a coder so the easier the guideline, the better) Once cross domain tracking is set up, e commerce tracking code should be only on thank you page should be looking like the image below? Should i add manually all the extra code for the ecommerce tracking code or I can get it done via a third party website? Thank you guys! oPgn8P4.png
Reporting & Analytics | | Ideas-Money-Art0 -
Does a Manual Penalty Affect Other Sites in Same GA Account
Hello Mozzers, I was a bit foolish a couple of years back when first getting into the game, and employed a dodgy agency to do some SEO for me on some sites. Fast forward to this year, and the two sites in my Google Analytics account have been hit with a manual penalty. I decided to ditch the websites and move on, so removed them from my GA account, webmaster tools etc and will simply let them die a death. My question is, do you think this would affect how easy it would be to rank other websites within my GA account? Does anybody have any views on this? Thanks!
Reporting & Analytics | | Marc-FIMA0 -
GA: How can non related kws show up in the organic report?
Hi mozzers, I have a site A: www.example.com (with its own branded kws) SiteB: subdomain.example.com Site A and B are related and belong to the same company. Site B was released a couple months ago. ISSUE: I have noticed branded kws from Site A showing up on Site B's GA which doesn't make any sense. I try to make searches in the SE with those kws and not a single search showed the Site B(subdomain). What is weird is that 2 months ago had a an issue with bounce rate on site B showing a 0% bounce rate, then I discovered that we had 2 GATC on site, removed the extra code and bounce was back to normal. Since then I have seen a rise of branded kws from Site A to Site B. Can someone help me here figuring out what is wrong? Thanks
Reporting & Analytics | | Ideas-Money-Art0 -
Where should I insert the code when I track an event on GA?
hi mozzers, I am trying to setup my first event to count the numbers of downloads of an infographic(pdf file) we just created on GA and after some research I figured that I should add this piece of code (below) but where exactly? <colgroup><col width="386"></colgroup>
Reporting & Analytics | | Ideas-Money-Art
| _gaq.push(['_trackevent', 'PDF', 'Download', 'name of file']); | Should I put it just in between _gaq.push(['_setDomainName', 'coit.com']); and _gaq.push(['_trackPageview']); ? Please provide details because I ve never done this before Thanks 🙂0 -
Is there any way to see how one my keywords ranked historically before I started tracking it?
Hello there! I'm in need of some historical data on some keywords as they relate to my site. Basically, I'd like to track which events have had the most impact on moving me through the rankings, but I wasn't using Moz at the time I had made some changes to my website... Is there any way to see how I ranked for a particular keyword at a given point in time? Thanks! Gene
Reporting & Analytics | | BGroup0 -
Tracking Email campaign
I generated the following URL to track visits from newsletter. http://www.example.com/ ?utm_source=newsletter1&utm_medium=email&utm_campaign=newletter2109 Do i have to use this link in our email ? My question is it looks ugly. How do i shorten this ? Using bit.ly ? But isn't it true that URL shortening services such as bitly, as some can increase the likelihood of email being marked as spam
Reporting & Analytics | | seoug_20051 -
Tracking SEO tests
Trying to get some best practices on testing SEO changes. We are going to make a bunch of changes on subsets of pages. Say testing about 5 different on-page changes. Originally we were going to submit separate Sitemaps to GWT and see if our test sets get indexed, how quickly, etc. But we noticed that GWT says some pages in our Sitemaps aren't indexed even though we know they are (what gives?). So we thought, for each test, let's put a unique code on the page so we can see how many get indexed by Google. But that doesn't solve the issue: how many people clicked on our test pages. So we are thinking of putting a tracking pixel on the test pages, specific for each test. But then I am thinking, why not just create a separate Google Analytics profile and place that code on the test pages (set up goals to track visits per test since we aren't going to change the actual URLs). and on and on This is where you come in. What kind of tracking do you implement when you set up tests? Advice appreciated! E
Reporting & Analytics | | ErinTM0