Mapping & Storing Multi-Valued Customer Data From AWS S3

Managing customer data efficiently is crucial for businesses today. In this guide, we will explore how to map contact information from AWS S3 and create custom Data Lake Objects (DLOs) in your data cloud. These DLOs are designed to store multiple identifiers and email addresses for each customer, ensuring that you can manage your customer data effectively and tailor your interactions with them. 

Follow along as we delve into the process of mapping and organizing customer information, empowering you to make the most of your data resources.

Understanding How Customer Data is Stored in AWS S3

First, let’s see how customer data is organized in AWS S3. The data includes two types of email addresses: primary and alternate. There are also two identifiers: customer reward number and passport number. To manage this data efficiently, we need to create separate objects for multiple email addresses and identifiers for each customer.

Also Read: How To Install a Data Bundle in the Data Cloud?

Creating Custom Data Lake Objects

Step 1: Identifier List

1. Go to the Data Lake Objects section.
2. Click on New to create a new data lake object.
3. Name the object Identifier List and set its category to Profile.
4. Add these fields:

•     Identifier Key (Text): This is the primary key and uniquely identifies each record.
•     Party (Text): This field links to a specific contact or individual.
•     Party Identification Type (Text): The type of identification.
•     Identification Name (Text): The name of the identification.
•     Identification Number (Text): The actual identification number.

5. Click Save to create the Identifier List object.

Also Read: Salesforce Data Cloud Consultant Certification Exam Guide 2024

Step 2: Email Address List

1. Return to the Data Lake Objects section.
2. Click on New to create another data lake object.
3. Name this object Email Address List.
4. Add these fields:

•    Email Address Key (Text): This is the primary key and uniquely identifies each record.
•    Party (Text): This field links to a contact.
•    Email Address (Email/Text): The email address.

5. Set the category to Profile and click Save.

By following these steps, you will create two custom Data Lake Objects: one for storing multiple identifiers per customer and one for managing multiple email addresses per customer. This approach ensures your data is well-organized and easily accessible within the data cloud.

Explore our Salesforce Data Cloud series on YouTube for expert guidance and tips on leveraging Salesforce Data Cloud effectively.

Conclusion

Mapping customer data from AWS S3 and creating custom Data Lake Objects is crucial for efficient data management. By organizing the data into separate objects for email addresses and identifiers, you can handle customer information more effectively. This method improves data organization and makes it easier to retrieve and use information within your data cloud.

If you’re looking to enhance your Salesforce skills, check out our Salesforce Data Cloud Consultant course. Start a free trial to access over 24 Salesforce certification courses, more than 50 mock exams, and 50+ hands-on Salesforce labs. 

Boost your career and simplify your learning experience with saasguru today!