Average factor the foreign currency has to be multiplied with to get to values in the main currency (e.g. 1.2 to get from GBP to EUR). This average is derived from the lastest transactions.
Cost of sending the product from the warehouse to the customer minus any shipping revenue paid by the customer in main currency. Outbound cost can include logistic cost, shipment cost, call center cost and payment cost
The EUR value you spend per (sales_before_returns - returns) for volume discount for example, 10% less if you buy 20 items or more, 3% sconto for paying cash, aftersale discount on red price to avoid a return, customer specific discount for a large customer (e.g. Siemens).
Group of products used to estimate the seasonality of the product and its long-term sales potential. This group is also used to calculate the Benchmark Sell Through Rate.
Share of product's Sales Before Returns expected to be sold within the short-term forecast period (default 14 days) divided by Sales Before Returns until the Liquidation End Date
Gross Red Price in local currency from which the corresponding commission rate should be applied. The corresponding commission rate will be applied up to the next highest Start Gross Red Price. If no higher Start Gross Red Price is specified, the corresponding commission rate will be applied to all prices higher than that price.
Split of products by the amount of avg. cross sell in 5 equally large buckets. Cross sell is calculated as the total revenue from other products bought in the same basket over the last 90 days, after the return period, but only when the product was the basket opener, defined as being in the first basket position in at least three orders.
Incremental future profit increase driven by the transaction in main currency. Is typically higher for new customers and customers with higher repurchase rates.
Counts the days since getting the first active price for the product in the market/channel. We use the earliest active price period for the product or the first sale of the product if that happened earlier.
Product's net value in main currency at liquidation end date to calculate the write-off for the seasonal profit calculation. The purchase price is the default value if not specified.
This is the lowest price within the last 30 days or NULL if such a price doesn't need to be displayed according to the "Omnibus Directive" (DIRECTIVE (EU) 2019/2161).
Indicator that determines if the product is available for purchase in the specified period, regardless of stock levels or other factors you are already sending.
Boolean flagging indicating if the product sales are limited by the Stock + Stock From Expected Returns. Using stock capping can lead to automated price increases as the optimizer will avoid to run out of stock. e.g. If there is 10 items on stock, we can't predict to sell more than 10 items over the prediction period.
Ranking of how important a product is for the end customer. Rank 1 identifying the most important product. By default, the ranking is based on historical revenue, the number of competitor prices and the historic margin as KVIs are highly price-sensitive.
Latest factor the foreign currency has to be multiplied with to get to values in the main currency (e.g. 1.2 to get from GBP to EUR), on a channel basis.
Three letter code for main currency according to ISO 4217 that we use for revenue summation across channels with different currencies (e.g. EUR for Euro currency)
Description of the campaign type used to steer the marketing intensity. We support "CpC" in which case marketing_option_float is the Cost per Click steering, "tROAS" in which case marketing_option_float = 100 / tROAS (e.g. 0.25 for a 400% tROAS), "ACoS" in which case marketing_option_float is Advertising Cost of Sale = Marketing Cost / Revenue (e.g. 0.25 for a 25% ACoS)
Costs in main currency of sending these products from the warehouse to the customer. You can add logistic cost, shipment cost, call center cost, and payment cost. And you can subtract shipping revenue paid by the customer.
URL to a Thumbnail of a product picture. Common thumbnail sizes include 75x75, 100x100, 150x150, and up to 300x300 pixels. Typical sizes ranging from 10 KB to 50 KB.
Advertising Cost of Sales, (ACoS), is a marketing metric that measures the efficacy of a digital advertising campaign. It's calculated as Marketing Cost / Revenue Before Returns
Incremental future profit increase by sales before returns in main currency. Is typically higher for new customers and customers with higher repurchase rates.
Sum of net profit from sales until Liquidation End and write-offs from stock left-over at the Liquidation End date for all products in the Optimization Group
Net Advertising Cost of Sales, (Net ACoS), is a marketing metric that measures the efficacy of a digital advertising campaign. It's calculated as Marketing Cost / Revenue After Returns
Cost of sending the product from the warehouse to the customer minus any shipping revenue paid by the customer by product in main currency. Outbound cost can include logistic cost, shipment cost, call center cost and payment cost
Price Change Impact Factor is the predicted sales impact by optimizing prices. It is used to correct the sales from last season in the order optimization.
Ranking of Products/Optimization Groups by suitability for a promotion campaign. By default, it is based on Stock Reach and historic Profit/Sale. However, the exact calculation method can be adjusted. As an example, "Promotion Rank <= 100" will select the 100 Products/Optimization Groups most recommended for a promotion in a given sales channel.
Return On Advertising Spend, (ROAS), is a marketing metric that measures the efficacy of a digital advertising campaign. It's calculated as Revenue before Returns / Marketing Cost
Percentage of Purchase Price that is left of the net product price after subtracting all inbound and outbound related costs. (Net Price - (Inbound Cost + Outbound Cost)) / Purchase price
Predicted incremental future profit increase driven by the transaction in main currency. Is typically higher for new customers and customers with higher repurchase rates.
Cost of sending the product to the customer minus any shipping revenue paid by the customer in main currency. Outbound cost can include logistic cost, shipment cost, call center cost and payment cost
Direction of price change for optimal price compared to current price. Price Increase if optimal price is higher than current price, Price Reduction if optimal price is lower than current price. No Change if optimal price is equal current price.
Difference between the optimal price and the Prev Gross Red Price Ordering in %. This gives an indication how the long-term historic price should change for the next ordering period.
Sum of predicted profit in the optimization divided by the sum of the actual profit over the same period of time. Values close to 100% indicate good predictability.
The sum of net landed cost of all products sold in the transaction, including freight cost from the production facility to the warehouse, customs duties, tariffs, insurance, handling fees, and any other import-related expenses in main currency (i.e., COGS or cost of goods sold).
Net landed cost of a single unit sold, including freight cost from the production facility to the warehouse, customs duties, tariffs, insurance, handling fees, and any other import-related expenses in main currency (i.e., COGS or cost of goods sold).
Sum of predicted sales before returns in the optimization divided by the sum of the actual sales before returns over the same period of time. Values close to 100% indicate good predictability.
(Sales after Returns since Liquidation Start Date - Stock From Expected Returns)/ (Sales after Returns since Liquidation Start Date + Stock) - for the Optimization Group of the product.
Rate of sales tax used to calculate net revenue from gross price. This value must be provided as a decimal (e.g. 0.19 for 19% for most products in Germany)
tROAS (Target Return on Ad Spend) is a bid strategy used in digital advertising where you can set a desired return on ad spend as a percentage. tROAS = Revenue Before Returns/Marketing Cost
The sales domain where prices will be uploaded (e.g., amazon.de for Amazon sales channel). This is used to distinguish the primary channel in the optimization process from any additional sub-channel where prices are uploaded (e.g., zafr for Zalando France if optimized prices should be sent via an API call to tradebyte).
The factor by which the foreign currency has to be multiplied to convert to values in the main currency (e.g., 1.2 to convert from GBP to EUR). This is used to differentiate conversion factors from any additional sub-channel definitions.
The currency code according to ISO 4217 format (e.g., EUR for Euro). This is used to differentiate the channel currency from any additional sub-channel definitions.
The day on which the optimization effectively ended, either because the optimization end date was reached, or because subsequent optimizations took over.
The country code according to ISO 3166 format (e.g., DE for Germany). This is used to differentiate the market ISO code from any additional sub-channel definitions.