Daasity Knowledge Base
Daasity Knowledge Base
  • Start here
    • Getting Started
    • Core Concepts
      • Ecommerce Glossary
      • Attribution Overview
      • What is a Daasity Valid Order?
      • Customer Householding
      • Timezones in Daasity
      • Daasity Data Security Overview
      • Getting Started as a New Merchant
        • 1- Connect Your Warehouse
          • BigQuery
          • Snowflake
        • 2- Extract your data with Daasity
          • All Integrations
            • Alchemer
              • Integration Setup
              • Integration Specifications
              • Workflow Configuration Setup
              • Transformation Configuration Setup
            • Algolia
              • Integration Setup
              • Integration Specifications
              • Workflow Configuration Setup
              • Transformation Configuration Setup
            • Amazon Advertising
              • Integration Setup
              • Integration Specifications
              • Workflow Configuration Setup
              • Transformation Configuration Setup
              • Where to Find Your Data
            • Amazon Seller Central
              • Validating Your Amazon Data in Daasity
                • Comparing Your Amazon Seller Central Orders to Daasity
              • Integration Setup
                • Configure Amazon Reports
                • Monitor Amazon Reports
              • Integration Specifications
                • Orders API
                • FBA Customer Concessions Reports
                • FBA Sales Reports
                • FBA Inventory Reports
                • FBA Removals Reports
                • Inventory Reports
                • Order Tracking Reports
                • Performance Reports
                • Returns Reports
                • Settlement Reports
                • Seller Retail Analytics Reports
              • Workflow Configuration Setup
                • Orders API
                • FBA Customer Concession Reports
                • FBA Inventory Reports
                • Performance Reports
                • FBA Sales Reports
                • FBA Removal Reports
                • Inventory Reports
                • Order Tracking Reports
                • Returns Reports
                • Seller Retail Analytics Reports
                • Settlement Reports
              • Transformation Configuration Setup
                • Orders API
                • FBA Customer Concessions Reports
                • FBA Inventory Reports
                • Performance Reports
                • FBA Sales Reports
                • FBA Removals Reports
                • Inventory Reports
                • Order Tracking Reports
                • Returns Reports
                • Seller Retail Analytics Reports
                • Settlement Reports
            • Amazon Vendor Central
              • Integration Setup
              • Integration Specifications
              • How to use
              • ASIN Mapping Configuration Setup
              • Workflow Configuration Setup
              • Transformation Configuration Setup
                • Vendor Sales & Inventory Report
                • Vendor Traffic Report
            • AppLovin
              • Integration Setup
            • Attentive Mobile
              • Integration Setup
              • Integration Specifications
              • Workflow Configuration Setup
              • Transformation Configuration Setup
            • Azure SQL Database
            • Back In Stock
              • Integration Setup
              • Integration Specifications
              • Workflow Configuration Setup
              • Transformation Configuration Setup
            • Big Commerce
              • Integration Setup
                • Connect Daasity From BigCommerce Marketplace
              • Integration Specifications
              • Workflow Configuration Setup
              • Transformation Configuration Setup
            • BigQuery Datasource
            • Bing Ads
              • Integration Setup
              • Integration Specifications
            • Circana
              • Integration Setup
              • Integration Specifications
              • Data Release Calendar
              • H-E-B Circana
            • Cordial
              • Integration Setup
              • Integration Specifications
              • Workflow Configuration Setup
              • Transformation Configuration Setup
            • Criteo
              • Integration Setup
              • Integration Specifications
              • Workflow Configuration Setup
              • Transformation Configuration Setup
            • D​ata File (CSV, XLS)
            • Emplifi
              • Integration Specifications
            • Extensiv (Skubana)
              • Integration Setup
              • Integration Specifications
              • Workflow Configuration Setup
              • Transformation Configuration Setup
            • Facebook Ads
              • Integration Setup
              • Integration Specifications
              • Workflow Configuration Setup
              • Transformation Configuration Setup
              • Where to Find Your Data
            • Fairing V2
              • Integration Setup
              • Integration Specifications
              • Workflow Configuration Setup
              • Important Notes
            • Google Ads
              • Integration Setup
              • Integration Specifications
              • Workflow Configuration Setup
              • Transformation Configuration Setup
              • Important Notes
            • Google Analytics 4
              • API vs BigQuery
              • API Integration
                • Integration Setup
                • Integration Specifications
                • Workflow Configuration Setup
                • Transformation Configuration Instructions
                • Custom Reports
                • Validating GA4 Data in Daasity
                • Blending Universal Analytics & GA4 Data
              • BigQuery integration
                • Integration Setup
                • Integration Specifications
                • Workflow Configuration Setup
                • Transformation Configuration Instructions
                • Important Notes
                • Creating a Custom Report
            • Google Sheet
            • Gorgias
              • Integration Setup
              • Integration Specifications
              • Workflow Configuration Setup
              • Transformation Configuration Setup
              • Important Notes
            • Impact Radius (Beta)
              • Integration Specifications
            • Iterable
              • Integration Setup
              • Integration Specifications
              • Workflow Configuration Setup
              • Transformation Configuration Setup
            • Klaviyo Summary Statistics
              • Integration Setup
              • Integration Specifications
            • Klaviyo V2
              • Integration Setup
              • Integration Specifications
            • KnoCommerce
              • Integration Setup
              • Integration Specifications
            • Loop Returns
              • Integration Setup
              • Integration Specifications
              • Workflow Configuration Setup
              • Transformation Configuration Setup
            • Microsoft SQL Server Database
            • Mongo Database
            • MySQL Database
            • Narvar
              • Integration Setup
              • Integration Specifications
              • Workflow Configuration Setup
              • Transformation Configuration Setup
            • NetSuite
            • Newstore
              • Integration Setup
              • Integration Specifications
              • Workflow Configuration Setup
              • Transformation Configuration Setup
            • Northbeam
              • Integration Setup
            • Okendo
              • Integration Setup
              • Integration Specifications
              • Workflow Configuration Setup
              • Transformation Configuration Setup
            • Ometria
              • Integration Setup
              • Integration Specifications
              • Workflow Configuration Setup
              • Transformation Configuration Setup
            • Order Desk
              • Integration Setup
              • Integration Specifications
              • Workflow Configuration Setup
              • Transformation Configuration Setup
            • Pepperjam
              • Integration Setup
              • Integration Specifications
              • Workflow Configuration Setup
              • Transformation Configuration Setup
            • Pinterest
              • Integration Setup
              • Integration Specifications
              • Workflow Configuration Setup
              • Transformation Configuration Setup
            • Postgres Database
            • Postscript (beta)
              • Integration Setup
              • Integration Specifications
              • Workflow Configuration Setup
              • Transformation Configuration Setup
              • Important Notes
            • Recharge
              • Integration Setup
              • Integration Specifications
              • Integration Specifications (2021-11 Beta)
              • Workflow Configuration Setup
              • Transformation Configuration Setup
              • Recharge Data and Known Discrepancies
            • Retail Next
              • Integration Setup
              • Integration Specifications
              • Workflow Configuration Setup
              • Transformation Configuration Setup
            • Rockerbox
              • Integration Setup
              • Integration Specifications
              • Workflow Configuration Setup
              • Transformation Configuration Setup
            • Salesforce Commerce Cloud
              • Integration Specifications
              • Workflow Configuration Setup
              • Transformation Configuration Setup
            • SFTP
            • ShipBob
              • Integration Setup
              • Integration Specifications
            • Shipstation
              • Integration Setup
              • Integration Specifications
              • Workflow Configuration Setup
              • Transformation Configuration Setup
            • Shopify
              • Integration Setup
              • Integration Specifications
              • Workflow Configuration Setup
              • Transformation Configuration Setup
              • Shopify B2B Data
            • SKIO
              • Integration Setup
              • Integration Specifications
            • Snapchat
              • Integration Setup
              • Integration Specifications
              • Workflow Configuration Setup
              • Transformation Configuration Setup
            • SPINS
              • Integration Setup
              • Integration Specifications
              • How to Use
              • Data Release Calendar
            • Stay Ai
              • Integration Setup
              • Integration Specifications
            • Target Plus
              • Integration Setup
            • Thankful
              • Integration Setup
              • Integration Specifications
              • Workflow Configuration Setup
              • Transformation Configuration Setup
            • TikTok
              • Integration Setup
              • Workflow Configuration Setup
              • Transformation Configuration Setup
            • Walmart Marketplace
              • Integration Setup
              • Integration Specifications
            • Whole Foods Market
              • Integration Setup
              • Integration Specifications
              • How to use
            • Yotpo
              • Integration Setup
              • Integration Specifications
              • Workflow Configuration Setup
              • Transformation Configuration Setup
            • Zendesk
              • Integration Specifications
              • Workflow Configuration Setup
              • Transformation Configuration Setup
        • 3- Adding Brand Supplied Data (BSD)
          • BSD Overview
          • Monitoring Your BSD Progress
          • Revenue Plan
          • Marketing Budget
          • Marketing Spend
          • RFM Values
          • Shipping & Fulfillment Cost
          • SKU Hierarchy
          • SKU Mapping
          • SKU Cost
          • Discount Code Mapping
          • Other Order Sources
          • Channel Mapping
            • Overview & Setup
            • Filling out Channel Mapping
            • Missing from GA & Missing from BSD
          • Configuration
    • Analyzing your Data
      • Templates Overview
        • Standard Dashboards
          • Daasity 101 Overview Dashboards
            • Flashes
            • Shopify Sales Report
            • Account Health
          • Digital Product & Revenue
            • Orders and Revenue
            • Amazon Settlement Report
            • Product Repurchase Rate
            • Product
              • Product Dimensions
                • Why is a Product Name NULL?
            • Inventory
            • Operations
              • Fulfilment Status Options
          • Retention Marketing Dashboards
            • Notifications (Email/SMS)
            • Retention
            • Customer Performance (Email/SMS)
            • Site Funnels
          • Acquisition Marketing Dashboards
            • Attribution Deep Dive
              • Marketing Attribution
                • Attribution Overview
                • Survey-Based Attribution
                • Discount Code Attribution
                • First Click, Last Click, and Assisted Attribution
                • Custom Attribution
                • Vendor-Reported Attribution
                • CPO, CPA, and CAC
                • Missing from GA & Missing from BSD
            • LTV & RFM
              • RFM
                • RFM in the Daasity App
                • Understanding RFM
                • Time on Books (TOB)
            • Marketing
            • Vendor-Reported Marketing Performance
            • Site Analytics & Attribution
        • Integration Dashboards
          • Amazon All Orders Report
          • Amazon Seller Central Business Reports
          • Gorgias
          • Klaviyo Campaign & Flow Performance
          • Loop Returns
          • Okendo Reviews
          • ShipBob
          • Shipstation
          • Subscription
          • Walmart Marketplace Account Sales Report
          • Yotpo
      • Explores
        • Explore Overview
        • Order Line Revenue vs. Transactional Sales Report
        • How to Access An Explore
        • Standard Daasity Explores
          • Current Inventory Level Explore
          • Customer Details Explore
          • Daily Company Metrics Explore
          • Daily Marketing Plan To Actual Marketing Performance Explore
          • Daily Plan to Actual Explore
          • Lifetime Value Explore
          • Marketing Attribution Explore
          • Multi-Channel Transaction Explore
          • Order and Order Line Revenue Explore
          • Product Page Explore
          • Shopping Stage Explore
          • SKU Level Repurchase Rates Explore
          • Traffic Explore
          • Transactional Sales Report Explore
          • UA vs G4 Explore
        • Integration Explores
          • Algolia
          • Amazon Settlement Explore
          • Fairing Survey Responses Explore
          • Gorgias Tickets Explore
          • Loop Returns Explore
          • Okendo Reviews Explore
          • Subscribers and Subscription Monthly Churn Rates Explores (Recharge)
          • Shipstation Explore
          • Yotpo
          • Zen Desk
      • Looker Guides
        • Building visualizations
        • Working with date dimensions & filters
        • Schedule a Report or Dashboard
        • Exporting Data
      • Retail Analytics 101
        • Understanding the Basics: POS Data 101
        • Understanding the Basics: Wholesale Data 101
        • How to use Syndicated Data
      • Visualization Guides (Developer)
        • Daasity Hub & Spoke Introduction
        • Hub & Spoke File Structure
        • Working with LookML Dashboards
        • Customizing Base Daasity Code
    • Important Product Updates
      • Daasity 2.0 Navigation Updates
      • New Explore Names (July 2025)
    • Product Changelog
    • Feature Requests
  • 🔀Technical Documentation
    • Transform
    • Daasity Data Models
      • Daasity Data Model Overview
      • Unified Data Schemas
        • Unified Schema Introduction
        • Unified Order Schema (UOS)
        • Unified Notification Schema (UNS)
        • Unified Subscription Schema (USS)
        • Unified Marketing Schema (UMS)
        • Unified Traffic Schema (UTS)
        • Unified Wholesale Schema (UWS)
      • Data Mart Models
        • Data Mart Introduction
        • Data Reporting Platform (DRP)
        • Channel Attribution Data Mart
        • Marketing Data Mart
      • Transform Code
        • Transform Code Introduction
        • Transform Code Sequence - DRP
        • Initialization Code
        • Householding Code
        • Order Status Code
        • Order Channel and Marketing Code
        • Daily Plan Code
        • Order and Order Line Revenue
        • Plan to Actual Code
        • Customer Code
        • Subscription Code
        • Reviews
        • Life-Time Value Code
        • Returns
        • Product and Inventory Code
        • Email & SMS
        • Transform Code Sequence - Data Mart
        • Unified Order Schema (UOS) Code
        • Unified Marketing Schema (UMS) Code
        • Unified Notification Schema (UNS)
        • Channel Attribution Data Mart Code
        • Marketing Data Mart Code
      • Source to Final Destination
    • Code Repository
      • Code Repository Overview
      • Getting Access to Your Code Repository
      • Code Repository Branches
      • Custom SQL Code
      • Custom Script Manifest Files
    • Script Manifest (YAML) Files
  • 🎵Data Orchestration
    • Workflows
      • Getting Started with Workflows
      • Creating Workflows
      • Managing Workflows
      • Workflow Metrics
    • Notifications
      • Introduction to Notifications
      • Enabling Notification Emails
      • Notifications UI
      • Managing Notifications
      • Authorization List
  • Audiences
    • Audiences Overview
    • Pushing Audience Data to Targets
      • Targets Overview
      • Attentive
        • Events Target
        • Subscribers Target
        • Target Endpoint Documentation
      • Facebook Ads
        • Facebook Target
        • Target Endpoint Documentation
      • Google Ads
        • Google Ads Target
        • Target Endpoint Documentation
      • Klaviyo
        • Events Target
        • Profiles Target
        • Target Endpoint Documentation
      • Sailthru
        • Events Target
        • Users Target
        • Target Endpoint Documentation
      • Tiktok Ads
        • TikTok Target
        • Target Endpoint Documentation
    • Building Audiences
  • warehouse
    • Test Data Warehouse
      • Test Data Warehouse Overview
      • Create a Snowflake Test Warehouse
      • Create a Redshift Test Warehouse
  • —
    • Go to Daasity App
    • Contact Support
    • ✍️Feature Requests
