Salesforce Data Cloud Data-Cloud-Consultant Question # 2 Topic 1 Discussion

To personalize the content of the email with five "fun" trip statistics, the consultant should recommend using adata transformto aggregate the statistics and map them to direct attributes on theIndividualobject 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:

Adata transformcan 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 todirect attributeson theIndividualobject.

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 theIndividualobject 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 adata transformto aggregate the statistics and map them to direct attributes on theIndividualobject is the most efficient and effective solution for personalizing the email content.