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
-
Do custom tracking codes affect indexing?
Hello, My company uses a tracking system that allows our employees to apply a short code snippet to the end of our URLs for marketing attribution. An example of such a code would be: https://www.schoolofmotion.com/?ref_id=moz-test However, in Google Analytics we are seeing duplicates of our content, where the pages with the individual tracking codes are counted separately from the pages without. From a reporting perspective, this is annoying and definitely worth a fix. However, I'm curious if this problem is affecting our search potential as well. Could this tracking system be splitting traffic in Google's eyes? From an SEO perspective, how should we approach this? Would canonical tags fix this duplication issue in Google Analytics? Is there something else that we should use? Thanks in advance. The Moz community is incredible.
Reporting & Analytics | | CalebWardSoM1 -
Is GA Real-Time Locations Broken?
When I look at my real-time site traffic in GA, I'm seeing a lot of direct traffic from Montvale, NJ. However, when I go to the audience tab for today or any day in the past, Montvale doesn't even show up in the list of cities sending traffic. What am I missing here?
Reporting & Analytics | | jimbeaux_slice2 -
Domain change from .co.uk to .com - do you add .com to the referral exclusion in GA?
Hi Mozzers, Just wanted to double check that when a website domain changes from .co.uk to .com - do you add .com to the referral exclusion in GA? Do you also keep the .co.uk version in the list too? I have updated the property settings to .com Thanks Anthony
Reporting & Analytics | | Tone_Agency0 -
Tracking in Google Analytics
My site has just recently (or maybe not so recently...) had a great deal of https URL's indexed (I was really only able to find this out thanks to the recent update to the GWT Index Status). It appears that Googlebot picked up an ssl somewhere (I already know where) on my site and then proceeded to crawl and index pages with https rather than http. Since I understand the issue, it should be an easy fix. My question is, does Google Analytics support (track) both http AND https for one site, or would I need to set up two different tracking codes for http and https? I figured that I might as well grab some data from the https pages that are indexed before I try and remove them. I've done a little research on using Groupings/Groups but I figured I would reach out to the MOZ community to see if anyone else has worked with a similar issue. Thanks!
Reporting & Analytics | | GalcoIndustrial0 -
ECommerce Tracking Code Installation
Hi All, Kindly explain how to implement eCommerce tracking code on the website.I am aware how to enable and generate eCommerce tracking code in Google Analytics but have confusion from website end.Also, where i read the steps, everywhere i read the below code: <script< span="">type="text/javascript"> var _gaq = _gaq ||[]; _gaq.push(['_setAccount','UA-XXXXX-X']); _gaq.push(['_trackPageview']); _gaq.push(['_addTrans', '1234', // transaction ID - required 'Acme Clothing', // affiliation or store name '11.99', // total - required '1.29', // tax '5', // shipping 'San Jose', // city 'California', // state or province 'USA' // country ]); // add item might be called for every item in the shopping cart // where your ecommerce engine loops through each item in the cart and // prints out _addItem for each _gaq.push(['_addItem', '1234', // transaction ID - required 'DD44', // SKU/code - required 'T-Shirt', // product name 'Green Medium', // category or variation '11.99', // unit price - required '1' // quantity - required ]); _gaq.push(['_trackTrans']);//submits transaction to the Analytics servers (function(){ var ga = document.createElement('script'); ga.type ='text/javascript'; ga.async =true; ga.src =('https:'== document.location.protocol ?'https://ssl':'http://www')+'.google-analytics.com/ga.js'; var s = document.getElementsByTagName('script')[0]; s.parentNode.insertBefore(ga, s); })(); ----------------------------------------</script<> In the above code specific transaction id, SKU/code are mentioned. What will be the modifications in the above code if i have to track all products present on my eCommerce website??
Reporting & Analytics | | RuchiPardal1 -
Google Analytics - Cross Domain Tracking Goals
Hi guys, looking at the best way to organize this - Site 1 - Shoe Store - (Old site with analytic history - UA-12345-1) Site 2 - Clothing Store - (Brand New UA-54321-1) Right now i have 2 separate GA Accounts for the sites. But i would like to track goals from Site 2 to Site 1. For that i need to set up cross domain tracking. So i take it i would need to create another account under Site 1 - (UA-12345-2) and put that new code on Site 2? Or do the UA numbers have to be exact? example both 12345-1? In which case, i would need to set up 2 different profiles with filtering? Main concern is i want to keep separate data for both sites, espically if UA's will be the same. Trying to visualize - UA-12345-1 Profile 1Shoes/Master Profile 2 Shoes Profile 3 Clothes Or UA-12345-1 Shoes UA-12345-2 Clothes Thanks, Mike
Reporting & Analytics | | IsHot0 -
GA Subdomain Setup
Hi Mozzers, Can someone show me how to add a subdomain profile (sub.example.com) under the master profile (www.example.com) on Google Analytics. I am not sure on how to set it up. Thanks
Reporting & Analytics | | Ideas-Money-Art0 -
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