Powered by GitBook
On this page
  1. Start here
  2. Core Concepts
  3. Getting Started as a New Merchant
  4. 2- Extract your data with Daasity
  5. All Integrations
  6. Klaviyo Summary Statistics

Integration Specifications

PreviousIntegration SetupNextKlaviyo V2

Was this helpful?

CtrlK
CtrlK
  • Refresh Cadence
  • Availability
  • API Endpoints
  • KLAVIYO_V2 Schema
  • Statistics Campaign Values
  • Statistics Campaigns
  • Statistics Flow Values
  • Statistics Flows
  • Statistics List Profile Count
  • Statistics Lists
  • Statistics Segment Profile Count
  • Statistics Segments

Was this helpful?

The Klaviyo Summary Statistics integration pulls aggregated reporting data from Klaviyo for:

  • Campaigns & Flows: Contains performance data such as Sends, Opens, Clicks, Conversions, and Conversion values segmented by Campaign and Flow

  • Lists & Segments: Contains profile counts by day for lists & segments

List & Segment growth history is not available

We capture List & Segment profile counts by snapshotting each list & segment's profile count at the time of extraction. Since we cannot go back in time using these APIs, we only load list & segment profile count data starting with the date of the first run of your integration.

This means if you set up the integration on February 14, you will only have data from February 14 onward.

