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

Question

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

alex.hong · Accepted Answer

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

Shital Pacharne · Answer

What should i do nowI mean how should i get number of deliver email and number of click emailI am little confuse for passing metric ID to the following APIhttps://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

Sign up

Use your Klaviyo credentials

Log in to the Community

Use your Klaviyo credentials

Scanning file for viruses.

This file cannot be downloaded