Highlighted

total visits larger than sum of line items

Chris_s_t

16-08-2017

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.

Replies

Highlighted

Saurabh_Kumar1

17-08-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.

Highlighted

Chris_s_t

17-08-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?

Highlighted

Saurabh_Kumar1

17-08-2017

Correct, the Total in prop report for Visits metric represent total number of visits to the site.

You may test this against any prop report and you'll get the same Total Visits count.

Saurabh.

Highlighted

Chris_s_t

17-08-2017

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.

Thank you

Highlighted

Gigazelle

Employee

17-08-2017

Do you have an example or screenshot of how your workspace project is laid out? We might be able to provide some more detailed insight there.

Highlighted

Chris_s_t

17-08-2017

here's a screenshot of my report. When adding up the line items, the result is less than Adobe's Total. I do not have any "unspecified" line items.

1281078_pastedImage_0.png

thank you.

Highlighted

Saurabh_Kumar1

18-08-2017

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.

Thanks,

Saurabh.

Highlighted

pankajb58197403

19-08-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.

Highlighted

Chris_s_t

21-08-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