Data discrepancy between interval "month" vs "day" (using Query Metric Aggregate)

Question

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?

David To · Accepted Answer

Hey@airboxr,That’s certainly an interesting behavior. Sounds likethere may be otherfactors 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

David To · Answer

Hello @airboxr,Great question!The discrepancy you’re seeing when using either the “by day” or “by month” interval grouping is basedon when those metrics/events were triggered.When grouping the data “by day” you’ll get an aggregate of how many times the event was triggered each day by a unique profile.Grouping the data “by month” will do the same thing, but for the entire month.For example, let's say you’re aggregating the data for profiles who have clicked an email within a two-week time frame. A profile is recorded as clicking the same email twice on the first day they received the email which falls into the time frame, but also decides to click on it again the next day.Using the “by day” grouping, this would be counted as 2 clicks. This unique profile clicked on both days. It wouldn’t matter how many times this profile clicked on an email in the same day, it would be counted as 1 click since its unique to them.This same understanding is appliedwhen using the “by month” grouping. Where, using this same example, this user would be counted as 1 click. The data would be viewing the entire month rather than day and grouping the unique profile action as a whole. Using this grouping method despite clicking on two separate days, it doesn’t change the fact that they clicked on the same email within the given time frame of the month.I hope this helps!David

Sign up

Use your Klaviyo credentials

Log in to the Community

Use your Klaviyo credentials