Planned Forecasts
Note: Our Model Amplifications feature only accepts files in CSV format at this time. Please make sure the files you upload are CSV files.
Chord Performance brands can now upload their daily planned forecasts of gross and net revenue along with number of orders and number of customers. With this, brands can now track their store performance comparing their forecasts with actuals.
This amplification allows input of data at different levels of detail.
- The fields Date an Forecast Version Name are required and cannot be left blank.
- The fields Is New Customer, Variant Product Category, and Variant Product Subcategory can be left blank to forecast different level of details:
- When Is New Customer is left blank it will be considered as All type of customers, meaning both new and returning customers.
- When Variant Product Category is left blank it will be considered as All product categories.
- When Variant Product Subcategory is left blank it will be considered as All product subcategories.
- Fill the rest of the fields with the forecasted value. Take into account the definition of each metric:
- Gross Revenue: Gross revenue of the orders calculated as item_total + fulfillment_total
- Net Revenue: Net revenue of the orders calculated as item_total + fulfillment_total - promo_total - refund_total
- Fulfillment Total: The total shipping revenue
- Promo Total: The total discounts applied to the price of the order
- Refund Total: The total refund transactions applied to the order
Based on the above, there are six (6) possible levels of detail in this amplification:
- Total Daily Forecast
- Customer Type Daily Forecast
- Subcategory Daily Forecast
- NOTE: If the Variant Product Subcategory is filled, the correspondent Variant Product Category must be filled tool, otherwise it will appear as NOT-PROVIDED.
- Category Daily Forecast
- Customer Type by Category Forecast
- Full Detail Forecast
With this amplification, Performance brands now have the ability to log forecasts at different levels of detail and can have several different forecast versions (tracked via the Forecast Version Name in the amplification).
To correctly visualize the data and the variance metrics, you must first filter the explore by selecting one value for Level Of Detail and one for Forecast Version Name (both of these fields are under the group Forecast Parameters).
Once the filters are set, you can drag and drop the desired dimensions and metrics.