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 –
- Adobe Analytics dataset – Event data.
primary id – ECID, secondary Id – Lead Id
person key in CJA connection - Lead Id
- Campaign performance data – Event data
primary id – Record Id, secondary Id – Lead Id,
person key in CJA connection - Lead Id
- 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 –
- 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 |
- 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 |
- 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