Daasity Knowledge Base
Daasity Knowledge Base
  • Start here
    • Daasity Overview
    • Important Concepts
      • Attribution Overview
      • What is a Daasity Valid Order?
      • Customer Householding
      • Timezones in Daasity
      • Ecommerce Glossary
      • Daasity Data Security Overview
    • Retail Analytics 101
      • Understanding the Basics: POS Data 101
      • How to use Syndicated Data
    • Product Changelog
    • Feature Requests
  • 🔌Extract
    • 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
    • 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
  • 📊VISUALIZE
    • Dashboards
      • Dashboard 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
    • Looker Guides (Developer)
      • Daasity Hub & Spoke Introduction
      • Hub & Spoke File Structure
      • Working with LookML Dashboards
      • Customizing Base Daasity Code
    • Visualize using other BI tools
  • 🔀Transform
    • Transforming Data with Daasity
    • 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
    • BigQuery
    • Redshift
    • Snowflake
    • 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
  • Integration Overview
  • Integration Availability
  • API Endpoints
  • Klaviyo V2 Schema
  • Campaigns
  • Campaign Audiences Excluded
  • Campaign Audiences Included
  • Campaign Messages
  • Campaign Message Send Times
  • Campaign Tags
  • Events
  • Event Attribution Group IDs
  • Event Group IDs
  • Flows
  • Flow Actions
  • Flow Action Messages
  • Lists
  • List Profiles
  • List Tags
  • Member Lists
  • Metrics
  • Profiles
  • Profile Email List Suppressions
  • Profile Email Suppressions
  • Segments
  • Segment Profiles
  • Segment Tags
  • STG Member Lists
  • Tags

Was this helpful?

  1. Extract
  2. All Integrations
  3. Klaviyo V2

Integration Specifications

This documentation is still under construction 🚧

Data load speeds for Klaviyo are slow

Klaviyo is an extremely slow endpoint and loading history can take a considerable amount of time if the data volume is high.

Integration Overview

Our Klaviyo extractor pulls information about your Email/SMS profiles, lists, and events so that they can be analyzed alongside your order and marketing data.

Integration Availability

This integration is available for:

  • Enterprise

  • Growth

API Endpoints

This extractor is based on this documentation. The following endpoints are used by Daasity to replicate data:

  • Get Campaigns

  • Get Events

  • Get Flows

  • Get Lists

  • Get Metrics

  • Get Profiles

  • Get Segments

  • Get Tags

Klaviyo V2 Schema

The Klaviyo V2 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.

  • Campaigns

  • Campaign Audiences Excluded

  • Campaign Audiences Included

  • Campaign Messages

  • Campaign Message Send Times

  • Events

  • Event Attribution Group IDs

  • Event Group IDs

  • Flows

  • Flow Actions

  • Flow Action Messages

  • Lists

  • List Profiles

  • List Tags

  • Metrics

  • Member Lists

  • Profiles

  • Profile Email List Suppressions

  • Profile Email Suppressions

  • Segments

  • Segment Profiles

  • Segment Tags

  • STG Member Lists

  • Tags

Campaigns

  • Endpoint: Get Campaigns

  • Update Method: UPSERT

  • Table Name: [klaviyo_v2.campaigns]

JSON Element
Database Column

data[].id

campaign_id

data[].attributes.name

name

data[].attributes.status

status

data[].attributes.archived

archived

data[].attributes.channel

channel

data[].attributes.send_options.use_smart_sending

send_options_use_smart_sending

data[].attributes.send_options.ignore_unsubscribes

send_options_ignore_unsubscribes

data[].attributes.tracking_options.is_tracking_opens

tracking_options_is_tracking_opens

data[].attributes.tracking_options.is_tracking_clicks

tracking_options_is_tracking_clicks

data[].attributes.tracking_options.is_add_utm

tracking_options_is_add_utm

data[].attributes.send_strategy.method

send_strategy_method

data[].attributes.send_strategy.options_static.datetime

send_strategy_options_static_datetime

data[].attributes.send_strategy.options_static.is_local

send_strategy_options_static_is_local

data[].attributes.send_strategy.options_static.send_past_recipients_immediately

send_strategy_options_static_send_past_recipients_immediately

