Open the CAB Integrations tab and select Data Extensions under Marketing Cloud Integration.
Select Create Data Extension.
Enter a Name and, optionally, a Description. Choose the Business Unit and the Folder, then select Next.
Under Data Extension Fields, add the columns with New, or take them over with Copy from Existing Data Extension.
Choose the Sendable Data Extension Field and the Sendable Subscriber Field it relates to, then select Done.
Create Data Extension
Define Fields
Data Extension Fields
Name
Data Type
Primary Key
Required
Default Value
Contact Field
Lead Field
Account Field
SalesforceId
Text
Id
Id
Id
LastSyncedAt
Date
CurrentDateTime
Email
EmailAddress
Email
Email
FirstName
Text
FirstName
FirstName
LastName
Text
LastName
LastName
relates to subscriber on
Every new data extension starts with two locked fields: SalesforceId, the primary key that holds each record’s Salesforce ID, and LastSyncedAt, which records when CAB last sent the row. You can’t edit or delete them. Each further field names the Contact, Lead or Account field it takes its value from.
The Data Extensions page lists the data extensions CAB has added to, each with its columns.
When you map a column in a data extension add, Audience Data Graph can take one value from related records. Choose the path, Sort By, Sort Order and the field, then select Done. The sort decides which related record’s value is sent. See Related data and Data Inclusions.
Audience Data Graph also offers the aggregates the audience calculates:
Number and currency aggregates go to Number and Decimal columns, date aggregates to Date columns.
Data extensions have no currency type, so a currency amount arrives as a plain number in your corporate currency.
The value is rounded to the column’s decimal places; a Number column gets a whole number.
A Decimal column needs its length and decimal places set in Marketing Cloud. Otherwise CAB refuses the mapping until you correct the column and search the data extension again.
An add that maps an aggregate always runs in the background. When a value can’t be delivered, for example an empty aggregate into a required column, CAB stops the add and reports it as failed, with the reason.
The data extension appears in Marketing Cloud in the chosen folder, and you can choose it as the target of a data extension add. A data extension add needs a primary key column. See Limits and requirements.