Weird Math in GA Ecommerce Tracking

[newwhy]

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!

[newwhy]

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.

[max.favilli]

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

[newwhy]

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?

[max.favilli]

Check the tracking code where the _addItem is done for the conversion value passed to analytics.