๐Ÿ“– Metric Definition

So many metrics... what do they all mean?!?

Maddy avatar
Written by Maddy
Updated over a week ago

To search for a metric, use the Table of Contents dropdown above. ๐Ÿ‘†
(If you are on our Help Center webpage, click the metric titles on the right ๐Ÿ‘‰)

A

Adjusted Units

Any variance between Stock Units (Stock on Hand), PO Received, Sales Units and Returns within the week. Usually shrinkage/system processing delays

Available To Sell | ATS

Closing Stock Units + Sales Units After Returns, which is how you would calculate Opening Stock on Hand (OSOH) manually, however, ATS and OSOH have few differences.

For example:

ATS differs from OSOH in the following ways:

  • ATS includes inventory that was DELIVERED during the period (OSOH does not)

  • ATS excludes inventory that was returned or transferred out during the period (whereas this WILL show up in OSOH)

If there are no transfers or Intake ATS will equal OSOH

Available To Sell @ Retail

Available to Sell x RRP

Average 4-Week Cover | Avg 4wk Cover

Current Week's Stock Units / Average Sales Units (after returns) of the last 4 weeks

Average Selling Price | ASP

Sales revenue before returns ex-tax, divided by sales units before returns

Average Stock Units | Average Stock U

Based on the average weekly closing stock over the time period you have selected.

Calculated by taking the Sum of Closing Stock U / Number of weeks in the selected timeframe

Average Stock @ Cost | Average SOH @ Cost

Calculated by taking Average Stock on Hand x Cost Price

C

Cost of Goods Sold | COGS

Mapped directly from the source system, or calculated by taking cost price x sales units after returns or before returns

Conversion Rate % Gross | CR% (G)

Sales $ Before Returns / Page views

Conversion Rate % Net | CR% (N)

Sales $ After Returns / Page views

Click Through Rate % | CTR%

Product List Clicks / Impressions

D

Discount After Returns | Discount AR

the value difference between the RRP or sell price (if the product is marked down) and the sales generated from the order.
Calculation = Total markdown $ - markdown $

Note: This metric is only available in the latest Shopify integration

F

First 4-week Rate of Sales | 1st 4W ROS

Average units sold in the first 4 weeks of Sales (after returns)

First Margin | FM % - Available on Product Page ONLY

((RRP/1.1) - Cost Price)/(RRP/1.1)

First Size Broken | 1st Size Broken - Available on Product Page ONLY

Shows the size that sold out first

First Week a Size Broke | 1st Week A Size Broke - Available on Product Page ONLY

Shows the week that the first size went out of stock

First x Week average sell through % | First x week rating

The week number is subjected to individual businesses, this shows the product's average sell through within the first x number of weeks of since launched

Full Price Sell Through % | FP ST %

Sales Units After Returns Full Price/ ATS (Available to sell)

Full Price Sales Units

Sales units when the productโ€™s price = RRP

Note: This metric is only available in the latest Shopify version

Future Orders

This metric shows the sum of all units that are currently on order, to be delivered at a future date for a product

Note: If you have a date range filter on, it might prevent some future orders from showing. We highly recommend reviewing future orders with your date range removed or in the product detail page for most accurate information.

Future Transfer

The in transit units that have not yet arrived at the intended store/warehouse

Style Arcade determines whether units as in transit or received by reading the due date of the movement

Note: This metric is only available to selected system integrations

G

GMROI

Used to analyse the profitability of inventory purchases. The calculation measures the cost of the average inventory compared to the gross margin you receive from selling it.


Calculated by taking Gross Profit After Returns / Average Stock @ Cost

Gross Profit Before Return $ | GP BR

Calculated by taking Sales $ Before Returns - Cost of Goods Sold Before Returns

Gross Profit After Return $ | GP AR

Calculated by taking Sales $ After Returns - Cost of Goods Sold After Returns

Gross Profit % Before Returns

Calculated by taking a percentage of Gross Profit Before Returns $ / Sales Before Returns $

Gross Profit % After Returns

Calculated by taking a percentage of Gross Profit After Returns $ / Sales After Returns $

I

Impressions

The number of times the user sees either a product image or thumbnail

L

Last Received Date / Week / Month

The date/week/month on which you last received stock in the selected store/location in the selected time period

Launch Date / Week / Month

The date/week/month a product was launched in any given store or online. For more info on how the launch date is calculated please check out this article

Last 4-Week Rate of Sales | Last 4W ROS

Average units sold in the last 4 weeks of Sales (after returns)

Last x Week Average Sell Through % | Last x Week Rating

The week number is subjected to individual businesses, this shows the product's average sell through within the last x number of weeks

M

Markdown After Returns | MD AR

This is your red pen discount revenue. Essentially showing the value difference between the RRP and the sell price (exc tax).
Calculation = ((RRP ex tax)-(sell price ex tax)) x markdown sales units

