Visits metric Data warehouse | Community
Skip to main content
prerna
Level 2
Jun 28, 2021 8:43 AM UTC
Solved

Visits metric Data warehouse

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.
HemanginiAccepted solution
Employee
Jun 28, 2021 9:04 AM UTC

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.

View reply

7 replies

amgup
Level 7
Jun 28, 2021 10:10 AM UTC

@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

Translate
    HemanginiAccepted solution
    Employee
    Jun 28, 2021 9:04 AM UTC

    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.

    Translate
      prernaAuthor
      Level 2
      Jun 28, 2021 10:14 AM UTC
      @hemangini - Yes, did try that as per the documentation but the numbers are still more than those in workspace. What could be the reason for that?
      Translate
      Terms & ConditionsAccessibility statement

      Loading footer...