Bookings Analytics

Written By Sam Walton (Super Administrator)

Updated at May 17th, 2023

Table of Contents

Applies to Version 1.10 or higher

The IBSS platform stores useful data about space bookings.

Per Booking Record

The following information is recorded per individual booking

Field Name
Description
Booking_Start
The start time of the booking stored in UTC.
Booking_End
The end time of the booking stored in UTC.
Booking_Party_Count
The number of participants. 
Booking_All_Day
0: Not an all day booking.
1: An all day booking.
Booking_Status
The state of the booking. See below.
Meta_Auto_Cancel_Thld_Min
The auto cancel time in minutes for this booking.
Booking_IsCheckedIn
0: Not checked in.
1: Checked In.
Booking_IsActive
0: Not yet started or completed.
1: In progress.
Booking_IsCancelled
0: Not cancelled.
1: Cancelled.
Booking_IsCompleted
0: Not completed.
1: Completed.
Booking_Parties
An array of JSON in the following format
[
 {
"IsVisitor":,
"Email":"",
"First_Name":"",
"Last_Name":"",
"Company":"",
"Visit_Id":""
}
]
Booking_Share_Loc
0: No
1: Yes
Booking_AutoCheckIn
0: No
1: Yes
Booking_IsEarly_CheckIn
0: No
1: Yes
Booking_IsLate_CheckIn
0: No
1: Yes
Booking_Checkin_Time
The time the booking was checked in stored in UTC.
Booking_Completed_Time
The time the booking was checked out stored in UTC.
Booking_Cancelled_Time
The time the booking was cancelled stored in UTC.
Booking_Actual Duration
The duration in seconds of the booking from check in to check out. 
Booking_Scheduled_Duration
The scheduled duration of the booking from Booking_Start to Booking_End.

Booking_Status

Bookings can exist in a number of states as explained below.

Name
Description
New
Booking has been created.
Amended
Booking has been edited in some way. 
Early CheckIn
Booking has been checked in early (before start time).
Late CheckIn
Booking has started but not yet checked in.
In Progress
Booking started and checked in.
Cancelled
Booking cancelled.
Auto Cancelled
Booking cancelled by system after auto cancel period expired.
No Show
Booking close by system after booking end with no check in.
Completed
Booking checked out.