Skip to content

Create data extensions

After these steps, a data extension in Marketing Cloud is ready to receive the results of your audiences.

Before you begin

Setting
Marketing Cloud is connected. See Connect Marketing Cloud.
Permission
The Campaign Audience Builder - Marketing Cloud Integration permission set. See Permission sets.

CAB adds people to data extensions as an action, once from the results page or on a schedule. See How integrations work.

  1. Open the CAB Integrations tab and select Data Extensions under Marketing Cloud Integration.

  2. Select Create Data Extension.

  3. Enter a Name and, optionally, a Description. Choose the Business Unit and the Folder, then select Next.

  4. Under Data Extension Fields, add the columns with New, or take them over with Copy from Existing Data Extension.

  5. Choose the Sendable Data Extension Field and the Sendable Subscriber Field it relates to, then select Done.

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.