data[].attributes.send_strategy.options_throttled.datetime

send_strategy_options_throttled_datetime

data[].attributes.send_strategy.options_throttled.throttle_percentage

send_strategy_options_throttled_throttle_percentage

data[].attributes.send_strategy.options_sto.date

send_strategy_options_sto_date

data[].attributes.created_at

created_at

data[].attributes.scheduled_at

scheduled_at

data[].attributes.updated_at

updated_at

data[].attributes.send_time

send_time

Campaign Audiences Excluded

  • Endpoint: Get Campaigns

  • Update Method: UPSERT

  • Table Name: [klaviyo_v2.campaign_audiences_excluded]

JSON Element
Database Column

data[].id

campaign_id

data[].attributes.audiences.audience_type[]

audience_id

Campaign Audiences Included

  • Endpoint: Get Campaigns

  • Update Method: UPSERT

  • Table Name: [klaviyo_v2.campaign_audiences_included]

JSON Element
Database Column

data[].id

campaign_id

data[].attributes.audiences.audience_type[]

audience_id

Campaign Messages

  • Endpoint: Get Campaigns

  • Update Method: UPSERT

  • Table Name: [klaviyo_v2.campaign_messages]

JSON Element
Database Column

included[].attributes.relationships.campaign.id

campaign_message_type

included[].id

campaign_message_id

included[].attributes.label

label

included[].attributes.channel

channel

included[].attributes.content.subject

content_subject

included[].attributes.content.preview_text

content_preview_text

included[].attributes.content.from_email

content_from_email

included[].attributes.content.from_label

content_from_label

included[].attributes.content.reply_to_email

content_reply_to_email

included[].attributes.content.cc_email

content_cc_email

included[].attributes.content.bcc_email

content_bcc_email

included[].attributes.render_options.shorten_links

render_options_shorten_links

included[].attributes.render_options.add_org_prefix

render_options_add_org_prefix

included[].attributes.render_options.add_info_link

render_options_add_info_link

included[].attributes.render_options.add_opt_out_language

render_options_add_opt_out_language

included[].attributes.created_at

created_at

included[].attributes.updated_at

updated_at

included[].attributes.relationships.campaign.data.type

campaign_data_type

included[].attributes.relationships.campaign.data.id

campaign_data_id

included[].attributes.relationships.template.data.type

template_data_type

included[].attributes.relationships.template.data.id

template_data_id

Campaign Message Send Times

  • Endpoint: Get Campaigns

  • Update Method: UPSERT

  • Table Name: [klaviyo_v2.campaign_message_send_times]

JSON Element
Database Column

included[].id

campaign_message_id

included[].relationships.campaign.data.id

campaign_id

included[].attributes.send_times[].datetime

send_time_datetime

included[].attributes.send_times[].is_local

send_time_is_local

Campaign Tags

  • Endpoint: Get Campaigns

  • Update Method: UPSERT

  • Table Name: [klaviyo_v2.campaign_audiences_excluded]

JSON Element
Database Column

data[].id

campaign_id

data[].relationships.tags.data[].id

tag_id

data[].relationships.tags.data[].type

tag_type

Events

  • Endpoint: Get Events

  • Update Method: UPSERT

  • Table Name: [klaviyo_v2.events]

❗️Not all events are pulled by our extractor

In order to speed up extraction of your events data, we only extract data for the following events:

  • received email

  • received sms

  • bounced email

  • failed to deliver sms

  • clicked email

  • clicked sms

  • opened email

  • marked email as spam

  • unsubscribed

  • unsubscribed from sms marketing

  • subscribed to list

❗️Some columns in the events table will be NULL

Some of the event properties in this table exist for only certain types of events.

For example, the TO_NUMBER property is available only for the following events: Unsubscribed from SMS Marketing, Received SMS, and Failed to Deliver SMS. Since we can't get that data for all event types, the TO_NUMBER column value will be NULL for many of your events records.

JSON Element
Database Column

data[].attributes.event_properties.$attribution.$attributed_channel

ATTRIBUTION_ATTRIBUTED_CHANNEL

data[].attributes.event_properties.$attribution.$attributed_event_id

ATTRIBUTION_ATTRIBUTED_EVENT_ID

data[].attributes.event_properties.$attribution.$flow

