conduyt_appointment_report
Generate appointment reports for a date window, including status, show rate, cancellations, reschedules, and breakdowns by user, calendar, source, channel, and day.
Instructions
Appointment report: every appointment whose time (basis=start, default) or booking (basis=booked) falls in the window: booked, by status (scheduled, confirmed, completed, cancelled, no-show), the outcome of the ones already in the past (held or no-show, show rate), cancellations, reschedules and upcoming; overall and by assigned user, by calendar or booking page, by lead source, by the channel it came in on (booking page, call disposition, created in Conduyt, calendar) and by day. Reschedules count moves by the attendee, by a person in Conduyt, or synced from a connected calendar. Spans clamp to 366 days; the definition comes back as definition.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| to | No | ISO end | |
| from | No | ISO start (omit both for the last 366 days) | |
| basis | No | start (default): appointments by their time; booked: by when they were booked | |
| sources | No | Exact contact source values of the appointment's contact; '__none__' adds appointments with no source or no contact | |
| assignedTo | No | Only appointments assigned to this user |