Replies posted by fpicanza

7 Replies

F
Contributor IV
fpicanzaContributor IV
asked in Developer Group

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

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! 

9
F
Contributor IV
2 months ago
F
Contributor IV
fpicanzaContributor IV
asked in Developer Group

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

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 403

9
F
Contributor IV
2 months ago
F
Contributor IV
fpicanzaContributor IV
asked in Developer Group

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

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

9
F
Contributor IV
2 months ago
F
Contributor IV
fpicanzaContributor IV
asked in Developer Group

attributed_message not working?

Once again, thank you Saulblum. That nuance did not jump at me when I was going through the examples in the doc. I did not grasp that different metrics used different properties to represent the campaign. From what I’ve just tested now, I can see that either of the following will accomplish what I need"by": ["$message"] will get me the campaign Idand"by": ["Campaign Name"], will get me the campaign name  

3
F
Contributor IV
2 months ago
F
Contributor IV
fpicanzaContributor IV
asked in Developer Group

attributed_message not working?

Here is a little more info from another test I just performed.If I do "by": ["$message"]  ...then in what is returned there is a breakdown on a property named dimensions which contains the value of a message_Id But if I do "by": ["$attributed_message"]  ...then in what is returned there is a property named dimensions but it is empty. Why would it not contain the campaign_id from my campaigns?

3
F
Contributor IV
2 months ago
F
Contributor IV
fpicanzaContributor IV
asked in Developer Group

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

That will do the trick! Thanks a whole bunch!  

9
F
Contributor IV
2 months ago
F
Contributor IV
fpicanzaContributor IV
asked in Developer Group

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

Hi Saulblum,I appreciate your proposed solution but I have checked that comparison chart and I do not find anything for what would have been api/v1/metric/{metric_id}/profiles in the old version. :( 

9
F
Contributor IV
2 months ago

Most helpful members this week

Terms & ConditionsCookie settings

Links & Resources

Platforms

Partners

Useful Things

About

  • Terms and Privacy
    © 2024 Klaviyo All rights reserved. Klaviyo and the Klaviyo logo are trademarks or registered trademarks of Klaviyo, Inc. or its affiliates.