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.