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
  • 12295 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?

      C
      Chris_s_tAuthor
      Level 2
      August 22, 2017

      A couple additional things to try:

      - sort the report by visits. It looks like you're sorting the report by another metric.

      - segment only hits where the prop in question exists. This will exclude every other hit where the prop isn't present, but if the total visit count is all you're after, this will give you that data.


      thank you for the suggestions, both have been applied and the same issue persists. I am thinking it may have something to do with the way Adobe is processing the data. in terms of reporting, my client is expecting to see both the grand total and the single rows. inevitably, the question now is "why isn't the sum of line items equal to the grand total?"

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