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

      • Saras IQ

        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