Topics started by IrinaK

2 Topics

I
Contributor I
IrinaKContributor I
asked in Developer Group

How to get a list of all Flows and Emails from API

Question 1: Do any messages exist that are not a part of a Flow or Campaign? If so, what would be the way to export ALL messages through the API, and which API would I use for this? Question 2: I want to export the flow data from API the same way they are exported from a UI report on flows. UI report lists individual emails/SMS for each flow. Example of an UI report:Flow ID Flow Name Flow Message ID Flow Message Name Flow Message Channel Status Delivered Unique Opens WEBBnY Approved SMS ViTyk5 SMS #3 SMS draft 85 0 WEBBnY Approved SMS Rf5KGu Approved SMS draft 464 0 WEBBnY Approved SMS Wfe3Pp Email #1 Email draft 865 604  Now, when I export the data from Flows API v3 ("https://a.klaviyo.com/api/flows”), I get a list of flows only. It does not include individual emails. I does give me an option to filter the results for specific email IDs. But I need a list of all emails so it looks similar to the above. What I get from Flows A

2
Brian Turcotte
Community Manager
10 months ago
I
Contributor I
IrinaKContributor I
asked in Developer Group

How to obtain Open Rate, Click Rate, Klaviyo Revenue through API

My client has been downloading Klaviyo reports through the UI by hand. She wants to automate this by exporting the data to Google Sheets through the API. I am a dev new to Klaviyo who got was task. The metrics needed are Revenue, Open Rate, Click Rate. I have been at this for over 5 days. I got through the Get Started Steps. Then I had to select which API to use, etc. etc. I found a Help Center article How to Export Conversion Data. It seems to cover the subject that I need. However, it gives v1 APIs which are no longer current. Per this article, my first step was to export all of the campaigns. As the list of campaigns turned out to be multi-page, I had to take care of fetching all the pages. I got through that. I am sharing a Google Apps Script function I ended up with, in case it might help anyone else or be improved. I also fetched all the metrics available in the account through the /metrics endpoint. I also found a trick, not prominently displayed: "you can find the metric_id in

3
Brian Turcotte
Community Manager
10 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.