Below is a bucket list of all of the Metrics Toolio comes out of the box with. If you want to learn more about metrics before diving into this list, please see the Metrics - Overview article first. You can see these Metrics in the Grid Format as well.

Gross Sales Ticket

Topline sales prior to returns and allowances (i.e. markdowns and discounts). Measured in ticket value.

Formula:

{gross_sales_retail} + {markdown} + {discount}

Gross Sales Retail

Topline sales prior to returns, but after allowances (i.e. markdowns and discounts). Measured in retail value.

Actualization:

{sale__sales_retail}

Gross Sales Units

Topline sales prior to returns. Measured in units.

Actualization:

{sale__sales_units}

Gross Sales Cost

Topline sales prior to returns. Measured in cost value.

Actualization:

{sale__sales_cost}

Gross Sales AUC

Average Unit Cost of Gross Sales

Formula:

{gross_sales_cost} / {gross_sales_units}

Gross Sales AUR

Average Units Retail (i.e. retail value) of Gross Sales

Formula:

{gross_sales_retail} / {gross_sales_units}

Gross Sales AIR

Average Initial Inventory at Retail (i.e. ticket value) of Gross Sales

Formula:

{gross_sales_ticket} / {gross_sales_units}

Gross Sales Margin

Formula:

{gross_sales_retail} - {gross_sales_cost}

Gross Sales Margin %

Formula:

({gross_sales_retail} - {gross_sales_cost}) / {gross_sales_retail}

Markdown

Markdowns are price reductions on items. These are reductions that are marked on the price tags, so they are also known as redlines. Markdowns cover all reductions that happen prior to the point of sale (POS).

Actualization:

{sale__markdown}

Markdown %

Formula:

{markdown} / {gross_sales_ticket}

Discount

Discounts are one-time price reductions applied at the point of sale (POS). Employee discounts or special promos for a weekend are some examples of these.

Actualization:

{sale__discount}

Discount %

Formula:

{discount} / {gross_sales_ticket}

Returns Ticket

Returns, measured in ticket value.

Actualization:

{sale__returns_ticket}

Returns Retail

Returns, measured in retail value.

Actualization:

{sale__returns_retail}

Returns Units

Actualization:

{sale__returns_units}

Returns Cost

Actualization:

{sale__returns_cost}

Returns AUC

Formula:

{returns_cost} / {returns_units}

Returns AUR

Formula:

{returns_retail} / {returns_units}

Returns AIR

Formula:

{returns_ticket} / {returns_units}

Returns Margin

Formula:

{returns_retail} - {returns_cost}

Returns Margin %

Formula:

({returns_retail} - {returns_cost}) / {returns_retail}

Returns Rate Retail

Formula:

{returns_retail} / {gross_sales_retail}

Returns Rate Units

Formula:

{returns_units} / {gross_sales_units}

Returns Rate Cost

Formula:

{returns_cost} / {gross_sales_cost}

Returns Rate Margin

Ratio of the margin that was returned and margin that was in gross sales. This gives an idea of whether more or less profitable items are being returned.

Formula:

{returns_margin} / {gross_sales_margin}

Net Sales Ticket

Formula:

{gross_sales_ticket} - {returns_ticket}

Net Sales Retail

Formula:

{gross_sales_retail} - {returns_retail}

Net Sales Units

Formula:

{gross_sales_units} - {returns_units}

Net Sales Cost

Formula:

{gross_sales_cost} - {returns_cost}

Net Sales AUC

Formula:

{net_sales_cost} / {net_sales_units}

Net Sales AUR

Formula:

{net_sales_retail} / {net_sales_units}

Net Sales Margin

Formula:

{net_sales_retail} - {net_sales_cost}

Net Sales Margin %

Formula:

({net_sales_retail} - {net_sales_cost}) / {net_sales_retail}

BOP Ticket

Beginning of period inventory measured at ticket value.

Formula:

PREVIOUS({eop_ticket})

BOP Retail

Beginning of period inventory measured in retail value.

Formula:

PREVIOUS({eop_retail})

BOP Units

Formula:

PREVIOUS({eop_units})

BOP Cost

Formula:

PREVIOUS({eop_cost})

BOP AUC

Formula:

PREVIOUS({eop_cost}) / PREVIOUS({eop_units})

BOP AUR

Formula:

PREVIOUS({eop_retail}) / PREVIOUS({eop_units})

BOP AIR

Formula:

PREVIOUS({eop_ticket}) / PREVIOUS({eop_units})

BOP Margin

Formula:

PREVIOUS({eop_retail}) - PREVIOUS({eop_cost})

BOP Margin %

Formula:

(PREVIOUS({eop_retail}) - PREVIOUS({eop_cost})) / PREVIOUS({eop_retail})

EOP Ticket

End of period inventory, measured in ticket value.

Actualization:

{inventory__total_ticket}

EOP Retail

End of period inventory, measured in retail value.

Actualization:

{inventory__total_retail}

EOP Units

End of period inventory, measured in units.

Actualization:

{inventory__units}

EOP Cost

End of period inventory, measured in cost value.

Actualization:

{inventory__total_cost}

EOP AUC

End of period inventory, average unit cost.

Formula:

{eop_cost} / {eop_units}

EOP AUR

End of period inventory, average unit retail.

Formula:

{eop_retail} / {eop_units}

EOP AIR

End of period inventory, average initial retail.

Formula:

{eop_ticket} / {eop_units}

EOP Margin

Formula:

{eop_retail} - {eop_cost}

EOP Margin %

Formula:

({eop_retail} - {eop_cost}) / {eop_retail}

Average Inventory Cost

Formula:

({eop_cost} + PREVIOUS({eop_cost})) / 2

On Order Ticket

