Issue in merging two event datasets in CJA

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)

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

Dimension - Campaign Id (Campaign Performance)

Breakdown - Customer Name (Customer Profile data)

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.

Thanks,

Sneha