Pauses & Cancellations
Memberships don't always run uninterrupted. They can be temporarily frozen (idle periods) or ended early (cancellations). Both directly affect billing, gym access, contract end dates, and churn reporting — so getting the vocabulary right matters for accurate revenue and retention analysis.
Membership Pauses (Idle Periods)
Members can temporarily freeze their memberships for various reasons — injury, travel, or as a loyalty reward. Idle periods affect billing, gym access, and contract end dates depending on the configuration. Understanding idle period types and their fee calculations is important for accurate revenue reporting and member status analysis.
Idle Period Types
| Type |
Scope |
Typical Use |
| MEMBER_IDLE_PERIOD |
Freezes ALL of a customer's contracts |
Customer request (injury, travel) |
| CONTRACT_IDLE_PERIOD |
Freezes a SINGLE contract |
Specific contract pause |
| CONTRACT_TRIAL_PERIOD |
Trial/probation period on a contract |
New member trial |
| BONUS_PERIOD |
Free period as a reward (gym access always allowed) |
Birthday gift, loyalty reward |
Idle Period Fee Calculation
| Type |
How the Fee Works |
| NONE |
No fee charged |
| ABSOLUTE |
A fixed amount is charged |
| RELATIVE |
A percentage of the regular rate |
| TERM_BASED |
Recurring billing at sub-term intervals |
Table: fct_idle_period joined with dim_idle_period_property. Date fields are YYYYMMDD integers.
Cancellations & Churn
Cancellations are one of the most important areas for business analysis. They track when and why contracts end early — whether initiated by the customer, the gym, or automatically due to non-payment. The cancellation origin, type, and strategy together determine when a contract actually ends and what fees apply. This data drives churn rate calculations and retention analysis.
Cancellation Origin
| Origin |
Who Initiated It |
| CUSTOMER |
Member requested cancellation |
| STUDIO |
Staff cancelled from the back-office |
| DUNNING |
Automated due to non-payment |
| CONTRACT_SWITCH |
Automated as part of switching to a new contract |
| IMPORT |
Migrated from a legacy system |
Cancellation Type
| Type |
Meaning |
| CUSTOM |
Cancelled with a custom/freeform reason |
| CONTRACT_SWITCH |
Membership continues with a new contract |
| REST_MATURITY |
All outstanding fees due immediately |
Cancellation Strategy
| Strategy |
How End Date Is Calculated |
| TERM |
Ends at the end of current term after notice period |
| RECEIPT_DATE |
Ends on receipt date plus notice period |
| Term |
Definition |
| Extraordinary Cancellation |
Cancellation outside normal terms — before minimum term ends or after regular window. Requires special circumstances (relocation, medical). |
Table: fct_contract + dim_contract_cancellation_reason. Key dates: cancellation_date_id (takes effect), cancellation_receipt_date_id (notice received), pre_cancellation_end_date_id (original end date).