---
schema_version: "1"
id: 12ae7a309994779b2deaaf2f0e78f38cfaa1b3184a8f69748054fd42b86b0f5e
title: Review the Data in Marketing Cloud Engagement
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/data/264-0-0/c360_a_relatt_uc1_step3.md
canonical_url: https://help.salesforce.com/s/articleView?id=data.c360_a_relatt_uc1_step3.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: 945fd4b38f7e076232391b71a0cf0c27a33ca57ed3d55c2e7cac5da166bf5e66
description: After the segment is activated, a data extension is added to the Marketing Cloud Engagement business unit that you identified in the activation.
products:
  - Data 360
release: "264"
---
# Review the Data in Marketing Cloud Engagement

After the segment is activated, a data extension is added to the Marketing Cloud Engagement business unit that you identified in the activation.

Here’s the data extension based on this activation use case.

![Sample Data extension](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-data-data_cloud-264-0-0-production-enus/f3569962-3c9b-4f83-9d0c-b6a574e785da/data_cloud/images/Data_Extension_RA_SMS.jpg)

The first four columns are required based on the activation type (SMS). 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, Loyalty\_Program\_Member, is named after the API name of the related attribute’s main DMO.

- Program Name
- Previous Loyalty Tier
- Loyalty Tier

These attributes are provided in the JSON code block.

```json
[
  {
    "program_name": "Premiere Plus",
    "Loyalty_Member_Tier": [
      {
        "previous_loyalty_tier": "Silver",
        "loyalty_tier": "Gold"
      }
    ]
  }
]
```

You can parse this data with either SSJS, AMPscript, or GTL. Here’s an example of parsing with SSJS.

```html
<script runat="server">
    Platform.Load("core","1");
  
    //Get First Name from Data Extension
    var First_Name = Platform.Recipient.GetAttributeValue("FirstName");
    Variable.SetValue("@First_Name", First_Name);

    //Get and Parse JSON Block from Data Extension
    var JSONblock = Platform.Recipient.GetAttributeValue("Loyalty_Program_Member");
    var JSONObj = Platform.Function.ParseJSON(JSONblock);

    //Read JSON Block variables
    Variable.SetValue("@program_name", JSONObj[0]["program_name"]);
    Variable.SetValue("@loyalty_tier", JSONObj[0]["Loyalty_Member_Tier"][0]["loyalty_tier"]);
</script>

Congrats, %%=v(@First_Name)=%%!! Your %%=v(@program_name)=%% loyalty status level has changed to
%%=v(@loyalty_tier)=%%!
```

Here’s an example of parsing with AMPscript.

```html

%%[
var @ProgramRowset, @ProgramRow, @ProgramName, @LoyaltyTierRowset, @LoyaltyTierRow, @LoyaltyTier


/* Query the first JSON object from the related attributes array. */
set @ProgramRowset=BuildRowsetFromJson(Loyalty_Program_Member,"$.[0]", false)


/* Get the program_name value. */
set @ProgramRow=row(@ProgramRowset, 1)
set @ProgramName=field(@ProgramRow, "program_name")


/* Query the first Loyalty_Member_Tier object inside of the first object. */
set @LoyaltyTierRowset=BuildRowsetFromJson(Loyalty_Program_Member,"$.[0]['Loyalty_Member_Tier'][0]", false)


/* Get the loyalty_tier value */
set @LoyaltyTierRow=row(@LoyaltyTierRowset, 1)
set @LoyaltyTier=field(@LoyaltyTierRow, "loyalty_tier")


/* Print the message */
OutputLine(concat("Congrats, ", FirstName, "!! Your ", @ProgramName, " loyalty status level has changed to ", @LoyaltyTier, "!"))
]%%

</script>
```

#### See Also

- [_Salesforce Developer_: Build Row Set From JSON](https://review-app-sdmarkdoc-pr-196.herokuapp.com/docs/marketing/marketing-cloud/guide/buildrowsetfromjson.html)