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.
    custom-namespace

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 as shown. Mark the crmid field as identity and primary.

profile-schema

Prepare sample data

Update the dummy email addresses to real ones. These will be used later when sending messages with Adobe Journey Optimizer.

crmId
firstName
lastName
email
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 .Make sure the dataset is enabled for profile.

  • 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.
    ingest-csv

  • Navigate to the next screen. Upload the csv file and verify the mappings
    mappings

  • Click Finish to start the data ingestion process

Verify profile

  • Navigate to Customer ->Profiles and search for FinWise CRM ID equal to FIN001 or any other valid value
    verify-profile
recommendation-more-help
e6c8f56b-fb30-4cf1-b47d-ba51830f4926