Incorrect Unique Journey Entries sum count | Community
Skip to main content
A
AGoodDoc
Level 2
February 17, 2025
Solved

Incorrect Unique Journey Entries sum count

  • February 17, 2025
  • 1 reply
  • 658 views

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 

 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Harveer_SinghGi1

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

I hope this helps.

Cheers!

1 reply

Harveer_SinghGi1
Community Advisor
Harveer_SinghGi1Community AdvisorAccepted solution
Community Advisor
February 17, 2025

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

I hope this helps.

Cheers!

    A
    AGoodDocAuthor
    Level 2
    February 17, 2025

    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

     

    Harveer_SinghGi1
    Community Advisor
    Harveer_SinghGi1Community Advisor
    Community Advisor
    February 18, 2025

    Hi @agooddoc ,

    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,

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

    Cheers!

     

      Terms & ConditionsAccessibility statement

      Loading footer...