Visits metric Data warehouse | Community
Skip to main content
P
prerna
Level 2
June 28, 2021
Solved

Visits metric Data warehouse

  • June 28, 2021
  • 2 replies
  • 2965 views

I noticed a difference between numbers returned by visits metric in Analytic workspace and visits metric numbers from Data warehouse report (on hourly granularity)

 

From my understanding, it could be because of the following case-

 

If a user visits my website and their visit lasts for 2 hours, then in hourly granularity, visit would be attributed to both Hour1 and Hour2

 

Can anybody help me validate my assumption? Are there any other possible cases where numbers would show a difference?

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 Hemangini

Hi @prerna ,
Adobe recommends using ‘Visits - All Visitors’ in Data Warehouse requests where visits are desired as a metric. Try this and see if there is still any difference in numbers.

2 replies

H
Adobe Employee
HemanginiAdobe EmployeeAccepted solution
Adobe Employee
June 28, 2021

Hi @prerna ,
Adobe recommends using ‘Visits - All Visitors’ in Data Warehouse requests where visits are desired as a metric. Try this and see if there is still any difference in numbers.

    H
    Adobe Employee
    HemanginiAdobe Employee
    Adobe Employee
    June 28, 2021

    @prerna ,

    Same as sitecatalyst is an internal setting not exposed in Analytics UI so you need to get this verified by Client Care. Now, could you share a screenshot of the reports that you are comparing?

    A
    amgup
    Level 7
    June 28, 2021

    @prerna  You can also check the below document as per the solution told by @hemangini 
    https://experienceleague.adobe.com/docs/analytics/components/metrics/visits.html?lang=en

      Terms & ConditionsAccessibility statement

      Loading footer...