@learningGuy123, it was unclear that your goal was to get to exact user-level data but now I understand what you’re trying to do. Thanks for clarifying. There is no easy way to do this through the APIs. You’ll need to pull down a lot of data to get to this kind of user-level reporting.
To do so, you would need to
(1) retrieve all the Placed Order from Klaviyo for your relevant using the Get Events API. You can include attribution info by adding ?include=attributions in your URL. You can also filter to just include events for the Placed Order metric, which is the one you care about, using ?filter=equals(metric_id, “PLACED_ORDER_METRIC_ID”).
(2) Filter down to only the events where attributions is tied to the relevant campaign. I’m not sure exactly how this data is structured and it may vary across different channel campaigns, as well as the older single-message vs. omni/multi-message campaigns.
To get clicks and opens at the recipient level, you would similarly retrieve Clicked + Opened Email events and filter down to the ones that had properties associated with the relevant email campaign.
It is not easy to get this kind of data from the API. There are also a number of tools that offer this level of reporting in Klaviyo’s app marketplace, if you decide to go that route.
Cadence / Book a demo