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).
The total Sales After Returns derived from the comparable period in the prior year adjusted with an estimated sales value for products with limited historical data.
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).
Recommended Retail Price (RRP) provided by the supplier of the product in local currency. Price should include taxes if a non-zero tax rate is set for the project.
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 the Liquidation End Date and write-offs from leftover stock at that date. To calculate this, the system predicts "Sales until Liquidation End" by scaling short-term predicted sales using the Benchmark Sell-Through Rate. The total profit is the sum of 1) Profit until Liquidation End = Profit per Unit * Predicted Sales until Liquidation End (using Current and Future Stock) 2) Write-off at Liquidation End = Liquidation End Stock * (Liquidation End Value - Purchase Price)
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
The predicted amount of Stock at the Liquidation End Date. This is calculated by taking the sum of the current Stock plus the Stock from Expected Returns plus the Future Stock and then subtracting the Predicted Sales expected to occur until the Liquidation End Date.
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
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
The predicted Sell-Through Rate at the Liquidation End Date. It is calculated as the ratio of "Cumulative Predicted Units Sold" to "Total Potential Stock." 1) Cumulative Predicted Units Sold = Sum of historical units sold since the Liquidation Start Date plus predicted net sales (forecasted units minus expected returns) until the Liquidation End Date. 2) Total Potential Stock = Sum of historical sales since the Liquidation Start Date and all current and future inventory (including allocated stock at start-of-day, expected returns, and client-provided future stock).
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.
The percentage difference between the Optimal Price and the Baseline Price Ordering. This indicates how the long-term historic price should be adjusted for the next order 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. For markets where prices are displayed to customers before tax (e.g., North America), set this value to 0. For all other markets where prices include tax, provide the decimal rate used to calculate net revenue from the gross price (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.