ZenotiHelp

Membership Operations Report β€” Sale from Upgrade and Sale from Downgrade Movement Columns

ZTZenoti Docs Team Updated October 16, 2026 6 min readReference

The Membership Operations Report tracks how memberships move through lifecycle states each day. This article describes four movement columns added to the report β€” Sale from Upgrade, Sale from Downgrade, Activation from Upgrade, and Activation from Downgrade β€” which distinguish memberships created or activated through a legacy upgrade or downgrade from those sold through normal enrollment.

Before you begin

  • Your organization must have access to the Membership Operations Report.
  • The four columns described in this article appear automatically in the report grid. No additional configuration is required to enable them.
  • To drill down into the individual member records behind a column count, you need the same permissions that govern other movement-column drilldowns in the report.

On this page


What these columns track

When a guest upgrades or downgrades a recurring membership using the legacy (non-in-place) flow, Zenoti cancels the original membership and creates a new destination membership. These new memberships were previously counted in the Immediate Sale movement column alongside normally enrolled memberships, making it difficult to distinguish organic new sales from upgrade- or downgrade-driven membership creations.

The four new movement columns separate these transactions so you can analyze upgrade and downgrade activity independently from standard enrollment:

  • Sale from Upgrade and Sale from Downgrade count newly created memberships born from the legacy upgrade or downgrade flow.
  • Activation from Upgrade and Activation from Downgrade count those new memberships that have transitioned to Active status as a result of the same flows.

Column descriptions

The following table describes each of the four new movement columns.

Column What it counts
Sale from Upgrade New memberships created as the destination of a legacy (non-in-place) upgrade β€” that is, the new membership issued when a guest upgrades from an existing membership. These memberships are not counted in Immediate Sale.
Sale from Downgrade New memberships created as the destination of a legacy (non-in-place) downgrade. These memberships are not counted in Immediate Sale.
Activation from Upgrade Memberships that transitioned to Active status as a direct result of a legacy upgrade action.
Activation from Downgrade Memberships that transitioned to Active status as a direct result of a legacy downgrade action.

Note: These columns apply only to the legacy upgrade and downgrade flow, in which the original membership is cancelled and a new membership is created. They do not apply to in-place upgrade or downgrade actions, which modify an existing membership rather than creating a new one.

How the daily aggregation classifies transactions

The Membership Operations Report is built by a daily aggregation job that reviews membership activity and assigns each transaction an event action code. The classification logic for the four new columns works as follows:

  • A new membership born from a legacy upgrade (where the source membership carried an upgrade indicator) is classified as event action 29 β€” Sale from Upgrade.
  • A new membership born from a legacy downgrade (where the source membership carried a downgrade indicator) is classified as event action 30 β€” Sale from Downgrade.
  • When a membership classified as Sale from Upgrade subsequently reaches Active status, it is also counted under Activation from Upgrade.
  • When a membership classified as Sale from Downgrade subsequently reaches Active status, it is also counted under Activation from Downgrade.

Because these transactions are assigned their own event action codes, they are excluded from the Immediate Sale count. A single upgrade or downgrade action produces exactly one record in the Sale from Upgrade or Sale from Downgrade column.

Drilldown behavior

Each of the four columns supports drilldown into the individual member records that make up the count, consistent with other movement columns in the Membership Operations Report. To view the underlying member records:

  1. Locate the row for the date range or center you want to investigate.
  2. Select the count in the Sale from Upgrade, Sale from Downgrade, Activation from Upgrade, or Activation from Downgrade column.
  3. A detail panel opens listing each membership record that contributed to the count, including the guest name, membership name, and relevant dates.

Steps

Open the Membership Operations Report

  1. Navigate to the Reports Dashboard.
  2. Locate and open the Membership Operations Report.
  3. Apply any filters for date range, center, or membership type as needed, then select Apply to load the report.

View upgrade and downgrade movement columns

  1. In the report grid, scroll right to locate the Sale from Upgrade, Sale from Downgrade, Activation from Upgrade, and Activation from Downgrade columns.
  2. Review the counts for each column across the displayed rows.
  3. To compare upgrade-driven sales against normal enrollment, compare the values in Sale from Upgrade and Sale from Downgrade against the Immediate Sale column. Upgrade- and downgrade-born memberships are excluded from Immediate Sale.

Drill down into member records

  1. Select a non-zero count in any of the four columns.
  2. Review the detail panel for the individual member records.
  3. To export the detail records, use the Export to Excel option available in the detail panel.

Filter criteria

The following table describes the filters available on the Membership Operations Report that affect the four new columns.

Filter Description
Date range Restricts the report to the aggregation period you specify. The daily aggregation job assigns each transaction to the date the upgrade or downgrade occurred.
Sale Center Filters results to the center where the new membership was created. In the UI, this filter is labeled Sale Center.
Membership Filters results to a specific membership. Use this filter to isolate upgrade or downgrade activity for one membership definition.
Membership type Filters by recurring or non-recurring membership. Legacy upgrades and downgrades apply to recurring memberships.

Tips

  • Use Sale from Upgrade and Sale from Downgrade to measure tier migration volume. Comparing these columns over time shows how frequently guests are moving between membership tiers, which is distinct from new guest acquisition measured by Immediate Sale.
  • Combine Activation from Upgrade with Sale from Upgrade to check activation lag. If the Sale from Upgrade count is consistently higher than Activation from Upgrade for the same period, some newly created memberships have not yet activated. This may indicate guests with future start dates or pending payment setup.
  • Filter by Sale Center to attribute upgrade and downgrade activity to specific locations. When your organization has multiple centers, this filter lets you compare whether certain centers drive more tier-change activity than others.
  • Export detail records for reconciliation. If your finance team reconciles membership revenue by source, use the drilldown export to identify revenue attributed to upgrade- or downgrade-created memberships separately from standard new sales.

Troubleshooting

The Sale from Upgrade or Sale from Downgrade column shows zero even though upgrades occurred during the period.

The four columns are populated by the daily aggregation job. If upgrades were processed but the job has not yet run for that day, the columns will show zero. Verify that the date range you selected corresponds to a period for which the aggregation has completed. If you expect data from today, wait until the next scheduled aggregation run.

Counts in Sale from Upgrade appear in Immediate Sale instead.

This behavior indicates that the upgrade was processed using the in-place upgrade flow rather than the legacy flow. The new columns apply only to legacy (non-in-place) upgrades and downgrades. In-place upgrades modify the existing membership rather than creating a new one, so no new membership record is created and no Sale from Upgrade count is generated.

Activation from Upgrade count is lower than Sale from Upgrade for the same period.

A membership created by a legacy upgrade is counted in Sale from Upgrade as soon as it is created. It is counted in Activation from Upgrade only when it reaches Active status. If a guest's new membership has a future start date or requires a payment method to be confirmed before activation, there will be a lag between the Sale and Activation counts. Check the member detail records using the drilldown to identify memberships still in a Not Started or Pending state.

Was this article helpful?
Your feedback helps us improve our documentation.