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
-
Track conversion from paypal express/Apple pay
Hi All, Is there any way to track apple pay conversion or paypal express conversion in Google Analytics? Thanks
Reporting & Analytics | | Alick3000 -
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 -
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 -
Google Internal Search Tracking Kaput :-(
Buongiorno from cloudy & overcast Wetherby UK... On this site http://www.dartexcoatings.com/ I configured Google to tracdk internal search & heres how - http://i216.photobucket.com/albums/cc53/zymurgy_bucket/internal-search-jinx_zpscf86b49d.jpg But internal search data is not pulling through 😞 How can i fix this please.
Reporting & Analytics | | Nightwing
Thanks,
David0 -
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 -
GA advanced segments - for how much volume keywords are sending per month
I am trying to follow the advice in this whiteboard friday video http://www.seomoz.org/blog/how-big-is-your-long-tail-whiteboard-friday of grouping keywords based on volume of traffic they send each month e.g. 100+, 50-99, 10-49, <10. I'm probably being super dumb, but how do I do this with advanced segments in GA? Thanks.
Reporting & Analytics | | KateV0 -
New GA interface - Number of conversion by source
Hi Guys, Hope this is an easy one for a GA ninja. In the new GA interface, how can I view the number of conversions by source, instead of the default conversion rate by source. For example, if I want to view the number of conversion from Adwords. I'm looking at Goals > Source / Medium > Google CPC and looking at Goal Set 1. However all data is expressed in percentages. Thanks in advance!
Reporting & Analytics | | David_ODonnell0 -
Looking for a Drupal module to track conversions...
I don't use drupal very often, so I'm looking for some help. We manage two sites in drupal, and the way they are set up, it creates a new thank you page every time someone fills out a contact form. The thank you page displays the information that was entered, so I assume it is necessary to create a page to do this (this was set up before I came on board). What I'm trying to do is track conversions in analytics by thank you page, but because a different node is created for every page, it makes things really difficult. My guess is that there's some kind of module or shortcut that could make this easier. Do any of you know of something, or preferably, is there something you're using that you'd endorse? Thanks for your help. -Adam
Reporting & Analytics | | DeliaAssociates0