Solved

Basic Ecommerce Reporting

  • 11 January 2023
  • 4 replies
  • 139 views

Is there a way to create an ecommerce report where the ROW is a product name (such as large blue shoe) and the Metric is an event (such as view_item)?

icon

Best answer by Saish Redkar 11 January 2023, 19:07

View original

4 replies

Userlevel 7
Badge +10

Hey @AnalyticsNinja 

You can try Data Tables for this. Here’s a demo chart for quick reference for your use case.

Hope this helps.

Thanks @Saish Redkar 

I’ve recently configured my Event Properties to use Splitting of the products array.  I don’t see them available in the Data Table.  Does it take time for those to populate?

 

Also, the Data Table doesn’t have any graphs.  Is it possible to use a dimension from an array (such ‘product name’ and graph performance of a metric over time?

Also, any idea how to create a simple metric such as “product revenue”.

Product Revenue is the sum of the item’s price * quantity.

 

I’m not seeing how to do that within the Metrics beta.  Price is generally not an integer (rather, it is a float), and it isn’t possible to multiply the value times quantity.  I must be missing something.

 

 

Userlevel 7
Badge +10

Hey @AnalyticsNinja 

Data Tables can be mostly used for summarizing your data into a tabular format and not for graphing trends over a time frame. For that, an event segmentation chart like this will help.

 

I haven’t played around with the Metric feature that much, but looks like it focuses more on the Sum part than the ability to multiply values for now.
Since you are sending the price and quantity as separate values on the purchase event, I’m not sure what’s the best way to use that in Metric. In the demo environment, Amplitude is capturing the $revenue property and summing that up on their purchase event .

More on the $revenue properties here.

 

You can also try to use Derived Properties and create a revenue property using the MULTIPLY formula.


Hope this helps.

Reply