Appointment Duration Query

Appointment Duration Query

This query helps determine how long appointments typically last by pulling key timestamp fields: checkedInAt, checkedOutAt, and completedAt. It’s often used for operational reporting, workflow optimizations, or identifying bottlenecks in client flow.

 Request

Pull all appointments that were updated within a given date range, including the following timestamp fields:

• checkedInAt – when the client checked in

• checkedOutAt – when they checked out

• completedAt – when the provider completed the appointment in the system

Example of a Query

query MyQuery {
  appointments(
    updatedAtStart: "2023-08-01T00:00:00"
    updatedAtEnd: "2023-09-30T00:00:00"
  ) {
    checkedInAt
    checkedOutAt
    completedAt
  }
}

 Notes

• You can adjust the updatedAtStart and updatedAtEnd values to cover your desired timeframe.

• This does not filter by appointment creation date — it filters by when the appointment was last updated.

• completedAt is triggered when the provider marks the appointment complete in Vetspire.

• checkedInAt and checkedOutAt are only present if the front desk or user manually checks the client in/out. If these fields are missing, it may indicate they weren’t marked at the time.

• You may want to export these timestamps into Excel or a tool like Looker/Power BI to calculate duration or averages.