| FACT |
FIELD NAME |
DEFINITION |
| Sales |
Docket Number |
Unique chronological number generated by the system at the time a sale is processed. Each Transaction generates a unique Docket number which is documented on the Customer Receipt. The details of the sales transaction is stored against the docket number. |
| Sales |
Transaction Number |
The POS generated Transaction number unique to a location |
| Sales |
Is Return |
Flag to filter on Transactions that include a Return 'Y' or do not inlcude a Return 'N'. Rule: If Sales Units <0 then 'Y' else 'N' |
| Sales |
Is Markdown Sale |
Flag to filter on Transactions that include a Permanent Markdown 'Y' or do not include a Permanent Markdown 'N' |
| Sales |
Is Temp Discount Sale |
Flag to filter on Transactions that include a Temporary Discount 'Y' or do not include a Temporary Discount 'N' |
| Sales |
Is True Discount Sale |
Flag to filter on Transactions that include a Temporary and/or Permanent Discount 'Y' or do not include any Discount 'N' |
| Sales |
Is Net Return |
Flag to filter on Transactions that have a return where the net value of the transaction is negative 'Y' or 'N', This takes into account the net value of a return after exchanges within the one transaction. Rule: If total docket value < 0, then 'Y', else "N" |
| Sales |
Is Named Sale |
Flag to filter on transactions where the sale has been attributed to a member ID |
| Sales |
Is New Member Sale |
Flag to filter on Sale Transactions where the Sale has been attributed to a New Member ID. A new member is someone who has had a sale within 30 days of their joined date |
| Sales |
Is First Member Sale |
Flag to filter on Sale Transactions where the Sale has been attributed to a Member who is registering their first sales transaction. |
| Sales |
Sales Units |
Net Sales Quantity of all units sold, includes Returns, during a defined calendar period. |
| Sales |
Sales $ |
Net Sales $ value of Sales transactions during a defined calendar period, including Returns and with all Discounts applied |
| Sales |
Sales $ Incl GST |
Net Sales $ value (including GST) of Sales transactions during a defined calendar period, including Returns and with all Discounts applied |
| Sales |
Sales Tax $ |
The Tax component of the Net Sales $ value of Sales transactions during a defined calendar period, including Returns and with all Discounts applied |
| Sales |
COGS $ |
Cost of goods sold (COGS) is the weighted average standard cost value of goods sold during a defined calendar period. |
| Sales |
GP $ |
Gross Profit (GP) $ is the difference between the Sales $ and the COGS $. This can also be referred to as Gross Margin |
| Sales |
GP % |
Gross Profit shown as a % of Sale $ |
| Sales |
GP $ (All Stores) |
Gross Profit (GP) $ is the difference between the Sales $ and the COGS $. This can also be referred to as Gross Margin |
| Sales |
GP % (All Stores) |
Gross Profit shown as a % of Sale $ |
| Sales |
GP % (All Products) |
Gross Profit shown as a % of Sale $ |
| Sales |
GP % Index to Total |
Gross Profit $ as a % of Sale $ Indexed to the Grand Total GP % of all Products. This is a statistical way to compare the relative change of a product, or it's hierarchy, where the base (Grand Total GP %) is 100. |
| Sales |
GP % Contribution |
Gross Profit (GP) % as a Contribution of the Sales $ % Mix. This provides another perspective on the GP results where the Grand Total GP % Contribution = overall GP % and the product breakdown shows the contribution of GP % to the Sales $ Mix % |
| Sales |
Sales Before Temp Discount $ |
The Sales value of the transaction as if there was no temporary markdown taken. Sales $ + Temp Discount $ |
| Sales |
Sales Before Temp Discount $ Incl GST |
The Sales value of the transaction as if there was no temporary markdown taken. Sales $ + Temp Discount $ |
| Sales |
Temp Discount $ |
Temp Discount value at time of Sales. incl both POS and Promo discount |
| Sales |
Temp Discount % |
Temp Discount amount as a % of pre discount value at the time of sale |
| Sales |
Temp Discount Tax $ |
Sale GST Tax amount of Temp Discount value |
| Sales |
Gross $ |
Gross Sales $ are the Sales $ after Returns and before Total Discounts |
| Sales |
Gross $ Incl GST |
Gross Sales $ (includes GST) are the Sales $ after Returns (incl GST) and before Total Discounts (incl GST) |
| Sales |
Perm Markdown $ Incl GST |
Markdown value at time of Sales (incl GST) |
| Sales |
Temp Discount $ Incl GST |
Temp Discount value at time of Sales (incl GST) |
| Sales |
Sales Units (All Products) |
Net Sales Quantity of all units sold, including returns, during a defined calendar period for All Products regardless of Product filters applied to the pivot. |
| Sales |
Sales Units Mix % |
Sales Units as a % Mix of the Total Sales Units |
| Sales |
Sales Units Mix % (All Stores) |
Sales Units as a % Mix of the Total Sales Units for All Locations regardless of the location filters applied to the pivot. |
| Sales |
Sales $ (Total) |
Net Sales $ value of Sales transactions during a defined calendar period, including Returns and with all Discounts applied. Results are for total sales regardless of filters applied to the pivot. |
| Sales |
Sales $ (All Salespeople) |
Net Sales $ value of Sales transactions during a defined calendar period, including Returns and with all Discounts applied. Results are for total Salespeople regardless of Salespeople filters applied to the pivot. |
| Sales |
Sales $ (All Stores) |
Net Sales $ value of Sales transactions during a defined calendar period, including Returns and with all Discounts applied. Results are for All Locations regardless of Location filters applied to the pivot. |
| Sales |
Sales $ (000s) |
Net Sales $ value of Sales transactions during a defined calendar period, including Returns and with all Discounts applied. Sales $ of a Transaction represented in thousands ie $10 represents $10,000 |
| Sales |
Sales $ (All Products) |
Net Sales $ value of Sales transactions during a defined calendar period, including Returns and with all Discounts applied. Results are for All Products regardless of Product filters applied to the pivot. |
| Sales |
Sales $ Mix % |
Sales $ as a % of the Total Sales $ for the defined calendar period |
| Sales |
Sales $ Mix % (All Stores) |
Sales $ as a % of the Total Sales $ for the defined calendar period. Results are for All Locations regardless of Location filters applied to the pivot. |
| Sales |
COGS $ (All Products) |
Cost of goods sold (COGS) is the weighted average standard cost value of goods sold during a defined calendar period. Results are for All Products regardless of Product filters applied to the pivot. |
| Sales |
COGS $ Mix % |
COGS $ as a % Mix of the Total COGS $ for the defined calendar period. |
| Sales |
Avg Cost Price |
Average Cost Price is the weighted average standard cost of goods which have been sold in a defined calendar period. This is calculated by dividing the COGS by the quantity of units sold. |
| Sales |
Returns Units |
Return Units is the quantity of all units returned for either a refund or exchange, during a defined calendar period |
| Sales |
Sales Units Excl Returns |
Sum of all Units sold during a defined calendar period. These Sales have NOT been adjusted for Returns including Refunds and Exchanges. |
| Sales |
Excl Returns Sales $ |
Sales $ value of products sold during a defined calendar period, with all Discounts applied. They do NOT include any Returns (defined as both refunds and exchanges) transaction. |
| Sales |
Excl Returns Sales $ Incl GST |
Sales $ value + the GST of products sold during a defined calendar period, with all Discounts applied. They do NOT include any Returns (defined as both refunds and exchanges) transaction. |
| Sales |
Excl Returns COGS $ |
Cost of goods sold (COGS) excluding returns transactions is the weighted average standard cost value of goods sold, during a defined calendar period, excluding any transaction value of both returns and refunds. |
| Sales |
Excl Returns Before Total Discount $ |
Sales $ Before Total Discount $ excluding Returns Sales Transactions |
| Sales |
Excl Returns GP $ |
Gross Profit (GP) $ excluding returns is the difference between the Sales $ and the COGS $ excluding all refund and exchanges transaction values. This can also be referred to as Gross Margin excluding returns |
| Sales |
Excl Returns # Sales Trnx |
Number of Sales Transactions excluding all negative transactions over a defined calendar period. These transactions are NOT adjusted for returns (defined as both refunds and exchanges). # Sales Transactions - # Returns Transactions |
| Sales |
Excl Returns % Sales Trnx |
Number of Sales Transactions that exclude Returns Transactions as a % of the total number of all Sales Transactions over a defined calendar period |
| Sales |
Excl Returns Temp Discount $ |
The Temp Discount value of sales transactions at time of Sales over a defined calendar period excluding all return transactions |
| Sales |
Excl Returns Temp Discount $ Incl GST |
The Temp Discount value inclusive of GST of sales transactions at time of sale over a defined calendar period excluding all return transactions |
| Sales |
Net Returns $ |
Value of Net Returns at Sales $ where the net sales value of the docket number is negative after returns and exchanges. I.e. Sales $ where Is Net Return is 'Y' |
| Sales |
Net Returns $ Incl GST |
Value of Net Returns at Sales $ inclusive of GST over a defined calendar period, where the net sales value inclusive of GST of the docket number is negative (after returns and exchanges). I.e. Sales $ incl GST where Is Net Return is 'Y' |
| Sales |
Net Returns $ % |
Net Returns $ Value as a % of Sales $ over a defined calendar period |
| Sales |
Net Returns COGS $ |
Value of Net Returns at COGS $ over a defined calendar period, where the net sales value of the docket number is negative (after returns and exchanges). I.e. COGS $ where Is Net Return is 'Y' |
| Sales |
Net Returns Total Discount $ |
Sales $ Value of Total (aka True) Discount of the Net Returns $ i.e. True discount value where is net returns is 'Y' |
| Sales |
Net Returns Before Total Discount $ |
Sales $ Value of Net Returns $ before adjustments for any discounts are applied over a defined calendar period. |
| Sales |
Net Returns GP $ |
Value of Net Returns at GP $ over a defined calendar period, where the net sales value of the docket number is negative (after returns and exchanges). Ie GP $ where Is Net Return is 'Y' |
| Sales |
Net Returns # Sales Trnx |
Number of Sales Transactions of Net Returns over a defined calendar period. I.e. Distinct Count of sales transaction where Is Net Return = 'Y' |
| Sales |
Net Returns % Sales Trnx |
Number of Net Return Sales Transactions as a % of the total number of all Sales Transactions over a defined calendar period |
| Sales |
Net Returns Units |
Quantity of Net Returns Units (where the sales units of a transaction is negative after returns and exchanges) over a defined calendar period. Ie Sales Qty where Is Net Return = 'Y' |
| Sales |
Returns $ |
Value of Returns at Sales $ over a defined calendar period, where the sales transactions includes any negatives. I.e. Sales $ where Is Return is 'Y' |
| Sales |
Returns $ Incl GST |
Value of Returns at Sales $ incl GST over a defined calendar period, where the sales transactions includes any negatives (both returns and exchanges). I.e. Sales $ incl GST where Is Return is 'Y' |
| Sales |
Returns $ % |
Returns $ as a % of the total Sales $ excluding Returns |
| Sales |
Returns COGS $ |
Total COGS $ value of the Returns Transaction |
| Sales |
Returns Temp Discount $ |
Temp Discount value of Returns Sales Transaction |
| Sales |
Returns Temp Discount $ incl GST |
Temp Discount value of Returns Sales Transaction (incl GST) |
| Sales |
Returns Before Total Discount $ |
Returns $ before Total Discounts $ are applied (Gross Return $) |
| Sales |
Returns GP $ |
Total GP $ value of the Returns Sales |
| Sales |
Returns # Sales Trnx |
Distinct count # Return Sales Transactions where 'Is Return' flag = "Y" |
| Sales |
Returns % Sales Trnx |
# Return Sales Transactions as a % to the total number of Sales Transactions |
| Sales |
Markdown % |
Perm markdown Sales $ as a % of Sales $ before Perm markdown amount deducted |
| Sales |
Markdown Tax $ |
Tax $ amount of the Perm Markdown Sales $ |
| Sales |
Markdown $ |
Perm Markdown value at time of Sales |
| Sales |
Sales Before Markdown $ |
Sales $ prior to the Perm Markdowns being deducted |
| Sales |
Sales Before Markdown $ Incl GST |
Sales $ prior to the Perm Markdowns being deducted (incl GST) |
| Sales |
GP $ Before Markdown |
GP$ of Perm Markdown Sales prior to Perm Markdowns being deducted |
| Sales |
GP % Before Markdown |
GP$ Before Perm Markdown as a % of Sales Before Perm Markdown $ |
| Sales |
Markdown % Sales $ |
% of Sales $ derived from products that had a permanent markdown applied at the time of the sale in the defined calendar period. Markdown Sales $ / Sales $ |
| Sales |
Markdown % Sales $ Incl GST |
% of Sales $ (incl GST) derived from products that had a permanent markdown applied at the time of the sale in the defined calendar period. Markdown Sales $ / Sales $ |
| Sales |
Markdown % Sales Units |
% of Sales Units derived from products that had a permanent markdown applied at the time of the sale in the defined calendar period. Markdown Units / Sales Units |
| Sales |
Markdown ASP |
Average Selling Price (ASP) of Sales $ derived from products that had a permanent markdown applied at the time of the sale in the defined calendar period. Markdown Sales $ / Markdown Units |
| Sales |
Markdown COGS $ |
COGS $ derived from products that had a permanent markdown applied at the time of the sale in the defined calendar period. |
| Sales |
Markdown GP % |
GP % derived from products that had a permanent markdown applied at the time of the sale in the defined calendar period. |
| Sales |
Markdown GP $ |
GP $ derived from products that had a permanent markdown applied at the time of the sale in the defined calendar period. |
| Sales |
Markdown Sales $ |
Sales $ derived from products that had a permanent markdown applied at the time of the sale in the defined calendar period. |
| Sales |
Markdown Sales $ Incl GST |
Sales $ (incl GST) derived from products that had a permanent markdown applied at the time of the sale in the defined calendar period. |
| Sales |
Markdown Units |
Sales Units derived from products that had a permanent markdown applied at the time of the sale in the defined calendar period. |
| Sales |
Markdown # Sales Trnx |
Distinct count of Sales transactions derived from products that had a permanent markdown applied at the time of the sale in the defined calendar period. |
| Sales |
Markdown % Sales Trnx |
Markdown Transactions as a % of Total Sales Transactions. Markdown # Sales Transactions / # Sales Transactions |
| Sales |
Full Price % Sales $ |
% of Sales $ derived from products that is considered Full Price at the time of the sale in the defined calendar period. Full Price Sales $ / Sales $ |
| Sales |
Full Price % Sales $ Incl GST |
% of Sales $ (incl GST) derived from products that is considered Full Price at the time of the sale in the defined calendar period. Full Price Sales $ / Sales $ |
| Sales |
Full Price % Sales Units |
Sales Units derived from products that is considered Full Price at the time of the sale in the defined calendar period. Full Price Sales Units / Sales Units |
| Sales |
Full Price ASP |
Average Selling Price (ASP) of Sales $ derived from products that are considered Full Price at the time of the sale in the defined calendar period. Full Price Sales $ / Full Price Units |
| Sales |
Full Price COGS $ |
COGS $ derived from products that are considered Full Price at the time of the sale in the defined calendar period. |
| Sales |
Full Price GP % |
GP% derived from products that are considered Full Price at the time of the sale in the defined calendar period. |
| Sales |
Full Price GP $ |
GP$ derived from products that are considered Full Price at the time of the sale in the defined calendar period. |
| Sales |
Full Price Sales $ |
Sales $ derived from products that are considered Full Price at the time of the sale in the defined calendar period. |
| Sales |
Full Price Sales $ Incl GST |
Sales $ (incl GST) derived from products that are considered Full Price at the time of the sale in the defined calendar period. |
| Sales |
Full Price Units |
Sales Units derived from products that are considered Full Price at the time of the sale in the defined calendar period. |
| Sales |
Full Price # Sales Trnx |
Distinct count of Sales transactions derived from products that are considered Full Price at the time of the sale in the defined calendar period. |
| Sales |
Full Price % Sales Trnx |
Full Price Transactions as a % of Total Sales Transactions. Full Price # Sales Transactions / # Sales Transactions |
| Sales |
GP $ Before Temp Discount |
GP$ of Temp Discounted Sales prior to Temp Discounted being deducted |
| Sales |
GP % Before Temp Discount |
GP$ Before Temp Discounted as a % of Sales Before Temp Discounted $ |
| Sales |
Temp Discounted % Sales $ |
Sales $ of Temp Discounted $ as a % of total Sales $ |
| Sales |
Temp Discounted % Sales $ Incl GST |
Sales $ of Temp Discounted $ (incl GST) as a % of total Sales $ (incl GST) |
| Sales |
Temp Discounted % Sales Units |
Sales Units of Temp Discounted as a % of total Sales Units |
| Sales |
Temp Discounted ASP |
Average Selling Price of the Temp Discounted Sales Transactions |
| Sales |
Temp Discounted COGS $ |
COGS $ of Temp Discounted Sales Transactions |
| Sales |
Temp Discounted GP % |
GP $ of Temp Discounted Sales as a % of Temp Discounted Sales $ |
| Sales |
Temp Discounted GP $ |
GP$ of Temp Discounted Sales Transactions |
| Sales |
Temp Discounted Sales $ |
Sales $ from Temp Discounted Transactions |
| Sales |
Temp Discounted Sales $ Incl GST |
Sales $ from Temp Discounted (incl GST) |
| Sales |
Temp Discounted Units |
Sales Units of Temp Discounted Transactions |
| Sales |
Temp Discounted # Sales Trnx |
# Temp Discounted Sales Transactions |
| Sales |
Temp Discounted % Sales Trnx |
# Temp Discounted Sales Transactions as a % of Total # Sales Transactions |
| Sales |
Total Discount $ |
Value of Total Discount applied to the transaction, i.e. Temp Discounted + Perm Markdown |
| Sales |
Total Discount Tax $ |
Value of Tax $ applied to Total Discounted Sales Transactions |
| Sales |
Total Discount $ Incl GST |
Value of Total Discount applied to the transaction (Incl GST) , i.e. Temp Discounted + Perm Markdown |
| Sales |
Total Discount % |
Total Discount $ value as a % of the Sales before Total Discount $ value |
| Sales |
Sales Before Total Discount $ |
Sales $ prior to Total Discounts (incl Temp and Perm) being deducted |
| Sales |
Sales Before Total Discount $ Incl GST |
Sales $ prior to Total Discounts (incl Temp and Perm) being deducted (Incl GST) |
| Sales |
First Margin $ |
GP $ of Sales Transactions prior to Total Discounts (incl Temp and Perm) being deducted |
| Sales |
First Margin % |
First Margin $ as a % of Sales Before Total Discount $ |
| Sales |
Total Discounted % Sales $ |
Sales $ of Total Discounted $ as a % of Total Sales $ |
| Sales |
Total Discounted % Sales $ Incl GST |
Sales $ of Total Discounted $ as a % of Total Sales $ (Incl GST) |
| Sales |
Total Discounted % Sales Units |
Sales Units of Total Discounted Sales as a % of Total Sales Units |
| Sales |
Total Discounted ASP |
Average Selling Price of the Total Discounted Sales Transactions |
| Sales |
Total Discounted COGS $ |
COGS $ of Total Discounted Sales Transactions |
| Sales |
Total Discounted GP % |
GP $ of Total Discounted Sales as a % of Total Discounted Sales $ |
| Sales |
Total Discounted GP $ |
GP$ of Total Discounted Sales Transactions |
| Sales |
Total Discounted Sales $ |
Sales $ from Total Discounted Transactions |
| Sales |
Total Discounted Sales $ Incl GST |
Sales $ from Total Discounted (incl GST) |
| Sales |
Total Discounted Units |
Sales Units of Total Discounted Transactions |
| Sales |
Total Discounted # Sales Trnx |
# Total Discounted Sales Transactions |
| Sales |
Total Discounted % Sales Trnx |
# Total Discounted Sales Transactions as a % of Total # Sales Transactions |
| Sales |
Full Price Non Discounted % Sales $ |
Sales $ of Non Discounted $ as a % of Total Sales $ |
| Sales |
Full Price Non Discounted % Sales $ Incl GST |
Sales $ of Non Discounted $ as a % of Total Sales $ (incl GST) |
| Sales |
Full Price Non Discounted % Sales Units |
Sales Units of Non Discounted Sales as a % of Total Sales Units |
| Sales |
Full Price Non Discounted ASP |
Average Selling Price of the Non Discounted Sales Transactions |
| Sales |
Full Price Non Discounted COGS $ |
COGS $ of Non Discounted Sales Transactions |
| Sales |
Full Price Non Discounted GP % |
GP $ of Non Discounted Sales as a % of Non Discounted Sales $ |
| Sales |
Full Price Non Discounted GP $ |
GP$ of Non Discounted Sales Transactions |
| Sales |
Full Price Non Discounted Sales $ |
Sales $ from Non Discounted Transactions |
| Sales |
Full Price Non Discounted Sales $ Incl GST |
Sales $ from Non Discounted (incl GST) |
| Sales |
Full Price Non Discounted Units |
Sales Units of Non Discounted Transactions |
| Sales |
Full Price Non Discounted # Sales Trnx |
# Non Discounted Sales Transactions |
| Sales |
Full Price Non Discounted % Sales Trnx |
# Non Discounted Sales Transactions as a % of Total # Sales Transactions |
| Sales |
# Sales Trnx |
Distinct count of Number of Sales Transactions |
| Sales |
Units Per Transaction |
The average number of Units Purchased in a Transaction |
| Sales |
Units Per Transaction (All Salespeople) |
The average number of Units Purchased in a Transaction for All Salespeople |
| Sales |
Units Per Transaction (All Stores) |
The average number of Units Purchased in a Transaction for All Stores |
| Sales |
Avg Transaction Value |
Average Transaction Value: Average Sales value for each Sales Transaction |
| Sales |
Avg Transaction Value (All Salespeople) |
Average Transaction Value for All Salespeople |
| Sales |
Avg Transaction Value (All Stores) |
Average Transaction Value for All Stores |
| Sales |
Avg Transaction Value Incl GST |
Average Transaction Value: Average Sales value for each Sales Transaction (Incl GST) |
| Sales |
Avg Transaction Value Incl GST (All Salespeople) |
Average Transaction Value for All Salespeople (incl GST) |
| Sales |
Avg Transaction Value Incl GST (All Stores) |
Average Transaction Value for All Stores (incl GST) |
| Sales |
Avg Sell Price |
Average Sale Price per Unit Sold |
| Sales |
Avg Sell Price (All Salespeople) |
Average Sale Price per Unit Sold for All Salespeople |
| Sales |
Avg Sell Price (All Stores) |
Average Sale Price per Unit Sold for All Stores |
| Sales |
Avg Sell Price Pre Temp Discount |
Average Sale Price of Temp Discount Transactions before any discount is applied |
| Sales |
Avg Sell Price Pre Perm Markdown |
Average Sale Price of Perm Discount Transactions before any discount is applied |
| Sales |
Avg Sell Price Pre Total Discount |
Average Sale Price of Total Discount Transactions before any discount is applied |
| Sales |
Avg Sell Price Incl GST |
Average Sale Price per Unit Sold (Incl GST) |
| Sales |
Avg Sell Price Incl GST (All Salespeople) |
Average Sale Price per Unit Sold for All Salespeople (Incl GST) |
| Sales |
Avg Sell Price Incl GST (All Stores) |
Average Sale Price per Unit Sold for All Stores (Incl GST) |
| Sales |
Avg Sell Price Incl GST Pre Temp Discount |
Average Sale Price of Temp Discount Transactions before any discount is applied (Incl GST) |
| Sales |
Avg Sell Price Incl GST Pre Perm Markdown |
Average Sale Price of Perm Discount Transactions before any discount is applied (Incl GST) |
| Sales |
Avg Sell Price Incl GST Pre Total Discount |
Average Sale Price of Total Discount Transactions before any discount is applied (Incl GST) |
| Sales |
Online Sales $ |
Sales $ of a Transaction in Locations defined as Online |
| Sales |
Online % Sales $ |
Sales $ where transactions are from Online Stores as a % of Total Sales $ |
| Sales |
Online % Sales $ Incl GST |
Sales $ (Incl GST) where transactions are from Online Stores as a % of Total Sales $ |
| Sales |
Online % Sales Units |
Sales Units where transactions are from Online Stores as a % of Total Sales Units |
| Sales |
Online ASP |
Average Sale Price per Unit Sold in Locations defined as Online |
| Sales |
Online COGS $ |
Total Sales at $ Cost of Goods Sold in Locations defined as Online |
| Sales |
Online GP % |
Gross Profit as a % of Sale $ in Locations defined as Online |
| Sales |
Online GP $ |
Gross Profit $ in Locations defined as Online: difference between Sales $ - COGS $ |
| Sales |
Online Sales $ Incl GST |
Sales $ (Incl GST) of a transaction in Locations defined as Online |
| Sales |
Online Units |
Units Sold in Locations defined as Online |
| Sales |
Online # Sales Trnx |
Number of Sales Transactions in Locations defined as Online |
| Sales |
Online % Sales Trnx |
# Online Sales Transactions as a % of Total # Sales Transactions |
| Sales |
Online Average Transaction Value |
Average Sales value for each Sales Transaction in Locations defined as Online |
| Sales |
Online Avg Transaction Value Incl GST |
Average Sales value (Incl GST) for each Sales Transaction in Locations defined as Online |
| Sales |
Online Units Per Transaction |
The average number of Units Purchased in a Transaction in Locations defined as Online |
| Sales |
Online Temp Discount $ |
Temp Discount value at time of Sales. incl both POS and Promo discount in Locations defined as Online |
| Sales |
Online Temp Discount % |
Temp Discount amount as a % of pre discount value at the time of sale in Locations defined as Online |
| Sales |
Online Perm Markdown $ |
Markdown value at time of Sales in Locations defined as Online |
| Sales |
Online Perm Markdown Discount % |
Perm markdown Sales $ as a % of Sales $ before Perm markdown amount deducted in Locations defined as Online |
| Sales |
OnlineTotal Discount $ |
Value of Total Discount applied to the transaction in Locations defined as Online, ie Temp Discounted + Perm Markdown |
| Sales |
OnlineTotal Discount % |
Total Discount $ value as a % of the Sales before Total Discount $ value in Locations defined as Online |
| Sales |
Online Net Returns $ |
Net Returns $ value after Returns and Sales (for eg Exchanges) in one Transaction in Locations defined as Online |
| Sales |
Online Net Returns # Sales Trnx |
# Net Returns Sales Transactions in Locations defined as Online |
| Sales |
Online Net Returns % Sales Trnx |
Net Returns Sales Transactions as a % of Sales Transactions in Locations defined as Online |
| Sales |
Online Returns $ |
Total $ value of the Returns Transaction in Locations defined as Online |
| Sales |
Online Returns $ % |
Returns $ as a % of the total Sales $ excluding Returns in Locations defined as Online |
| Sales |
Online Returns # Sales Trnx |
# Return Sales Transactions in Locations defined as Online |
| Sales |
Online Net Returns Units |
Net Returns Sales Units in Locations defined as Online |
| Sales |
Online Returns Units |
Total Units of the Returns Transaction in Locations defined as Online |
| Sales |
# Selling SKUs |
Count of the number of Style / Colour / Size level of a product available to sell |
| Sales |
# Selling Stores |
Count of the number of Stores available to sell |
| Sales |
Sales $ Per store |
Average Sales $ per Store with Sales Transactions |
| Sales |
Units Sold Per Store |
Average number of Units Sold per Store with Sales Transaction |
| Sales |
Sales $ Per Sku |
Average Sales $ per # Sales Transactions at the Style / Colour / Size level of a product |
| Sales |
Units Sold Per Sku |
Average Sales Units per # Sales Transactions at the Style / Colour / Size level of a product |
| Sales |
Weeks Cover Units Last 4 Weeks |
Calculates the weeks of Available Stock, based on the average Sales Units for the given time period |
| Sales |
Weeks Cover Units Last 7 Days |
Calculates the weeks of Available Stock, based on the average Sales Units for the given time period |
| Sales |
Weeks Cover Units Last 8 Weeks |
Calculates the weeks of Available Stock, based on the average Sales Units for the given time period |
| Sales |
Weeks Cover Cost Last 4 Weeks |
Calculates the weeks of Available Stock, based on the average Sales at Cost for the given time period |
| Sales |
Weeks Cover Cost Last 7 Days |
Calculates the weeks of Available Stock, based on the average Sales at Cost for the given time period |
| Sales |
Weeks Cover Cost Last 8 Weeks |
Calculates the weeks of Available Stock, based on the average Sales at Cost for the given time period |
| Sales |
Weeks Cover Retail Last 4 Weeks |
Calculates the weeks of Available Stock, based on the average Sales at Retail for the given time period |
| Sales |
Weeks Cover Retail Last 7 Days |
Calculates the weeks of Available Stock, based on the average Sales at Retail for the given time period |
| Sales |
Weeks Cover Retail Last 8 Weeks |
Calculates the weeks of Available Stock, based on the average Sales at Retail for the given time period |
| Sales |
Sell Thru % Units |
Sales units as a % of Opening Stock on Hand (calculated as Sales U + CSOH U) |
| Sales |
Sell Thru % Units Accum |
Lifetime Sales units as a % of Opening Stock on Hand (calculated as Sales U + CSOH U) |
| Sales |
Sell Thru % Cost |
Sales at COGS $ as a % of Opening Stock on Hand C$ (calculated as Sales C$ + CSOH C$) |
| Sales |
Sell Thru % Cost Accum |
Lifetime Sales at COGS $ as a % of Opening Stock on Hand (calculated as Sales C$ + CSOH C$) |
| Sales |
Named # Sales Trnx |
Distinct count of # Sales Transactions that have a Member ID attached to the Sales Transaction |
| Sales |
Named # Sales Trnx (All Stores) |
Distinct count of # Sales Transactions that have a Member ID attached to the Sales Transaction |
| Sales |
Named % Sales Trnx |
Sales Transactions that have a Member ID attached to the Sales Transaction as a % of Total # Sales Transactions. Named # Sales Trnx / # Sales Trnx |
| Sales |
Named % Sales Trnx (All Salespeople) |
Sales Transactions for all Salespeople that have a Member ID attached to the Sales Transaction as a % of Total # Sales Transactions. Best used to benchmark individual Salesperson results against all Salespeople result. Named # Sales Trnx (All Salespeople) / # Sales Trnx |
| Sales |
Named % Sales Trnx (All Stores) |
Sales Transactions that have a Member ID attached to the Sales Transaction as a % of Total # Sales Transactions. Best used to benchmark individual Stores results against all Stores result. Named # Sales Trnx (All Stores) / # Sales Trnx |
| Sales |
Named # Sales Trnx with Email |
Sales Transactions that have a Member ID (with an email recorded for that member) attached to the Sales Transaction as a % of Total # Sales Transactions. Named # Sales Trnx / # Sales Trnx |
| Sales |
Named % Sales Trnx with Email |
Sales Transactions that have a Member ID (with an email recorded for that member) attached to the Sales Transaction as a % of Total # Sales Transactions. Named # Sales Trnx / # Sales Trnx |
| Sales |
Named % Sales Trnx with Email (All Salespeople) |
Sales Transactions for all Salespeople that have a Member ID (with an email recorded for that member) attached to the Sales Transaction as a % of Total # Sales Transactions. Best used to benchmark individual Salesperson results against all Salespeople result. Named # Sales Trnx (All Salespeople) / # Sales Trnx |
| Sales |
Named % Sales Trnx with Email (All Stores) |
Sales Transactions that have a Member ID (with an email recorded for that member) attached to the Sales Transaction as a % of Total # Sales Transactions. Best used to benchmark individual Stores results against all Stores result. Named # Sales Trnx (All Stores) / # Sales Trnx |
| Sales |
Unnamed # Sales Trnx |
Distinct count of # Sales Transactions that do not have a Member ID attached to the Sales Transaction |
| Sales |
Unnamed % Sales Trnx |
Sales Transactions that do not have a Member ID attached to the Sales Transaction as a % of Total # Sales Transactions. Unnamed # Sales Trnx / # Sales Trnx |
| Sales |
Named Sales $ |
Sales $ that have a Member ID attached to the Sales Transaction |
| Sales |
% Named Sales $ |
Sales $ that have a Member ID attached to the Sales Transaction as a % of all Sales $ |
| Sales |
Unnamed Sales $ |
Sales $ that do not have a Member ID attached to the Sales Transaction |
| Sales |
% Unnamed Sales $ |
Sales $ that do not have a Member ID attached to the Sales Transaction as a % of all Sales $ |
| Sales |
Named Sales Units |
Sales Units that have a Member ID attached to the Sales Transaction |
| Sales |
% Named Sales Units |
Sales Units that have a Member ID attached to the Sales Transaction as a % of all Sales Units |
| Sales |
Unnamed Sales Units |
Sales Units that do not have a Member ID attached to the Sales Transaction |
| Sales |
% Unnamed Sales Units |
Sales Units that do not have a Member ID attached to the Sales Transaction as a % of all Sales Units |
| Sales |
# Existing Named Sales Trnx |
calculation of Named # Sales Trnx - # New Named Sales Trnx |
| |
|
|
