Platform: Enolytics DTC

Summary:

What it calculates: This measures how efficiently your club is growing relative to its total membership activity. It calculates the ratio of net membership change (signups minus cancellations) to total membership volume, giving you a growth efficiency percentage that excludes membership switches and reporting anomalies.

Variants:
• CP: Current period growth ratio
• PP: Prior period growth ratio
• Δ: Change in growth ratio between periods
• Δ%: Percentage change in growth ratio

How to use it:
• Compare growth efficiency across different time periods to see if your club is getting better at converting activity into net growth — a rising ratio means you're retaining more members relative to your signup volume
• Benchmark your club's growth efficiency against industry standards or your own historical performance to identify whether membership churn is improving or declining relative to acquisition efforts

Tip: A consistently positive and improving growth ratio indicates healthy club momentum, while a declining ratio might signal retention challenges even if absolute signup numbers look good.

Note: Parts of this article were generated with AI and may not be perfect. If something looks off or could be better, click the 😞 below — it opens a quick chat so you can let us know.

Quick Stats:

Type: Calculated metric
Build Beyond Limits Group: μ Growth Ratio

Copy of Copy of Memberships Growth Ratio Δ%

🔢 Formula

((m₁  ÷  ((((m₂  ÷  m₃))))) - (m₄  ÷  (m₅  ÷  m₆)))  ÷  (m₇  ×  (m₈  ÷  m₉))
with:
m₁ = Sum([Club Memberships Calendar].[Signed Up Flag])
    WHERE
        [Club Memberships Calendar].[Membership Date] ≥ 'Start of Current Period'
        AND [Club Memberships Calendar].[Membership Date] ≤ 'End of Current Period'
        AND [Club Memberships Calendar].[Is Excluded From Reporting] = false
        AND [Club Memberships Calendar].[Is Switch] = false
m₂ = Sum([Club Memberships Calendar].[Active Flag])
    WHERE
        [Club Memberships Calendar].[Is Excluded From Reporting] = false
        AND [Club Memberships Calendar].[Membership Date] ≥ 'Start of Current Period'
        AND [Club Memberships Calendar].[Membership Date] ≤ 'End of Current Period'
m₃ = Distinct Count([Club Memberships Calendar].[Membership Date])
    WHERE
        [Club Memberships Calendar].[Membership Date] ≥ 'Start of Current Period'
        AND [Club Memberships Calendar].[Membership Date] ≤ 'End of Current Period'
m₄ = Sum([Club Memberships Calendar].[Signed Up Flag])
    WHERE
        [Club Memberships Calendar].[Membership Date] ≥ 'Start of Previous Period'
        AND [Club Memberships Calendar].[Membership Date] ≤ 'End of Previous Period'
        AND [Club Memberships Calendar].[Is Excluded From Reporting] = false
        AND [Club Memberships Calendar].[Is Switch] = false
m₅ = Sum([Club Memberships Calendar].[Active Flag])
    WHERE
        [Club Memberships Calendar].[Is Excluded From Reporting] = false
        AND [Club Memberships Calendar].[Membership Date] ≥ 'Start of Previous Period'
        AND [Club Memberships Calendar].[Membership Date] ≤ 'End of Previous Period'
m₆ = Distinct Count([Club Memberships Calendar].[Membership Date])
    WHERE
        [Club Memberships Calendar].[Membership Date] ≥ 'Start of Previous Period'
        AND [Club Memberships Calendar].[Membership Date] ≤ 'End of Previous Period'
m₇ = Sum([Club Memberships Calendar].[Signed Up Flag])
    WHERE
        [Club Memberships Calendar].[Membership Date] ≥ 'Start of Previous Period'
        AND [Club Memberships Calendar].[Membership Date] ≤ 'End of Previous Period'
        AND [Club Memberships Calendar].[Is Excluded From Reporting] = false
        AND [Club Memberships Calendar].[Is Switch] = false
m₈ = Sum([Club Memberships Calendar].[Active Flag])
    WHERE
        [Club Memberships Calendar].[Membership Date] ≥ 'Start of Previous Period'
        AND [Club Memberships Calendar].[Membership Date] ≤ 'End of Previous Period'
        AND [Club Memberships Calendar].[Is Excluded From Reporting] = false
m₉ = Distinct Count([Club Memberships Calendar].[Membership Date])
    WHERE
        [Club Memberships Calendar].[Membership Date] ≥ 'Start of Previous Period'
        AND [Club Memberships Calendar].[Membership Date] ≤ 'End of Previous Period'

Output Format: #,##0

Formula Last Updated: 2025-11-14T07:02:16Z

Denominator Growth Ratio Δ%

🔢 Formula

