Level 1

0% to

Level 2

Tip /

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

View all

## Average visits per hour of day

mdep
Level 1

Likes

0 likes

Total Posts

3 posts

0 solutions
View profile

mdep
Level 1

Likes

0 likes

Total Posts

3 posts

0 solutions
View profile
mdep
Level 1

16-04-2021

Hi, I'm trying to calculate the average number of visits per hour of day over a given time period.
When I create an Average Visits metric like this:

and then use that to breakdown by the Hour of Day dimension, I would expect it to give me the average per hour of day, however, it gives me only one value: the average of the entire selected time period. Like this:

How do i get the average number of visits that I can break down by hour of day?

#### Accepted Solutions (1)

PratheepArunRaj
Moderator

Likes

291 likes

Total Posts

819 posts

250 solutions
View profile

PratheepArunRaj
Moderator

Likes

291 likes

Total Posts

819 posts

250 solutions
View profile
PratheepArunRaj
Moderator

21-04-2021

Dear mdep,

Are you looking for the average hourly visits in a day i.e. Visits in a day / 24? Or average hourly visits for the time period selected i.e. Visits for the time period / No. of hours for the time period? If yes, create a calculated metric based on the below.

Once created, you should see the below numbers.

But, not sure about the metric average number of visits per hour of the day, can you explain more?

Thank You, Pratheep Arun Raj B | Xerago | Terryn Winter Analytics

Hi Pratheep,

Thank you for your response.
Here's what I'm after: I'm trying to find out the most popular hour to visit the site on average. Instead of just summing visits per hour I want to take the average.
Like this:

 Date 1AM 2AM 3AM 4AM 5AM 6AM 7AM 4/1/2021 2 1 2 4 6 10 20 4/2/2021 4 0 0 5 4 11 22 4/3/2021 1 1 3 5 6 12 19 Average 2.3 0.7 1.7 4.7 5.3 11.0 20.3

This is just and example, I'd need this for all hours of day (12AM to 12PM) for a certain date range.

So from this I can see that between 1 to 7AM we have on average most number of visits at 7AM.

Any chance you know how to do this in Adobe Analytics?
Thank you for your help!
Manon

Dear Mdep, Still the same metric. But instead of the dimension 'Day', use the dimension 'Hour Of Day'. Thank You, Pratheep Arun Raj B

Hi PratheepArunRaj, that worked! nice for average number of visits per weekday too!

_Analytics_Guru_
Level 2

Likes

4 likes

Total Posts

14 posts

2 solutions
View profile

_Analytics_Guru_
Level 2

Likes

4 likes

Total Posts

14 posts

2 solutions
View profile
_Analytics_Guru_
Level 2

25-04-2021

Hoping this should solve the problem without creating any additional metrics. Where the Bars are showing the maximum visits in a particular hour from Jan-Feb in this case. Make sure to update the Date range or feel free to use the Rolling date range.

yuhuisg
MVP

Likes

146 likes

Total Posts

476 posts

90 solutions
View profile

yuhuisg
MVP

Likes

146 likes

Total Posts

476 posts