Looking for example on getting all the profiles that performed an activity on a campaign

There’s a handy comparison chart for the new API.

Get Events and filtering on the metric ID will get you all events for a given metric.

Hi Saulblum,

If I look at my campaigns on the Klaviyo site, I can see the Open, Clicked and Active on site numbers on the page shown in the screenshot. 

I wanted to get the profile_id of people that fall under each of those events for each of the campaigns. I’ve been mostly successful thanks to your help. 

For the Open and the Clicked events, I’ve used https://a.klaviyo.com/api/events/?filter=equals(metric_id,"METRIC_ID") to get info on the "clicked-email" metric and for the "opened-email" and I was able to tie each instance to a campaign by looking at the property  attributes.event_properties.CampaignName for the campaign name and looking at attributes.event_properties.message for the CampaignId. 

However when I do the same for the metric Active on site, I can’t get the same because the CampaignName, and $message are not returned by the call to the API for that metric. Only a tiny subset  of the properties is returned as shown below.

Since on the first screenshot of this reply it shows the Active on Site for each campaign, I know it is feasible to the event to a campaign but how is it done for that one? 

I have tried it but it does not seem to work. 

in this screenshot we see that my recipients under Open rate is 4037, Click Rate is 162 and Active on Site is 44

Here is the body of my request posted to https://a.klaviyo.com/api/campaign-values-reports/ where there was no options for Active on site in the statistic drop-down of https://developers.klaviyo.com/en/reference/query_campaign_values so I have put its metric_id in the Conversion metric id as you suggested...

{
  "data": {
    "type": "campaign-values-report",
    "attributes": {
      "statistics": [
        "clicks_unique",
        "opens_unique"
      ],
      "timeframe": {
        "start": "2024-01-01T00:00:00",
        "end": "2024-12-31T23:59:59"
      },
      "conversion_metric_id": "METRIC_ID_FOR_ACTIVE_ON_SITE",
      "filter": "and(equals(campaign_id,\"CAMPAIGN_ID\"),contains-any(send_channel,[\"email\",\"sms\"]))"
    }
  }
}

Running this returns the following properties shown in the screenshot below. We can see the 162 clicks and 4037 open but nothing about the 44 Active on site. 

Yes it does. Thank you so much Saulblum. It’s a good thing that you are around to spread this knowledge as simply reading the docs by themselves do not make a clear enough on how to go about achieving this. That makes you a priceless resources! Thanks again!