Skip to main content
Solved

How can i calculate openrate and click rate % and match with Dashboard of klaviyo


Forum|alt.badge.img+2

Currently I am getting metric data from following API
https://a.klaviyo.com/api/v1/metrics?api_key=”Key”


Getting campaigns data from Following api
https://a.klaviyo.com/api/v1/campaigns?api_key=”Key

 

What should i do now
I mean how should i get number of deliver email and number of click email
I am little confuse for passing metric ID to the following API
https://a.klaviyo.com/api/v1/metric/${Metics_ID}/export?api_key=”KEY&unit=day&measurement=count&start_date=2022-04-031&end_date=2022-04-03&where=[["$message","=","${Camp_ID}"]]


Formula -  total number of deliverable / click emails*100    RIght?
How can i export data for particular day ?
How can i calculate open rate, click rate and place order for the given date range which should match with dashboard?
I am confuse how should i proceed.
Can you please help me   

Best answer by alex.hong

Hi there @Shital Pacharne,

Welcome to the Community.

Let me know if I am understanding correctly. 

Although you can get some information about campaigns with this endpoint. However, open and click rates are not available.  You can list event timelines for things like Opened Email or Clicked Email with the metrics API. Other than that, the only way to get other information would be through analytics exports in the Klaviyo UI. 

 

Best,

Alex

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

2 replies

Forum|alt.badge.img+2
Shital Pacharne wrote:

 

 

What should i do now
I mean how should i get number of deliver email and number of click email
I am little confuse for passing metric ID to the following API
https://a.klaviyo.com/api/v1/metric/${Metics_ID}/export?api_key=”KEY&unit=day&measurement=count&start_date=2022-04-031&end_date=2022-04-03&where=[["$message","=","${Camp_ID}"]]

Can you please help me   

 


alex.hong
Forum|alt.badge.img+58
  • Klaviyo Alum
  • 1552 replies
  • Answer
  • April 6, 2022

Hi there @Shital Pacharne,

Welcome to the Community.

Let me know if I am understanding correctly. 

Although you can get some information about campaigns with this endpoint. However, open and click rates are not available.  You can list event timelines for things like Opened Email or Clicked Email with the metrics API. Other than that, the only way to get other information would be through analytics exports in the Klaviyo UI. 

 

Best,

Alex