How to replicate Klaviyo Revenue (Flow and Campaigns) using the Events table?

Question

Hey everyone!So I’ve been trying to replicate what I see on the klaviyo’s dashboards to our local dashboard tool. We have a connection with the Klaviyo API and everything seems to be working fine.However, I’m facing difficulties when matching the values I see on Klaviyo and and the ones we get from the API.From Klavyio we get this “event” JSON file, and there we identify if the purchase was a Flow or Campaign due to “attributtion” fied. However, when I sum up to a specific date, the number are always pretty different (5 - 20%) different.  Did anyone has ever face that? Thank you very much!

Omar · Accepted Answer

@giovanniggI've not yet done this and I wouldn't be able to help out besides adding the fact that attribution in Klaviyo is given to the last email sentbefore a purchase within the atribution timeframe set in settings.Not sure if it's relevant or useful.Omar Lovert//Polaris Growth//Klaviyo Master Platinum PartnerWe helpwith e-commerce growth through CRO, Klaviyo and CVO

growth_hack_404 · Answer

Did you maybe find a solution to this problem?

I’m using the API, the metric-aggregates endpoint, and I also get different values from the dashboard when calculating the revenue.

From my analysis, I concluded that the values returned by the API are probably dated based on when the email was sent, while the once I see in the dashboard are reported on the date the order was placed.

Sign up

Use your Klaviyo credentials

Log in to the Community

Use your Klaviyo credentials