Documentation

Contact Us

If you still have questions or prefer to get help directly from an agent, please submit a request.
We’ll get back to you as soon as possible.

Please fill out the contact form below and we will reply as soon as possible.

  • Talk To sales
  • Start Trial

Schema Information for Klaviyo

Contact Us

If you still have questions or prefer to get help directly from an agent, please submit a request.
We’ll get back to you as soon as possible.

Please fill out the contact form below and we will reply as soon as possible.

  • Saras Pulse

    • Saras Daton

      Need help with something?

      Talk to data expert

      Schema Information for Klaviyo

      In this article, we will look at the schema information of the supported APIs and tables for Klaviyo.

      Find the links to other articles related to Klaviyo Below:

      • Essential Attributes and Supported Tables for Klaviyo
         
      • Setup Instructions for Klaviyo
         
      • Authentication Credentials for Klaviyo

         

      Tables/APIs -

      The following is the list of tables or APIs associated with the Klaviyo connector:

      Metrics -

      Purpose: This API is used to fetch all metrics in the account
       
      Source API Documentation: https://developers.klaviyo.com/en/reference/get_metrics
       
      Replication: Full Replication
       
      Replication Key: NA
       
       
      Fields -
      Name
      Data Type
      type
      STRING
      id
      STRING
      attributes
      RECORD
      links
      RECORD


      Lists -

      Purpose: This API is used to fetch all lists in the account
       
      Source API Documentation: https://developers.klaviyo.com/en/reference/get_lists
       
      Replication: Full Replication
       
      Replication Key: NA

       
      Fields -
      Name
      Data Type
      type
      STRING
      id
      STRING
      attributes
      RECORD
      links
      RECORD


      Segments

      Purpose: This API is used to fetch all segments in the account
       
      Source API Documentation: https://developers.klaviyo.com/en/reference/get_segments
       
      Replication: Full Replication
       
      Replication Key: NA
       
      Fields
      Name
      Data Type
      type
      STRING
      id
      STRING
      attributes
      RECORD
      links
      RECORD

      Profiles

      Purpose: This API is used to fetch all profiles in the account
       
      Source API Documentation: https://developers.klaviyo.com/en/reference/get_profiles
       
      Replication: Full Replication
       
      Replication Key: NA
       
      Fields
      Name
      Data Type
      type
      STRING
      id
      STRING
      attributes
      RECORD
      links
      RECORD

      Flows

      Purpose: This API is used to fetch all flows
       
      Source API Documentation: https://developers.klaviyo.com/en/reference/get_flows
       
      Replication: Full Replication
       
      Replication Key: NA
       
      Fields
      Name
      Data Type
      type
      STRING
      id
      STRING
      attributes
      RECORD
      links
      RECORD

      Flow Actions

      Purpose: This API is used to fetch all flow actions for the flows
       
      Source API Documentation: https://developers.klaviyo.com/en/reference/get_flow_flow_actions
       
      Replication: Full Replication
       
      Replication Key: NA
       
      Fields
      Name
      Data Type
      type
      STRING
      id
      STRING
      attributes
      RECORD
      links
      RECORD

      Flow Messages

      Purpose: This API is used to fetch all flow messages for the flow actions
       
      Source API Documentation:https://developers.klaviyo.com/en/reference/get_flow_action_messages
       
      Replication: Full Replication
       
      Replication Key: NA
       
      Fields
      Name
      Data Type
      type
      STRING
      id
      STRING
      attributes
      RECORD
      links
      RECORD

      Templates

      Purpose: This API is used to fetch all templates in the account
       
      Source API Documentation: https://developers.klaviyo.com/en/reference/get_templates
       
      Replication: Key Based Incremental
       
      Replication Key: greater-or-equal, less-or-equal
       
      Fields
      Name
      Data Type
      type
      STRING
      id
      STRING
      attributes
      RECORD
      links
      RECORD

      Active On Site

      Purpose: This API is used to fetch all events of Active On Site metric
       
      Source API Documentation: https://developers.klaviyo.com/en/reference/get_events
       
      Replication: Key Based Incremental
       
      Replication Key: greater-or-equal, less-or-equal
       
      Fields
      Name
      Data Type
      type
      STRING
      id
      STRING
      attributes
      RECORD
      links
      RECORD

      Bounced Email

      Purpose: This API is used to fetch all events of Bounced Email metric
       
      Source API Documentation: https://developers.klaviyo.com/en/reference/get_events
       
      Replication: Key Based Incremental
       
      Replication Key: greater-or-equal, less-or-equal
       
      Fields
      Name
      Data Type
      type
      STRING
      id
      STRING
      attributes
      RECORD
      links
      RECORD

      Cancelled Order

      Purpose: This API is used to fetch all events of Cancelled Order metric of Shopify
       
      Source API Documentation: https://developers.klaviyo.com/en/reference/get_eve
      nts
       
      Replication: Key Based Incremental
       
      Replication Key: greater-or-equal, less-or-equal
       
      Fields
      Name
      Data Type
      type
      STRING
      id
      STRING
      attributes
      RECORD
      links
      RECORD

      Clicked SMS

      Purpose: This API is used to fetch all events of Clicked SMS metric
       
      Source API Documentation: https://developers.klaviyo.com/en/reference/get_events
       
      Replication: Key Based Incremental
       
      Replication Key: greater-or-equal, less-or-equal
       
      Fields
      Name
      Data Type
      type
      STRING
      id
      STRING
      attributes
      RECORD
      links
      RECORD

      Clicked Email

      Purpose: This API is used to fetch all events of Clicked Email metric
       
      Source API Documentation: https://developers.klaviyo.com/en/reference/get_events
       
      Replication: Key Based Incremental
       
      Replication Key: greater-or-equal, less-or-equal
       
      Fields
      Name
      Data Type
      type
      STRING
      id
      STRING
      attributes
      RECORD
      links
      RECORD

      Consented To Receive SMS

      Purpose: This API is used to fetch all events of Consented To Receive SMS metric
       
      Source API Documentation: https://developers.klaviyo.com/en/reference/get_events
       
      Replication: Key Based Incremental
       
      Replication Key: greater-or-equal, less-or-equal
       
      Fields
      Name
      Data Type
      type
      STRING
      id
      STRING
      attributes
      RECORD
      links
      RECORD

      Dropped Email

      Purpose: This API is used to fetch all events of Dropped Email metric
       
      Source API Documentation: https://developers.klaviyo.com/en/reference/get_events
       
      Replication: Key Based Incremental
       
      Replication Key: greater-or-equal, less-or-equal
       
      Fields
      Name
      Data Type
      type
      STRING
      id
      STRING
      attributes
      RECORD
      links
      RECORD

      Failed To Deliver Automated Response SMS

      Purpose: This API is used to fetch all events of Failed To Deliver Automated Response SMS metric
       
      Source API Documentation: https://developers.klaviyo.com/en/reference/get_events
       
      Replication: Key Based Incremental
       
      Replication Key: greater-or-equal, less-or-equal
       
      Fields
      Name
      Data Type
      type
      STRING
      id
      STRING
      attributes
      RECORD
      links
      RECORD

      Failed To Deliver SMS

      Purpose: This API is used to fetch all events of Failed To Deliver SMS metric
       
      Source API Documentation: https://developers.klaviyo.com/en/reference/get_events
       
      Replication: Key Based Incremental
       
      Replication Key: greater-or-equal, less-or-equal
       
      Fields
      Name
      Data Type
      type
      STRING
      id
      STRING
      attributes
      RECORD
      links
      RECORD

      Marked Email As Spam

      Purpose: This API is used to fetch all events of Marked Email As Spam metric
       
      Source API Documentation: https://developers.klaviyo.com/en/reference/get_events
       
      Replication: Key Based Incremental
       
      Replication Key: greater-or-equal, less-or-equal
       
      Fields
      Name
      Data Type
      type
      STRING
      id
      STRING
      attributes
      RECORD
      links
      RECORD

      Merged Profile

      Purpose: This API is used to fetch all events of Merged Profile metric
       
      Source API Documentation: https://developers.klaviyo.com/en/reference/get_events
       
      Replication: Key Based Incremental
       
      Replication Key: greater-or-equal, less-or-equal
       
      Fields
      Name
      Data Type
      type
      STRING
      id
      STRING
      attributes
      RECORD
      links
      RECORD

      Opened Email

      Purpose: This API is used to fetch all events of Opened Email metric
       
      Source API Documentation: https://developers.klaviyo.com/en/reference/get_events
       
      Replication: Key Based Incremental
       
      Replication Key: greater-or-equal, less-or-equal
       
      Field
      Name
      Data Type
      type
      STRING
      id
      STRING
      attributes
      RECORD
      links
      RECORD

      Opened Push

      Purpose: This API is used to fetch all events of Opened Push metric
       
      Source API Documentation: https://developers.klaviyo.com/en/reference/get_events
       
      Replication: Key Based Incremental
       
      Replication Key: greater-or-equal, less-or-equal
       
      Fields
      Name
      Data Type
      type
      STRING
      id
      STRING
      attributes
      RECORD
      links
      RECORD

      Placed Order

      Purpose: This API is used to fetch all events of Placed Order metric of Shopify
       
      Source API Documentation: https://developers.klaviyo.com/en/reference/get_events
       
      Replication: Key Based Incremental
       
      Replication Key: greater-or-equal, less-or-equal
       
      Fields
      Name
      Data Type
      type
      STRING
      id
      STRING
      attributes
      RECORD
      links
      RECORD

      Received Automated Response SMS

      Purpose: This API is used to fetch all events of Received Automated Response SMS metric
       
      Source API Documentation: https://developers.klaviyo.com/en/reference/get_events
       
      Replication: Key Based Incremental
       
      Replication Key: greater-or-equal, less-or-equal
       
      Fields
      Name
      Data Type
      type
      STRING
      id
      STRING
      attributes
      RECORD
      links
      RECORD

      Received Email

      Purpose: This API is used to fetch all events of Received Email metric
       
      Source API Documentation: https://developers.klaviyo.com/en/reference/get_events
       
      Replication: Key Based Incremental
       
      Replication Key: greater-or-equal, less-or-equal
       
      Field
      Name
      Data Type
      type
      STRING
      id
      STRING
      attributes
      RECORD
      links
      RECORD

      Received Push

      Purpose: This API is used to fetch all events of Received Push metric
       
      Source API Documentation: https://developers.klaviyo.com/en/reference/get_events
       
      Replication: Key Based Incremental
       
      Replication Key: greater-or-equal, less-or-equal
       
      Fields
      Name
      Data Type
      type
      STRING
      id
      STRING
      attributes
      RECORD
      links
      RECORD

      Received SMS

      Purpose: This API is used to fetch all events of Received SMS metric
       
      Source API Documentation: https://developers.klaviyo.com/en/reference/get_events
       
      Replication: Key Based Incremental
       
      Replication Key: greater-or-equal, less-or-equal
       
      Fields
      Name
      Data Type
      type
      STRING
      id
      STRING
      attributes
      RECORD
      links
      RECORD

      Refunded Order

      Purpose: This API is used to fetch all events of Refunded Order metric of Shopify
       
      Source API Documentation: https://developers.klaviyo.com/en/reference/get_events
       
      Replication: Key Based Incremental
       
      Replication Key: greater-or-equal, less-or-equal
       
      Fields
      Name
      Data Type
      type
      STRING
      id
      STRING
      attributes
      RECORD
      links
      RECORD

      Sent SMS

      Purpose: This API is used to fetch all events of Sent SMS metric
       
      Source API Documentation: https://developers.klaviyo.com/en/reference/get_events
       
      Replication: Key Based Incremental
       
      Replication Key: greater-or-equal, less-or-equal
       
      Fields
      Name
      Data Type
      type
      STRING
      id
      STRING
      attributes
      RECORD
      links
      RECORD

      Subscribed To Back In Stock

      Purpose: This API is used to fetch all events of Subscribed To Back In Stock metric
       
      Source API Documentation: https://developers.klaviyo.com/en/reference/get_events
       
      Replication: Key Based Incremental
       
      Replication Key: greater-or-equal, less-or-equal
       
      Fields
      Name
      Data Type
      type
      STRING
      id
      STRING
      attributes
      RECORD
      links
      RECORD

      Subscribed To List

      Purpose: This API is used to fetch all events of Subscribed To List metric
       
      Source API Documentation: https://developers.klaviyo.com/en/reference/get_events
       
      Replication: Key Based Incremental
       
      Replication Key: greater-or-equal, less-or-equal
       
      Fields
      Name
      Data Type
      type
      STRING
      id
      STRING
      attributes
      RECORD
      links
      RECORD

      Unsubscribed

      Purpose: This API is used to fetch all events of Unsubscribed metric
       
      Source API Documentation: https://developers.klaviyo.com/en/reference/get_events
       
      Replication: Key Based Incremental
       
      Replication Key: greater-or-equal, less-or-equal
       
      Fields
      Name
      Data Type
      type
      STRING
      id
      STRING
      attributes
      RECORD
      links
      RECORD

      Unsubscribed From List

      Purpose: This API is used to fetch all events of Unsubscribed From List metric
       
      Source API Documentation: https://developers.klaviyo.com/en/reference/get_events
       
      Replication: Key Based Incremental
       
      Replication Key: greater-or-equal, less-or-equal
       
      Field
      Name
      Data Type
      type
      STRING
      id
      STRING
      attributes
      RECORD
      links
      RECORD

      Unsubscribed From SMS

      Purpose: This API is used to fetch all events of Unsubscribed From SMS metric
       
      Source API Documentation: https://developers.klaviyo.com/en/reference/get_events
       
      Replication: Key Based Incremental
       
      Replication Key: greater-or-equal, less-or-equal
       
      Fields
      Name
      Data Type
      type
      STRING
      id
      STRING
      attributes
      RECORD
      links
      RECORD

      Updated Email Preferences

      Purpose: This API is used to fetch all events of Updated Email Preferences metric
       
      Source API Documentation: https://developers.klaviyo.com/en/reference/get_events
       
      Replication: Key Based Incremental
       
      Replication Key: greater-or-equal, less-or-equal
       
      Fields
      Name
      Data Type
      type
      STRING
      id
      STRING
      attributes
      RECORD
      links
      RECORD

       

       

      data structure klaviyo update

      Was this article helpful?

      Yes
      No
      Give feedback about this article

      Related Articles

      • Essential Attributes and Supported Tables for Klaviyo
      • Klaviyo: Authentication Credentials
      • Setup Instructions for Klaviyo

      Table of Contents

      Tables/APIs - Metrics - Lists - Segments Profiles Flows Flow Actions Flow Messages Templates Active On Site Bounced Email Cancelled Order Clicked SMS Clicked Email Consented To Receive SMS Dropped Email Failed To Deliver Automated Response SMS Failed To Deliver SMS Marked Email As Spam Merged Profile Opened Email Opened Push Placed Order Received Automated Response SMS Received Email Received Push Received SMS Refunded Order Sent SMS Subscribed To Back In Stock Subscribed To List Unsubscribed Unsubscribed From List Unsubscribed From SMS Updated Email Preferences

      Get Started on your Data Journey Today!

      Get a free 14-day trial of Daton today, no credit card is required.

      Start Free Trial
      Talk To Experts
      • Quick & Easy Setup
      • Secure & Reliable
      • No-Code Platform
      • Auto Updates
      • 24/7 Support

      Follow Us

      Linkedin Youtube

      Company

      • Customers
      • Partner With Us
      • Contact Us

      Culture

      • About
      • People
      • Careers

      Offerings

      • Daton
      • For Brands
      • For Agencies

      Policies

      • Terms of Service
      • Privacy Policy
      • MSA

      Follow Us

      Linkedin Youtube

      DISCLAIMER: Various trademarks are held by their respective owners

      © 2023 sarasanalytics.com

      Sitemap

      Get Started on your Data Journey Today!

      Get a free 14-day trial of Daton today, no credit card is required.

      Start Free Trial
      Talk To Sales
      DISCLAIMER: Trademarks are held by their respective owners
      • Quick & Easy Setup
      • Secure & Reliable
      • No-Code Platform
      • Auto Updates
      • 24/7 Support

      Company

      • Customers
      • Partners
      • About
      • People
      • Careers
      • Contact Us

      Offerings

      • Daton
      • Solution for Brands
      • Solution for Agencies
      • Dashboards
      • Founder's Note
      • Status

      Policies

      • Terms of Service
      • Privacy Policy
      • MSA
      • Sitemap

      © 2023 sarasanalytics.com

      Linkedin Youtube

      Knowledge Base Software powered by Helpjuice

      Expand