AEP profile merge | Community
Skip to main content
January 8, 2020
Solved

AEP profile merge

  • January 8, 2020
  • 2 replies
  • 4389 views

Need help on AEP profile merge. I need to be able create a unified profile for customer data coming from different Profile datasets.

I have 2 different profile datasets as given below, which have common identifier like ECID and Email as Primary Identities present in the schema. I am trying to ingest online data into these datasets. But the problem is its creating two separate profiles in AEP. I am not getting unified profile view.

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by KevinFosterDX

I don't see your data or schemas so will just outline some generic steps to try:

 

1. Make sure that your two XDM Profile based schemas have exactly one primary identity marked, and if those two identities aren't in the same namespace, then at least one of those schemas must have a secondary identity that matches the other schema's primary identity.

 

2. Mark your datasets for profile service and then load your data. Marking afterwards doesn't work as loading profile service is not retroactive.

 

3. Go to the Profiles page and look at the union schema. Confirm that the union includes fields from each of your schemas.

 

4. On the Profiles page confirm that the default merge policy is still timestamp based and doesn't explicitly include or exclude datasets... default is "all" which is what you want.

 

5. On the Profiles page click the Find Profiles option. Enter an identity value that you know is in both or your datasets.

 

6. If you can't see your fields well enough to confirm that this profile has data from both datasets, then use the GET API call from Postman or equivalent.

 

7. If none of this works then open a Support ticket by clicking the "?" symbol in the upper right corner of the page.

 

-Kevin

2 replies

KevinFosterDXAdobe EmployeeAccepted solution
Adobe Employee
March 15, 2020

I don't see your data or schemas so will just outline some generic steps to try:

 

1. Make sure that your two XDM Profile based schemas have exactly one primary identity marked, and if those two identities aren't in the same namespace, then at least one of those schemas must have a secondary identity that matches the other schema's primary identity.

 

2. Mark your datasets for profile service and then load your data. Marking afterwards doesn't work as loading profile service is not retroactive.

 

3. Go to the Profiles page and look at the union schema. Confirm that the union includes fields from each of your schemas.

 

4. On the Profiles page confirm that the default merge policy is still timestamp based and doesn't explicitly include or exclude datasets... default is "all" which is what you want.

 

5. On the Profiles page click the Find Profiles option. Enter an identity value that you know is in both or your datasets.

 

6. If you can't see your fields well enough to confirm that this profile has data from both datasets, then use the GET API call from Postman or equivalent.

 

7. If none of this works then open a Support ticket by clicking the "?" symbol in the upper right corner of the page.

 

-Kevin

Level 2
July 14, 2021

@89199
Here is a situation. Customer table has customerId and crmId. Customer preferences are stored in a Preferences table with preferenceId and customerId. If we model both Customer and Preference as XDM Individual Profile Schemas, then it becomes a cartesian product of records from both datasets. Records from both datasets are considered as separate profiles even though customerId field is primary identity in Customer schema and secondary identity field in Preference schema. If I define an array of preferences in Customer schema, I am not sure how to populate it.

jantzen_b
Adobe Employee
Adobe Employee
March 19, 2020
Does Kevin's answer give you the info you need? If not, can you provide additional details to help the community better solve your question?