Read Watched Product

Products above the last group (the tail, no sales) of the store's latest captured bestseller list, also on a capped list: tail_start - 1, the denominator of bestseller_top_percent. Null without a list or for an empty list.

The top percent of the store's sold products on its latest captured bestseller list the product is in: ceil(bestseller_rank * 100 / (tail_start - 1)), tail_start - 1 = bestseller_sold_count, the products above the list's last group (the tail), also on a capped list; 1-100, 1 = the best 1 %. Lists are captured up to 25,000 products. Null without a rank or a list, and for a product in the last group.

A lower bound of the units the product sold per day, from how far it climbed the groups of its store's Shopify bestseller list between two snapshots scaling_days apart. Null without two comparable lists or when the product had no sales in the older one; 0 = no climb measured. Lags real sales.

Days between the two bestseller snapshots scaling_units_per_day compares.

F3: the climb is read against the other products of the product's new group (reliable). F1: the product is alone in its group, so only its own group count is compared (less certain).

The share in percent of the store's sold products (in the older snapshot) the product overtook, net, between the two snapshots scaling_days apart. Only a product that climbed counts; 0 otherwise. Null exactly when scaling_units_per_day is null.

Estimate per #1561 (sales_estimate_expr) from the bestseller rank, with n1, x and u from the store's latest bestseller snapshot; Shopify counts order line items, not units. Unrounded. At least 1 above the tail, 0 in the tail. Null when the product is not ranked or has no snapshot.

How sales_estimate came about: geschaetzt (estimated, the rank is above the tail) or tail (in the tail, no sales known; 0). Null when not ranked or without a snapshot.

Revenue from sales_estimate: sales times the first variant's price, in revenue_currency, unrounded. Null when there is no sales estimate, no readable price or no currency.

Always null until its factor is fitted to the #1561 sales formula; then a one-sided 1 sigma upper bound of the revenue (84 % of comparable products below it), in revenue_currency.

Always null until its factor is fitted to the #1561 sales formula; then a one-sided 2 sigma upper bound of the revenue (97.7 % of comparable products below it), in revenue_currency.

Currency of all revenue fields (the store's currency). Null means no revenue fields.