Skip to main content
Solved

Analyzing data pulled from API in Google Sheets

  • August 26, 2021
  • 1 reply
  • 939 views

Forum|alt.badge.img+2

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.

Best answer by julie.accardo

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. This endpoint 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

View original
Did this topic or the replies in the thread help you find an answer to your question?

1 reply

julie.accardo
Klaviyo Employee
Forum|alt.badge.img+36
  • Klaviyo Employee
  • 185 replies
  • Answer
  • August 28, 2021

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. This endpoint 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