Membership Operations Report
The Membership Operations Report gives administrators a time-series view of how membership counts move over a selected date range. Use this report to track new sales, cancellations, freezes, upgrades, downgrades, and other status transitions β grouped by day or month β so you can identify trends and take action on membership lifecycle changes.
Audience: Organization administrators and center managers who monitor membership health and operational trends.
On this page
- Before you begin
- Steps
- Filter criteria
- Column descriptions
- Active-count drilldown
- Movement drilldown
- Center and category filtering
- Related articles
Before you begin
Availability: This report appears on the Reports dashboard only after it is enabled for your organization. Its permission check box β Membership Ops Report under Marketing in the Reports(V2) section β is listed in the role editor only once the report is enabled.
- You must have access to the Reports section in Zenoti.
- The report covers data from 2024-01-01 onward. Data for dates before this range is not available.
- The End date you select is automatically capped at yesterday (UTC). You cannot run this report for today or future dates.
- The Start date must not be later than the End date.
- The report date range has no upper day limit β you can select arbitrarily wide date ranges.
Steps
Open the report
- Open the Reports dashboard, type the report name in Search Report, and select Membership Operations Report.
- The report filter panel opens. Configure the filters described in Filter criteria below.
- Select Refresh to load the report results.
Export the report
- After the report loads, select Export to Excel to download the data as a spreadsheet.
Understand Active Start and Active End counts
The report tracks membership movement over a selected period using two anchor counts:
- Active Start β the number of members in the configured active bucket as of the end of the day immediately before the period's start date.
- Active End β the number of members in the configured active bucket as of the end of the last day of the period.
The difference between Active End and Active Start, combined with the net movement counts, reconciles the membership population change over the period.
Note: The active bucket is an administrator-configurable set of membership status and recurring status combinations. When no custom configuration has been saved for your organization, the report uses a system-defined default set. To review or change which status combinations count as "active," see Configure the active bucket and movement labels below.
Read the movement rows
Between Active Start and Active End, the report lists each movement label as a separate row. Each movement label represents a category of status transition β for example, New Sale, Cancellation, or Freeze β and carries an impact sign of either +1 or β1 to indicate whether the transition increases or decreases the active count.
The following table describes how to interpret the movement section:
| Column | Description |
|---|---|
| Movement label | The name assigned to a status-transition rule, such as New Sale or Cancellation. Labels are configurable per organization. |
| Count | The number of memberships that underwent this transition during the reporting period. |
| Impact | The net effect on the active count per transition: +1 (adds to active count) or β1 (subtracts from active count). |
| Net change | Count Γ Impact for the row. |
Note: When both the From and To status combinations of a transition are within the active bucket, the system automatically sets that transition's impact to 0. This intra-active-bucket lock prevents double-counting movements that do not change the active population. The lock is applied when the configuration is saved and cannot be overridden manually.
Configure the active bucket and movement labels
Administrators can customize which status combinations count as "active" and how each transition is labeled and scored. The active bucket configuration supports up to 20 rows (one per status combination) and the movement configuration supports up to 45 rows (one per transition). Configuration changes apply to all future report runs for the organization.
Important: Changes to the active bucket or movement label mapping affect how Active Start, Active End, and all movement counts are computed. Review the impact on historical comparisons before saving changes.
To configure the active bucket:
- Open the Membership Operations Report as described above.
- Under Active bucket, review the 20 rows β one for each (Membership Status, Recurring Status) combination.
- Select the checkbox for each combination you want to count as "active."
- Select Save.
To configure movement label mappings:
- On the same page, scroll to Movement configuration.
- Review the 45 rows β one for each status transition (From Membership Status, From Recurring Status, To Membership Status, To Recurring Status).
- For each row:
- Movement label β Enter the name that should appear on the report for this transition (for example, New Sale, Cancellation, Freeze).
- Impact β Select +1 or β1 to indicate whether this transition increases or decreases the active count.
- Select Save.
Note: If no configuration has been saved, the report uses system defaults for both the active bucket and movement mappings. Saving a configuration for the first time seeds the tables from those system defaults and then applies your overrides. Subsequent saves update only the rows you have changed.
Note: The intra-active-bucket lock is enforced at save time. If you assign a +1 or β1 impact to a transition where both the From and To combinations are in the active bucket, the system overrides your entry and sets the impact to 0.
Filter criteria
Use the following filters to scope the report to the data you need.
| Filter | Description |
|---|---|
| Start date | The first date of the reporting period. Active Start is computed as of the end of the day immediately before this date. Must not exceed the end date. |
| End date | The last date of the reporting period. Active End is computed as of the end of this date. Automatically capped at yesterday (UTC); future dates and the current day are not permitted, because the daily aggregation only processes completed days. |
| Sale Center | Select one or more centers to include in the report. Results are restricted to centers your account has access to. When no center is selected, all accessible centers are included. |
| Category | Filter results to one or more membership categories. Leave blank to include all categories. |
| Group by | Choose how to aggregate time buckets: Day (one row per day) or Month (one row per calendar month). If no value is selected, the report defaults to Day. |
Tip: To compare month-over-month trends across a full year, set Group by to Month and set the date range to cover the full year. To investigate a specific spike or drop, switch to Day and narrow the date range to the relevant period.
Column descriptions
The report displays one row per time bucket (day or month). Each row shows the membership count at the start and end of the period, plus one column per configured movement label showing the net member count change for that movement type.
| Column | Description |
|---|---|
| Date | The date or month that the row represents, depending on the Group by selection. |
| Active Start | The number of active members at the beginning of the time bucket, computed as of the end of the day immediately before the period start date. |
| Active End | The number of active members at the end of the time bucket, computed as of the end of the period end date. |
| Movement columns | One column per configured movement label (for example, New Sale, Cancellation, Freeze, Upgrade, Downgrade, and other status transitions). Each column shows the net change in member count for that movement type during the time bucket. Movement columns where the effective impact is 0 β such as intra-active-bucket transitions β are excluded from the signed label columns. The specific movement labels displayed depend on your organization's configuration. |
Note: Movement column labels are configured at the organization level. The columns you see may differ from those shown in another organization's instance of this report.
Interpreting the data
The difference between Active Start and Active End reflects the net effect of all movement types during the period. For example:
- If Active Start is 500 and Active End is 520, the net gain is 20 members for that period.
- The movement columns explain how that net change was composed β for example, 35 new sales minus 15 cancellations equals a net gain of 20.
Use the movement columns to identify which transition types are driving changes in your active membership count. For example:
- A high cancellation count relative to new sales in a given month may indicate a retention issue worth investigating.
- A spike in freezes during a specific period may correlate with a seasonal pattern or a local event.
Note: The report data is pre-computed nightly. Data for the previous day becomes available the morning after. If you notice a gap in data for a specific date range, the backfill process may still be processing historical data starting from 2024-01-01. Contact your Zenoti administrator if data gaps persist.
Active-count drilldown
The active-count drilldown lets you see exactly which members were active at a specific point in time. When you select an active-count figure in the report, Zenoti opens a paginated list of individual members in that active bucket.
How the drilldown works
The system reconstructs the active population from status-change logs recorded at end-of-day for the snapshot date. This historical path is used for all dates β including recent ones β to ensure drilldown totals agree with the aggregated counts shown in the main report. Reading live membership state rather than the reconstructed end-of-day state would produce systematic discrepancies, so that approach is not used.
Columns in the active-count drilldown
The drilldown grid displays the following information for each member in the active bucket:
| Column | Description |
|---|---|
| Guest name | Full name of the member |
| Guest code | Unique identifier for the guest profile |
| Membership name | Name of the membership the guest holds |
| Member code | Unique code assigned to this membership instance |
| Membership category | Category assigned to the membership |
| Sale date | Date the membership was sold |
| Start date | Date the membership benefits began |
| End date | Expiration date of the membership |
| Membership Status | Current membership status (for example, Active, Frozen) |
| Recurring Status | Current recurring collection status (for example, Active, Cancelled) |
Note: Membership Status and Recurring Status are independent dimensions. A membership can show Active in Membership Status while showing Cancelled in Recurring Status if a mid-cycle cancellation has been submitted but the termination date has not yet passed.
Movement drilldown
The movement drilldown lets you see which members underwent a specific lifecycle transition during a date or date range. When you select a movement figure in the report, Zenoti opens a paginated list of members who experienced that transition.
How the drilldown works
You access the movement drilldown by selecting a date range, a movement label, and an impact direction (for example, members who moved into the active state versus members who moved out of it).
For most movement types, the drilldown queries the membership status-transition log for the requested period. The drilldown filters movement rows using the effective impact value, so the members listed always describe the same population as the count shown in the main report column.
Scheduled actions (Scheduled Freeze and Scheduled Cancel): For these two movement types, the drilldown queries pending scheduled actions rather than completed transitions. This means the list shows members who have a freeze or cancellation scheduled to take effect within the requested date range, not members for whom the action has already executed.
Columns in the movement drilldown
The drilldown grid displays the following information for each member in the movement:
| Column | Description |
|---|---|
| Sale center | The center where the membership was sold |
| Guest name | Full name of the member |
| Guest ID | Unique identifier for the guest profile |
| Membership name | Name of the membership |
| Sale date | Date the membership was sold, based on the invoice creation date at the center |
| Start date | Date the membership benefits began |
| From status | The membership status before the transition |
| To status | The membership status after the transition |
Center and category filtering
Both the main report and all drilldowns respect the following filters:
Center access: Results are automatically restricted to the centers your user account is permitted to access. You will not see data from centers outside your access scope. If you have access to all centers in the organization, the report includes all non-voided centers.
Membership category: Use the Sale Center filter on the report to narrow results by center. To filter by membership category, select one or more categories from the category filter. When no category is selected, the report includes all membership categories.
Note: The category filter applies to both the summary-level report figures and to any drilldown you open from those figures. Drilldown results always reflect the same filter criteria as the parent report view.