Import sample CRM data into AEP profile dataset
To begin the identity stitching, import sample CRM profile data into a dataset tied to a profile-enabled schema in Adobe Experience Platform
Create a custom namespace
- Navigate to Customer -> Identities -> Create identity namespace
- Select Individual cross-device ID and provide the display name and identity symbol as shown in the screen-shot below.
Create a profile enabled schema
Create an individual profile schema called FinWiseProfileSchema. Include fields, such as annualIncome, email,firstName,lastName and loyaltyStatus.
Add an identity field crmid under the SystemIdentifier object. Mark the crmid field as identity and primary
Prepare sample data
| crmId | firstName | lastName | loyaltyStatus | zipCode | annualIncome | |
|---|---|---|---|---|---|---|
| FIN001 | Alice | Wong | alice.wong@example.com | Gold | 92128 | 120000 |
| FIN002 | Bob | Smith | bob.smith@example.com | Silver | 92126 | 85000 |
| FIN003 | Charlie | Kim | charlie.kim@example.com | Platinum | 60614 | 175000 |
| FIN004 | Diana | Lee | diana.lee@example.com | Gold | 30303 | 98000 |
| FIN005 | Ethan | Brown | ethan.brown@example.com | Bronze | 75201 | 60000 |
Ingest the CSV file
-
Create a dataset called FinWiseCustomerDataSetWithAnnualIncome based on the FinWiseProfileSchema created in the earlier step
-
Navigate to Connections -> Sources -> Local system
-
Select the Add Data under the Local file upload. Make sure to select the FinWiseCustomerDataSetWithAnnualIncome as the target dataset.
-
Navigate to the next screen. Upload the csv file and verify the mappings
-
Click Finish to start the data ingestion process
