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 overview 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 how it works 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 (with each level's required attribute(s)) total daily forecast no fields required customer type daily forecast is new customer subcategory daily forecast variant product subcategory note if the variant product subcategory is filled, the corresponding variant product category must be filled as well, otherwise it will appear as not provided category daily forecast variant product category customer type by category forecast is new customer variant product category full detail forecast is new customer variant product category variant product subcategory planned forecasts variances explore 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