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 –
primary id – ECID, secondary Id – Lead Id
person key in CJA connection - Lead Id
primary id – Record Id, secondary Id – Lead Id,
person key in CJA connection - Lead Id
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 –
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 |
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 |
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
Views
Replies
Total Likes
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?
Views
Replies
Total Likes
Hi @Jason_Egan ,
There are common person Ids across the datasets.
Views
Replies
Total Likes
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
Views
Replies
Total Likes
ECID is available only in one dataset and not in other two datasets.
Views
Replies
Total Likes
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
Thanks
Avinash
Views
Replies
Total Likes