This API Query shows a result table that summarizes the number of active stores (defined as those who are registered), active stores with placed orders, quantity or the number of sent orders, the number of unique products sold, the total quantity of SKUs or items, the total amount of revenue, all of these, calculated per day, per each flow ID.
| Filter Base | { "queryName": "<query_name>", "limit": "<total_records_to_return>", "timeZone": "<time_zone>" , "startDate": "<init_date_yyyy-mm-dd HH:mm:ss>", "endDate": "<end_date_yyyy-mm-dd HH:mm:ss>" } |
|---|---|
| Custom Filters | N/A |
Metrics
| Name | Description |
|---|---|
| Date | Time interval of analysis |
| Customer Name | The customer company that owns the flows. |
| Flow | It helps to understand which of our flows the information corresponds to. |
| Active Stores | Total stores who interacted with Storefront on analysis interval |
| Active Stores With Placed Orders | Total stores with at least one sent order on analysis interval |
| Total Orders | Quantity of Sent Orders in the selected analysis interval. |
| Quantity Of Distinct Products Sold | Quantity of distinct SKUs or items sold in the selected time analysis interval |
| Total Quantity Of Items | Total quantity of products or items sold in the selected time analysis interval |
| Total Revenue | Total amount of revenue generated in the selected time analysis interval |
| Storefront | Commerce platform version used for the web view of the products |