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
Solved! Go to 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
Thanks
Avinash
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?
Hi @Jason_Egan ,
There are common person Ids across the datasets.
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
ECID is available only in one dataset and not in other two datasets.
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
@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.
Views
Replies
Total Likes
Views
Likes
Replies
Views
Likes
Replies