...
Measures | Description | Explanation |
|---|---|---|
Age New Memberships | The average age for new members at the actual start date. | The total age of new members is divided by the total number of new members in the given period. |
Age Terminated Members | The average age for terminated members at the actual termination date. | The total age of terminated members is divided by the total number of terminated members in the given period. |
Age Overall | The average age for all members. | The average age of all members. Including new members, terminated members and frozen members during the given period. |
Churn % | The number of members that ended their subscription during the given period. Shown in percentage over ingoing members in the same period. | Calculation: Terminated Members/Members IB  |
Churn % LY | The number of members that ended their subscription during the given period last year. Shown in percentage over ingoing members in the same period last year. | No further explanation needed. |
Frozen IB | Distinct count of ingoing frozen memberships during the given period. | A membership is shown as “Frozen IB” up until and including the day that the freeze ends. |
Frozen IB Diff | Difference of distinct count of ingoing frozen memberships during the given period against the same period last year. | No further explanation needed. |
Frozen IB Diff % | Difference of distinct count of ingoing frozen memberships during the given period against the same period last year shown in percentage. | No further explanation needed. |
Frozen IB LY | Distinct count of ingoing frozen memberships the same period last year. | No further explanation needed. |
Frozen UB | Distinct count of outgoing frozen memberships during the given period. | A membership is shown as “Frozen UB” up until the day before the last day of the freeze period. |
Frozen UB Diff | Difference of distinct count of outgoing frozen memberships during the given period against the same period last year. | No further explanation needed. |
Frozen UB Diff % | Difference of distinct count of outgoing frozen memberships during the given period against the same period last year shown in percentage. | No further explanation needed. |
Frozen UB LY | Distinct count of outgoing frozen memberships the same period last year. | No further explanation needed. |
Members IB | The total number of ingoing members during the given period. | Members IB as a measure is calculated on smallest date in the given period and includes all members that does not have a frozen membership or is a new member on the given date. |
Members IB Diff | The total number of ingoing members during the given period against the same period last year. | No further explanation needed. |
Members IB Diff % | The total number of ingoing members during the given period against last year is shown in percentage. | No further explanation needed. |
Members IB LY | The total number of ingoing members, the same period last year. | No further explanation needed. |
Members Net | Difference of new vs terminated members during the given period. | Calculation: [New Members]-[Terminated Members] Negative value in the Members Net metric means that terminated members are greater than new members for the given period. |
Members Net % | Net members against ingoing members during the selected period in percent. | Calculation: [Members Net]/[Members IB] |
Members Net % LY | Net members against ingoing members during the selected period LY in percent. | No further explanation needed. |
Members Net LY | Difference of new vs terminated members during the selected period LY. | No further explanation needed. |
Members UB | The total number of outgoing members during the given period. | For a membership to be included in the count of Members OB, one of the following two conditions must be met: Both FlagMemberOut and FlagFrozen must equal 0. FlagMemberOut is set to 1 on the day a membership ends, and FlagFrozen is set to 1 for the entire period during which a membership is frozen. Both FlagFrozen andFlagFrozenOut must equal 1. FlagFrozenOut is set to 1 on the day the membership freeze period ends. On the last day of a freeze period, the membership is counted as 1 Member OB. Example: Member buys membership starting 2023-07-24 through 2024-06-18, in between the person freezes his/her membership between 2023-12-07 to 2024-04-07. Member UB will therefore show 1, the dates 2023-07-24 to 2023-12-06 and then 2024-04-07 to 2024-06-17. |
Members UB Diff | Difference of total number of outgoing members during the given period against the same period last year. | Calculation: [Members UB]-[Members UB LY] |
Members UB Diff % | Difference of total number of outgoing members during the given period against the same period last year shown in percentage. | No further explanation needed. |
Members UB LY | The total number of outgoing members, the same period last year. | No further explanation needed. |
Members UB R24 | The total number of outgoing members last 24 months. | No further explanation needed. |
Membership Life Time | The average lifetime of active membership. | This measure calculates number of months that a person has been a member. If several subscriptions exists over multiple periods of time, the smallest start date of a subscription will be used as long as the person is not considered a member out in between subscriptions. |
Membership Life Time Diff | The lifetime of an active membership against the same period last year. | No further explanation needed. |
Membership Life Time Diff % | The lifetime of an active membership against the same period last year is shown in percentage. | No further explanation needed. |
Membership Life Time LY | The lifetime of active membership for the same period last year. | No further explanation needed. |
New Members | New members for the period. | A person is considered a new member on the day the membership starts. FlagMemberIn will equal 1 the date a membership is activated and 0 all other dates that the membership is active. Calculation: count(distinct "Member In") |
New Members Diff | New members for the period against the same period last year. | No further explanation needed. |
New Members Diff % | New members for the period against the same period last year are shown in percentage. | No further explanation needed. |
New Members LY | New members the same period last year. | No further explanation needed. |
Terminated Members | Terminated memberships in the given period. | A person is considered to have a terminated membership on the date their membership ends, meaning it is not being renewed. MemberOut is set to True (1) on the date the membership ends and remains False (0) on all other dates while the membership is active. If subscription for example runs between 2023-10-24 and 2024-10-23, MemberOut will be 1 on the last day of the subscription period (2024-10-23). Calculation: Terminated Members = count(distinct "Member Out") |
Terminated Members Diff | Terminated memberships in a given period against the same period last year. | No further explanation needed. |
Terminated Members Diff % | Terminated memberships in a given period against the same period last year are shown in percentage. | No further explanation needed. |
Terminated Members LY | Terminated memberships the same period last year. | No further explanation needed. |
Training Frequency Yearly | Calculation: [Training Occasions Yearly]/count({<_FlagMemberActive={1},Date={">=$(=YearStart(Max(Date)))<=$(=YearEnd(Max(Date)))"},Year=,YearMonth=,DA_ShowLastDays=,EN_ShowLastDays=,NB_ShowLastDays=,SV_ShowLastDays=>}distinct %PersonID) | |
Training Frequency Yearly LY | Calculation: [Training Occasions Yearly LY]/count({<_FlagMemberActive={1},Date={">=$(=Addyears(YearStart(Max(Date)),-1))<=$(=Addyears(YearEnd(Max(Date)),-1))"},Year=,YearMonth=,DA_ShowLastDays=,EN_ShowLastDays=,NB_ShowLastDays=,SV_ShowLastDays=>}distinct %PersonID) | |
Training Occasions Yearly | Number of visits per year | Calculation: Sum({<Date={">=$(=YearStart(Max(Date)))<=$(=YearEnd(Max(Date)))"},Year=,YearMonth=,DA_ShowLastDays=,EN_ShowLastDays=,NB_ShowLastDays=,SV_ShowLastDays=>} Visit) |
Training Occasions Yearly LY | Number of visits per year the same period last year | Calculation: Sum({<Date={">=$(=Addyears(YearStart(Max(Date)),-1))<=$(=Addyears(YearEnd(Max(Date)),-1))"},Year=,YearMonth=,DA_ShowLastDays=,EN_ShowLastDays=,NB_ShowLastDays=,SV_ShowLastDays=>} Visit) |
Yearly attrition | Calculation: (RangeSum(Above(Count({<_FlagMemberOut={1}>} distinct [Subscription ID]), 0, 12))) / (Rangesum(Above(count(distinct [Member IB]), 0, 12))/12) | |
Membership Cancellations R12 | Total number of membership cancellations during the last 12 months | Calculation: (RangeSum(Above(Count({<_FlagMemberOut={1}>} distinct [Subscription ID]), 0, 12))) |
...