ATTRIBUTION_FLOW

data[].attributes.event_properties.$attribution.$message

ATTRIBUTION_MESSAGE

data[].attributes.event_properties.$attribution.$send_ts

ATTRIBUTION_SEND_TS

data[].attributes.event_properties.$attribution.$variation

ATTRIBUTION_VARIATION

data[].attributes.event_properties.Bounce Type

BOUNCE_TYPE

data[].attributes.event_properties.Campaign Name

CAMPAIGN_NAME

data[].attributes.event_properties.Carrier Delivery Status

CARRIER_DELIVERY_STATUS

data[].attributes.event_properties.Client Canonical

CLIENT_CANONICAL

data[].attributes.event_properties.Client Name

CLIENT_NAME

data[].attributes.event_properties.Client OS

CLIENT_OS

data[].attributes.event_properties.Client OS Family

CLIENT_OS_FAMILY

data[].attributes.event_properties.Client Type

CLIENT_TYPE

data[].attributes.event_properties.$_cohort$message_send_cohort

COHORT_MESSAGE_SEND_COHORT

data[].attributes.event_properties.$_cohort$variation_send_cohort

COHORT_VARIATION_SEND_COHORT

data[].attributes.event_properties.Content Type

CONTENT_TYPE

data[].attributes.event_properties.Email Domain

EMAIL_DOMAIN

data[].attributes.event_properties.$ESP

ESP

data[].attributes.datetime

EVENT_DATETIME

data[].attributes.event_properties.$event_id

EVENT_ID

data[].attributes.event_properties.$extra.$bounce_delivery_info.action_id

EXTRA_BOUNCE_DELIVERY_INFO_ACTION_ID

data[].attributes.event_properties.$extra.$bounce_delivery_info.add_exclusion

EXTRA_BOUNCE_DELIVERY_INFO_ADD_EXCLUSION

data[].attributes.event_properties.$extra.$bounce_delivery_info.code

EXTRA_BOUNCE_DELIVERY_INFO_CODE

data[].attributes.event_properties.$extra.$bounce_delivery_info.ip

EXTRA_BOUNCE_DELIVERY_INFO_IP

data[].attributes.event_properties.$extra.$bounce_delivery_info.is_autoresponder

EXTRA_BOUNCE_DELIVERY_INFO_IS_AUTORESPONDER

data[].attributes.event_properties.$extra.$bounce_delivery_info.reason

EXTRA_BOUNCE_DELIVERY_INFO_REASON

data[].attributes.event_properties.$extra.$bounce_delivery_info.type

EXTRA_BOUNCE_DELIVERY_INFO_TYPE

data[].attributes.event_properties.$extra.customer_merge

EXTRA_CUSTOMER_MERGE

data[].attributes.event_properties.$extra.From City

EXTRA_FROM_CITY

data[].attributes.event_properties.$extra.From Country

EXTRA_FROM_COUNTRY

data[].attributes.event_properties.$extra.From State

EXTRA_FROM_STATE

data[].attributes.event_properties.$extra.IP Address

EXTRA_IP_ADDRESS

data[].attributes.event_properties.$extra.Message Body

EXTRA_MESSAGE_BODY

data[].attributes.event_properties.$extra.Message ID

EXTRA_MESSAGE_ID

data[].attributes.event_properties.$extra.$metadata.recipient_variation_id

EXTRA_METADATA_RECIPIENT_VARIATION_ID

data[].attributes.event_properties.Failure Source

FAILURE_SOURCE

data[].attributes.event_properties.Failure Type

FAILURE_TYPE

data[].attributes.event_properties.$flow

FLOW

data[].attributes.event_properties.From Number

FROM_NUMBER

data[].attributes.event_properties.From Phone Region

FROM_PHONE_REGION

data[].id

ID

data[].attributes.event_properties.Inbox Provider

INBOX_PROVIDER

data[].attributes.event_properties.$internal.send_timestamp

INTERNAL_SEND_TIMESTAMP

data[].attributes.event_properties.$internal.vendor

INTERNAL_VENDOR

data[].attributes.event_properties.$extra.$bounce_delivery_info.ip

IP

data[].attributes.event_properties.$klaviyo_bounce_category

KLAVIYO_BOUNCE_CATEGORY

