How can I get metrics such as click_rate, open_rate, and aov filtered by segment through api

Question

I would like to be able to pull the click rate, open rate, and average order value for a specific segment using the klaviyo api (the values that I see available when I run the engagement report under a specific segment in the klaviyo ux).

How can I do this?

I’ve already tried using metric aggregates and filtering by id and that doesn’t seem to work and I looked at segments report under reporting api but that doesn’t seem to give me any metrics other than members. I’ve also tried using the campaigns and flows reports under the reporting api and that doesn’t seem to allow me to filter or group by a segment.

Is there some way that I’m missing? Surely the functionality to filter by segments is available in the api?

Thanks for your help!

Kim from Cadence · Accepted Answer

Hey ​@Email Pulse, unfortunately this functionality isnot available through Klaviyo’s API todaybut is a good feature request! cc ​@Byrne CCadence/Book a demo

talha.hussain · Answer

Hi ​@Email Pulse, Right now there is no single Klaviyo API endpoint that returns open rate, click rate, and AOV already filtered by a segment.The usual approach is:Get the segment membersUse the Segments API to retrieve the profile IDs that belong to the segment.Pull the raw metricsUse the metrics or aggregates endpoints to pull totals for events like Received Email, Opened Email, Clicked Email, and Placed Order over your time range.Calculate the metrics yourselfOpen rate equals opens divided by receivedClick rate equals clicks divided by receivedAOV equals total revenue divided by total ordersImportant to noteSegment reporting endpoints are focused on segment membership changes, not engagement or revenue metrics. Because of that, calculating these values outside of Klaviyo is currently required if you need them strictly filtered by segment.

Sign up

Use your Klaviyo credentials

Log in to the Community

Use your Klaviyo credentials