Topics started by hassanashas

2 Topics

H
Contributor I
hassanashasContributor I
asked in Developer Group

How to obtain Total Clicks, Total Opens, Unique Opens against the Campaigns using Klaviyo API

HI, I am trying to get the Total Opens, Unique Opens and Total Clicks against my campaigns.  I am able to get the Campaign Information using the following code,  import requestsimport pandas as pd url = "https://a.klaviyo.com/api/campaigns/?filter=equals%28messages.channel%2C%27sms%27%29"headers = { "accept": "application/json", "revision": "2023-12-15", "Authorization": f"Klaviyo-API-Key {API_KEY}"}response = requests.get(url, headers=headers)campaigns = response.json()data = campaigns['data']transformed_data = [{ 'id': item['id'], 'Name': item['attributes']['name'], 'Status': item['attributes']['status'], 'Send Date': item['attributes']['send_time'] } for item in data]campaigns_df = pd.DataFrame(transformed_data) What I need now is the Total Clicks, Unique Opens and Total Opens against these campaigns over a certain period of time. I have been trying to use query metric aggregates endpoint but its not helping me at all.  What I have tried so far is the followi

2
H
Contributor I
3 months ago
H
Contributor I
hassanashasContributor I
asked in Developer Group

I can get Opened Email Count by Messages but how do I get the same for Campaigns

Hi,  I need to figure out a way to get the count of emails opened, I am able to get the Campaigns data with the following code, import requestsurl = "https://a.klaviyo.com/api/campaigns/?filter=equals(messages.channel,'email')"headers = { "accept": "application/json", "revision": "2023-12-15", "Authorization": f"Klaviyo-API-Key {API_KEY}"}response = requests.get(url, headers=headers)campaigns = response.json()data = campaigns['data']transformed_data = [{ 'id': item['id'], 'Name': item['attributes']['name'], 'Status': item['attributes']['status'], 'Send Date': item['attributes']['send_time'] } for item in data]campaigns_df = pd.DataFrame(transformed_data) Now, I want to get the following items against each Campaign,  Opened Email CountUnique Opens Click Rates  I understand that I need to use Query End Parameter for this purpose. My understanding is that if we want to group the data by campaign_id, then we use by = [‘$attributed_message’]. So I used the following

7
S
Klaviyo Employee
3 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.