Skip to content
English
Customer portal Sign in
Go to theretailscore.com
  • There are no suggestions because the search field is empty.

Definitions of Member table measures

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.