Skip to main content
Docs
Feature Requests Onboarding Trust Center Status Page

Community

klaviyo__campaigns Model

Answered
Erica McMahon User

Hello,

We have some columns coming back in the klaviyo__campaigns model without any accurate data. Just returns zeroes. Do we know why this is happening?

Thanks!

Erica

sum_revenue_refunded_order
sum_revenue_placed_order
sum_revenue_ordered_product
sum_revenue_checkout_started
sum_revenue_cancelled_order
count_unsubscribed
unique_count_unsubscribed

Please sign in to leave a comment.

Comments

1 comment

Date Votes
  • Official comment
    Joe Fivetranner

    Hi Erica, thanks for reaching out!

    These columns are driven by the metrics in the source data. These are default metrics we've provided in the pre-built report, but that doesn't necessarily mean ever user will have these metrics. You can confirm if these events exist in your data by checking the `stg_klaviyo__event` table and confirming if any of these zero events are present as `type` field values.

    If you don't see any then that would confirm you don't have events recorded for this metric type. However, we do offer the ability to customize these metrics via the "Settings" tab of your Quickstart data model transformation. There you can modify the "Count Metric Event Types" and "Revenue Metric Event Types" to match what exists in your data.

    Let me know if you have any other questions. Thanks!