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

Add reporting dimension for Hour of Day

Avatar

Avatar
Shape 1
Level 4
eeidbgsu
Level 4

Likes

79 likes

Total Posts

17 posts

Correct Reply

0 solutions
Top badges earned
Shape 1
Shape 10
Boost 50
Boost 5
Boost 3
View profile

Avatar
Shape 1
Level 4
eeidbgsu
Level 4

Likes

79 likes

Total Posts

17 posts

Correct Reply

0 solutions
Top badges earned
Shape 1
Shape 10
Boost 50
Boost 5
Boost 3
View profile
eeidbgsu
Level 4

20-11-2019

Our institution would like to find out what times of day that messages from certain campaigns are most frequently opened.  Are users mostly opening them in the morning, early afternoon, late afternoon, etc.?

When building a report, there are Time dimensions for Day, Hour, Minute, Month, and Quarter.  However, the Hour dimension is for the hour of a specific day (e.g. Nov 1, 2019 9:00 AM), not an hour of a general day (e.g. 9:00 AM - 9:59 AM).

We would like a new dimension for Hour of Day that would enable us to get counts of events by hour regardless of the day and across multiple campaigns.  This will enable us to better understand our recipients' reading and usage habits and time the sending of our campaign messages accordingly.  For instance, if most of our recipients read in the morning, then we would likely shift the sending time to the morning.