Acuity Scheduling connector

Use your Acuity Scheduling data for reporting, automation and AI.

Data Panda brings your Acuity Scheduling data together with the data from the rest of your business. From one place, we turn it into dashboards, automations, AI workflows and custom apps your team uses every day.

Data Panda Reporting Automation AI Apps
Acuity Scheduling logo
About Acuity Scheduling

Online booking that quietly runs the front door of a small practice.

Acuity Scheduling is online appointment scheduling software founded in 2006 by Gavin Zuchlinski, who first built it to help his mother manage bookings for her massage therapy practice. Squarespace bought the company in April 2019 in its first ever acquisition, and Acuity now operates as a Squarespace company. The product still ships under the Acuity Scheduling name for standalone customers, while Squarespace site owners get the same engine bundled as Squarespace Scheduling.

The platform serves over 250,000 customers, mostly solo professionals and small teams in beauty, wellness, health and medical, fitness, coaching, photography, tutoring, professional services and pet care. Customers manage appointment types, calendars, intake forms, gift certificates, packages and subscriptions, with native links to Google Calendar, Apple Calendar, Stripe, Square, PayPal, QuickBooks, Zoom, Google Meet and Mailchimp.

What your Acuity Scheduling data is for

What you get once Acuity Scheduling is connected.

Reporting that follows the booking

Appointments, no-shows, package usage and gift-certificate sales on one timeline, tied to invoiced revenue.

  • Revenue per appointment type, per practitioner and per location
  • No-show and late-cancel rate by client cohort and weekday
  • Package and gift-certificate liability against the calendar that will burn it down

Cross-system automation

Let Acuity bookings drive billing, marketing and operations without copy-paste.

  • A new appointment writes a draft invoice into the accounting system
  • A second no-show in a quarter drops the client into a deposit-required segment
  • Package balance updates push back into the email and SMS tool the moment a session is used

AI workflows

Turn years of booking history into scoring that protects the calendar.

  • No-show probability per appointment, surfaced before the slot is confirmed
  • Best-fit appointment type per returning client based on history and intake answers
  • Demand forecast per appointment type and weekday for staffing decisions

Custom apps on your data

Internal tools the Acuity UI does not ship, for the people who never log in.

  • Front-desk cockpit with appointment, package balance and unpaid invoice on one screen
  • Practitioner-load board with target hours and actual booked hours
  • Gift-certificate liability monitor with redemption forecast
Use cases

Use cases we deliver with Acuity Scheduling data.

A list of concrete reports, automations and AI features we have built on Acuity Scheduling data. Pick the one that matches your situation.

Revenue per appointment typeBooked, completed and paid revenue split by appointment type and practitioner.
No-show and late-cancel rateBy client cohort, weekday, slot and reminder sequence variant.
Practitioner loadBooked hours against available hours per calendar, per week.
Package balance and burn-downOutstanding sessions per client, expected redemption month, expiry risk.
Gift-certificate liabilityOutstanding value, average days to redemption, share that expires.
Subscription churn signalRecurring appointment subscriptions that drop a billing or skip two slots in a row.
First-visit conversionShare of first-time clients that book a second appointment within ninety days.
Channel-to-booking attributionWhich marketing channel produced the booking that paid, not the click that landed.
Intake-form quality auditWhich form fields get filled in by clients, and which ones predict revenue.
Multi-location consolidationSeveral Acuity calendars and locations rolled up into one P&L view.
Real business questions

Answers you will finally get.

Which appointment types pay the rent?

Appointment types ranked by completed-and-paid revenue per available hour, not by booking count. Splits the volume slot that fills the calendar from the premium slot that pays the bills, and shows which appointment type a practitioner should be guided toward when the diary opens up.

Where are no-shows really hurting us?

No-show and late-cancel rates per client cohort, per weekday and per appointment type, costed against the empty hour. Highlights the slots and clients that justify a deposit policy and the ones where a friendlier reminder cadence would do the same job for less.

What is sitting on the books in packages and gift certificates?

Outstanding package sessions and gift-certificate value, with the expected month of redemption and the share that historically expires. Turns a deferred-revenue line that finance only sees once a year into a weekly number the practice can plan staffing and promotions around.

Value for everyone in the organisation

Where each function gets value.

For finance leaders

Booked, performed and paid revenue per appointment type and practitioner against deferred liability in packages and gift certificates. The monthly close stops being a calendar export plus a Stripe export, and starts being one number per practice or location.

For sales leaders

Channel-to-booking attribution that ends at paid appointments, not at form submissions. The campaign and the front-desk follow-up both get judged on the second visit and the package buy, not on the first hold.

For operations

Practitioner load, no-show heatmap and waitlist conversion in one picture. The owner sees where to add a calendar, where to tighten the cancellation window and where a deposit policy will pay for itself.

Ideas

What you can automate with Acuity Scheduling.

Pair with Stripe

Match Acuity bookings to Stripe charges

