Sum of Visits | Community
Skip to main content
K
kheepark
Level 2
October 16, 2015
Solved

Sum of Visits

  • October 16, 2015
  • 2 replies
  • 1154 views

I want to show total visits of several categories in my site with Report Builder in excel.

and they are distinguished with prop.

I can see total visits without overlapped values in site catalyst in web service.

But I can't see right values by Report Builder because it doesn't provide total visits of particular props.

Can I draw a right data without using segmentation?

I don't think I can use segmentation because there are many sites that I should see in and I pick the particular props with filtering rule.

 Please find me a solution.

Thank you!

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

    I've done a bit of testing in the report builder Excel add-in, and have found that under step 2 of the request wizard, clicking 'modify' next to a metric allows you to obtain a subtotal of it. This is exactly the same as summing all the line items in the request together. This would work fantastic for page views or other metrics that aren't persistent. 

    If you're looking for deduplicated total visits of anyone who touched a specific prop or eVar, the best method here is going to be segmentation. 

    2 replies

    Gigazelle
    Adobe Employee
    GigazelleAdobe EmployeeAccepted solution
    Adobe Employee
    October 16, 2015

    I've done a bit of testing in the report builder Excel add-in, and have found that under step 2 of the request wizard, clicking 'modify' next to a metric allows you to obtain a subtotal of it. This is exactly the same as summing all the line items in the request together. This would work fantastic for page views or other metrics that aren't persistent. 

    If you're looking for deduplicated total visits of anyone who touched a specific prop or eVar, the best method here is going to be segmentation. 

      B
      bnieco
      October 16, 2015

      Did you ever get an answer that relates to Report Builder (rather than Excel Client)? The problem persists for me in Report Builder. In Site Catalyst, a report with the visits metric shows a de-duplicated total. This shows total visits to the group of pages on the report as opposed to the total of the line items. Report Builder, however, offers no such option that I can find.

      Terms & ConditionsAccessibility statement

      Loading footer...