Calculating open rate using events leading to incorrect results

Question

Hello,I currently have a service that syncs Klaviyo events to a data warehouse, where we calculate metrics such as open rates and click-through rates by aggregating event data.When calculating the open rate for a given campaign, we follow this process:Unique Open Rate: Group events of type 'Opened Email' by recipient email and count distinct.	Total Recipients: Group events of type 'Received Email' by recipient email and count distinct.We then calculate the open rate as:Open Rate = (Unique Open Rate / Total Recipients).However, for one of our campaigns, we're seeing an issue where the Unique Open Rate is 36,410, while the Total Recipients is only 240. This results in an impossible open rate, as the number of opens significantly exceeds the total recipients, which shouldn't be possible.Could you assist with this? Can you verify on your end that the events API is 100% accurate and correctly reporting all events?

chloe.strange · Accepted Answer

Hi @stevenwithnorby,Can you share with us exactly how you are querying the events AP in order to get the Opened Email and Received Email events that are going into your data warehouse? Including arguments to the API. Please mask any sensitive data as necessary, e.g. for Ids that are the same, make sure they have the same mask.~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