(m₁  ×  (m₂  ÷  m₃))
with:
m₁ = Sum([Club Memberships Calendar].[Signed Up Flag])
    WHERE
        [Club Memberships Calendar].[Membership Date] ≥ 'Start of Previous Period'
        AND [Club Memberships Calendar].[Membership Date] ≤ 'End of Previous Period'
        AND [Club Memberships Calendar].[Is Excluded From Reporting] = false
        AND [Club Memberships Calendar].[Is Switch] = false
m₂ = Sum([Club Memberships Calendar].[Active Flag])
    WHERE
        [Club Memberships Calendar].[Membership Date] ≥ 'Start of Previous Period'
        AND [Club Memberships Calendar].[Membership Date] ≤ 'End of Previous Period'
        AND [Club Memberships Calendar].[Is Excluded From Reporting] = false
m₃ = Distinct Count([Club Memberships Calendar].[Membership Date])
    WHERE
        [Club Memberships Calendar].[Membership Date] ≥ 'Start of Previous Period'
        AND [Club Memberships Calendar].[Membership Date] ≤ 'End of Previous Period'

Output Format: #,##0.00

Formula Last Updated: 2025-05-05T17:17:43Z

Memberships Growth Ratio CP

🔢 Formula

m₁  ÷  (m₂  ÷  m₃)
with:
m₁ = Sum([Club Memberships Calendar].[Signed Up Flag])
    WHERE
        [Club Memberships Calendar].[Membership Date] ≥ 'Start of Current Period'
        AND [Club Memberships Calendar].[Membership Date] ≤ 'End of Current Period'
        AND [Club Memberships Calendar].[Is Excluded From Reporting] = false
        AND [Club Memberships Calendar].[Is Switch] = false
m₂ = Sum([Club Memberships Calendar].[Active Flag])
    WHERE
        [Club Memberships Calendar].[Is Excluded From Reporting] = false
        AND [Club Memberships Calendar].[Membership Date] ≤ 'End of Current Period'
        AND [Club Memberships Calendar].[Membership Date] ≥ 'Start of Current Period'
m₃ = Distinct Count([Club Memberships Calendar].[Membership Date])
    WHERE
        [Club Memberships Calendar].[Membership Date] ≥ 'Start of Current Period'
        AND [Club Memberships Calendar].[Membership Date] ≤ 'End of Current Period'

Output Format: ##0.0%

Formula Last Updated: 2025-05-05T14:55:37Z

Memberships Growth Ratio PP

🔢 Formula

m₁  ÷  (m₂  ÷  m₃)
with:
m₁ = Sum([Club Memberships Calendar].[Signed Up Flag])
    WHERE
        [Club Memberships Calendar].[Membership Date] ≥ 'Start of Previous Period'
        AND [Club Memberships Calendar].[Membership Date] ≤ 'End of Previous Period'
        AND [Club Memberships Calendar].[Is Excluded From Reporting] = false
        AND [Club Memberships Calendar].[Is Switch] = false
m₂ = Sum([Club Memberships Calendar].[Active Flag])
    WHERE
        [Club Memberships Calendar].[Is Excluded From Reporting] = false
        AND [Club Memberships Calendar].[Membership Date] ≤ 'End of Previous Period'
        AND [Club Memberships Calendar].[Membership Date] ≥ 'Start of Previous Period'
m₃ = Distinct Count([Club Memberships Calendar].[Membership Date])
    WHERE
        [Club Memberships Calendar].[Membership Date] ≥ 'Start of Previous Period'
        AND [Club Memberships Calendar].[Membership Date] ≤ 'End of Previous Period'

Output Format: ##0.0%

Formula Last Updated: 2025-05-05T15:02:48Z

Memberships Growth Ratio Δ

🔢 Formula

(m₁  ÷  (m₂  ÷  m₃)) - (m₄  ÷  (m₅  ÷  m₆))
with:
m₁ = Sum([Club Memberships Calendar].[Signed Up Flag])
    WHERE
        [Club Memberships Calendar].[Membership Date] ≥ 'Start of Current Period'
        AND [Club Memberships Calendar].[Membership Date] ≤ 'End of Current Period'
        AND [Club Memberships Calendar].[Is Excluded From Reporting] = false
        AND [Club Memberships Calendar].[Is Switch] = false
m₂ = Sum([Club Memberships Calendar].[Active Flag])
    WHERE
        [Club Memberships Calendar].[Is Excluded From Reporting] = false
        AND [Club Memberships Calendar].[Membership Date] ≥ 'Start of Current Period'
        AND [Club Memberships Calendar].[Membership Date] ≤ 'End of Current Period'
