Data mismatch between API and Klaviyo dashboard
Hello,
We’ve noticed some mismatches between the data that we get from the API and the data on the Klaviyo dashboard.
For the campaign highlighted in red here for example, the API returns 1756 for the recipient count.
Moreover, the click rate and open rate don’t match either. We arrive at 63.38% for the open rate by computing unique email opens / recipient count. This is not explained by the recipient count mismatching alone obviously, so there is a discrepancy in the email open count as well.
Finally, the value for opened emails is different if we request them by day vs by month for the same 30 day date range. When going by day, the total is 1.113, however if we set unit to month, the result is 906.
Could someone provide some insight into this?
(API responses below)
{
"metric": {
"object": "metric",
"id": "X5h9ua",
"name": "Opened Email",
"integration": {
"object": "integration",
"id": "0rG4eQ",
"name": "Klaviyo",
"category": "Internal"
},
"created": "2022-02-04 19:52:47",
"updated": "2022-02-04 19:52:47"
},
"start_date": "2023-01-01 00:00:00",
"end_date": "2023-01-31 00:00:00",
"unit": "daily",
"measurement": "q",
"by": "",
"where": [
[
"$message",
"=",
"01GQ5E71NMD2SVRYG3AC6D5Q30"
]
],
"results": [
{
"segment": "Everyone",
"data": [
{
"date": "2023-01-01 00:00:00",
"values": [
0.0
]
},
{
"date": "2023-01-02 00:00:00",
"values": [
0.0
]
},
{
"date": "2023-01-03 00:00:00",
"values": [
0.0
]
},
{
"date": "2023-01-04 00:00:00",
"values": [
0.0
]
},
{
"date": "2023-01-05 00:00:00",
"values": [
0.0
]
},
{
"date": "2023-01-06 00:00:00",
"values": [
0.0
]
},
{
"date": "2023-01-07 00:00:00",
"values": [
0.0
]
},
{
"date": "2023-01-08 00:00:00",
"values": [
0.0
]
},
{
"date": "2023-01-09 00:00:00",
"values": [
0.0
]
},
{
"date": "2023-01-10 00:00:00",
"values": [
0.0
]
},
{
"date": "2023-01-11 00:00:00",
"values": [
0.0
]
},
{
"date": "2023-01-12 00:00:00",
"values": [
0.0
]
},
{
"date": "2023-01-13 00:00:00",
"values": [
0.0
]
},
{
"date": "2023-01-14 00:00:00",
"values": [
0.0
]
},
{
"date": "2023-01-15 00:00:00",
"values": [
0.0
]
},
{
"date": "2023-01-16 00:00:00",
"values": [
0.0
]
},
{
"date": "2023-01-17 00:00:00",
"values": [
0.0
]
},
{
"date": "2023-01-18 00:00:00",
"values": [
0.0
]
},
{
"date": "2023-01-19 00:00:00",
"values": [
0.0
]
},
{
"date": "2023-01-20 00:00:00",
"values": [
0.0
]
},
{
"date": "2023-01-21 00:00:00",
"values": [
0.0
]
},
{
"date": "2023-01-22 00:00:00",
"values": [
0.0
]
},
{
"date": "2023-01-23 00:00:00",
"values": [
0.0
]
},
{
"date": "2023-01-24 00:00:00",
"values": [
718.0
]
},
{
"date": "2023-01-25 00:00:00",
"values": [
210.0
]
},
{
"date": "2023-01-26 00:00:00",
"values": [
61.0
]
},
{
"date": "2023-01-27 00:00:00",
"values": [
37.0
]
},
{
"date": "2023-01-28 00:00:00",
"values": [
24.0
]
},
{
"date": "2023-01-29 00:00:00",
"values": [
24.0
]
},
{
"date": "2023-01-30 00:00:00",
"values": [
21.0
]
},
{
"date": "2023-01-31 00:00:00",
"values": [
18.0
]
}
]
}
]
}{
"metric": {
"object": "metric",
"id": "X5h9ua",
"name": "Opened Email",
"integration": {
"object": "integration",
"id": "0rG4eQ",
"name": "Klaviyo",
"category": "Internal"
},
"created": "2022-02-04 19:52:47",
"updated": "2022-02-04 19:52:47"
},
"start_date": "2023-01-01 00:00:00",
"end_date": "2023-01-31 00:00:00",
"unit": "monthly",
"measurement": "q",
"by": "",
"where": [
[
"$message",
"=",
"01GQ5E71NMD2SVRYG3AC6D5Q30"
]
],
"results": [
{
"segment": "Everyone",
"data": [
{
"date": "2023-01-01 00:00:00",
"values": [
906.0
]
}
]
}
]
}