Membership Operations Report β Revised Column Set
The Membership Operations report tracks how membership counts change over time by recording each movement event β such as a sale, freeze, cancellation, or renewal β as a distinct column. This article describes the revised column set that replaces the previous movement columns, explains how the Active Count Impact column works in the drill-down view, covers the XLSX export formatting for movement columns, and explains the Definitions panel available for this report.
Audience: Reporting administrators and finance managers who use the Membership Operations report to monitor membership lifecycle activity.
On this page
- Before you begin
- About the revised column set
- Movement columns reference
- Active Count Impact column in the drill-down
- XLSX export formatting
- Help summary panel
- Tips
- Troubleshooting
- Related articles
Before you begin
- You must have access to the Membership Operations report through your security role. Access is granted under the Marketing_Reports_V2 permission group.
- The Membership Operations report is available in the modern reporting platform. If you do not see it on the Reports Dashboard, contact your administrator to verify your role permissions.
- Confirm that your organization has an active membership program before expecting movement data to appear.
About the revised column set
The Membership Operations report has been updated with a new set of movement columns. The previous column set β which included New Sale, Unsuspend, Upgrade, Downgrade, Voids, Reactivate, Expiration Extended, Suspend, Renewed, Collections Completed Expired, and Restart Collections β has been removed and replaced by a more comprehensive and precisely named set.
The column previously named New Sale is now named Immediate Sale, reflecting its precise meaning: memberships sold and activated on the same day.
Each movement column records the count of membership events of that type within the selected date range. A positive value in a movement column indicates an event occurred; the Active Count Impact column in the drill-down view (described below) indicates whether that event increased, decreased, or had no effect on the active membership count.
The revised column set provides clearer separation between movement types that previously shared a column, and adds new columns for lifecycle events that were not tracked individually before.
Movement columns reference
The following movement columns are now available in the Membership Operations report. They replace the previous column set in its entirety.
The table below lists each column in the order it appears in the report.
| Movement column | What it records |
|---|---|
| Active Start | The opening active membership count at the start of the reporting period. |
| Immediate Sale | Memberships sold and activated on the same day. Replaces the former New Sale column. |
| Future Sale | Memberships sold with an activation date in the future. |
| Activation | Memberships that moved from a future-sale state to active status. |
| Activation from Upgrade | Memberships activated as a result of an upgrade action. |
| Activation from Downgrade | Memberships activated as a result of a downgrade action. |
| Suspension | Memberships placed into a suspended collection status. |
| Resume | Memberships resumed from a suspended state. |
| Cancellation | Memberships for which a cancellation was initiated. |
| Rescind | Cancellations that were reversed before the termination date. |
| Termination | Memberships terminated after a cancellation offset period. |
| Reinstate | Memberships reinstated after termination. |
| Collection Close | Memberships for which recurring collection was closed. |
| Collections Reopen | Memberships for which recurring collection was reopened. |
| Expiration | Memberships that reached and passed their expiry date. |
| Renewal | Memberships renewed before or on expiry. |
| Backdated Expiration | Memberships expired with an effective date earlier than the current date. |
| Extension | Memberships extended beyond their original expiry date. |
| Upgrade Initiated | Upgrades from one membership plan to a higher plan that were initiated. |
| Sale from Upgrade | Memberships sold as part of an upgrade transaction. |
| Upgrade Cancellation | Upgrade actions that were cancelled before taking effect. |
| Downgrade Initiated | Downgrades from one membership plan to a lower plan that were initiated. |
| Sale from Downgrade | Memberships sold as part of a downgrade transaction. |
| Downgrade Cancellation | Downgrade actions that were cancelled before taking effect. |
| Transferred Out | Memberships transferred away from the current center or guest. |
| Transferred In | Memberships transferred to the current center or guest. |
| Freeze | Memberships placed into a frozen state. |
| Unfreeze | Memberships removed from a frozen state. |
| Closed | Memberships administratively closed. |
| Reopen | Memberships reopened after being closed. |
| Deleted | Membership records deleted from the system. |
| Inactivation | Memberships moved to an inactive status. |
| Active End | The closing active membership count at the end of the reporting period. |
| Scheduled Freeze | Freezes scheduled for a future date. |
| Scheduled Cancellation | Cancellations scheduled for a future date. |
| Unmapped Positive | Movement events with a positive active-count impact that do not map to a named movement type above. |
| Unmapped Negative | Movement events with a negative active-count impact that do not map to a named movement type above. |
| Unmapped Neutral | Movement events with no active-count impact that do not map to a named movement type above. |
Note: The three Unmapped columns capture movement events recorded in the system that do not correspond to any of the named movement types. If you see counts in these columns, contact your Zenoti administrator to investigate whether new movement types have been introduced that have not yet been mapped.
Active Count Impact column in the drill-down
When you select a row in the Membership Operations report to open the movement drill-down view, you will see an Active Count Impact column alongside the standard movement detail columns.
The Active Count Impact column shows whether a given movement event increased, decreased, or had no effect on the count of active memberships at your center or organization. This allows you to distinguish events that change active-membership totals from those that are purely administrative.
Worked example: A guest purchases a membership today (Immediate Sale). In the drill-down, the Active Count Impact column for that row shows a positive value β the active count increased by one. If the same guest's membership is then placed on a scheduled freeze (Scheduled Freeze), that event row may show a neutral impact because the membership is still active until the freeze date arrives.
Use the Active Count Impact column to:
- Validate that your active membership count moves in the expected direction after a batch of lifecycle events.
- Identify events β such as backdated expirations β that may have reduced your active count without appearing in the standard Expiration column for the current period.
- Reconcile the movement columns in the summary report against period-over-period active-membership totals.
XLSX export formatting
When you click Export to download the Membership Operations report as an XLSX file, movement columns that have an active-count impact component receive special formatting:
- Highlighted formatting on no-impact columns: Columns whose identifier designates them as a no-impact variant are rendered with highlighted cell formatting in the XLSX file. These highlighted columns correspond to the "No active count impact" sub-columns for each movement type. This visual distinction helps you identify movement events that did not affect the active membership count at a glance.
- Merged adjacent column headers: When a movement type produces two adjacent columns β one for the active-count-impact variant and one for the no-impact variant β the XLSX export merges the parent header row for those two columns so the shared movement name appears once above both sub-columns.
CSV export labelling: When you export to CSV instead of XLSX, the two sibling columns for each movement type are labelled explicitly in the column header row:
- The active-count-impact column is labelled [Movement Name] - Active count impact (for example, Freeze - Active count impact).
- The no-impact column is labelled [Movement Name] - No active count impact (for example, Freeze - No active count impact).
This labelling ensures that CSV consumers β such as spreadsheet tools or data pipelines β can unambiguously identify which column represents each variant without relying on visual formatting.
Note: The XLSX highlighted formatting and merged headers apply only to movements that have a no-impact sibling column. Movements that produce only a single column are not affected by this formatting behavior.
Help summary panel
The Membership Operations report has its help summary turned on. In the report viewer, select Definitions to open a slide-in panel with definitions for the report.
- The Definitions button is not shown in the movement drilldown.
- The help summary is set for the report itself. There is no organization or center setting to turn it on or off.
Tips
- Filter by movement type to focus your analysis. If you are investigating a specific lifecycle event β such as all cancellations in a quarter β apply a movement-type filter before exporting. This keeps the exported file focused and avoids the need to hide columns manually.
- Use the Active Count Impact column to spot unexpected drops. If your active membership count fell unexpectedly in a period, drill into the movement report and sort by Active Count Impact ascending to surface the events with the largest negative impact first.
- Compare Immediate Sale and Activation counts. A large gap between Immediate Sale and Activation may indicate a backlog of future-sale memberships that have not yet activated β useful for forecasting active-count growth.
Troubleshooting
The revised movement columns do not appear in the report.
Verify that you are viewing the current version of the Membership Operations report on the Reports Dashboard. If you are still seeing the older column set (for example, New Sale or Voids), clear your browser cache and reload the page. If the issue persists, contact your Zenoti administrator to confirm that the report update has been deployed to your organization.
The Unmapped Positive, Unmapped Negative, or Unmapped Neutral columns show unexpected counts.
These columns capture movement events that do not correspond to any named movement type in the revised set. Non-zero counts typically indicate that a system event occurred that has not yet been assigned to a named column. Export the drill-down for the affected period and share the event details with your Zenoti administrator for investigation.
The Active Count Impact column is missing from the drill-down view.
The Active Count Impact column is part of the movement drill-down, not the summary-level report. Confirm that you have clicked into a specific row or movement cell to open the drill-down. If the column does not appear in the drill-down grid, your security role may not include access to the full drill-down view β contact your administrator to review your permissions under the Marketing_Reports_V2 group.