Product SKU incompatibility with transaction revenue

[MT]

Combining SKU with transaction revenue in a query results in "400 : Selected dimensions and metrics cannot be queried together", even though according to the dimensions and metrics reference, they should be compatible (https://developers.google.com/analytics/devguides/reporting/core/dimsmets#cats=ecommerce).

[dan...@contiamo.com]

We currently have the same problem. The ga:transactions metric can not be queried for the ga:productSku, ga:productName or ga:productCategory dimension, it results in a 400. Is this as intended? While the Google Analytics interface does not allow for that query in the first place, the following page does not indicate that this query is in any way invalid: https://developers.google.com/analytics/devguides/reporting/core/dimsmets#cats=ecommerce,time

[cis elsevier]

Same problem here, which is a big problem for us. Any chance of getting a reply from Google on this (initial question was raised more than 3 months ago).

On Friday, April 19, 2013 8:07:46 AM UTC+2, MT wrote:

[Stephen Puiszis]

Having the exact same issue. It's October and it looks like it hasn't been fixed. 

[Tiffany Wang]

Mid-Oct, problem still not fixed!

[Aaron Toledo]

If you are request productSku, you should be pairing it with itemRevenue.  This effectively gives you the revenue brought in by a specific product.  

If you want transactions and transactionRevenue, you can pair them with transactionId.  

If you're trying to figure out how many transactions a specific product was in, you'd have to break down productSku by transactionId and do a unique count of transactionId at the productSku level (which isn't an available metric).

[kush...@gmail.com]

I believe Aaron's answer is correct. Transactions and TransactionRevenue are order-level metrics, so it makes sense that you wouldn't be able to combine them with item-level dimensions.