Acuity appointments, packages and gift-certificate sales reconcile against the Stripe charges and refunds that paid for them. Booked-but-unpaid slots, partially refunded sessions and gift certificates that were sold but never collected stop hiding between two dashboards, and finance closes the month from one row per appointment.

Pair with Exact Online

Push Acuity revenue into Exact Online

Completed appointments and product sales from Acuity write a draft sales invoice in Exact Online with the right account, VAT code and project per appointment type. Practitioners stop maintaining a parallel spreadsheet for the bookkeeper, and deferred revenue from packages and gift certificates lives on the balance sheet where it belongs.

Pair with Mailchimp

Segment Mailchimp on real Acuity behaviour

Acuity client status, last appointment date, package balance and no-show count push into Mailchimp as merge fields and tags. Reactivation goes to clients who have not booked in ninety days, no-show offenders skip the discount campaign, and gift-certificate buyers get a different post-purchase flow than first-visit clients.

Pair with Klaviyo

Trigger Klaviyo flows from Acuity events

Booking, completion, cancellation and package-balance events from Acuity feed Klaviyo as profile properties and metric events. Pre-visit prep, post-visit care and package-near-empty reminders fire on the appointment itself, and the Klaviyo report finally credits revenue back to the appointment that triggered the flow.

Pair with HubSpot

Bring Acuity bookings into the HubSpot timeline

Acuity appointments, intake-form answers and package purchases land on the HubSpot contact as activities and custom properties. Sales sees the actual appointment history when they pick up a call, lifecycle stages move on real visits instead of on form submits, and reporting can finally split first-time clients from regulars.

Pair with Slack

Send Acuity calendar signals to the right Slack channel

New high-value bookings, second no-shows in a quarter and gift-certificate sales above a threshold drop into the Slack channel of the practice they touch. The owner stops refreshing the Acuity dashboard between clients and gets the three signals that matter, with a link back to the appointment in one click.

Your existing tools

Your data lands in a warehouse. Your BI tools read from it.

You keep the reporting tool you already have. We connect it to the warehouse where your Acuity Scheduling data lives.

Power BI logo
Power BI Microsoft
Microsoft Fabric logo
Fabric Microsoft
Snowflake logo
Snowflake Data warehouse
Google BigQuery logo
BigQuery Google
Tableau logo
Tableau Visualisation
Microsoft Excel logo
Excel Sheets & pivots
Three steps

From Acuity Scheduling to answers in three steps.

01

Connect securely

OAuth authentication. Read-only by default. We sign a DPA and your admin keeps the keys.

02

Land in your warehouse

Data flows into your warehouse on your schedule. Near real time or nightly, your call. You own the data.

03

Reporting, automation, AI

We build the first dashboard, workflow or AI feature with you, then hand over the keys. Or we stay on for ongoing delivery.

Two ways to work with us

Pick the track that fits how you work.

Track 01

Self-serve

We set up the foundation. Your team builds on top.

  • Acuity Scheduling connector configured and running
  • Warehouse set up in your cloud account
  • Clean access for your Power BI, Fabric or Tableau team
  • Documentation on what's in the data model
  • Sync monitoring so you're warned before reports break

Best fit Teams that already have a BI analyst or data engineer and want to own the build.

Track 02

Done for you

We build the whole thing, end to end.

  • Everything in Self-serve
  • Dashboards built to the questions your team actually asks
  • Automations between your systems
  • AI workflows scoped to real tasks your team runs
  • Custom apps where a dashboard does not cut it
  • Ongoing delivery at a pace that fits your team

Best fit Teams without in-house BI or dev capacity. You tell us what you need and we deliver it.

Before you book

Frequently asked questions.

Who owns the data?

You do. It lands in your warehouse, on your cloud account. We don't resell or aggregate it. If you stop working with us, the warehouse stays yours and keeps running.

How fresh is the data?

Near real time for most operational systems. For heavier sources we schedule hourly or nightly. You pick based on what the reports need.

Do I need a warehouse already?

No. If you don't have one, we help you pick one and set it up as part of the first delivery. Common starting points are Snowflake, Microsoft Fabric, or a small Postgres start.

Does the sync support multiple calendars and locations?

Yes. Each calendar and appointment type lands with its own dimension, with practitioner and location attached. A multi-location practice gets per-location P&L and per-practitioner booked-hours load without merging exports by hand, and a holding with several Acuity accounts can roll up into one revenue view.

How are packages, subscriptions and gift certificates handled?

All three land as separate dimensions with their own balance and redemption history. Outstanding package sessions, active appointment-subscription billings and unredeemed gift-certificate value each get their own deferred-revenue line, with the expected redemption month and historical expiry rate per cohort.

GDPR-compliant
Data stays in the EU
You own the warehouse

A first deliverable live in four to six weeks.

We review your Acuity Scheduling setup and the systems around it. Together we pick the first thing worth building.