Loading...

Input connector

The CDP fetches the following four entities through the Workato connectors to SFTP location:

  • Campaigns

  • Customers/Contacts

  • Events

  • Unsubscribe information

Klaviyo entities read

This page provides the following information for a given entity read from Klaviyo:

  • CDP entities

  • Attributes populated for CDP entities

  • Klaviyo attributes used to populate the value of CDP attributes

  • Notes to provide any additional information

CDP-Klaviyo entity read for Campaign entity

This section provides information about the following CDP entities:

Campaign

CDP Attribute

Klaviyo Attribute

SourceCampaignNumber

campaign.id

Name

name

Type

message_type

DateCreated

created

DateModified

updated

Dispatch

CDP Attribute

Klaviyo Attribute

SourceDispatchNumber

campaign.id

Name

name

Type

message_type

DateCreated

created

Message

CDP Attribute

Klaviyo Attribute

SourceMessageNumber

campaign.id

Subject

subject

MessageFrom

message.from_email

CDP-Klaviyo entity read for Customer entity

This section provides information about the following CDP entities:

Customer

CDP Attribute

Klaviyo Attribute

Note

SourceCustomerNumber

$id

FirstName

$first_name

LastName

$last_name

Title

$title

Company

$organization

PrimaryPhone

$phone_number

Email

$email

DoNotEmail

Static value set to N

DateCreated

created

DateModified

updated

Address

CDP Attribute

Klaviyo Attribute

Note

SourceAddressNumber

$address1

Key=ADR

SourceAddressNumber

$id

Key=SCN

SourceAddressNumber

$zip

Key=Zip

Address1

$address1

Address2

$address2

City

$city

Zip

$zip

Country

$country

CustomerAddressXref

CDP Attribute

Klaviyo Attribute

Note

SourceAddressNumber

$address1

Key=ADR

SourceAddressNumber

$id

Key=SCN

SourceAddressNumber

$zip

Key=Zip

SourceCustomerNumber

$id

CDP-Klaviyo entity read for Event entity

This section provides information about the Event CDP entity.

Event

CDP Attribute

Klaviyo Attribute

Note

Type

event_name

Value transformation of Klaviyo:CDP

  • ‘Opened Email’:’emailOpen’

  • ‘Bounced Email’:’emailBounce’

  • ‘Clicked Email’:’emailClick’

  • ‘Clicked SMS’:’smsOpen’

  • ‘Dropped Email’:’emailDefer’

  • ‘Failed to Deliver SMS’:’smsBounce’

  • ‘Marked Email as Spam’:’emailSpam’

  • ‘Received Email’:’emailDeliver’

  • ‘Received SMS’:’smsDeliver’

  • ‘Sent SMS’:’smsSend’

  • ‘Unsubscribed’:’emailUnsubscribe’

  • ‘Unsubscribed from SMS’:’smsUnsubscribe’

SubType

For bounced email events, this is set to the Bounce Type. Otherwise the value is Null

EventTimeStamp

timestamp

Email

person.$email

SourceMessageNumber

campaign.id

SourceCustomerNumber

person.id

URL

URL

Set for click events. Otherwise the value is Null

CDP-Klaviyo entity read for Unsubscribe entity

This section provides information about the Customer CDP entity.

Customer

CDP Attribute

Klaviyo Attribute

Note

SourceCustomerNumber

$id

Email

email

DoNotEmail

Static value set to Y

emailOptOutDate

timestamp

Did not find what you were looking for?

If this content did not answer your questions, try searching or contacting our support team for further assistance.

Back to Section navigation