m₃ = Distinct Count([Club Memberships Calendar].[Membership Date])
    WHERE
        [Club Memberships Calendar].[Membership Date] ≥ 'Start of Current Period'
        AND [Club Memberships Calendar].[Membership Date] ≤ 'End of Current Period'
m₄ = Sum([Club Memberships Calendar].[Signed Up Flag])
    WHERE
        [Club Memberships Calendar].[Membership Date] ≥ 'Start of Previous Period'
        AND [Club Memberships Calendar].[Membership Date] ≤ 'End of Previous Period'
        AND [Club Memberships Calendar].[Is Excluded From Reporting] = false
        AND [Club Memberships Calendar].[Is Switch] = false
m₅ = Sum([Club Memberships Calendar].[Active Flag])
    WHERE
        [Club Memberships Calendar].[Is Excluded From Reporting] = false
        AND [Club Memberships Calendar].[Membership Date] ≥ 'Start of Previous Period'
        AND [Club Memberships Calendar].[Membership Date] ≤ 'End of Previous Period'
m₆ = Distinct Count([Club Memberships Calendar].[Membership Date])
    WHERE
        [Club Memberships Calendar].[Membership Date] ≥ 'Start of Previous Period'
        AND [Club Memberships Calendar].[Membership Date] ≤ 'End of Previous Period'

Output Format: ##0.0%

Formula Last Updated: 2025-05-05T15:02:10Z

Memberships Growth Ratio Δ%

🔢 Formula

((m₁  ÷  ((((m₂  ÷  m₃))))) - (m₄  ÷  (m₅  ÷  m₆)))  ÷  (m₇  ×  (m₈  ÷  m₉))
with:
m₁ = Sum([Club Memberships Calendar].[Signed Up Flag])
    WHERE
        [Club Memberships Calendar].[Membership Date] ≥ 'Start of Current Period'
        AND [Club Memberships Calendar].[Membership Date] ≤ 'End of Current Period'
        AND [Club Memberships Calendar].[Is Excluded From Reporting] = false
        AND [Club Memberships Calendar].[Is Switch] = false
m₂ = Sum([Club Memberships Calendar].[Active Flag])
    WHERE
        [Club Memberships Calendar].[Is Excluded From Reporting] = false
        AND [Club Memberships Calendar].[Membership Date] ≥ 'Start of Current Period'
        AND [Club Memberships Calendar].[Membership Date] ≤ 'End of Current Period'
m₃ = Distinct Count([Club Memberships Calendar].[Membership Date])
    WHERE
        [Club Memberships Calendar].[Membership Date] ≥ 'Start of Current Period'
        AND [Club Memberships Calendar].[Membership Date] ≤ 'End of Current Period'
m₄ = Sum([Club Memberships Calendar].[Signed Up Flag])
    WHERE
        [Club Memberships Calendar].[Membership Date] ≥ 'Start of Previous Period'
        AND [Club Memberships Calendar].[Membership Date] ≤ 'End of Previous Period'
        AND [Club Memberships Calendar].[Is Excluded From Reporting] = false
        AND [Club Memberships Calendar].[Is Switch] = false
m₅ = Sum([Club Memberships Calendar].[Active Flag])
    WHERE
        [Club Memberships Calendar].[Is Excluded From Reporting] = false
        AND [Club Memberships Calendar].[Membership Date] ≥ 'Start of Previous Period'
        AND [Club Memberships Calendar].[Membership Date] ≤ 'End of Previous Period'
m₆ = Distinct Count([Club Memberships Calendar].[Membership Date])
    WHERE
        [Club Memberships Calendar].[Membership Date] ≥ 'Start of Previous Period'
        AND [Club Memberships Calendar].[Membership Date] ≤ 'End of Previous Period'
m₇ = Sum([Club Memberships Calendar].[Signed Up Flag])
    WHERE
        [Club Memberships Calendar].[Membership Date] ≥ 'Start of Previous Period'
        AND [Club Memberships Calendar].[Membership Date] ≤ 'End of Previous Period'
        AND [Club Memberships Calendar].[Is Excluded From Reporting] = false
        AND [Club Memberships Calendar].[Is Switch] = false
m₈ = Sum([Club Memberships Calendar].[Active Flag])
    WHERE
        [Club Memberships Calendar].[Membership Date] ≥ 'Start of Previous Period'
        AND [Club Memberships Calendar].[Membership Date] ≤ 'End of Previous Period'
        AND [Club Memberships Calendar].[Is Excluded From Reporting] = false
m₉ = Distinct Count([Club Memberships Calendar].[Membership Date])
    WHERE
        [Club Memberships Calendar].[Membership Date] ≥ 'Start of Previous Period'
        AND [Club Memberships Calendar].[Membership Date] ≤ 'End of Previous Period'