Page tree
Skip to end of metadata
Go to start of metadata

New Name: Marketing Cloud Personalization

Interaction Studio (formerly Evergage) is now known as Marketing Cloud Personalization. The new name reflects our mission and vision for innovation in Salesforce Marketing Cloud. We wish we could snap our fingers to update the name everywhere, but you can expect to see the previous name in various places until we replace it.

Interaction Studio can ingest data about email campaigns that were sent by an external ESP. Data ingested can include sends, opens, clicks, and unsubscribes.


This Article Explains

This article details the requirements and schema for the User External Email Campaign Events ETL and provides a sample file to download.

Sections in this Article

Requirements and Schema

Data ingested via the External Email Campaign Events ETL gets stored in a third party campaign object and against the user profile. This data is subsequently available for segmentation and targeting purposes. The associated file format is detailed below.


IMPORTANT NOTE

For customers leveraging Interaction Studio’s multiple identities system, at least one identity attribute is required to be present in the ETL file. If you would like to send in multiple identity attributes for a single customer, this is supported by simply having multiple identity attribute columns in the file.  Only unique identities can be included and updated through etl.

The correct ETL header format for identity attributes is attribute:value. Examples of the out-of-the box identity attributes with proper formatting is as follows:

  • attribute:emailAddress
  • attribute:sfmcContactKey
  • attribute:customerId
  • attribute:sfcrmContactId
  • attribute:sfcrmLeadId

userId is not referenced in ETL processing when the multiple identities system is enabled. For customers NOT leveraging Interaction Studio’s multiple identities system, userId will still be supported for profile merging.



File Name Format:
 externalEmailCampaign-YYYY-MM-DD_HH-MM-SS.csv


Field NameMinimum RequirementsExample ValuesMax LengthData Type

userId OR an Identity Attribute

Required.

  • For clients that ARE NOT using Interaction Studio's multiple identities system, a user ID must be included. This ID must be one that is tracked within the Evergage platform so that the events can be tied to the specific user profile.
  • For clients that ARE using Interaction Studio's multiple identities system, userId is not referenced in ETL file loads. At least one identity attribute is required. Multiple identity attributes can be included for a single user by simply including multiple columns in the file. The proper format for identity attributes is detailed in the comment above.


user@example.com

120String

externalCampaignId

Required. The unique identifier for the external campaign.

3823923

QLcjsAjC

1023

Any Valid Interaction Studio Data type

externalCampaignName

Optional. The unique name for the campaign.

Example_campaignname

Testcampaign_242424

testcampaign

1023

eventType

Required. The type of event. Currently supported values include send, click, open, unsubscribe.

Send

Click

Open


120String

eventDate

Required. The date and time that the event occurred.

2017-04-22T10:23:3 7Z


String

externalSystem

Required. Include the system that ran the campaign.

Salesforce Marketing Cloud

Eloqua

Marketo

Responsys

1023

String

sourceOptional. The source of the campaign.
1023String
mediumOptional. The medium the campaign.
1023String

       

Sample File Structure

Sample File Structure: Not Leveraging the IS Multiple Identity System

userIdexternalCampaignIdexternalCampaignNameeventTypeexternalSystemeventDate
jdoe3823923
SendSalesforce Marketing Cloud2017-07-17T11:24:23Z
tester@test.comQLcjsAjC
OpenEloqua2009-10-19T08:42:58Z
user103925newsletterCampaignNewsletter CampaignClickResponsys2020-07-07T10:11:34Z

Sample File Structure: Leveraging the IS Multiple Identity System

attribute:emailAddressattribute:customerIdexternalCampaignIdexternalCampaignNameeventTypeexternalSystemeventDate
jdoe@ac.com1234563823923
SendSalesforce Marketing Cloud2017-07-17T11:24:23Z
tester@test.com111234QLcjsAjC
OpenEloqua2009-10-19T08:42:58Z
bob@test.com

675908

newsletterCampaignNewsletter CampaignClickResponsys2020-07-07T10:11:34Z