When you export the Office Hours Dashboard data as a CSV file, you'll see a variety of labels that provide information about your office hours and users.
Below, we'll break down each label and explain what it represents.
Definitions:
ID
The unique office hour system ID number, not associated with employee ID
Created Date
The date and time when the office hour entry was initially created. It helps track when each record was created in the system, which occurs upon the first publication
Created By
The email address of the person who created the office hour
Location
The geo-physical location of the office hour
Timezone
The time zone set for the office hour
Start Time (local)
The start time of the office hour expressed in the office hour's local time zone
Start Time (UTC)
The UTC-based time the office hour is scheduled to begin
End Time (UTC)
The UTC-based time the office hour is scheduled to conclude
Duration
The length of time the office hour is scheduled to span
Is In Person
Whether the office hour has an in-person option — Yes or No
Is Online
Whether the office hour has an online option — Yes or No
Office Hour Series
The name of the office hour series that this office hour belongs to
Attendance Limit
The attendance limit set for the office hour
Host ID
The platform profile ID of the person hosting the office hour
Host Name
The full name of the person hosting the office hour
Host Email
The email address of the person hosting the office hour
Host Employee ID
The employee ID of the person hosting the office hour
Host Title
The job title of the person hosting the office hour
Host Department
The department of the person hosting the office hour
Host Location
The geo-physical location of the person hosting the office hour
Host Hire Date
The hire date of the person hosting the office hour
Host Manager
The name of the manager of the person hosting the office hour
Attendees
A complete list of user names attending the office hour