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 

[aa_from_savoy · Accepted solution]

Hi @Sneha-Parmar ,

have tried to play with the persistence? 

Try to set the persistence of Lead ID [Analytics] to Session or maybe 1 week (just for testing). Probably you don't see anything because there are no rows with both Lead ID and Campaign ID.