hourly | Community
Skip to main content
alnavarg
Level 4
April 14, 2023
Declined

hourly

  • April 14, 2023
  • 2 replies
  • 1462 views

Our organization aims to determine the most common times of day when users open messages from specific campaigns. We want to know whether they tend to open them in the morning, early afternoon, late afternoon, or other times.

When creating a report, we have Time dimensions available for Day, Hour, Minute, Month, and Quarter. However, the Hour dimension currently only specifies the hour of a particular day (such as 9:00 AM on April 1, 2023), not the hour of a general day (such as 8:00 AM - 8:59 AM)

2 replies

Adobe Employee
April 16, 2023

In reporting indeed at the moment you can't have it created that way.

If you want to have those details:

* create a workflow and determine it in the workflow

* export the data to CSV and aggregate it in Excel or so

Sukrity_Wadhwa
Community Manager
Community Manager
January 9, 2024

As recommended by @bisswang, I would encourage you follow that approach. Thanks! 

Sukrity Wadhwa