total visits larger than sum of line items | Community
Skip to main content
C
Chris_s_t
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

    S
    Saurabh_Kumar1
    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.

      C
      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?

      Gigazelle
      Adobe Employee
      GigazelleAdobe Employee
      Adobe Employee
      August 17, 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


      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.

      P
      pankajbagga_sme
      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.

        C
        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
        Urs_BollerCommunity 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...

        Terms & ConditionsAccessibility statement

        Loading footer...