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 | Daytime 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 the selected time analysis interval |
| Active Stores With Placed Orders | Total stores with at least one sent the order on time analysis interval |
| Total Orders | Quantity of Sent Orders in the selected analysis interval. |
| Total Revenue | Total amount of revenue generated in the selected time analysis interval |
| Total Quantity Of Items | Total quantity of products/items sold in the selected time analysis interval |
| Quantity Of Distinct Products Sold | Quantity of distinct SKUs or items sold in the selected time analysis interval |