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?
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.
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?
I have to disagree here.
A prop2 visit report will show at the bottom the total visits (sessions) where prop2 was set. The same applies for all the traffic variables reports. Having the total number of visits reported as the total for the propX report doesn't make sense, and yes, I did check across a few traffic variables out of curiosity.
There must be something related to how Adobe processes the visit count, for instance, it makes sense for the sum of rows to be higher than the bottom total as multiple values for a prop can be set within one visit. I have the exact opposite though.
An instances report will show a perfect match between the bottom total and the sum of rows, however that may not be a good indicator of traffic to the pages/sections as an instance is recorded on every page load and page re-loads can happen for a plethora of reasons.
So, for prop2 visit report, you checked, did Total at bottom was different than the value 1,949 shown in your prop3 visits screenshot for that same date range? In your prop2 report, it might be the case you are setting it with some value on each Web page Load in contrast to prop3 where it may have been set for specific pages / action say registration pages only. Just trying to put together my thoughts so as to resolve this question.
Let me know your thoughts.
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:
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.
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)