Expand my Community achievements bar.

Your voice matters! Help shape the future of Adobe Journey Optimizer by sharing your feedback.
SOLVED

Incorrect Unique Journey Entries sum count

Avatar

Level 1

Hi, 

 

I am trying to create a Adobe CJA report for the journeys matching a condition. Under the Unique Journey Entries metrics, I see the total count as being incorrect {Total displayed :15/15 | actual sum : 24}. Need help 

AGoodDoc_2-1739787919027.png

 

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

1 Accepted Solution

Avatar

Correct answer by
Level 9

Hi @AGoodDoc ,

CJA shows deduplicated metric value as the column total, what this means is that if there were multiple values seen in the same journey of the dimension/field that you are using against a metric then on rows level you'll see that metric attributed against each of those values but in total it will be deduplicated and counted only once.

Let's take an example, if user visited a site and viewed home page and product page during the same session, the report run for pages with session metric will give 1 session credit to each home page and product page, which if you add will result as 2 but the total number of sessions is actually 1 only and that is what will show as column total, like below

Harveer_SinghGi1_0-1739808057156.png

I hope this helps.

Cheers!

View solution in original post

4 Replies

Avatar

Correct answer by
Level 9

Hi @AGoodDoc ,

CJA shows deduplicated metric value as the column total, what this means is that if there were multiple values seen in the same journey of the dimension/field that you are using against a metric then on rows level you'll see that metric attributed against each of those values but in total it will be deduplicated and counted only once.

Let's take an example, if user visited a site and viewed home page and product page during the same session, the report run for pages with session metric will give 1 session credit to each home page and product page, which if you add will result as 2 but the total number of sessions is actually 1 only and that is what will show as column total, like below

Harveer_SinghGi1_0-1739808057156.png

I hope this helps.

Cheers!

Avatar

Level 1

Hi @Harveer_SinghGi1 ,

 

Thanks! that makes sense. 

 

Is there a way by which I can reflect/calculate the actual sum while retaining the individual count for each row

 

Avatar

Level 9

Hi @AshishKu21 ,

If by actual sum you mean returning 24 instead of 15 in the example shared in question then you can use column sum function in a calculated metric to return this information,

Harveer_SinghGi1_0-1739867834719.png

Please note that this metric will show column sum for each row when trended on a ranked report.

Cheers!

 

Avatar

Level 1

Thanks @Harveer_SinghGi1