Hi. I am currently working on a Google Sheet report using Klaviyo reporting API. I was able to get campaign performances like open rate, click rate, etc. I am working on a monthly basis so I am currently getting March data. I wanted to use the data I gathered to compute the average open rate for campaigns for instance but when I compare it to the overall open rate, in the Campaign Performance card from Klaviyo dashboard, the two numbers are completely different. What should I do? Am I wrong for computing the overall open rate this way?
Answer
Data mismatch between API and Klaviyo dashboard regarding Open Rate
+3Best answer by Christiannoerbjerg
Hi
Thank you for posting in the Community!
Great and interesting question! You're definitely not alone in running into this issue when comparing calculated averages with Klaviyo’s reported metrics.
I think the problem arises, because Klaviyo uses a weighted average, based on how many emails were delivered per campaign.
So when you’re calculating your open rate, you’re possibly using the following formular: (The sum of open rates across your campaigns) / (Number of campaigns, that you have sent).
But the right formular would be: Total tracked opens from all campaigns / Total delivered e-mail from all of your campaigns.
Hope this helps and saves you a bit of head-scratching! :-)
Christian Nørbjerg Enger
Partner & CPO
Web: Segmento.dk
LinkedIn: @christianfromsegmento
Voldbjergvej 22b, 8240 Risskov
+15Hi
Thank you for posting in the Community!
Great and interesting question! You're definitely not alone in running into this issue when comparing calculated averages with Klaviyo’s reported metrics.
I think the problem arises, because Klaviyo uses a weighted average, based on how many emails were delivered per campaign.
So when you’re calculating your open rate, you’re possibly using the following formular: (The sum of open rates across your campaigns) / (Number of campaigns, that you have sent).
But the right formular would be: Total tracked opens from all campaigns / Total delivered e-mail from all of your campaigns.
Hope this helps and saves you a bit of head-scratching! :-)
Christian Nørbjerg Enger
Partner & CPO
Web: Segmento.dk
LinkedIn: @christianfromsegmento
Voldbjergvej 22b, 8240 Risskov
+3Hi
Thank you for your answer. It really helps.
I will come back here if I have other questions.
Prunella DOUSSO
Log in to the Community
Use your Klaviyo credentials
Log in with Klaviyo
Use your Klaviyo credentials
Log in with KlaviyoEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.