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

Community

Klaviyo campaign-level Reporting API support

Answered
Adam Alexander User
  • Edited

Connector name: Klaviyo

Table name:
campaign_message_reporting
or campaign_values_report

or something simliar

API documentation link:
Klaviyo Reporting API overview:
https://developers.klaviyo.com/en/reference/reporting_api_overview

Klaviyo Query Campaign Values endpoint:
https://developers.klaviyo.com/en/reference/query_campaign_values

Additional details:
We need Fivetran’s Klaviyo connector to support campaign message-level performance reporting that matches Klaviyo UI/exported campaign performance reports.

The target grain is one row per campaign message/send, with fields similar to the ones below. A sample report can be provided if helpful:

  • Reporting date range
  • Campaign Message ID
  • Campaign Message Name
  • Send Date
  • Send Time
  • Campaign Message Channel
  • Total Recipients
  • Unique Opens
  • Unique Clicks
  • Bounces
  • Spam Complaints
  • Unique Unsubscribes
  • Total Placed Order
  • Total Placed Order Value
  • Subject
  • Preview Text
  • Included Lists / Segments
  • Excluded Lists / Segments
  • Tags, where available

This appears to align with Klaviyo’s Reporting API, specifically the Campaign Values Report endpoint:
POST /api/campaign-values-reports

Klaviyo notes that the Reporting API is intended to return campaign, flow, form, or segment performance data matching the Klaviyo UI, whereas metric aggregate endpoints may not match UI campaign reporting because of attribution/send-date handling.

This table is needed for downstream BI reporting, campaign QA, and client-facing campaign performance dashboards. Today, the Fivetran Klaviyo connector does not appear to expose this campaign message-level reporting table directly, requiring manual exports or custom API extraction.

Please sign in to leave a comment.

Comments

4 comments

Date Votes
  • Official comment
    Abdul Ghaffar Fivetranner

    Hi Adam, Abdul from the Product team here. Thank you for submitting this request.

    We have an existing ticket for campaign-level reporting on Klaviyo. The API endpoint you referenced does exist, but Klaviyo's rate limits on it are quite restrictive, which makes it difficult to support reliably for most connections. I'm going to revisit this with engineering to see if anything has changed since we last looked at it, and I'll update you here.

  • Adam Alexander User

    Thanks Abdul,

    Can you give us more detail on what exactly is the rate limitation you are running into?  Is it a daily limit, project limit, etc?

    Any additional details would be helpful.

    Thanks!

  • Adam Alexander User

    Hello,

    Is their any update on this and/or an ETA of when that may be available?

    Can you please address my question on further details on the rate limits?

    Thanks!

  • Abdul Ghaffar Fivetranner

    Hi Adam, apologies for the delay.

    The campaign-values-reports endpoint has a daily limit of 225 requests, a steady rate of 2 per minute, and a burst rate of 1 per second.

    The bigger issue is the shape of the endpoint. For flows, forms, and segments, Klaviyo offers series endpoints that return data broken down by an interval (hourly, daily, weekly, monthly) in a single call. That's how we sync them today. For campaigns, there's no equivalent series endpoint, only campaign-values-reports, which returns a single aggregate for the date range you query. To synthesize a time-broken-down report, we'd need a separate request per time period per campaign, which doesn't scale within the 225/day cap.

    In the meantime, our dbt_klaviyo package may help. It includes a klaviyo__campaigns model that aggregates per-campaign performance metrics from the underlying event and campaign data we already sync: https://github.com/fivetran/dbt_klaviyo.

    Let me know if you need help in getting started. 

    We're tracking this closely and will revisit as soon as Klaviyo ships a campaign-series-reports endpoint that mirrors the others. I'll keep you posted.

    Thanks,
    Abdul