Markdown % | MD % - Available on Product Page ONLY

This is the & difference between your RRP and the current selling price.

Calculation = 1 - (Selling Price / RRP) all ex tax

Markdown Sales Units

Sales units when the productโ€™s price > RRP

Note: This metric is only available in the latest Shopify version

P

Page Views

The number of times a page has been viewed on a website

Price Status

Price Status is dependent on the time you selected
Full Price = Selling at full price or at RRP
Markdown = Item has a red pen discount applied
Unknown = When the sell price is at 0 or unavailable


Product List Clicks

The number of times the users clicked the product when it appeared in the product list


Products Count (Range Plan)

How many individual styles within the time selected based on product code
โ€‹

Products Count (Fashion Analytics)

Count of products that made sales or held stock within the time frame selected

Projected Return

To calculate the projected return, we consider the expected number of returns based on the current return rate (RR%) of the product and the remaining stock.

For instance, if the RR% is 10% and there are 100 units remaining, the projected returns would be estimated at 10 units.

Purchase Order @ Retail

PO Received Unit x RRP (ex tax)

R

Rate of Sale Before Returns | ROS BR

Sales Units Before Returns SINCE LAUNCHED / Number of weeks SINCE LAUNCHED

Rate of Sale After Returns | ROS AR

Sales Units After Returns SINCE LAUNCHED / Number of weeks SINCE LAUNCHED

Returned Units | Returns

Returns are attributed to the week they are returned/processed

Return Rate % | RR%

Returned Units % of Sales Before Returns


Recommended Retail Price | RRP

Inclusive of tax. Please refer this article for the most updated tax rates in Style Arcade

S

Sales After Returns | Sales AR

Sales $'s after returns and discounts

Sales Before Returns | Sales BR

Sales $'s before returns and after discounts

Sales Units After Returns | Sales U AR

The net sales units, calculated by taking Sales Units Before Returns - Returned Units

Sales Units Before Returns | Sales U BR

The gross sold units

Sales Units This Week | Sls U TW

Sales units after returns of the selected week in your date range

Sales Units This Week - 2 | Sales U - 2

Sales units after returns 2 weeks before your selected week

Sales Units This Week - 3 | Sales U - 3

Sales units after returns 3 weeks before your selected week

Sell Price

The selling price of the product at the end of the selected week

Size Availability % | SizeA(S)%

Count of Sizes in Stock / Count of Total Sizes Bought

Spot Cover

Shows how many more weeks the current stock will last based on the last full week's sales.

  • When users time slice on a partial week, calculation = current stock units / last full week's sales units. If the sales unit after returns is zero or negative then it will show the actual stock units of the current week.

  • When users time slice on a period with full weeks of sales, calculation = closing stock units/ sales units after returns of the last week in the time-sliced period

  • If the current week is the product's first active week then it will show actual stock units

Sell Through % | ST %

Sales Units After Returns (Sales U AR)/Available to Sell (ATS) of the selected period


Sell Through Velocity | ST Velocity - Available on Product Page ONLY

Average Weekly Sell Through of the product in the first or last X weeks (customer dependent)

Stock Units | Stock U

Stock on Hand Units or Closing Stock Units (when looking at historical sales data)

Stock @ Cost

Stock at original cost price. Calculated by Cost price x Stock Units

Stock @ Sell Price

Stock value at sell price ex GST. Calculated by (Sell Price ex tax rounded) x Stock Units

Stock @ Retail

Stock value at original retail ex GST. Calculated by Stock units x RRP

T

Total Markdown (MD) $

The difference between (sales units after returns X RRP ex tax) and (sales after returns). This includes both markdowns & discounts.

Total Markdown (MD) %

Calculation is 1 - [Sales Revenue / (Sales U AR x RRP (ex tax))]. This metric is time-sliceable.

Total Sell Through %

The to-date sell-through % since the product's gone live.

Transferred U

The units that were transferred in from another store/warehouse

Note: This metric is available to selected system integrations

True Rate of Sale | TROS

Showing what you could have sold if you were always in stock of all sizes.

Calculated using sales units before or after returns of the selected timeframe / number of weeks the sizes were in stock

V

Variance %

All variance % metrics are a comparison of this year vs last year.

E.g. Sales Units After Returns Variance % = Sales Units After Returns / Sales Units After Returns - 1

W

Weighted Size Availability | SizeA(W)%

Units Bought in Sizes Still Available / Total Units Bought

Weeks Active | Wks Active - Available on Product Page ONLY

How many weeks a product was in stock and able to make sales after the launch date

If a product sells out and comes back into stock it will calculate from the original launch date. This also takes into account if a time filter is applied

Weeks Age | Wks Age - Available on Product Page ONLY

How many weeks has the product been in the business since its 1st date of launch

Not affected by time filters

Did this answer your question?