Scaling Bookings for large demand
Published Jan 28 2021 02:26 PM 15.9K Views
Microsoft

Editor's note (2/3/22): Removed a broken link to UserVoice and fixed a link to our Bookings customer stories that was taking people to a third-party site.

Editor's note (1/28/21): Title was updated to make it shorter

 

There is a growing need for virtual meetings, consults, and appointments but also an increase in the amount of time people are dedicating to try to schedule those appointments. Back and forth phone calls, emails, text messages. Bookings can make it easier, so you can spend more time talking to customers rather than trying to schedule them, and it does it in a secure and integrated way with Microsoft 365.

 

Microsoft Bookings helps making scheduling and managing appointments easy and seamless. It does this through a web-based booking tool where people have the flexibility to see and book services when it’s convenient for them, it makes it easier to manage staff’s time by integrating with Outlook’s calendar and keeps everyone updated with timely and automatic email confirmations and reminders to reduce no-shows, all these also helps organizations reduce repetitive scheduling tasks.

 

Bookings is flexible, customizable, secure as it uses a mailbox in Exchange Online, and can be designed to fit scenarios and needs of different parts of an organization.

 

We have worked with various industries to enable different scenarios. Tele-Health by virtual consultations with doctors through Microsoft Teams, educational classrooms, financial consulting, organizations internal services like legal/IT/HR provided to their employees,  candidate interviews, assisted shopping in retail, and government services. To read more on how customers are using Bookings for these scenarios, please click here.

 

These scenarios demand high scale, to help make sure Bookings works well for you and scale to your needs, we have prepared these best practices.

 

1. Planning for scale

Each Bookings calendar is currently designed to handle a maximum of 2,500 bookings across all services in that calendar per day, along with a creation limit of 10 booking requests per second, this will work for common scenarios.

If your requirements exceed this, you should plan to distribute the load using the steps below.

  • Create a Bookings calendar with just one service.
  • Clone this calendar to multiple calendars.
  • You can opt-in to the Bookings preview to use a clone option and optout of the preview anytime you want to.
  • Limit each calendar for specific audiences, like:
        By buildings or operating group
        By booking period (mornings only vs afternoons)
  • Dividing the load across different Bookings calendars will help ensure none of them will reach the 2,500 limit.

 

2. Set how far in advance your customers can book an appointment

Finding the optimal value for the maximum advance appointment time your customers can book can help prioritize the daily limits for appointments that are closer to “today”. We have attached a simple Excel spreadsheet where you can enter the values to help you estimate the number of appointments and forward-looking time you can have in your Bookings calendar.

Follow the instructions below to use the attached spreadsheet.

 

  • Calculating the maximum advance appointment time in which those 2,500 appointments could be achieved.
  • Open the booking availability timeframe only for that period of time.
  • Keep updating the timeframe once the slots are full or a day has passed, so people will always have the option to book up to the same timeframe in advance.

If you got confused (don’t worry, we did too), below is an example. This example is calculated at the calendar level, not at the service level. 

  • If the appointment duration is 10 minutes, and the maximum number of working hours are 8, then the possible number of appointments/day will be 8*60/10. This means up to 48 appointments per staff member, assuming you don’t need buffer time between appointments.
  • If we consider 5 staff members per booking calendar, the max number of appointments you can have in a workday will be 240.
  • Considering that opening more than 2,500 slots will throttle the system, then the ability to book a service shouldn’t be opened for more than 2500/240 = ~10.5 days
  • Assuming a 5-day week, do not let your customers book appointments 2 weeks before the current date (I.e. today). This will ensure that your customers can always book an appointment
  • You can choose to move the booking timeframe every day to always have a 2 week pre-booking time or do it when your bookings are filling up.

We are actively working to increase the scaling limits as you read this and we will post a new communication as soon as our systems are updated.

 

Thank you!

Gabriel on behalf of the Bookings team

5 Comments
Copper Contributor

Our Company has rebranded & has an old email & our new email.

 

Our bookings (on Microsoft Bookings) are still being used with our old email account.

 

Is there away of merging all current bookings & Customer details from our old account to our new account?

 

Any help appreciated, 

Jamie @ AJT Safety.

Microsoft

Hi Jamie - @Teja Vinukollu  might be able to help you.

Microsoft

Hi @JamieAWalker,

 

Can you try the steps given below to update the email domain to new value?

Babu_Alagarsamy_0-1614313449124.png

Thanks,

Babu

Copper Contributor

Any thought in adding features that would be more applicable to sales organizations. Having everything in one ecosystem provides better control and permissions functionality, but I have found that a few private alternatives have features that are necessary. For instance,

 

1. I'd like the idea of having a round-robin scheduler option. In such a feature, people who are otherwise indifferent about who they meet, can be randomly assigned, in order to have as even a distribution of appointments as possible among staff.

 

2. Alternatively, provide an option where people can be ranked, and assigned an appointment based on some seniority. Maybe a senior person gets the appointment first, if they aren't available, then a more junior person, and so-on.

 

3. Provide a calendar option that supersedes internal meeting conflicts so as not to lose sales opportunities due to time blocks people put on schedules. I have a weekly focus meeting on my calendar, but if a prospective client needed to meet, I could easily rearrange my calendar. In its current format, it will just look like I more busy than I actually am.

 

 

 

 

Brass Contributor

Hello,

Are all these limits still applied today, end of 2023?

Thank you very much.

Co-Authors
Version history
Last update:
‎Feb 03 2022 11:08 AM
Updated by: