Salesforce Docs Portal

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 
[
  {
    "policy_number": 1234,
    "starting_date": "2021-11-15T00:00:00.000Z",
    "product_type": "Auto",
    "RA_PolicyProducts": [
      {
        "product_type_1": "Auto",
        "productId": "A123",
        "RA_Account02": [
          {
            "membername": "Raul",
          },
          {
            "membername": "Jennifer"
          }
        ]
      }
    ]
  }
]

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"
          }
        ]
      }
    ]
  }
]

See Also