Skip to main content

Appointments Tab

The tab follows the date range, comparison and forecast set at the top of Reporting & Intelligence. Appointments Deep Dive, at the bottom of the tab, analyses every appointment in a range you choose.

Review your appointments for a period

Do this to see how many appointments you had, how many were paid, and which days carried the load.

  1. Open Reporting & Intelligence and choose Appointments.

  2. Choose the period in the date range picker at the top of the page.

  3. Read the Key Metrics, then the insight cards and charts below them.

Key metrics

Metric

What it shows

Appointments

Appointments in the period, declined requests left out. When any were cancelled, the cancelled count, the cancellation rate (cancelled out of every appointment) and any no-shows

Completion

Visits finished (completed, ready to pay, paid, payment declined, refunded or voided), out of every appointment not cancelled, with a badge of how many that is

Avg Duration

Booked service minutes on the appointments not cancelled, divided by those appointments

Revenue (earned)

Appointments that were completed, ready to pay, paid, payment declined or refunded, by visit date

With a team member or service filter on, Appointments, Completion, Status Breakdown and Cancellations by type stay whole-business and carry an All team · all services badge, and the cancelled line under Appointments is hidden.

Insight cards

The Appointments tab can generate up to eight insight cards. Each card leads with its finding, and How is this calculated? on the card shows the name used here and the working behind it:

  • Booking Trend: whether bookings rose, fell or held steady between the first seven and the last seven days of the period. It needs at least 14 days, so the two weeks never overlap.

  • Booking Momentum: compares the second half of the period with the first, and appears when bookings accelerated or slowed by 10% or more.

  • Demand Imbalance: your busiest weekday against quiet working days that run more than 30% below your daily average, with how many bookings your quietest day runs under the average and what filling that gap would be worth each week at your average appointment value. Create Special Service opens Fill Your Quiet Days, a six-step plan for a limited, lower-priced service on those days.

  • Peak Day Saturation: flags a busiest day that runs 20% or more ahead of the next busiest day.

  • Cancellation Rate: how many appointments were cancelled, the rate and any no-shows. It does not estimate lost revenue, because many clients who cancel rebook. Run Deep Dive opens the Appointments Deep Dive, which shows who rebooked.

  • Awaiting Confirmation: booking requests still in Pending, which nobody has confirmed yet. No payment is due on them, so the card carries no dollar figure. Includes Run Deep Dive.

  • Declined Payments: appointments whose payment was declined, with the amount estimated at your average appointment value. Includes Manage Payments.

  • Payment Flow: the share of appointments fully paid, out of the five statuses the tab counts, flagged when it is above 90% or below 70%.

Run Deep Dive and Manage Payments both scroll to the Appointments Deep Dive card, highlight it and open it for you.

With a team member or service filter on, Cancellation Rate, Awaiting Confirmation, Declined Payments and Payment Flow do not appear.

Charts and sections

Bookings Over Time

An area chart of appointments per day. With a comparison on, a dashed grey line shows the look-back period before it. With a forecast on, a dashed blue line projects forward and a Forecast badge appears. Dotted vertical lines and background tints mark where each zone starts.

Completion

A ring showing the completion rate, with how many visits were finished or paid out of the appointments not cancelled beneath it.

Status Breakdown

Horizontal bars showing how appointments split across statuses:

  • Pending: booking requests nobody has confirmed yet

  • Confirmed: accepted appointments that have not started

  • In progress: appointments under way

  • Completed: appointments marked as completed

  • Ready to pay: finished appointments waiting on payment

  • Paid: appointments where payment was processed

  • Payment declined: appointments where the payment was declined

  • Refunded: appointments refunded in full

  • Partly refunded: appointments refunded in part

  • Voided: finished appointments whose invoice amount was voided

  • Cancelled: cancelled appointments, no-shows included

  • Request declined: booking requests the business said no to

Each status shows its icon, count and its share of every appointment in the period, declined requests included. Only statuses with at least one appointment are shown.

Bookings by Day of Week

A bar chart of the average number of appointments on each day of the week, averaged over the days that had bookings, so a public holiday does not pull a weekday down. Days outside your team's working hours are greyed. Use it to find your busiest and quietest working days.

Cancellations by type

Appears when the period has cancellations. It splits them into standard cancellations and no-shows, with a count and a share each, under a badge with the total. The reason a client gave is on each appointment; this card does not group by it yet.

Export appointments as CSV

Do this to take every appointment in a date range out of Petboost, filtered to what you need.

  1. Open Reporting & Intelligence and choose Appointments.

  2. Scroll to Appointments Deep Dive at the bottom of the tab and select Deep Dive.

  3. Select Run Appointments Analysis.

  4. Check the Start date and End date, then select Crunch the Numbers.

  5. At the foot of the results, select View raw appointment data.

  6. Optional: filter by status, Payment Method, Campaign Source, State / Region, Tags or Add-ons.

  7. Select Export CSV.

