Sum of Breakdown Rows in Adobe | Community
Skip to main content
A
Ashar5151
New Participant
December 13, 2023
Solved

Sum of Breakdown Rows in Adobe

  • December 13, 2023
  • 2 replies
  • 620 views

Hi, I'm looking for a way to add the breakdown rows in a freeform table.

 

For Context: I have created a segment which gives me the total visits on the landing of a screen and on the same screen another variable is configured which captures the keyword. I want the unique combination of the visit and the keyword.

Example: If there are total 3 visits (V1, V2 and V3) and K1, K2 and K3 are 3 different keyword captured in the other variable (v9)

V1 - K1 & K2

V2 - K1

V3 - K3 & K1 & K1

 

Count of Visits in which a Keyword was captured:

K1 - 3

K2 - 1

K3 - 1

Total - 5 (I'm trying to get this total from the segment)

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 Josh__Stephens

Hi @ashar5151  - not sure if Jennifer's answer below helped. 

 

Within Workspace, you can also select a subset of the breakout values.  This removes the de-duplication of visits. 

 

In this demo data example, the left table is standard, visits by page. On the right, I duplicated the original table and selected just the top 5.  I right clicked and selected Display Only Selected Rows.  This removes the deduplication and the total value shown is the sum of the top 5 rows. 

 

2 replies

Josh__Stephens
Josh__StephensAccepted solution
New Participant
December 21, 2023

Hi @ashar5151  - not sure if Jennifer's answer below helped. 

 

Within Workspace, you can also select a subset of the breakout values.  This removes the de-duplication of visits. 

 

In this demo data example, the left table is standard, visits by page. On the right, I duplicated the original table and selected just the top 5.  I right clicked and selected Display Only Selected Rows.  This removes the deduplication and the total value shown is the sum of the top 5 rows. 

 

Jennifer_Dungan
Jennifer_Dungan
New Participant
December 13, 2023

I am just going to re-iterate your scenarios to make sure I understand them, I am a little confused as to what the "keywords" are? Are they your internal search keywords? Or does every page have a keyword/tag associated to it?

 

Visit 1

  • Page A
  • Page B - Keyword "K1"
  • Page C - Keyword "K2"

 

Visit 2

  • Page B - Keyword "K1"
  • Page E

 

Visit 3

  • Page D - Keyword "K3"
  • Page E
  • Page B - Keyword "K1"
  • Page B - Keyword "K1"

 

Or are all the keywords on the "Landing Screen", where you can have multiple keywords on the page, and multiple of the same keyword on the page?

 

If the Keywords are like above, the values, "K1", "K2" and "K3" are captured into an eVar, then you shouldn't need segments at all...

 

Just use your eVar as the breakdown and Visits as the metric.

 

  Page Views Visits
Keywords 6 3
K1 4 3
K2 1 1
K3 1 1

^ assuming your eVar is set to "Hit" expiry

 

If your eVar is set to Visit (last touch) expiry then you will get:

 

  Page Views Instance of eVarX Visits
Keywords 8 6 3
K1 5 4 3
K2 1 1 1
K3 2 1 1

(because Page E in the examples above aren't setting a value, therefore the Visit expiry of the eVar will maintain itself onto those pages)

 

However, in both cases, pairing Visits with your eVar will yield the same result, any Visit with K1 (no matter how many times K1 is set) will still return "1 Visit".

Terms & ConditionsAccessibility statement

Loading footer...