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.
Open Reporting & Intelligence and choose Appointments.
Choose the period in the date range picker at the top of the page.
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.
Open Reporting & Intelligence and choose Appointments.
Scroll to Appointments Deep Dive at the bottom of the tab and select Deep Dive.
Select Run Appointments Analysis.
Check the Start date and End date, then select Crunch the Numbers.
At the foot of the results, select View raw appointment data.
Optional: filter by status, Payment Method, Campaign Source, State / Region, Tags or Add-ons.
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
Financial Tab: for revenue-focused analysis
Customers Tab: for customer-centric analysis