Refresh Cadence

By default the Klaviyo Summary Statistics integration loads data once per day.

Availability

This integration is available for:

  • Enterprise

  • Growth

API Endpoints

This extractor use the Klaviyo Developer API. The following endpoints are used to replicate data into Daasity:

  • Query Flow Series

  • Query Campaign Values

  • Get Campaigns

  • Get Flows

  • Get List

  • Get Segment

KLAVIYO_V2 Schema

The Klaviyo Summary Statistics extractor creates these tables using the endpoints and replication methods listed. The data is mapped from source API endpoint to the table based on the mapping logic outlined in each table.

  • Statistics Campaign Values

  • Statistics Campaigns

  • Statistics Flow Values

  • Statistics Flows

  • Statistics List Profile Count

  • Statistics Lists

  • Statistics Segment Profile Count

  • Statistics Segments

Statistics Campaign Values

  • Endpoint: Query Campaign Values

  • Update Method: UPSERT

  • Table Name: klaviyo_v2.statistics_campaign_values

JSON Element
Database Column

report_id

UTC date when the data was extracted

extraction_date

data.attributes.results[].groupings.send_channel

send_channel

data.attributes.results[].groupings.campaign_id

campaign_id

data.attributes.results[].statistics.opens

opens

data.attributes.results[].statistics.bounced

