To personalize the content of the email with five "fun" trip statistics, the consultant should recommend using a data transform to aggregate the statistics and map them to direct attributes on the Individual object for inclusion in the activation. Here’s why:
Understanding the Requirement
The rideshare company wants to send personalized emails to customers with aggregated trip statistics (e.g., destination, distance traveled).
The raw data is not aggregated at the source, so it must be processed in Data Cloud.
Why Use a Data Transform?
Aggregating Statistics :
A data transform can aggregate the raw trip data (e.g., summing distances, counting destinations) into meaningful statistics for each customer.
This ensures that the data is summarized and ready for personalization.
Mapping to Direct Attributes :
The aggregated statistics can be mapped to direct attributes on the Individual object.
These attributes can then be included in the activation and used to personalize the email content.
Other Options Are Less Suitable :
B. Create five calculated insights for the activation and add dimension filters : While calculated insights are useful, creating five separate insights is inefficient compared to a single data transform.
C. Use a data action to send each ride as an event to Marketing Cloud Engagement, then use AMP script to summarize this data in the email : This approach is overly complex and shifts the aggregation burden to Marketing Cloud, which is not ideal.
D. Include related attributes in the activation for the last 365 days : Including raw data without aggregation would result in unprocessed information, making personalization difficult.
Steps to Implement the Solution
Step 1: Create a Data Transform
Use a batch or streaming data transform to aggregate the trip statistics (e.g., total distance, unique destinations) for each customer.
Step 2: Map Aggregated Data to Individual Object
Map the aggregated statistics to direct attributes on the Individual object in Data Cloud.
Step 3: Activate the Data
Include the aggregated attributes in the activation for the email campaign.
Step 4: Personalize the Email
Use the activated attributes to personalize the email content with the trip statistics.
Conclusion
Using a data transform to aggregate the statistics and map them to direct attributes on the Individual object is the most efficient and effective solution for personalizing the email content.