Enhanced Ecommerce - Product Data and Transactions
I am trying to create a simple custom report which shows Product Revenue metric for the following dimensions: Transaction ID | Affiliation | Product | Product Revenue. However the report returns no data.
I've tried selecting first the metric of 'Revenue' rather than 'Product Revenue', however that eliminates the dimension options of 'Product' and 'Product Category'.
I realize Transactions are parents of Items, but I don't see why I can't query for child detail (i.e. product category, product, product revenue) with parent level values included in dimension (i.e. Affiliation). This would be simple to accomplish in SQL... Also, I can do this with standard reports available in Ecommerce section, by selecting a secondary dimension - so why not in custom? User error on my part?
Thanks for your help.
Re: Enhanced Ecommerce - Product Data and Transactions
Custom reports don't, which is whay you can't have transaction-level data coexist with item-level data.
If you were a 360/Premium user, you could use BigQuery and pull that data without a problem, though.
Level 80 Digital Analytics Warrior, KPI Therapist and Keeper of the One True Tagging Plan