When using the Klaviyo connector in Catchr, the following metrics behave differently depending on how you query them:
API – Placed Order Value (revenue)
API – Placed Order (orders)
By default, these metrics return the total orders and revenue, not specifically the amounts attributed to Klaviyo campaigns.
To retrieve data attributed to Klaviyo, you must include a breakdown by campaign:
Use a campaign-related dimension such as Campaign Name or Campaign ID.
This ensures the API only returns orders and revenue attributed to Klaviyo.
If you want a simple scorecard (no campaign breakdown) in Looker Studio, you can:
Add a filter → Exclude Campaign equals “a”.
This filter doesn’t actually exclude anything, but it forces the query to run at the campaign level.
The API then returns the attributed orders and revenue, rather than totals.
In Power BI, Tableau, Google Sheets, Microsoft Excel or any database
It’s best practice to add a Campaign Name or Campaign ID breakdown.
Then, sum the metrics to get the total attributed values.
Without a campaign breakdown, Klaviyo’s API will always return the global totals, not the attributed results.