I am trying to get the following KPI metrics (and more) for every email campaign (given the campaign ids). What is a good way to get these? Do I need to use data sync tools such as Fivetran or Airbyte to get all the data and then fire queries on them to calculate them? Here is the Klaviyo schema I got from Fivetran: https://docs.google.com/presentation/d/1PeT41zlqyrVj03umiIPh7mIX-hIN6F1Ds74GiShgH08/edit#slide=id.g23c09aaff5c_0_5
| Open rate |
| Click rate |
| Sales |
| Click through rate |
Best answer by zach.scheimer
Hi! I currently use Fivetran and pull this down. We use the Events table and Metrics table to pull in the correct metrics. To view your metrics in your account, go to Analytics > Metrics on the right-hand side (pictured first below) of your Klaviyo menu then when you click on a specific metric, you’ll see the format https://www.klaviyo.com/metric/ followed by the 6 letter metric ID.
I’ve personally put in a roadmap request to make a campaign table that has all of the metrics rolled up to the campaign level. You can do the same through your rep and they may be able to add it to the road map if enough people request it.
There are also outside companies that do this kind of work that I put below:
+6Hi! I currently use Fivetran and pull this down. We use the Events table and Metrics table to pull in the correct metrics. To view your metrics in your account, go to Analytics > Metrics on the right-hand side (pictured first below) of your Klaviyo menu then when you click on a specific metric, you’ll see the format https://www.klaviyo.com/metric/ followed by the 6 letter metric ID.
I’ve personally put in a roadmap request to make a campaign table that has all of the metrics rolled up to the campaign level. You can do the same through your rep and they may be able to add it to the road map if enough people request it.
There are also outside companies that do this kind of work that I put below:
+20Hi
Another option here would be to utilize our custom reporting, and create a Campaign Performance Report. In this report, you can include Open Rate, Click Rate, Placed Order Revenue, etc. and you can filter by Campaign.
Here is our guide for how to build out one of these reports: https://help.klaviyo.com/hc/en-us/articles/360047022912 .
I hope this helps, and let me know if you have any questions!
Hi! I currently use Fivetran and pull this down. We use the Events table and Metrics table to pull in the correct metrics. To view your metrics in your account, go to Analytics > Metrics on the right-hand side (pictured first below) of your Klaviyo menu then when you click on a specific metric, you’ll see the format https://www.klaviyo.com/metric/ followed by the 6 letter metric ID.
I’ve personally put in a roadmap request to make a campaign table that has all of the metrics rolled up to the campaign level. You can do the same through your rep and they may be able to add it to the road map if enough people request it.
There are also outside companies that do this kind of work that I put below:
Hi
+6Hi
Your Klaviyo rep is a good place to put in a feature request. Putting in a request for campaign-level Fivetran (or other similar platform) data is something that I’ve put in with my rep as well.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