bounced

data.attributes.results[].statistics.delivered

delivered

data.attributes.results[].statistics.clicks

clicks

data.attributes.results[].statistics.opens_unique

opens_unique

data.attributes.results[].statistics.conversion_uniques

conversion_uniques

data.attributes.results[].statistics.conversion_value

conversion_value

data.attributes.results[].statistics.conversions

conversions

data.attributes.results[].statistics.bounced_or_failed

bounced_or_failed

data.attributes.results[].statistics.clicks_unique

clicks_unique

data.attributes.results[].statistics.failed

failed

data.attributes.results[].statistics.recipients

recipients

data.attributes.results[].statistics.spam_complaints

spam_complaints

data.attributes.results[].statistics.unsubscribes

unsubscribes

data.attributes.results[].statistics.unsubscribes_uniques

unsubscribes_uniques

Klaviyo API key used for extraction

__source_id

__sync_key

Merchant account id from the Daasity app

_account_id

UTC timestamp when the data was extracted

__synced_at

Statistics Campaigns

  • Endpoint: Get Campaigns

  • Update Method: UPSERT

  • Table Name: klaviyo_v2.statistics_campaigns

JSON Element
Database Column

id

UTC date when the data was extracted

extraction_date

data[].attributes.name

name

data[].attributes.status