Purchase Orders that are meant to be received in given time period, measured in ticket value.

Actualization:

({purchase_order_item_2__order_units} - {purchase_order_item_2__received_units}) * {purchase_order_item_2__unit_retail}

On Order Retail

Purchase Orders that are meant to be received in given time period, measured in retail value.

Actualization:

({purchase_order_item_2__order_units} - {purchase_order_item_2__received_units}) * {purchase_order_item_2__unit_retail}

On Order Units

Actualization:

{purchase_order_item_2__order_units} - {purchase_order_item_2__received_units}

On Order Cost

Actualization:

({purchase_order_item_2__order_units} - {purchase_order_item_2__received_units}) * {purchase_order_item_2__unit_cost}

On Order AUC

Formula:

{on_order_cost} / {on_order_units}

On Order AUR

Formula:

{on_order_retail} / {on_order_units}

On Order Margin

Formula:

{on_order_retail} - {on_order_cost}

On Order Margin %

Formula:

({on_order_retail} - {on_order_cost}) / {on_order_retail}

Receipts Ticket

Purchase Orders that are received in the given time period, measured in ticket value.

Actualization:

{purchase_order_item_2__received_units} * {purchase_order_item_2__unit_retail}

Formula:

{eop_ticket} + {gross_sales_ticket} - {returns_ticket} + PREVIOUS({eop_ticket})

Receipts Retail

Purchase Orders that are received in the given time period, measured in retail value.

Actualization:

{purchase_order_item_2__received_units} * {purchase_order_item_2__unit_retail}

Formula:

{eop_retail} + {net_sales_retail} - PREVIOUS({eop_retail})

Receipts Units

Actualization:

{purchase_order_item_2__received_units}

Formula:

{eop_units} + {net_sales_units} - PREVIOUS({eop_units})

Receipts Cost

Actualization:

{purchase_order_item_2__received_units} * {purchase_order_item_2__unit_cost}

Formula:

{eop_cost} + {net_sales_cost} - PREVIOUS({eop_cost})

Receipts AUC

Formula:

{receipts_cost} / {receipts_units}

Receipts AUR

Formula:

{receipts_retail} / {receipts_units}

Receipts AIR

Formula:

{receipts_ticket} / {receipts_units}

Receipts Margin

Formula:

{receipts_retail} - {receipts_cost}

Receipts Margin %

Formula:

({receipts_retail} - {receipts_cost}) / {receipts_retail}

IMU

Initial Markup applied on products to get to Gross Sales Ticket

Formula:

1 - ({gross_sales_cost} / {gross_sales_ticket})

ST Retail

Sell Through %, measured in retail value. This is a measure of the % of beginning inventory and receipts have been sold in the time period.

Formula:

({gross_sales_retail} - {returns_retail}) / ({eop_retail} + {gross_sales_retail} - {returns_retail})

ST Units

Formula:

({gross_sales_units} - {returns_units}) / ({eop_units} + {gross_sales_units} - {returns_units})

ST Cost

Formula:

({gross_sales_cost} - {returns_cost}) / ({eop_cost} + {gross_sales_cost} - {returns_cost})

WOS Retail

Weeks of Supply remaining, measured in retail value.

Formula:

LAST({eop_retail}) / AVERAGE({gross_sales_retail})

WOS Units

Formula:

LAST({eop_units}) / AVERAGE({gross_sales_units})

WOS Cost

Formula:

LAST({eop_cost}) / AVERAGE({gross_sales_cost})

Turn Retail

Inventory Turn, measured in retail value.

Formula:

(SUM({gross_sales_retail}) - SUM({returns_units})) / AVERAGE({eop_retail})

Turn Units

Formula:

(SUM({gross_sales_units}) - SUM({returns_units})) / AVERAGE({eop_units})

Turn Cost

Formula:

(SUM({gross_sales_cost}) - SUM({returns_cost})) / AVERAGE({eop_cost})

GMROI

Gross Margin Return on Inventory Investment

Formula:

(SUM({gross_sales_retail}) - SUM({gross_sales_cost})) / AVERAGE({eop_cost})

Open to Buy Retail

Open To Buy, measured in retail value. This give an indicator of how much more should be invested to meet the receipts targets to meet the desired end of period inventory position.

Formula:

{receipts_retail} - {on_order_retail}

Open to Buy Units

Formula:

{receipts_units} - {on_order_units}

Open to Buy Cost

Open To Buy, measured in cost value. This give an indicator of how much more should be invested to meet the receipts targets to meet the desired end of period inventory position. This is typically the appropriate way to look at Open to Buy, since cash-flow will be happening in Cost.

Formula:

{receipts_cost} - {on_order_cost}

Open to Buy Margin

Formula:

({receipts_retail} - {on_order_retail}) - ({receipts_cost} - {on_order_cost})

Open to Buy Margin %

Formula:

(({receipts_retail} - {on_order_retail}) - ({receipts_cost} - {on_order_cost})) / ({receipts_retail} - {on_order_retail})

Open to Buy AUR

Formula:

({receipts_retail} - {on_order_retail}) / ({receipts_units} - {on_order_units})

Open to Buy AUC

Formula:

({receipts_cost} - {on_order_cost}) / ({receipts_units} - {on_order_units})

New Styles

Actualization:

IS_IN_TIME_PERIOD('{product_2__first_sale_date}') ? '{variant__product_id}' : null

Styles per Week

Actualization:

'{variant__product_id}'

FWD WOS Retail

Formula:

FWOS({eop_retail},{gross_sales_retail})

FWD WOS Units

Formula:

FWOS({eop_units},{gross_sales_units})

FWD WOS Cost

Formula:

FWOS({eop_cost},{gross_sales_cost})
Did this answer your question?