Help

Deals-Forecasting monthly revenue

Topic Labels: Formulas
1102 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Daniel_Walter
4 - Data Explorer
4 - Data Explorer

Hey,

we partly have a subscription model in our company and our deals are closed for a certain period of time.
For example a deal is closed for 3 months and a new invoice is issued every month.
How can this be easily displayed with airtable in terms of forecasting on monthly revenue bases?(Especially the automatic transfer to the next month)

thanks in advance.

best

1 Reply 1

Hi Daniel, and welcome to the community!

The only reasonable way to do this is with script processes that either run inside Airtable using the Script Block or Custom Script Apps (React Javascript environment). While both of these approaches make forecasting possible, I tend to use a more distant approach with Google Apps Script, NodeJS, or even Julia if I need a compiled app in an embedded device.

But I did create an example using script blocks and it worked pretty well as a demonstration of pure machine-learning in simple javascript. I must warn you though - the code is wonky because it is based on some very old data so it simulates years ahead and it can be a little wonky to read.

Not only transfer to the next month, but embracing all earlier data/forecasts to derive a newly updated forecast based on the most recent information, right? This is the machine learning component of the forecasting methodology and you can see how I did that in the example.

image