Topics started by Graham

1 Topic

G
Contributor I
GrahamContributor I
asked in Developer Group

Exporting metrics per campaign when there are many campaigns

Hi there, I’m able to export metrics for a given metric and a given campaign, however, there are 22 metrics and we have 54 campaigns, so to export all the combinations, it takes ~1,200 API calls and takes hours. Is there a better way to do this? This is how I’m doing it at the moment;Step 1Get all the campaign id's and names;curl https://a.klaviyo.com/api/v1/campaigns -G -d api_key=XXXXX |  jq '.data|.[]| {id: .id, name: .name}'Returns 54 campaigns;{  "id": "UTYxxx",  "name": "July Newsletter"}{  "id": "R7Lxxx",  "name": "May Newsletter"}... Step 2Get all the metric id's and their names;curl https://a.klaviyo.com/api/v1/metrics -G -d api_key=XXXXX |  jq -r '.data|.[]| {id: .id, name: .name}' Returns 22 metrics;{  "id": "HGExxx",  "name": "Clicked Email"}{  "id": "N2vxxx",  "name": "Dropped Email"}... Step 3Get the metric data by iterating over the metric id's and campaign id's. E.g. For the "Clicked Email" metric, HGExxx, and the "May Newsletter" campaign,R7Lxxx ; curl https://a.klaviy

2
G
Contributor I
2 years 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.