The Salesforce Marketing Cloud (SFMC) integration syncs Contact and Activity Data Extensions (DE) from SFMC into Demandbase.
To ensure optimal performance, configure your Data Extensions according to the structure outlined in this article, including all required fields and any optional fields needed for reporting flexibility.
SFMC Data Extension Structure
You must create separate Data Extensions for:
- Contact Profile data
- Activity data (one DE per activity type)
Important: If Contact Profile and activity data are currently stored in a single DE, you must separate them before starting the integration.
Contact Profile Data Extension (DE)
Create a Contact Profile DE that contains core subscriber information and any additional personalization fields.
Required Fields
Important: Field names may vary, but data types and requirements must match the following table.
| Field Name | Data Type | Requirement | Description |
| SubscriberKey | Text | Required (PrimaryKey) | Unique ID for the contact Must be the Primary Key |
| EmailAddress | Required | Used to link to external systems | |
| FirstName | Text | Required | Contact attribute |
| LastName | Text | Required | Contact attribute |
| LastModifiedDate | DateTime | Required | Used for data sync and integrity checks |
| CreatedDate | DateTime | Optional | Contact creation date |
| (Custom Fields) | Varies | Optional | Additional Contact attributes used for personalization |
Activity Data Extensions (DEs)
Create individual Activity DE's for each activity type.
Examples:
- Email_Clicks
- Email_Opens
- Email_Sends
Important:
- Do not combine multiple activity types into a single DE.
- Retain historical activity records for accurate reporting.
Required Fields
Important: Field names may vary, but data types and requirements must match the following table.
| Field Name | Data Type | Requirement | Description |
| UniqueExternalID | Text | Required | Unique identifier for the activity record |
| SubscriberKey | Text | Required | Links the activity back to the Contact Profile DE |
| EventDate | DateTime | Required | Used for time-based metric calculations |
| (Custom Fields) | Varies | Optional | Additional activity attributes |