Acquia CDP

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