Topics started by airboxr

5 Topics

A
Contributor IV
airboxrContributor IV
asked in Developer Group

data discrepancy between api and klaviyo dashboard

hi, i’m using metric aggregates endpoint to get subscribed and unsubscribed numbers like thisconst start_date = '2023-07-01';const end_date = '2023-08-01';const total_subbed_to_list = await axios.request({ method: 'POST', baseURL: 'https://a.klaviyo.com/api/metric-aggregates', headers: { accept: 'application/json', revision: '2023-06-15', Authorization: `Klaviyo-API-Key ${api_key}`, }, data: { data: { type: 'metric-aggregate', attributes: { metric_id: metricId['Subscribed to List'], interval: 'month', measurements: ['count'], filter: [`greater-or-equal(datetime,${start_date})`, `less-than(datetime,${end_date})`], page_size: 10000, timezone: 'UTC', }, }, },});similarly i’m getting it for ‘Unsubscribed’ and ‘Unsubscribed from List’here are the results i’m getting from the api for july"total_subbed_to_list": 104,"total_unsubbed": 164,"total_unsubbed_from_list": 0 but on the dashboard it shows different numbers. 

1
Brian Turcotte
Community Manager
8 months ago
A
Contributor IV
airboxrContributor IV
asked in Developer Group

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

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? 

4
David To
Klaviyo Employee
10 months ago
A
Contributor IV
airboxrContributor IV
asked in Developer Group

Data discrepancy between API and dashboard

Hi, i’m using the latest stable version of Klaviyo API to fetch number of opened emails, here’s the API request config{ method: 'POST', baseURL: 'https://a.klaviyo.com/api/metric-aggregates/', headers: { accept: 'application/json', Authorization: `Klaviyo-API-Key ${apiKey}`, revision: '2023-06-15', 'content-type': 'application/json', }, data: JSON.stringify({ data: { type: 'metric-aggregate', attributes: { measurements: ['unique'], filter: [`greater-or-equal(datetime,${start_date})`, `less-than(datetime,${end_date})`], by: ['$message'], metric_id: metric_id, interval: 'month', }, }, }),};i then sum the values based on campaign, but the data is not accurate when compared to the dashboard, in the dashboard no. of opened emails is higher than what i get from the APIIs this a bug or is there any explanation for these discrepancies? same is happening with other metrics as well like ‘Clicked Email’, ‘Active on Site’, e

1
Brian Turcotte
Community Manager
10 months ago
A
Contributor IV
airboxrContributor IV
asked in Integrations and Reviews

Campaign API missing fields

Hey guys, It looks like the new Campaign API does return sent_at and subject fields.These are important properties that our app uses.- Is there any way to fetch these fields with the new APIs? - If not, what are some alternative properties that we can use instead of these fields?Thank you.FYI:New docs: https://developers.klaviyo.com/en/reference/get_campaignv1/v2 docs: https://developers.klaviyo.com/en/v1-2/reference/get-campaigns

2
Brian Turcotte
Community Manager
10 months ago
A
Contributor IV
airboxrContributor IV
posted in Developer Group

Klaviyo event timeline data mismatch with the dashboard

I’m trying to get revenue through api and for that i’m fetching the timeline data of ‘Placed Orders’ metric (using this endpoint `/api/v1/metric/${metricId}/timeline`) and summing up `event_properties.$value` but the number is significantly different from what i see in the dashboard, any reason for that?

2
Brian Turcotte
Community Manager
11 months ago

Most helpful members this week

Terms & ConditionsCookie settings

Links & Resources

Platforms

Partners

Useful Things

About

  • Terms and Privacy
    © 2024 Klaviyo All rights reserved. Klaviyo and the Klaviyo logo are trademarks or registered trademarks of Klaviyo, Inc. or its affiliates.