Hello Klaviyo’s community,
I just need your help to find a solution to my issue.
I’m exporting my data outside from Klaviyo to do my own analysis about clicks/opens regarding specific campaigns/flows.
Everything seemed to work, but when i tried a different unit (from month to week) data are not the same for a same date range.
Here is my postman request by day
And here is the result →
"results": s
{
"segment": "Everyone",
"data": "
{
"date": "2021-04-01 00:00:00",
"values": a
0.0
]
},
{
"date": "2021-04-02 00:00:00",
"values": a
0.0
]
},
{
"date": "2021-04-03 00:00:00",
"values": a
0.0
]
},
{
"date": "2021-04-04 00:00:00",
"values": a
0.0
]
},
{
"date": "2021-04-05 00:00:00",
"values": a
0.0
]
},
{
"date": "2021-04-06 00:00:00",
"values": a
0.0
]
},
{
"date": "2021-04-07 00:00:00",
"values": a
0.0
]
},
{
"date": "2021-04-08 00:00:00",
"values": a
0.0
]
},
{
"date": "2021-04-09 00:00:00",
"values": a
0.0
]
},
{
"date": "2021-04-10 00:00:00",
"values": a
0.0
]
},
{
"date": "2021-04-11 00:00:00",
"values": a
0.0
]
},
{
"date": "2021-04-12 00:00:00",
"values": a
0.0
]
},
{
"date": "2021-04-13 00:00:00",
"values": a
0.0
]
},
{
"date": "2021-04-14 00:00:00",
"values": a
0.0
]
},
{
"date": "2021-04-15 00:00:00",
"values": a
0.0
]
},
{
"date": "2021-04-16 00:00:00",
"values": a
0.0
]
},
{
"date": "2021-04-17 00:00:00",
"values": a
5.0
]
},
{
"date": "2021-04-18 00:00:00",
"values": a
8.0
]
},
{
"date": "2021-04-19 00:00:00",
"values": a
12.0
]
},
{
"date": "2021-04-20 00:00:00",
"values": a
2.0
]
},
{
"date": "2021-04-21 00:00:00",
"values": a
2.0
]
},
{
"date": "2021-04-22 00:00:00",
"values": a
1.0
]
},
{
"date": "2021-04-23 00:00:00",
"values": a
2.0
]
},
{
"date": "2021-04-24 00:00:00",
"values": a
2.0
]
},
{
"date": "2021-04-25 00:00:00",
"values": a
8.0
]
},
{
"date": "2021-04-26 00:00:00",
"values": a
3.0
]
},
{
"date": "2021-04-27 00:00:00",
"values": a
6.0
]
},
{
"date": "2021-04-28 00:00:00",
"values": a
3.0
]
},
{
"date": "2021-04-29 00:00:00",
"values": a
5.0
]
},
{
"date": "2021-04-30 00:00:00",
"values": a
4.0
]
},
{
"date": "2021-05-01 00:00:00",
"values": a
5.0
]
}
]
}
]
But same call with a different unit
https://a.klaviyo.com/api/v1/metric/ID_of_my_opened_email_metric/export?unit=month&measurement=unique&start_date=2021-04-01&end_date=2021-06-01&where=gc"$message","=",{{message_id}}]]&api_key={{klaviyo_api_key}}
Here is the result →
"results": >
{
"segment": "Everyone",
"data":
{
"date": "2021-04-01 00:00:00",
"values":
55.0
]
},
{
"date": "2021-05-01 00:00:00",
"values":
84.0
]
},
{
"date": "2021-06-01 00:00:00",
"values":
35.0
]
}
]
}
]
So for the same call, same date range (2021-04-01), i get →
| Api Call 1 | 68 clicks |
|---|---|
| Api Call 2 | 55 clicks |
Can someone explain me why ?
Thanks a lot.
Thomas.