Review Data in Marketing Cloud Engagement

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

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

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.

[
  {
    "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.

<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.

%%[
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!"))
]%%