The file is appointments-deep-dive.csv. It holds every appointment that matches your filters, with these columns: Start Date, Start Time, End Date, End Time, Grand Total (incl. fees), Services and Add-ons (after discounts), Fees, Discount, Deposit Paid, Balance Due, Pet Name(s), Service(s), Team Member(s), Add-ons, Add-on Revenue, Service Paid by Package, Add-on Paid by Package, Package Name, Pet Owner, Phone, Email, Payment Method (earned visits), Street Address, Suburb, State, Campaign Source, Pet Profile URL, Appointment URL, Status and Status Key.

Export CSV sits on the View raw appointment data row, so you can export without opening the table.

Appointments Deep Dive

Deep Dive on the Appointments Deep Dive card opens a full-screen view that reports on the appointments starting in a range you choose, up to 460 days. The dates start from the page's range. Comparison and forecast periods set at the top of the page do not apply to it, and the view says so when they are on. Petboost works the results out when you select Crunch the Numbers, and the view shows Analysing Appointments while it does. A long range takes longer, and you can leave the tab and come back. A longer range than 460 days is refused in the date dialog. Once it has run, the header names the dates it covers.

The results cover the location you are in, with GST included. Earned Revenue counts appointments that were completed, ready to pay, paid, payment declined or refunded, at their service and add-on value after discounts, without card, booking or date fees. Rates count appointments that are not cancelled or declined.

What it analyses

The results open on their own Key Metrics: Earned Revenue (excluding fees), Appointments, Self-Service Rate, Add-on Rate, Rebook Rate, No-Show Rate and Booking Frequency. Below them, insight cards and sections cover:

Area

What it covers

Bookings and add-ons

Booked Value by Status, the self-service booking rate, how often staff book with Quick Create rather than Magic Availability Check, the add-on attach rate, Add-ons sold (name, appointments, revenue, attach rate) and Add-on attach by service

Clients and revenue

Top Clients by Revenue, recurring against one-off appointments, the $100 Club (appointments of $100 or more), the Appointment Value Distribution, client revenue concentration and client lifetime value

Timing and demand

Popular time slots (morning, midday, afternoon), recurring day patterns and booking lead time

Payments and operations

Earned Bookings by Payment Method, card-on-file adoption, Outstanding (the balance still due on finished visits), the average value of mobile appointments against appointments at your premises, and the effect of pickup and drop-off on appointment value

Cancellations

Clients who cancelled and rebooked against those who cancelled and did not return, repeat cancellers, and self-service against staff-booked cancellation rates

Retention and team

Rebook rate, no-show rate and no-show fee collection, discounts, booking frequency, staff loyalty, calendar gaps, estimated team hours (Payroll Summary), the prebooking rate and vaccination expiry

Customers and campaigns

Best Customers, Problem Customers and Rollercoaster Customers, each judged on its cancellation rate, and the Campaign Source Breakdown when bookings came through campaign links

Calendar gaps count only the time inside each team member's shifts, so a break between two shifts is not a gap. A client who cancelled counts as rebooked when they have a later active booking at any date, including one made before they cancelled. Booking lead time runs from when the booking was made to the start of the appointment in your business's time zone.

Many of these insight cards have a View action that opens a list of the clients, pets or appointments behind them. Rebook Rate, for example, offers a View action with the count of clients not rebooked, such as View 12 Not Rebooked: a list of clients without a future booking, each with a mail icon that opens a personalised rebook reminder in your email app.

The raw appointment table

View raw appointment data, at the foot of the results, shows the number of appointments in the range and opens them 50 to a page, with Previous and Next below. On a wide screen they form a table with Start Date, Time, End Date, Time, Total, Pet(s), Service(s), Add-ons, Package, Owner, Phone, Email, Location, Campaign, Payment, Status and Links columns. On a narrow screen each appointment is a card. Export CSV has every appointment the filters leave.

The filters above the table narrow both the rows and the export:

  • Status, with a count for each

  • Payment Method, when more than one method was used

  • Campaign Source, when bookings came through campaign links, including No campaign

  • State / Region, when owners have an address on file

  • Tags, when pets or owners carry tags

  • Add-ons, with each extra and No add-ons

The pet and owner names and Profile open the pet's profile, and Appt opens the appointment, each in a new tab.

Results and email

Results stay loaded while you switch tabs. Changing the date range at the top of the page clears them, so run the analysis again for the new range.

Email on the Appointments Deep Dive card opens an email in your email app with the analytics summary for the page's date range and an Appointments section. You choose who it goes to and send it yourself.

Related articles

Did this answer your question?