status

data[].attributes.archived

archived

data[].attributes.created_at

created_at

data[].attributes.scheduled_at

scheduled_at

data[].attributes.updated_at

updated_at

data[].attributes.send_time

send_time

Klaviyo API key used for extraction

__source_id

__sync_key

Merchant account id from the Daasity app

_account_id

UTC timestamp when the data was extracted

__synced_at

Statistics Flow Values

  • Endpoint: Query Flow Series

  • Update Method: UPSERT

  • Table Name: klaviyo_v2.statistics_flow_values

JSON Element
Database Column

report_id

UTC date when the data was extracted

extraction_date

data.attributes.results[].groupings.send_channel

send_channel

data.attributes.results[].groupings.flow_id

flow_id

data.attributes.results[].groupings.flow_message_id

flow_message_id

data.attributes.results[].statistics.opens

opens

data.attributes.results[].statistics.bounced

bounced

data.attributes.results[].statistics.delivered

delivered

data.attributes.results[].statistics.clicks

clicks

data.attributes.results[].statistics.opens_unique

opens_unique

data.attributes.results[].statistics.conversion_uniques

conversion_uniques

data.attributes.results[].statistics.conversion_value

conversion_value

data.attributes.results[].statistics.conversions

conversions

data.attributes.results[].statistics.bounced_or_failed

