Operations Report
Cart conversion, cancellations, AR aging, gift card liability, and coupon effectiveness.
Overview
A comprehensive operational dashboard that covers what happens around the revenue numbers — funnel conversion, what gets canceled and why, what you're owed, what's on outstanding gift cards, and how your promo code program is performing. Access from Dashboard > Reports > Operations.
This page documents every section's calculation. For shared rules, see How report calculations work.
What this report counts
The Operations report contains several sections with different rules — they are documented per section below. The defaults:
- Recognized bookings (for revenue-style calcs): Confirmed and Pending.
- Cancellation sections: Canceled only — that's the point.
- AR Aging: snapshot at request time, no date range.
- Date axis: bookings filtered by
Booking.CreatedAtunless noted.
Cart Conversion
How well your booking flow converts visitors into committed bookings.
| Metric | What it is | How it's calculated |
|---|---|---|
| Total Carts | Shopping carts started in the period | Count of ShoppingCart rows with CreatedAt in the period |
| Converted Bookings | Carts that became recognized bookings | Count of bookings with status Confirmed or Pending, created in the period |
| Cart Conversion Rate | Conversion % | Converted Bookings ÷ Total Carts × 100 |
| Abandoned Cart Value | Approximate dollar value of unconverted carts | Sum of Cart.GrandTotal for carts in the period, minus sum of business revenue for converted bookings in the period |
A cart counts as "converted" when it becomes a Confirmed or Pending booking. Drafts (still in cart) and Canceled bookings are not conversions.
Cancellation Analytics
What gets canceled, when, and by how much.
| Metric | What it is | How it's calculated |
|---|---|---|
| Cancelled Bookings | Bookings ending in Canceled status | Count of Canceled bookings created in the period |
| Overall Cancellation Rate | Share of period bookings that were canceled | Cancelled Bookings ÷ all bookings in period × 100 |
| Revenue Impact | Dollar value of canceled bookings | Sum of GrandTotal − TipAmount across Canceled bookings — "what would have been earned if they hadn't canceled" |
Cancellations by Activity
Per-activity breakdown of which activities lose the most bookings to cancellation:
- Cancellation Rate — Canceled ÷ Total for that activity × 100
- Revenue Impact — sum of business revenue across this activity's canceled bookings
Cancellation Lead Time
How far in advance customers cancel relative to their service date. Bookings are bucketed into ranges and each bucket shows count and share of total cancellations. Use this to understand whether cancellations cluster right before service (suggests a refund-policy issue) or far in advance (suggests over-booking / waitlist issues).
Payment Methods (all sources)
A breakdown of every payment method used in the period:
- Payment method — credit card, cash, gift card, etc.
- Transaction count — number of payment rows
- Revenue — total gross payment amount (includes tips)
- Percentage — share of total payment volume
This view uses the payment date (CustomerPayment.Date), not booking
creation date — it's about cash-flow activity. Numbers here will not match
the Revenue Report's Gross Revenue (different date axis, includes tips).
Revenue by Line Item Type
A breakdown of revenue by what the customer is paying for:
| Type | What it represents |
|---|---|
| Duration | Activity time |
| Equipment | Equipment rental |
| Addon | Add-on purchases |
| TimeSlot | Time-slot-priced activities |
| Coupon | Coupon discounts (negative) |
| GiftCard | Gift card credit applied (negative) |
| Tax | Tax line items |
| Fee | Service / processing fees |
| TripProtection | Trip protection charges |
| Seats / EquipmentUnits / Custom | Specialty line item types |
Each row shows revenue (sum of Price × Quantity for line items of that
type), count of line items, and share of total. Filtered to line items on
Confirmed or Pending bookings created in the period.
Use this view to understand what share of your revenue is activity vs add-ons vs taxes vs fees — useful for product-mix analysis and pricing strategy.
Accounts Receivable Aging
A snapshot at the moment the report runs of every booking with an outstanding balance.
| Bucket | Bookings whose creation date is… |
|---|---|
| Current (0–30 days) | 0–30 days old |
| 31–60 days | 31–60 days old |
| 61–90 days | 61–90 days old |
| 90+ days | More than 90 days old |
Each bucket shows the count of outstanding bookings and the sum of their outstanding balances.
What counts as outstanding
- The booking must be Confirmed or Pending. Drafts (pre-commit) and Canceled bookings are excluded — neither is collectible.
- The booking must have
Balance > 0.
Important — AR is not date-range-filtered
Unlike the rest of the Operations report, AR Aging ignores your selected date range. It always shows the current snapshot. If you want "AR as of month-end last month", you'd need to capture the snapshot then.
Reconciliation with Revenue
Because the revenue-recognition rule (Confirmed + Pending) matches the AR rule, the totals reconcile in principle: every dollar in AR Aging is a dollar that's been counted as revenue but not yet collected. Previously, revenue only counted Confirmed bookings while AR counted both — the two could never reconcile.
Gift Card Liability
A snapshot of your outstanding gift card liability:
- Total Issued Value — sum of original gift card values issued at this location
- Outstanding Liability — sum of remaining balances on active gift cards
- Redeemed — sum of gift card value that has been applied to bookings
Gift card revenue is recognized when the card is redeemed against a booking, not when it's purchased. Outstanding liability is real money your business owes to customers.
Coupon Effectiveness
For every active coupon at this location:
| Metric | What it is | How it's calculated |
|---|---|---|
| Use Count | Bookings that used this coupon | Count of all bookings (any status) created in the period that applied this coupon |
| Total Discount Given | Total dollar amount discounted | Sum of CouponDiscountTotal across those bookings |
| Revenue From Coupon Bookings | Business revenue from recognized bookings that used this coupon | Sum of GrandTotal − TipAmount for Confirmed/Pending bookings that used this coupon |
| ROI | Revenue ÷ Discount | The dollar return per dollar of discount given |
Use ROI to evaluate which coupons drive incremental business vs subsidize bookings that would have happened anyway.
Date axis summary
| Section | Date used |
|---|---|
| Cart Conversion (carts, bookings, abandoned value) | ShoppingCart.CreatedAt and Booking.CreatedAt |
| Cancellation Analytics | Booking.CreatedAt |
| Payment Methods | CustomerPayment.Date |
| Revenue by Line Item Type | Booking.CreatedAt |
| AR Aging | No date range — snapshot at request time |
| Gift Card Liability | No date range — snapshot at request time |
| Coupon Effectiveness | Booking.CreatedAt |
Filters
- Date range — applies to most sections (not AR / Gift Cards).
- Activities — narrow to specific activities.
- Sources — filter by booking source.