📋 Summary:

What it calculates: Calculates the rate of rejoined wine club memberships by dividing the number of signed-up memberships for rejoined members by the total number of signed-up memberships, filtered for the current period WHERE Membership Date is within the selected time range, excluding switched or reporting-excluded memberships.

Variants: CP shows current period rejoined signup rate, PP shows prior period rate, allowing direct comparison of membership reactivation performance across time periods.

How to use it:
• Track wine club member retention and reactivation trends
• Evaluate effectiveness of win-back campaigns and membership renewal strategies

Tip: Ensure date picker settings accurately reflect the precise time range you want to analyze, and verify that the "Rejoined Membership" flag is correctly applied to returning members.

This summary was generated by AI.

📊 Quick Stats:

🏷️ Type: Calculated metric
📁 Build Beyond Limits Group: μ Rejoined Signup Rate

Rejoined Membership Signup Rate CP

🔢 Formula

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 Switch] = false
        AND [Club Memberships Calendar].[Is Excluded From Reporting] = false
        AND [Club Memberships].[Rejoined Membership] = true
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 Switch] = false
        AND [Club Memberships Calendar].[Is Excluded From Reporting] = false

Output Format: ##0.0%;-##0.0%

Formula Last Updated: 2025-12-11T08:05:31Z

Rejoined Membership Signup Rate PP

🔢 Formula

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 Switch] = false
        AND [Club Memberships Calendar].[Is Excluded From Reporting] = false
        AND [Club Memberships].[Rejoined Membership] = true
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 Switch] = false
        AND [Club Memberships Calendar].[Is Excluded From Reporting] = false

Output Format: ##0.0%;-##0.0%

Formula Last Updated: 2025-12-11T08:07:21Z