bounced_or_failed

data.attributes.results[].statistics.clicks_unique

clicks_unique

data.attributes.results[].statistics.failed

failed

data.attributes.results[].statistics.recipients

recipients

data.attributes.results[].statistics.spam_complaints

spam_complaints

data.attributes.results[].statistics.unsubscribes

unsubscribes

data.attributes.results[].statistics.unsubscribes_uniques

unsubscribes_uniques

Klaviyo API key used for extraction

__source_id

__sync_key

Merchant account id from the Daasity app

_account_id

UTC timestamp when the data was extracted

__synced_at

Statistics Flows

  • Endpoint: Get Flows

  • Update Method: UPSERT

  • Table Name: klaviyo_v2.statistics_flows

JSON Element
Database Column

id

UTC date when the data was extracted

extraction_date

data[].attributes.name

name

data[].attributes.status

status

data[].attributes.archived

archived

data[].attributes.created

created_at

data[].attributes.updated

updated_at

data[].attributes.trigger_type

trigger_type

Klaviyo API key used for extraction

__source_id

__sync_key

Merchant account id from the Daasity app

_account_id

UTC timestamp when the data was extracted

__synced_at

Statistics List Profile Count

  • Endpoint: Get List

  • Update Method: UPSERT

  • Table Name: klaviyo_v2.statistics_list_profile_count

JSON Element
Database Column

data[].id

list_id

UTC date when the data was extracted

extraction_date

data[].attributes.profile_count

profile_count

Klaviyo API key used for extraction

__source_id

__sync_key

Merchant account id from the Daasity app

_account_id

UTC timestamp when the data was extracted

__synced_at

Statistics Lists

  • Endpoint: Get List

  • Update Method: UPSERT

  • Table Name: klaviyo_v2.statistics_lists

JSON Element
Database Column

data[].id

list_id

data[].attributes.name

name

data[].attributes.created

created

data[].attributes.updated

updated

data[].attributes.opt_in_process

opt_in_process

Klaviyo API key used for extraction

__source_id

__sync_key

Merchant account id from the Daasity app

_account_id

UTC timestamp when the data was extracted

__synced_at

Statistics Segment Profile Count

  • Endpoint: Get Segment

  • Update Method: UPSERT

  • Table Name: klaviyo_v2.statistics_segment_profile_count

JSON Element
Database Column

data[].id

segment_id

UTC date when the data was extracted

extraction_date

data[].attributes.profile_count

profile_count

Klaviyo API key used for extraction

__source_id

__sync_key

Merchant account id from the Daasity app

_account_id

UTC timestamp when the data was extracted

__synced_at

Statistics Segments

  • Endpoint: Get Segment

  • Update Method: UPSERT

  • Table Name: klaviyo_v2.statistics_segments

JSON Element
Database Column

data[].id

segment_id

data[].attributes.name

name

data[].attributes.created

created

data[].attributes.updated

updated

data[].attributes.is_active

is_active

data[].attributes.is_processing

is_processing

data[].attributes.is_starred

is_starred

Klaviyo API key used for extraction

__source_id

__sync_key

Merchant account id from the Daasity app

_account_id

UTC timestamp when the data was extracted

__synced_at