understanding the difference between total numbers and row numbers | Community
Skip to main content
New Participant
August 10, 2023
Solved

understanding the difference between total numbers and row numbers

  • August 10, 2023
  • 1 reply
  • 1777 views

hello

I made a segment that looks for visits that go to the buy page ->(then) checkout page ->(then) evar(button click).

 

For a table I put the segment I made with visit metric and put evar in rows.

The total number was 35.

There were different values of evar from different pages. Then when I looked at the evar value that I put for my segment, it was only 18. I know that total is the result of de-duplicated values and values from seg contain duplicates.

 

What I don’t understand is that I understood 35 is the number of visits that exactly followed the sequence that I made for seg. So when I looked at evar as dimension, I thought the evar with the value I put in the seg also should be 35 or more if there are duplicates.

So I tried to check the number by putting the visitor id for dimension with the metric in the same condition. Then I tried to break it down with the visit number, then with the evar. There were cases where the visit number contained the evar I set for the seg. But there were also cases that didn’t have the certain value of evar I put in the segment but still counted as the case.

I assume the value from each row is the number of visits that contributed to Evar which is from the sequence I made.

since I made a seg with the sequence that contained a certain evar at the end, why is the evar I put in the seg only 18 when I put it in rows compared to the total 35.

 

 

 

 

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 Jennifer_Dungan

 

Visits

 

Buy Page Visit > Check out page > evar 1

 

Site Code: somewhere (eVar)

evar 1 total

35

Unspecified

24

evar 1 = login blah blah

18

evar 1 = extra 1

15

evar 1 = extra 2

13

evar 1 = extra 3

11

 

maybe this might help to understand what I meant.

evar 1 is about collecting interactions that happen in account-related pages

for Buy Page Visit > Check out page > Evar 1

it is a segment with a visit bucket and I specified evar 1 as login blah blah (evar 1 equals login blah blah) so it only collects the call I want.

when I look at the numbers of different values of evar 1 evar 1 = login is only 18 and the total says the # of visits that included my seg sequence is 35. what about the other 17? how should I understand this? I am guessing that I am not following the concept of visits that are used in seg and the number of values that are from breaking down evar 1.


Ok, 

 

So your Segment is something like this:

 

 

Visit level, Specific Page, then Specific Page, then eVar1 exists (Not looking for a specific value)?

 

And now you see a distribution of eVar1 like "login", "extra 1", "extra 2", etc? 

 

So first off, when you are looking at a Visit level segment, every hit in that segment will appear, just so long as the sequence was met during the visit.

 

Now, if you didn't specify the value of the eVar to be "login", then anyone who completed the first 2 pages, then hit any eVar1 would be included... 

 

And when you show the data the way you have above, you noticed that if you add 24 + 18 + 15 + 13 + 11, etc, it's much more than 35....

 

This is because some of those other eVars will be in the same visit as "extra 1" or "extra 2"...  it will be hard to identify those in isolation of your "login" with just that segment...  you would have to have a separate segment that excludes the path to login to see what is happening in the 17 other visits...

 

I hope that makes sense.. Visits is hard to explain sometimes.

1 reply

Jennifer_Dungan
New Participant
August 10, 2023

What date range is your report?

 

The segment preview looks at "Last 90 Days"... whereas your panel / project may be limited to "This Month" or "Last Month" resulting in a smaller number due to the reduced time scope?

Jennifer_Dungan
New Participant
August 10, 2023

Or do you mean the total at the top is showing 35, but you only have numbers that add up to 18 in the rows?

 

If you could share some visuals of what you are seeing (you can obscure sensitive areas, or send it as a private message if you feel more comfortable with that.).. I think that would help us to understand your issue better.

kr8tiveAuthor
New Participant
August 11, 2023

 

Visits

 

Buy Page Visit > Check out page > evar 1

 

Site Code: somewhere (eVar)

evar 1 total

35

Unspecified

24

evar 1 = login blah blah

18

evar 1 = extra 1

15

evar 1 = extra 2

13

evar 1 = extra 3

11

 

maybe this might help to understand what I meant.

evar 1 is about collecting interactions that happen in account-related pages

for Buy Page Visit > Check out page > Evar 1

it is a segment with a visit bucket and I specified evar 1 as login blah blah (evar 1 equals login blah blah) so it only collects the call I want.

when I look at the numbers of different values of evar 1 evar 1 = login is only 18 and the total says the # of visits that included my seg sequence is 35. what about the other 17? how should I understand this? I am guessing that I am not following the concept of visits that are used in seg and the number of values that are from breaking down evar 1.