You are here:
Locate the Data Extension in Marketing Cloud Engagement
After it’s activated, a data extension is added to the Marketing Cloud Engagement business unit identified in activation.
Here’s the data extension based on this activation use case.
| SubscriberKey | Id | EmailAddress | FirstName | RA_PolicyInformation_02 |
|---|---|---|---|---|
| Raul_J_123 | Raul_J_123 | Raul.J@example-email.com | Raul | |
The first three columns are required based on the activation type (email). The FirstName column is the selected direct attribute. The last column contains the related attributes formatted as a JSON code block in one data extension field. The column name, RA_Policies_02, is named after the API name of the related attribute’s main DMO.
- Policy Number
- Starting Date
- Product Type
- Product Type 1
- Product Id
- Member Name
The first three attributes are shown first in the JSON code block.
[
{
"policy_number": 1234,
"starting_date": "2021-11-15T00:00:00.000Z",
"product_type": "Auto",The next attributes come from the RA_PolicyProducts data model object.
"RA_PolicyProducts": [
{
"product_type_1": "Auto",
"productId": "A123",The final code shows data from the RA_Account02 data model object. In this example, the customer has two members, Raul and Jennifer.
"RA_Account02": [
{
"membername": "Raul"
},
{
"membername": "Jennifer"
}
]
}
]
}
]