Analyzing data pulled from API in Google Sheets

Question

Hey all,I am a newbie to APIs and my Google Sheets knowledge is… in development.Currently, I’m using APIpheny to pull Klaviyo data into Sheets. My question is:Is it possible to pull in metrics like Open Rate and CTR per campaign/send? So that I could then setup a sheet to display something like:  Campaign Name | Segment | Open Rate | Click Through Rate. I guess my question is: How do I do bring that data together and actually tie the metrics (Open Rate, CTR) to the dimension (Campaign Name) within the sheet? Is that something I do:As part of the API request?	With the sheet itself (I would assume this normally, but if I pull in campaign data, I don’t see this associated with it.)?	Something else I am totally unaware of? Thank you for literally any help or insight anyone can provide on this.

julie.accardo · Accepted Answer

Hi @BDFroedge,Thanks for reaching out to the Klaviyo Community!You can look into exporting data from Klaviyo using our /export endpoint from our Metrics API. Thisendpoint can give you metric data for a time period and filtered for specific campaign IDs, for events like Opened Email and Clicked Email.We do also offer campaign performance reporting within Klaviyo where you can see things like open rate/click rate and conversion data for your campaigns.Have a nice weekend!Julie

Reply

Sign up

Use your Klaviyo credentials

Log in to the Community

Use your Klaviyo credentials

Scanning file for viruses.

This file cannot be downloaded