data[].attributes.event_properties.List

LIST

data[].attributes.event_properties.machine_open

MACHINE_OPEN

data[].attributes.event_properties.$message

MESSAGE

data[].attributes.event_properties.Message Body

MESSAGE_BODY

data[].attributes.event_properties.Message Format

MESSAGE_FORMAT

data[].attributes.event_properties.$message_interaction

MESSAGE_INTERACTION

data[].attributes.event_properties.Message Name

MESSAGE_NAME

data[].attributes.event_properties.Message Type

MESSAGE_TYPE

data[].attributes.event_properties.Method

METHOD

data[].relationships.metric.data.id

METRIC_DATA_ID

data[].relationships.metric.data.type

METRIC_DATA_TYPE

data[].relationships.profile.data.id

PROFILE_DATA_ID

data[].relationships.profile.data.type

PROFILE_DATA_TYPE

data[].relationships.profile.data.id

PROFILE_EMAIL

data[].attributes.event_properties.Segment Count

SEGMENT_COUNT

data[].attributes.event_properties.Subject

SUBJECT

data[].attributes.timestamp

TIMESTAMP

data[].attributes.event_properties.To Number

TO_NUMBER

data[].attributes.event_properties.To Phone Region

TO_PHONE_REGION

data[].type

TYPE

data[].attributes.event_properties.URL

URL

data[].attributes.uuid

UUID

data[].attributes.event_properties.$variation

VARIATION

data[].attributes.event_properties.Vendor Error Code

VENDOR_ERROR_CODE

Event Attribution Group IDs

Event Group IDs

Flows

  • Endpoint: Get Flows

  • Update Method: UPSERT

  • Table Name: [klaviyo_v2.flows]

JSON Element
Database Column

data[].attributes.name

name

data[].attributes.status

status

data[].attributes.archived

archived

data[].attributes.created

created

data[].attributes.updated

updated

data[].attributes.trigger_type

trigger_type

Flow Actions

  • Endpoint: Get Flows

  • Update Method: UPSERT

  • Table Name: [klaviyo_v2.flow_actions]

JSON Element
Database Column

data[].id

flow_action_id

data[].relationships.flow.data.id

flow_id

data[].attributes.action_type

action_type

data[].attributes.status

status

data[].attributes.created

created

data[].attributes.updated

updated

data[].attributes.tracking_options.add_utm

tracking_options_add_utm

data[].attributes.tracking_options.utms

tracking_options_utm_params

data[].attributes.tracking_options.is_tracking_opens

tracking_options_is_tracking_opens

data[].attributes.tracking_options.is_tracking_clicks

tracking_options_is_tracking_clicks

data[].attributes.send_options.use_smart_tracking

send_options_use_smart_tracking

data[].attributes.send_options.is_transactional

send_options_is_transactional

Flow Action Messages

  • Endpoint: Get Flows

  • Update Method: UPSERT

  • Table Name: [klaviyo_v2.flow_action_messages]

JSON Element
Database Column

included[].id

flow_action_id

included[].attributes.id

flow_action_message_id

included[].attributes.name

name

included[].attributes.channel

channel

included[].attributes.created

created

included[].attributes.updated

updated

included[].attributes.content.subject

content_subject

included[].attributes.content.preview_text

content_preview_text

included[].attributes.content.from_email

content_from_email

included[].attributes.content.from_label

content_rom_label

included[].attributes.content.reply_to_email

content_reply_to_email

included[].attributes.content.cc_email

content_cc_email

Lists

  • Endpoint: Get List Profiles

  • Update Method: UPSERT

  • Table Name: [klaviyo_v2.lists]

JSON Element
Database Column

data[].id

list_id

data[].name

name

data[].created

created

data[].updated

updated

List Profiles

  • Endpoint: Get List Profiles

  • Update Method: UPSERT

  • Table Name: [klaviyo_v2.list_profiles]

JSON Element
Database Column

(part of url path, not part of response)

list_id

data[].id

profile_id

List Tags

  • Endpoint: Get List Profiles

  • Update Method: UPSERT

  • Table Name: [klaviyo_v2.list_tags]

JSON Element
Database Column

data[].id

list_id

data[].relationships.tags.data

tag_id

Member Lists

