[Index]

Model: data/MeetingRoomUtilization

Unified hourly meeting room utilization, quality, and remote presence across platforms.

Model Details: data/MeetingRoomUtilization

Title Description Details
Timestamp Interval * Hour bucket start (UTC).
  • Field Name: timestamp_interval
  • Type: String
  • MaxLength: 1024
  • Format: date-time
Timestamp Epoch Unix time for the hour bucket (UTC).
  • Field Name: timestamp_epoch
  • Type: Integer
Arbitrator IP Vendor media/arbitrator IP when available.
  • Field Name: arbitrator_ip
  • Type: String
  • MaxLength: 1024
Year Calendar year (UTC) of bucket.
  • Field Name: year
  • Type: Integer
Month Calendar month (UTC) of bucket.
  • Field Name: month
  • Type: Integer
Day Day of month (UTC) of bucket.
  • Field Name: day
  • Type: Integer
Hour Hour of day (0–23, UTC) of bucket.
  • Field Name: hour
  • Type: Integer
  • Maximum: 23
Vendor Platform family (e.g., microsoft, cisco).
  • Field Name: vendor
  • Type: String
  • MaxLength: 1024
Source Platform Session type (e.g., teams_meeting, webex_meeting, webex_call).
  • Field Name: source_platform
  • Type: String
  • MaxLength: 1024
Room Name Human name of the room/workspace.
  • Field Name: room_name
  • Type: String
  • MaxLength: 1024
Room Email Room mailbox address used for mapping.
  • Field Name: room_email
  • Type: String
  • MaxLength: 1024
Unified Room ID Internal canonical room ID.
  • Field Name: unified_room_id
  • Type: String
  • MaxLength: 1024
Site Site/campus identifier.
  • Field Name: site
  • Type: String
  • MaxLength: 1024
Building Building identifier.
  • Field Name: building
  • Type: String
  • MaxLength: 1024
Capacity Seating capacity.
  • Field Name: capacity
  • Type: Integer
Size Category Key Stable size band key (e.g., small, medium, large).
  • Field Name: size_category_key
  • Type: String
  • MaxLength: 1024
Size Category Title Display label for size band.
  • Field Name: size_category_title
  • Type: String
  • MaxLength: 1024
Total Calls Distinct sessions overlapping the hour.
  • Field Name: total_calls
  • Type: Integer
Total Participants Sum of per-session participant counts in the hour.
  • Field Name: total_participants
  • Type: Integer
Total Duration (s) Sum of per-session overlap seconds in the hour.
  • Field Name: total_duration_seconds
  • Type: Integer
Audio Calls Sessions using audio.
  • Field Name: audio_calls
  • Type: Integer
Video Calls Sessions using video.
  • Field Name: video_calls
  • Type: Integer
Sharing Calls Sessions with content sharing.
  • Field Name: vbss_calls
  • Type: Integer
Audio Poor Calls Audio sessions flagged poor.
  • Field Name: audio_poor_calls
  • Type: Integer
Audio Good Calls Audio sessions not flagged poor.
  • Field Name: audio_good_calls
  • Type: Integer
Video Poor Calls Video sessions flagged poor.
  • Field Name: video_poor_calls
  • Type: Integer
Video Good Calls Video sessions not flagged poor.
  • Field Name: video_good_calls
  • Type: Integer
Sharing Poor Calls Sharing sessions flagged poor.
  • Field Name: vbss_poor_calls
  • Type: Integer
Sharing Good Calls Sharing sessions not flagged poor.
  • Field Name: vbss_good_calls
  • Type: Integer
Is Room Meeting True if any session maps to a unified_room_id.
  • Field Name: is_room_meeting
  • Type: Boolean
Is Non-room Meeting True if any session lacks a room mapping.
  • Field Name: is_non_room_meeting
  • Type: Boolean
Audio Poor Rate audio_poor_calls / NULLIF(audio_calls, 0).
  • Field Name: audio_poor_rate
  • Type: Number
Video Poor Rate video_poor_calls / NULLIF(video_calls, 0).
  • Field Name: video_poor_rate
  • Type: Number
Sharing Poor Rate vbss_poor_calls / NULLIF(vbss_calls, 0).
  • Field Name: vbss_poor_rate
  • Type: Number
Quality Score 100 - 100 * (poor_sessions / total_sessions).
  • Field Name: quality_score
  • Type: Number
  • Maximum: 100
