Profile dataset components attribution (Costumer journey analytics CJA)

Question

We are working on a client that has a profile dataset available in CJA. As part of our analysis tasks, we want to know the subscriptor statement (actived or canceled) at a given snapshot.

However, when we set the report, we are observing that when a profile dimension is used for a specific event, CJA returns multiple value if user has multiple values during along the time, acting as a list var. But when using the same dimension but on the event dataset, attribution is as we expected and only shows the last value known.

Data with profile dimension

Person ID	Timestamp	Event type	suscription state (profile dataset)
A	01/10/2024	order upgrade	active
A	01/10/2024	order upgrade	canceled
B	01/10/2024	order canceled	active
B	01/10/2024	order canceled	canceled

Data with event dimension

Person ID	Timestamp	Event type	suscription state (event dataset)
A	01/10/2024	order upgrade	active
B	01/10/2024	order canceled	canceled

Is this a expected behaviour or is it caused by a wrong implement?

Harveer_SinghGi1 · Accepted Answer

Hi @javierma8 ,In CJA the profile datasets ideally work as lookups against the Person ID and like any lookup dataset these should return the most recent value of the lookup field in the Profile Dataset (Profile dataset is separate and unrelated to an AEP Real-Time Customer Profile).In your example, the first table containing data from profile dataset seems to be be returning multiple  values for "subscription state" attribute which doesn't seem correct. I'd expect this table to return one row per Person ID with "subscription state" column showing the most recent value recorded in Profile Dataset for that Person ID.I believe what you expect is correct and there seems to either incorrect implementation, some timing issue in data ingestion to CJA or some other CJA working concept that is causing it.If you go through below links these also suggest that profile lookups should return only the most recent value for a given attributes,A Guide to Understanding Adobe Customer Journey Analytics Lookup DatasetsHow to Leverage Event, Lookup, and Profile Datasets in Adobe Customer Journey AnalyticsProfile dataset from AEP into CJAbrian_au or bryan_skelton might be able to help you with this.Cheers!

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded