total visits larger than sum of line items | Community
Skip to main content
Level 2
August 16, 2017

total visits larger than sum of line items

  • August 16, 2017
  • 3 replies
  • 12311 views

Hello everyone,

I am running into this issue where I am running an s.prop report using visits as a metric and the total reported is higher than the sum of the line items. I get why the sum of line items can be, and usually is higher than the reported total, but I am seeing the complete opposite. Thoughts?

Much appreciated.

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

3 replies

Level 5
August 17, 2017

Regarding total visits displayed in report, it represents the total no. of visits to your site for the selected time range.

It is higher than sum of line items as there may be visits to your site where the user did not perform an action so as to set prop variable you are referring to in your query. Hence, that visit is not credited to any line item.

Hope this helps.

Regards,

Saurabh Kumar.

Chris_s_tAuthor
Level 2
August 17, 2017

Thank you for your reply. So what you are saying is that although I am running a visits report on prop3 (for example), The total is actually the total number of visits, not the total number of visits where prop3 was set?

Urs_Boller
Community Advisor
Community Advisor
August 21, 2017

You are correct, prop3 shows different numbers as it's being used for other purposes. I need to report on visits to certain pages where prop2 is set. Let's say we're looking at a department store and my prop2 is set to identify the store section: seasonal, gardening, shoes, clothing, etc. I am looking at reporting how many visits I got to each department and then the total for those departments. (not the site total)

thank you


@ Chris_s.t

you can use a segment like this:

"visit" container where "hit"-container has "prop2 exists"

this way you can break down the visits by prop2 and see only visits where in any hit the prop2 is set, the col total is the total to all "prop2" visits ...

Level 2
August 19, 2017

The total Visits will be same throughout the tool, regardless of viewing any report. The individual line items sum total will some how differs for different custom reports based on the instances variables are set in the web site. Below link might be of help:

Compare sum of line items to report total

p.s. Best metric for a prop report would be instances for most of the root cause analysis, while for a few business cases, other traffic metrics also plays an important role.

Chris_s_tAuthor
Level 2
August 21, 2017

thank you for your suggestion, instances will indeed match but instances also count page reloads and the user movement between pages during the same session/visit.

Urs_Boller
Community Advisor
Community Advisor
August 22, 2017

sorry, can't see the problem

1) did you make a Hit- Segment with defnition prop2 exists?

2) you mean that the sum of all the rows is smaller than the total based ln "visits"?

mayve you can post some more screenshots above those two points...