How to extract data from your bookings calendar

How can you extract data from your Bookings calendar?

Bookings collects data in a 120-day range to enable basic reporting on services provided in a calendar.  History beyond 120 days is not retained; therefore, extract your data on a schedule to maintain a historical reference of Booking events scheduled.

1. Access your Bookings page from your Office 356 app launcher.
2. Click the calendar option from the navigation menu.

3. Click Export to produce an Excel spreadsheet of recently scheduled events.

4. Select the range of dates within 120 days from the date of your report.  

5. Click the Export button to download the file for the range selected.
6. Open Excel then open the downloaded file named "BookingsReportingData". 
   NOTE: This downloaded file is of type TSV.  Use Excel to delimit the fields into a readable format.
   All appointment types in the Bookings calendar within the selected date range will list in the file. 
7. Filter the Excel spreadsheet to view the services being analysed.   It may be necessary to further delimit the field which contains custom questions and answers.