Hi, we’re using the latest stable version of the “Query Metric Aggregates” endpoint and we’re using it to query common use-cases e.g. “Revenue”, “active on site”, etc.
The “interval” filter for this API does not seem to have much documentation (https://developers.klaviyo.com/en/docs/using_the_query_metric_aggregates_endpoint)
We know that it is for aggregating the data. But why does “day” and “month” return different results?
Data discrepancy between interval "month" vs "day" (using Query Metric Aggregate)
Best answer by David To
Hey
That’s certainly an interesting behavior. Sounds like there may be other factors involved in the discrepancies you’re seeing then. Other than how the interval grouping is calculated.
If you’re on a paid subscription, I would suggest reaching out to our wonderful Support colleagues. Although our colleagues can’t provide coding assistance, they may be able to help spot the cause of this discrepancy in learning more about how you have things set up.
When it comes to which interval is more appropriate, it really depends on your business strategies. There’s really no right or wrong option here as it all involves the same data, just viewed from different perspectives.
As I like to say, it’s just all a matter of how you want to cut the pie.
David
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.