- 2 Minutes to read
- Print
- DarkLight
Recipient Activity Mapping
- 2 Minutes to read
- Print
- DarkLight
You can use a mapping to assign one of several possible values to a contact, based on an analysis of the data in his profile. A mapping allows you to create more complex selections than the Selections or the Selection Builder.
This topic contains the following examples:
Hot / Warm / Cold (based on the date when a contact last clicked on a message link)
Gold / Silver / Bronze (based on the date when a contact last completed a purchase)
Hot / Warm / Cold (Based on Last Click)
This example creates a mapping that categorizes contacts based on their most recent click date.
Hot: The contact made a purchase within the last 2 weeks.
Warm: The contact made a purchase between 4 weeks and 2 weeks ago.
Cold: The contact made a purchase between 8 weeks and 4 weeks ago.
Procedure
Create an event-based automation to store the date of your contact's last purchase in a custom user attribute with the name LastClickDate. The data type is Date.
Create a new custom user attribute with the name Category. The date type is string. Enumerate the 3 values in advance: Hot, Warm and Cold.
Create a mapping with three conditions. From the Target Attribute drop-down list, select the attribute Category.
Tab. : MappingCondition
When
Then
1
${ecm:greater(user.CustomAttribute.LastClickDate, ecm:addInterval(date.today, '-2W'))}
Hot
2
${ecm:between(user.CustomAttribute.LastClickDate, ecm:addInterval(date.today, '-4W'), ecm:addInterval(date.today, '-2W'))}
Warm
3
${ecm:between(user.CustomAttribute.LastClickDate, ecm:addInterval(date.today, '-8W'), ecm:addInterval(date.today, '-4W'))}
Cold
Click the Save button.
Select the profile-based automation and click the Activate button.
⇒ The profile-based automation is now active.Click the Apply Automations button.
⇒ Engage applies the automation to all contacts in the system. This can take a long time. An email notifies you when the automation is finished.
Gold / Silver / Bronze (Based on Last Purchase)
This example creates a mapping that categorizes contacts based on their most recent purchase on your website. Contacts are categorized as gold, silver or bronze.
Gold: The contact made a purchase within the last 6 weeks.
Silver: The contact made a purchase between 6 months and 6 weeks ago.
Bronze: The contact made a purchase between 12 months and 6 months ago.
Procedure
Create an event-based automation to store the date of your contact's last purchase in a custom user attribute with the name LastPurchaseDate. The date type is Date.
Create a new custom user attribute with the name Category. The date type is string. Enumerate the 3 values in advance: Gold, Silver and Bronze.
Create a mapping with three conditions. From the Target Attribute drop-down list, select the attribute Category.
Tab. : MappingCondition
When
Then
1
${ecm:greater(user.CustomAttribute.LastPurchaseDate, ecm:addInterval(date.today, '-6W'))}
Gold
2
${ecm:between(user.CustomAttribute.LastPurchaseDate, ecm:addInterval(date.today, '-6M'), ecm:addInterval(date.today, '-6W'))}
Silver
3
${ecm:between(user.CustomAttribute.LastPurchaseDate, ecm:addInterval(date.today, '-12M'), ecm:addInterval(date.today, '-6M'))}
Bronze
Click the Save button.
Select the profile-based automation and click the Activate button.
⇒ The profile-based automation is now active.Click the Apply Automations button.
⇒ Engage applies the automation to all contacts in the system. This can take a long time. An email notifies you when the automation is finished.