Avg Participants per Call total_participants / NULLIF(total_calls, 0).
  • Field Name: avg_participants_per_call
  • Type: Number
Avg Duration (s) per Call total_duration_seconds / NULLIF(total_calls, 0).
  • Field Name: avg_duration_seconds_per_call
  • Type: Number
Local Date (Day) Site local calendar day.
  • Field Name: date_day
  • Type: String
  • MaxLength: 1024
  • Format: date
Local Week Start Local week bucket (date_trunc('week', local)).
  • Field Name: date_week
  • Type: String
  • MaxLength: 1024
  • Format: date-time
Local Month Start Local month bucket (date_trunc('month', local)).
  • Field Name: date_month
  • Type: String
  • MaxLength: 1024
  • Format: date-time
Day of Week Local day-of-week (0=Sun..6=Sat).
  • Field Name: day_of_week
  • Type: Integer
  • Maximum: 6
Is Business Hours True if bucket falls inside configured business hours.
  • Field Name: is_business_hours
  • Type: Boolean
Hours Utilized total_duration_seconds / 3600.0.
  • Field Name: hours_utilized
  • Type: Number
Remote Participants Sum of non-room participants in the hour.
  • Field Name: remote_participants
  • Type: Integer
Has Remote Any True if any session had remote participants.
  • Field Name: has_remote_any
  • Type: Boolean
Computed At When this row was (re)computed.
  • Field Name: computed_at
  • Type: String
  • MaxLength: 1024
  • Format: date-time
Last Collected Timestamp Timestamp when data was last collected.
  • Field Name: last_collected_timestamp
  • Type: String
  • MaxLength: 1024
  • Format: date-time
Last Collected Epoch Unix time when data was last collected.
  • Field Name: last_collected_epoch
  • Type: Integer
Total Duration (minutes) Total duration in minutes.
  • Field Name: total_duration_minutes
  • Type: Number
Total Duration (hours) Total duration in hours.
  • Field Name: total_duration_hours
  • Type: Number
Avg Duration (minutes) per Call Average duration in minutes per call.
  • Field Name: avg_duration_minutes_per_call
  • Type: Number
Avg Duration (hours) per Call Average duration in hours per call.
  • Field Name: avg_duration_hours_per_call
  • Type: Number
Day of Week Name Local day-of-week name (e.g., Sunday, Monday).
  • Field Name: day_of_week_name
  • Type: String
  • MaxLength: 1024
Has Business Hours Config Indicates if business hours configuration exists.
  • Field Name: has_business_hours_config
  • Type: String
  • MaxLength: 1024
Is Business Holiday Indicates if this is a business holiday.
  • Field Name: is_business_holiday
  • Type: String
  • MaxLength: 1024
Holiday Name Name of the holiday if applicable.
  • Field Name: holiday_name
  • Type: String
  • MaxLength: 1024
Meeting Was Booked Number of distinct bookings for the room in the hour.
  • Field Name: meeting_was_booked
  • Type: Integer
Meeting Was Not Booked Number of times the meeting was used without a booking in the hour.
  • Field Name: meeting_was_not_booked
  • Type: Integer
People Count Average number of people using the room in the hour.
  • Field Name: people_count
  • Type: Number
Reported Capacity Room capacity (should match spark/place for validation).
  • Field Name: reported_capacity
  • Type: Integer
Room Occupancy Percentage Percentage of room capacity utilized.
  • Field Name: room_occupancy_percentage
  • Type: Number
Time Used Number of minutes the room was used in the hour.
  • Field Name: time_used
  • Type: Integer
Time Booked Number of minutes the room was booked in the hour.
  • Field Name: time_booked
  • Type: Integer
Booked With People In Room Number of times the room was booked and had people in the room in the hour.
  • Field Name: booked_with_people_in_room
  • Type: Integer
Booked No Show Number of times the room was booked but had no call in the hour.
  • Field Name: booked_no_show
  • Type: Integer
Not Booked With People In Room Number of times the room was not booked but people were in the room.
  • Field Name: not_booked_with_people_in_room
  • Type: Integer
Device Joined Meeting True if the room device joined the call.
  • Field Name: device_joined_meeting
  • Type: Integer
Meeting Usage Percentage Percentage of time the room was used for meetings.
  • Field Name: meeting_usage_percentage
  • Type: Number
Meeting Usage Category Title Display label for the meeting usage category band.
  • Field Name: meeting_usage_category_title
  • Type: String
  • MaxLength: 1024