Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

Visits metric Data warehouse

Avatar

Avatar
Boost 1
Level 1
prerna
Level 1

Likes

2 likes

Total Posts

22 posts

Correct Reply

0 solutions
Top badges earned
Boost 1
Validate 1
View profile

Avatar
Boost 1
Level 1
prerna
Level 1

Likes

2 likes

Total Posts

22 posts

Correct Reply

0 solutions
Top badges earned
Boost 1
Validate 1
View profile
prerna
Level 1

28-06-2021

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?

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Affirm 5
Level 4
HemanginiS
Level 4

Likes

32 likes

Total Posts

59 posts

Correct Reply

20 solutions
Top badges earned
Affirm 5
Affirm 3
Boost 10
Affirm 1
Establish
View profile

Avatar
Affirm 5
Level 4
HemanginiS
Level 4

Likes

32 likes

Total Posts

59 posts

Correct Reply

20 solutions
Top badges earned
Affirm 5
Affirm 3
Boost 10
Affirm 1
Establish
View profile
HemanginiS
Level 4

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

Answers (1)

Answers (1)

Avatar

Avatar
Affirm 10
Level 3
amgup
Level 3

Likes

23 likes

Total Posts

127 posts

Correct Reply

16 solutions
Top badges earned
Affirm 10
Boost 5
Boost 3
Boost 10
Boost 1
View profile

Avatar
Affirm 10
Level 3
amgup
Level 3

Likes

23 likes

Total Posts

127 posts

Correct Reply

16 solutions
Top badges earned
Affirm 10
Boost 5
Boost 3
Boost 10
Boost 1
View profile
amgup
Level 3

28-06-2021

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