---
schema_version: "1"
id: 41feb8eeba053991b23f796617d78f4f955aab4383b64eb324b3c94ae5995251
title: Review 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_mobile_push_review_data.md
canonical_url: https://help.salesforce.com/s/articleView?id=data.c360_a_mobile_push_review_data.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: ad81914725bb243a1d8e97a030dfa734bca0970ffa1588824b38c6572e868186
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 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.

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small ">
        <colgroup>
          <col style="width:25%">
          <col style="width:25%">
          <col style="width:25%">
          <col style="width:25%">
        </colgroup>
        <thead class="slds-text-title_caps ">
          <tr class="">
            <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d199917e39">SubscriberKey</th>
            <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d199917e42">Id</th>
            <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d199917e45">FirstName</th>
            <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d199917e48">Loyalty_Program_Member</th>
          </tr>
        </thead>
        <tbody>
          <tr class="">
            <td data-label="SubscriberKey" class="slds-cell-wrap" style="vertical-align:top;" headers="d199917e39 ">Raja_Jones_Push_123</td>

            <td data-label="Id" class="slds-cell-wrap" style="vertical-align:top;" headers="d199917e42 ">Raja_Jones_Push_123</td>

            <td data-label="FirstName" class="slds-cell-wrap" style="vertical-align:top;" headers="d199917e45 ">Raja</td>

            <td data-label="Loyalty_Program_Member" class="slds-cell-wrap" style="vertical-align:top;" headers="d199917e48 ">
              <p>JSON BLOCK</p>
              <pre class="line-numbers slds-box slds-box_x-small slds-theme_shade slds-m-top_medium slds-m-bottom_medium slds-scrollable_x"><code class="language-html">[{"program_name":
"Premiere Plus","Loyalty_Member_Tier":
[{"previous_loyalty_tier":"Silver",
"loyalty_tier":"Gold"}]}]</code></pre>
            </td>

          </tr>
        </tbody>
      </table>

The first two columns are required based on the activation type (Push). The FirstName column is the selected direct attribute. 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 field 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)=%%!! You have recently reached %%=v(@loyalty_tier)=%% status 
for %%=v(@program_name)=%%. To thank you for being such a loyal member with us, 
we are giving you a $100 gift card for your favorite food delivery service!
```

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, "!! You have recently reached ", @LoyaltyTier, " status 
for ", @ProgramName, ". To thank you for being such a loyal member with us, 
we are giving you a $100 gift card for your favorite food delivery service!"))
]%%

```

#### See Also

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