This API Query summarizes per each Store ID, User ID, Order ID, and DateTime: the total quantity of SKUs or items placed, the total amount of revenue, the total quantity of distinct products within the order.
| 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 | { “flow”: “<workflow_name_or_botid>”, “storeId”: “<storefront_storeid>”, “userId”: “<user_id>” } |
Metrics
| Name | Description |
|---|---|
| DateTime | 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. |
| Order ID | Unique ID of the order generated |
| Store ID | Unique ID of the registered store |
| User ID | Phone number of the user registered in WhatsApp |
| Total Order Revenue | Total amount of revenue generated in the order 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 In Order | Quantity of distinct SKUs or items sold within the order in the selected time analysis interval |