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)?
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.
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.
I am running into a loop when attempting to import data from BigQuery. At origin, my data is already in milliseconds since epoch. If I query: event_time as time, I get the error: 1.'time' column should be a TIMESTAMP_NTZ column (Snowflake) or a TIMESTAMP column (BigQuery). example for the type of 'time' column is…
How do I transfer data from one amplitude account to another? It seems all the community chats about this have completely broken links. Easy to export, no way to import, very frustrating. :(
When using @amplitude/plugin-web-vitals-browser with Create React App v4 (react-scripts@4.0.3), the build fails with: ./node_modules/@amplitude/plugin-web-vitals-browser/node_modules/web-vitals/dist/web-vitals.js<br /><br />SyntaxError:…
Hello, I'm using SpringBoot and Kotlin to integrate with the Amplitude Export API. The official Amplitude documentation (https://amplitude.com/docs/apis/analytics/export) states that "data is available to export at a minimum within 2 hours of when the servers received it." However, there's no clear information about the…
Hello, Is there a way to make a query like: “Give me all the users that have the user property X equal to 10”, by using just any of the APIs, without making a cohort first through the Amplitude’s UI? Thank you!
