Connector Improvement: Pulling In Entire klaviyo Events Table To Get Only 5 Kpi's
Planned
The current Klaviyo connector is prohibitively expensive for any brand. While an average connector (i.e. facebook), may cost around 1-$200 a month. The Klaviyo connector will charge you thousands of dollars in a matter of days.
The issue is the events table. It is absolutely massive, and contains so many events that I gurantee no one cares about.
For my specific use case, I simplay want to get only a few kpi's from the klaviyo events. Those are open rate, delivery rate, click through rate, and thats it. But in order to get thee few kpi's, I have to pull in the entire events table, and it is so much data that it would be insane for me to leave it live only to get those couple kpi's
So my request would be, to be able to pull out only these critical kpi's I am looking for from the klaviyo data so we can actually afford to use it. Thank you
-
Official comment
Hi Adam,
Luke from the Product team here. Thanks for submitting this feature request.I understand your frustration with the amount of data required to report on a few metrics. We added the ability to create a report on our Klaviyo connector: https://fivetran.com/docs/connectors/applications/klaviyo/setup-guide#optionaladdreport. This new feature leverages Klaviyo's Reporting API. This API delivers aggregated metrics instead of the raw event data we sync to our EVENT table.
This reporting feature is in private preview and currently only supports Flow reports. However, we plan to expand this feature to the other reports offered by Klaviyo. Note: Klaviyo doesn't provide a Campaign Series reporting endpoint, so currently we are blocked from creating campaign reports, but we're hopeful they will add that soon.
Would love to know what types of reports you'd be interested in creating.
Thanks,
Luke
Please sign in to leave a comment.
Comments
1 comment