Orders associated with a specific promotion
How to use the Metrics API to get the total number of orders that triggered a specific promotion
Last updated
How to use the Metrics API to get the total number of orders that triggered a specific promotion
Last updated
You want to get the total number of orders to which a specific promotion (identified by its type and name) was applied, over a selected date and time range.
You need to perform a stats query setting the required query keys as follows and adding the optional ones based on your needs:
field
order.id
operator
value_count
Set the desired date and time range using the date_from
and date_to
keys and add additional filters on the line items field to restrict the related computation to the orders that triggered the desired promotion:
types
"in": [ "percentage_discount_promotions" ]
names
"in": [ "Percentage 50" ]
As shown in the example below, use placed_at
as the date_field
in the if you want the results to count all the orders that were placed in the selected date and time range ( about this).
The following request uses the Metrics API to get the total number of orders that triggered a specific promotion:
Just changing a couple of query keys and/or filter parameters you can address lots of very similar use cases, such as: