List of definitions for Member measures found in the Member Table of the Master Template cube
| Fact | Field Name | definition |
| Members | # Members | Distinct count of the number of members linked to the calendar by the joined date |
| Members | # Members with email | Distinct count of the number of members with the email field filled in and is linked to the calendar by the joined date |
| Members | % Members with email | The number of members with the email field filled in, as a % of the total number of members |
| Members | Sales $ (Available Lifetime) | Member sales is a fact that has one record per member. Lifetime spend is an unfiltered sum of all sales transactions for a person from the ERP. When looking at regular sales by member, it may not equal the lifetime spend if you don’t use a filter. This is because lifetime spend has no exclusions and includes all transactions. It is only limited by the go live date of the ERP. On the other hand, the sales fact may only have a subset of data e.g. last 3 years. |
| Members | # Online Sales Transactions (Available Lifetime) | Distinct count of the number of members that have recorded a Sales Transaction in an Online Location |
| Members | # Sales Transactions (Available Lifetime) | Distinct count of the number of members that have recorded a Sales Transaction |
| Members | ATV (Available Lifetime) | Average transaction Value (ATV) of all member transactions |
| Members | # Sales Excl Net Returns Transactions (Available Lifetime) | Distinct count of the number of members that have recorded a Sales Transaction excluding a count of all net returns transactions. |
| Members | Sales $ (Last 12 Months) | Sales $ recorded against a member ID for the last 12 months (Member Sales $ has no exclusions and includes all transactions) |
| Members | # Sales Excl Net Returns Transactions (Last 12 Months) | Distinct count of the number of members that have recorded a Sales Transaction in the last 12 months, excluding a count of all net returns transactions. |
| Members | ATV (Last 12 Months) | Average transaction Value (ATV) of all member transactions over the last 12 months |
| Members | # Online Sales Transactions (Last 12 Months) | Distinct count of the number of members that have recorded a Sales Transaction in an Online Location over the last 12 months |
| Members | Member Signup Conversion (Members and Non-member Trnx) | Distinct count of the # members + # unnamed transactions |
| Members | Member Signup Conversion Rate | Conversion rate of Members that have signed up and transacted. |