Ctrlk
Home
For the complete documentation index, see llms.txt. This page is also available as Markdown.

Basic Report - Customer Activity & Events

Glossery Overview

The Customer Activity & Events basic report inside the Analytics+ package contains one row per Reservation, Event signup, or invitee record, with columns describing the booking, the people involved, and the resulting revenue. Each column header is described below so the data can be interpreted accurately when exporting or filtering the report.

Identifiers and Event Metadata

  • series_id — The ID of the Series. If you open a Series in the Dashboard, the ID is in the URL

  • Event Id — The ID of the Event. If you open an Event in the Dashboard, the ID is in the URL

  • event_name — The name of the Event, visible to the Customer in the App and to staff in the Dashboard

  • Event Type — The type of Event. Also shown on the Purchase page Export and the Settlements CSV

  • Location — The venue location and the booking experience (pickleball courts, ping pong tables, etc.)

  • Recurring / One Time — If "Recurring" is selected, the Event is part of a Series. If "One Time" is selected, the row represents a single Event or a Reservation

Date and Time

  • Date — The date the Reservation or Event occurred

  • Weekday — The specific day of the week

  • Event Time — The local time at the Club when the Event started

  • Event Duration — Length in minutes of the Reservation or Event

  • # courts per event — Quantity of courts associated with the Event or Reservation

  • court_names_list — Court shortname is pulled from your environment settings

  • Week — Which week of the year the Reservation or Event fell on (1–52)

  • Month — Which month the Reservation or Event fell on

Status and Cancellation

  • Event Status — For an Event, the canceling person is an Admin; for a Reservation, the canceling person is the Customer who booked it

  • Canceled By User — True or False (Null = False). For an Event, the canceling person is an Admin; for a Reservation, the canceling person is the Customer who booked it

  • Canceled At Date — When the Event or Reservation was canceled. Only appears if the booking was canceled

Revenue and Payments

  • Revenue — Total revenue generated by the Reservation or Event

  • Cash — Amount collected as cash

  • Paid to Coach — Amount paid to the Coach, when a Coach is attached to the Reservation or Event

Capacity and Attendance

  • # Members in Waitlist — Null if there are no Members in the Event Waitlist

  • # Non Members in Waitlist — Null if there are no Non-members in the Event Waitlist

  • Event Attendees — Number of Customers in the attendee list of the Reservation or Event

  • Available Spots — How many available spots existed in the Event when it was first created

This column is being updated soon to reflect updated_at rather than created_at. After that change, Available Spots will reflect any later edits an Admin makes to the participant quantity in Event settings.

  • % Fill Rate — Available spots in the Event versus the total Customers who signed up

  • Is Locked — Whether the court / table is locked. Always locked for an Event, and locked for a Reservation if the Customer locks it down during booking

Reservation Holder (Reservation Owner)

  • Resv Holder — Name of the Customer who signed up, or the Reservation Owner if it is a private Reservation

  • Booking Resv Holder Gross — Amount paid by the Reservation Holder for the Reservation booking or Event signup

  • When Resv Holder booked / signup at? — For private Reservations, it is the time the Reservation was created; for Events it is the timestamp of when they signed up for the Event

  • Resv Holder Email — Email of the Customer who booked the Reservation

  • Resv Holder Is Member — Indicates whether the Reservation Owner pays for a Membership

  • Resv Holder Membership Name — The name of the Reservation Owner's Membership

  • resv_holder_DUPR — DUPR ID for the Reservation Owner

  • resv_holder_current_DUPR_rating_singles — Reservation Owner's singles DUPR rating

  • resv_holder_current_DUPR_rating_doubles — Reservation Owner's doubles DUPR rating

Invitee

  • Invitee In Private Resv — Another Customer who was invited to a Reservation, or a Guest inside an Event signup

  • Invitee accepted at — timestamp of when the Reservation or Event invite was accepted by the invitee

  • Signup Resv Holder Gross — The gross amount paid by the user for an Event signup

  • is_checked_in — Whether the invitee has checked in to the Reservation or Event

  • invitee_canceled — Whether the invitee accepted and then canceled their invite

  • invite_type — EVENT_SIGNUP if the listed Customer signed up for an Event; COACH if the listed Customer is a Coach in an Event; GUEST if the listed Customer is a guest of the Reservation Owner

  • Invitee Is Member — Indicates whether the invitee holds a Membership

  • Invitee Membership Name — The name of the invitee's Membership

  • Invitee Email — The invitee's email address

  • invitee_DUPR — DUPR ID for the invitee

  • invitee_current_DUPR_rating_singles — Numerical value for the invitee's singles DUPR rating

  • invitee_current_DUPR_rating_doubles — Numerical value for the invitee's doubles DUPR rating

PreviousShare Analytics+ Credentials
NextOnboarding

Last updated

Was this helpful?