get
https://developers.yotpo.com/messaging/v3/stores//analytics/query/aggregations
Aggregate data based on dimensions and measures from a specified source such as campaigns or flows. The data for each store is available from the Yotpo account creation date.
Recent Requests
Log in to see full request history
| Time | Status | User Agent | |
|---|---|---|---|
Retrieving recent requests… | |||
Loading…
Suggested FiltersYou can use Filters to get specific dimension value, for example:
source_type=campaign, channel_type=email
Important:The data via API is returned on an hourly basis and in UTC. The data on the Yotpo admin is shown in EST.
It is recommended to convert to EST and sum up the data for each day. Don't use the date aggregation since it won't match between the UTC and EST - always convert and then sum up the hours.
To learn more about how to query a range of dates in the aggregation API you can look here.
Example
Below is an example of a request that can be sent.
https://developers.yotpo.com/messaging/v3/stores/{store_id}/analytics/query/aggregations?dimensions[]=channel_type&dimensions[]=source_type&dimensions[]=source_name&filters[]=source_type=campaign&dimensions[]=source_id&dimensions[]=aggregation_date&measures[]=all_sent&measures[]=all_delivered&measures[]=all_open&measures[]=all_unique_open&measures[]=opened_delivered_rate&measures[]=unique_opened_delivered_rate&measures[]=all_clicks&measures[]=all_unique_clicks&measures[]=click_through_rate&measures[]=unique_click_through_rate&measures[]=all_orders&measures[]=all_revenue&measures[]=all_unsubscribed&measures[]=unsubscribe_rate&measures[]=average_order_value