Query and aggregate event data associated with a metric, including native Klaviyo metrics, integration-specific metrics, and custom events. Queries must be passed in the JSON body of your POST request.
Results can be filtered and grouped by time, event, or profile dimensions.
Request body parameters (nested under attributes):
page_size: limit the number of returned results per page
by: optional attributes used to group by the aggregation function
When using by attributes, an empty dimensions response is expected when the counts for the events do not have the associated dimension requested by the set by attribute. For example, a query including "by": ["$flow"] will return an empty dimensions response for counts of metrics not associated with a $flow
measurement: the measurement key supports the following values:
"sum_value": perform a summation of the _Event Value_, optionally partitioned over any dimension provided in the by field
"count": counts the number of events associated to a metric, optionally partitioned over any dimension provided in the by field
"unique" counts the number of unique customers associated to a metric, optionally partitioned over any dimension provided in the by field
interval: aggregation interval, such as "hour","day","week", and "month"
metric_id: the metric ID used in the aggregation
filter: list of filters for specific fields, must include time range using ISO 8601 format ("YYYY-MM-DDTHH:MM:SS.mmmmmm")
The time range can be filtered by providing a greater_or_equal filter on the datetime field, such as "greater-or-equal(datetime,2021-07-01T00:00:00)" and a less-than filter on the same datetime field, such as "less-than(datetime,2022-07-01T00:00:00)"
The time range may span a maximum of one year. Time range dates may be set to a maximum of 5 years prior to the current date
Filter the list of supported aggregate dimensions using the common filter syntax, such as "equals(URL,\"https://www.klaviyo.com/\")"
timezone: the timezone used when processing the query. Case sensitive. This field is validated against a list of common timezones from the IANA Time Zone Database
For a comprehensive list of native Klaviyo metrics and their associated attributes for grouping and filtering, please refer to the metrics attributes guide.