Metrics

  • Endpoint: Get Metrics

  • Update Method: UPSERT

  • Table Name: [klaviyo_v2.metrics]

JSON Element
Database Column

data[].id

list_id

data[].attributes.name

tag_id

data[].attributes.created

created

data[].attributes.updated

updated

data[].attributes.integration.id

integration_id

data[].attributes.integration.name

integration_name

data[].attributes.integration.category

integration_category

Profiles

  • Endpoint: Get Profiles

  • Update Method: UPSERT

  • Table Name: [klaviyo_v2.profiles]

JSON Element
Database Column

data[].id

profile_id

data[].attributes.email

email

data[].attributes.phone_number

phone_number

data[].attributes.external_id

external_id

data[].attributes.first_name

first_name

data[].attributes.last_name

last_name

data[].attributes.organization

organization

data[].attributes.image

image

data[].attributes.created

created

data[].attributes.updated

updated

data[].attributes.last_event_date

last_event_date

data[].attributes.properties

properties

data[].attributes.location.address1

location_address1

data[].attributes.location.address2

location_address2

data[].attributes.location.city

location_city

data[].attributes.location.country

location_country

data[].attributes.location.latitude

location_latitude

data[].attributes.location.longitude

location_longitude

data[].attributes.location.region

location_region

data[].attributes.location.timezone

location_timezone

data[].attributes.location.ip

location_ip

data[].attributes.subscriptions.email.marketing.consent

email_marketing_consent

data[].attributes.subscriptions.email.marketing.marketing

email_marketing_timestamp

data[].attributes.subscriptions.email.marketing.method

email_marketing_method

data[].attributes.subscriptions.email.marketing.method_detail

email_marketing_method_detail

data[].attributes.subscriptions.email.marketing.custom_method_detail

email_marketing_custom_method_detail

data[].attributes.subscriptions.email.marketing.double_optin

email_marketing_double_optin

data[].attributes.subscriptions.sms.marketing.consent

sms_marketing_consent

data[].attributes.subscriptions.sms.marketing.timestamp

sms_marketing_timestamp

data[].attributes.subscriptions.sms.marketing.method

sms_marketing_method

data[].attributes.subscriptions.sms.marketing.method_detail

sms_marketing_method_detail

Profile Email List Suppressions

  • Endpoint: Get Profiles

  • Update Method: UPSERT

  • Table Name: [klaviyo_v2.profile_email_list_suppressions]

JSON Element
Database Column

data[].id

profile_id

data[].attributes.subscriptions.email.marketing.list_suppressions[].reason

reason

data[].attributes.subscriptions.email.marketing.list_suppressions[].list_id

list_id

data[].attributes.subscriptions.email.marketing.list_suppressions[].timestamp

timestamp

Profile Email Suppressions

  • Endpoint: Get Profiles

  • Update Method: UPSERT

  • Table Name: [klaviyo_v2.profile_email_suppressions]

JSON Element
Database Column

data[].id

profile_id

data[].attributes.subscriptions.email.marketing.suppressions[].reason

reason

data[].attributes.subscriptions.email.marketing.suppressions[].timestamp

timestamp

Segments

  • Endpoint: Get Segments

  • Update Method: UPSERT

  • Table Name: [klaviyo_v2.segments]

JSON Element
Database Column

data[].id

segment_id

data[].attributes.name

name

data[].attributes.created

created

data[].attributes.updated

updated

Segment Profiles

  • Endpoint: Get Segment_Profiles

  • Update Method: UPSERT

  • Table Name: [klaviyo_v2.segment_profiles]

JSON Element
Database Column

(part of url path, not part of response)

segment_id

data[].id

profile_id

Segment Tags

  • Endpoint: Get Segments

  • Update Method: UPSERT

  • Table Name: [klaviyo_v2.segment_tags]

JSON Element
Database Column

data[].id

segment_id

data[].relationships.tags.data[].id

tag_id

STG Member Lists

Tags

  • Endpoint: Get Tags

  • Update Method: UPSERT

  • Table Name: [klaviyo_v2.tags]

JSON Element
Database Column

data[].id

tag_id

data[].attributes.name

name

PreviousIntegration SetupNextKnoCommerce

Last updated 1 year ago

Was this helpful?

🔌