Issue in merging two event datasets in CJA

[Sneha-Parmar]

Hi All,

I am facing an issue while merging data from different dataset in CJA. I have used three datasets in my CJA connection with details as below –

1. Adobe Analytics dataset – Event data.

primary id – ECID, secondary Id – Lead Id

person key in CJA connection - Lead Id

1. Campaign performance data – Event data

primary id – Record Id, secondary Id – Lead Id,

person key in CJA connection - Lead Id

1. Customer data – Profile data

primary id – Customer ID, secondary Id – Lead Id

person key in CJA connection - Lead Id

Now when I get data in CJA workspace dashboard, I can see data from three dataset and can breakdown data between event data by profile data [ Adobe Analytics data by Customer data & Campaign data by Customer data] but when I choose to breakdown Adobe Analytics data by Customer data & Campaign data

Example –

1. Analytics event data breakdown by Customer profile data – WORKING

Dimension - Lead Id (Analytics)

Breakdown - Customer Name (Customer Profile data)

	People
Lead ID [Analytics]	1101
L1ff-341d-tr22-0456	1
Customer Name [Profile]	1
TestUser1	1
L5dr-414g-kj52-0576	1
Customer Name [Profile]	1
TestUser5	1

1. Campaign performance event data breakdown by Customer profile data – WORKING

Dimension - Campaign Id (Campaign Performance)

Breakdown - Customer Name (Customer Profile data)

	People
Campaign ID [Campaign Performance]	150
C1345-Summer	2
Customer Name [Profile]	2
TestUser1	1
TestUser10	1
C1345-Welcome	1
Customer Name [Profile]	1
TestUser5	1

1. Campaign performance event data breakdown by Analytics event data – NOT WORKING

Dimension - Campaign Id (Campaign Performance)

Breakdown - Lead Id (Analytics)

It gives ‘No Value’ when broken down.

	People
Campaign ID [Campaign Performance]	150
C1345-Summer	2
Lead ID [Analytics]	2
No Value	2
C1345-Welcome	1
Lead ID [Analytics]	1
No Value	1

Thanks,

Sneha

[Jason_Egan]

Looking over the documentation, it seems that the ability for this to work is tied to the consistent Person ID. It looks like you have the same field for person ID in both of your event data sets. Is there anyway that a person has a different value in the different event data sets maybe?

[Sneha-Parmar]

Hi @Jason_Egan ,

There are common person Ids across the datasets.

[PavanBabuGandla_Analytics]

I have the similar implemntation, here the data stiching is happening across teh device id and marketing id ,please reru nthe analysis with person id-> ECID  then it will reslove.

feel free t oconnect over linkedin www.linkedin.com/in/pavan89 

[Sneha-Parmar]

ECID is available only in one dataset and not in other two datasets.

[an1989 · Accepted solution]

This might be because your analytics dataset might not have the lead id value on all the event records, some might be anonymous, stitched ID might help you here. 

https://experienceleague.adobe.com/docs/analytics-platform/using/stitching/overview.html

https://experienceleague.adobe.com/docs/customer-journey-analytics-learn/tutorials/visitor-id/unders...

Thanks

Avinash 

[NimashaJain]

@Sneha-Parmar Did you find the suggested solutions helpful? It would be great if you can  mark the answer as correct for posterity. If you have found out solution yourself, share it with wider audience in the community.