Klaviyo

Klaviyo

Module: Exports
Path: Processing > Imports/Exports > Exports
Topic: Klaviyo
Version(s): 5.1 & up
Editions: All

What Is Klaviyo

Klaviyo (clay-vee-oh) is an email and SMS marketing platform. 

Making The Connection

Where Will I See This Within OLX?

This export is triggered by multiple events that happen within your OLX instance. Please see the configuration settings to determine which events you want to trigger an export record for you.

What Reports Can Be Pulled?

  1. at this time there are no reports

What Imports/Exports Relate to xxxx

  1. at this time there are no imports

Trouble Shooting

  1. Process failed- Reason:SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM.

    1. this issue arises due to the fact that there is no record in the table, so it is defaulting to date "1/1/1753 12:00:00 AM" and overflowing. Set Klaviyo_Start_Date on Client custom value.

  2. Add New Fulfilled Order Events Process failed- Reason:Object reference not set to an instance of an object. Error in onStart():Process failed.

    1. Run schedule without sending tracking url > If successful - run with everything selected again > Resave schedule

Setup

Custom Values

Client

Custom values need to be added at client level:
  1. Klaviyo_Domain (not required)
    1. klaviyo > select correct account > settings > account > Domains
  2. Klaviyo_Client (required)
    1. set this value to 'true' in order to include that client
  3. Klaviyo_Start_Date (not required)
    1. if this value is a valid date then process will use this value as start date
    2. works on the date range of 24 hours difference.
      1. takes last transaction date as end date and start date would be the previous 24 hours.
  4. Klaviyo_ListId (not required)
    1. Can be set at client or campaign (campaign will override client)

Source

Custom values need to be added at source level:
  1. Klaviyo_Ignore (not required)
    1. If set to true orders associated to this source will be ignored and not send
    2. All other values are considered false, and orders will export during process

Configuration

Navigate to Processing > Processes

  1. Category = Other
  2. Process Type = Klaviyo Integration

Configuration Tab API Information

  1. API Endpoint - 
  2. (public) API Key -
    1. Klaviyo > Settings > API Keys
  3. Private API Key (used for email consent subscribe / unsubscribe -
    1. Klaviyo > Settings > API Keys

Configuration Tab Tracking Information

  1. Send Tracking URL
    1. this is not an event, this is information to send if the Fulfilled Order Events is checked below

Configuration Tab Klaviyo Events

  1. Profiles Events
    1. unchecked - no records will send for this event
    2. checked - records back to the last 24 hours (or start date set at client level custom value) will send
  2. Placed Order Events
    1. unchecked - no records will send for this event
    2. checked - records back to the last 24 hours (or start date set at client level custom value) will send
  3. Placed Non-Recurring Order Events
    1. unchecked - no records will send for this event
    2. checked - records back to the last 24 hours (or start date set at client level custom value) will send
  4. Ordered Product Events
    1. unchecked - no records will send for this event
    2. checked - records back to the last 24 hours (or start date set at client level custom value) will send
  5. Fulfilled Order Events
    1. unchecked - no records will send for this event
    2. checked - records back to the last 24 hours (or start date set at client level custom value) will send
  6. Cancelled Order Events
    1. unchecked - no records will send for this event
    2. checked - records back to the last 24 hours (or start date set at client level custom value) will send
  7. Refunded Order Events
    1. unchecked - no records will send for this event
    2. checked - records back to the last 24 hours (or start date set at client level custom value) will send
  8. Started Subscription Events
    1. unchecked - no records will send for this event
    2. checked - records back to the last 24 hours (or start date set at client level custom value) will send
  9. Updated Subscription Events
    1. unchecked - no records will send for this event
    2. checked - records back to the last 24 hours (or start date set at client level custom value) will send
  10. Cancelled Subscription Events
    1. unchecked - no records will send for this event
    2. checked - records back to the last 24 hours (or start date set at client level custom value) will send
  11. Subscribe / Unsubscribe Email Consent for Profiles Events
    1. unchecked - no records will send for this event
    2. checked - records back to the last 24 hours (or start date set at client level custom value) will send

Results Tab



The Results tab will display something similar to what you displayed above or if there are errors it will display information about the error to help you resolve and try again.

Copyright 2019
Revised 11.07.2024