Comparing Metrics From Different Campaign Reports

Question

I built two reports in the Custom Reports section. The first is Email Campaign Performance Data By Day and it allows me to select message name, and the the unique sum and total sum of opens and clicks. The second is Email Engagement by Campaign Report and it shows a single line for every campaign with the same metrics (unique sum and total sum of opens and clicks). When I aggregate the unique opens by email campaign name in both reports, the totals do not match. Is this because the Unique count in the By Day report is showing the same person multiple times if they returned on a different day? Whereas the email engagement by campaign report shows the total unique count of people that opened the email?

If this is the case, how can I extract the Email Engagement By Campaign Report data via API?

chloe.strange · Accepted Answer

Hi @wsdev_td,Unique metrics are aggregated over a time period. It is possible that unique opens by day vs. across days would result in different count due to the difference in aggregation. For example, if one person opens an email once per day 7 times, that would be 1 unique each day for 7 days but 1 unique aggregated over the 7 days.In order to fetch this information by API, you can use the Reporting API. You can pass in your campaign ID in order to fetch metrics per campaign including opens and clicks. Please see the link to the reporting api here: https://developers.klaviyo.com/en/reference/reporting_api_overview. I hope this helps!~Chloe

Reply

Sign up

Use your Klaviyo credentials

Log in to the Community

Use your Klaviyo credentials

Scanning file for viruses.

This file cannot be downloaded