ML Forecasting

ML Forecasting uses machine learning to predict future data by using historical data about your business.

We use this to forecast certain key business metrics such as:

Mega Report Row	Formula
Revenue	ForecastedForecast Revenue per location per day/week/month
Hours	ForecastedForecast Hours per location per day/week/month
Revenue Per Hour	Forecast Revenue divided by Forecast Hours (this value itself is not forecasted,forecast, it is calculated)

We plan to support more dataforecast types over timetime, but are currently prioritizingprioritising dataforecast accuracy ratherbefore thanexpanding "forecaststo forother everything"statistics

Where can I see these forecasts?

These forecasts are available on the Mega Report if you have ML forecasting available on your plan. If you can't see them then it's possible that they are hidden in your current view, you don't have permission to see those rows, or your account has not been set up correctly. 

All ML Forecast rows can be identified with the "AI Generated Forecast" icon and typically start with 'ML Forecast'. The only available dropdown on these rows is the Location dropdown.

How often are forecasts generatedgenerated?

Forecasts are automatically generated for the next 12 months at the start of every month. Additionally, a special control panel to generate updated forecasts is available to users on some plans. 

Generating forecasts more frequently than once a month is not as insightful as it may appear because even a "record setting" great week or "worst we have ever had bad week" is only one week of data that contributes to a forecast that is potentially looking at multiple years of historical business performance. 

Forecast Tagging ('quarterly' forecasts)

By default each forecast row shows the latest data we have forecastedforecast for that metric. For example, as you get closer to December the ML forecast will be updating monthly (and when you trigger it) to ensure that you have the most accurate forecast based on the most up-to-date data. 

Some of our clients also like to "lock in" a forecast, typically for a quarter or year so they can then measure actual business performance against the original forecast. For this we have Forecast Tags. This allows you to tag a specific forecast run with a label. In the screenshot below we have generated a forecast on October 1st, 2023 and then created the Quarterly tag. This allows us to add a second set of ML forecast rows to the Mega Report (as seen in the above screenshot):

• ML Forecast Revenue: our latest (most accurate) forecast for this period
• ML Forecast Revenue Quarterly: the most recent forecast containing the 'Quarterly' tag (aka. the 'locked in October 1st) forecast. 

This tag can be added by any manager accounts by visiting Company Settings -> ML Forecasts then creating an appropriate tag.

Can all data be forecasted?forecast?

The short answer is "NoNo". ForecastingOur essentiallyforecasting looks for trends across multiple seasonalities (such as day-of-week, month-of-year, year-on-yearetc) etc).plus an underlying growth rate. This makesis itnot harderuseful towhen forecastforecasting erratic values or values that are ratios such as Hours Per ClientClient, which has been demonstrated to vary month-to-month in most of our clients without a clear trend.

Questions and Feedback

This is new technology that is constantly evolving. If you have any questions, feedback or suggestions please Contact Us and let us know.