Expand my Community achievements bar.

SOLVED

Issue in merging two event datasets in CJA

Avatar

Community Advisor

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

1 Accepted Solution

Avatar

Correct answer by
Level 2

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

https://experienceleague.adobe.com/docs/customer-journey-analytics-learn/tutorials/visitor-id/unders...

 

Thanks

Avinash 

View solution in original post

6 Replies

Avatar

Adobe Champion

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?

Avatar

Level 2

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 

 

 

Avatar

Community Advisor

ECID is available only in one dataset and not in other two datasets.

Avatar

Correct answer by
Level 2

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

https://experienceleague.adobe.com/docs/customer-journey-analytics-learn/tutorials/visitor-id/unders...

 

Thanks

Avinash 

Avatar

Administrator

@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.