This feature is available to AppSheet Enterprise accounts only. See AppSheet pricing.
Predictive models perform a statistical analysis of your app data in order to make predictions about future data. Some examples include:
- Categorizing customer feedback, given examples of feedback and the categories they belong to
- Predicting customer churn, given examples of customers and whether they churned
- Estimating the cost of a project, given examples of previous projects and how much they cost
Predictive models work by using machine learning algorithms to generalize from your historical data. Machine learning has two phases:
- The training phase, when your historical training data is analyzed and a new predictive model is created
- The prediction phase, when your predictive model makes predictions on data that was not included in your training data
Use predictive models as described in the following sections:
Get started
Watch a video to learn more about creating predictive models.
Create a new predictive model
To create a predictive model:
- Open your app in the editor.
- Go to Intelligence .
The Intelligence panel opens. - Click + adjacent to the Predictive Models heading.
We've made some improvements to the app editor.
You are opted in to the new editor by default, but you can switch back to the legacy editor at any time.If you are using the legacy navigation
Go to the Intelligence > Predictive Models pane and click + New Predictive Model. - Rename the predictive model by updating the Model Name field.
-
Configure the training model, including:
- Training Data Table: This is the table in your app that holds your historical data that is used as input to the machine learning algorithm.
- Column To Predict: The column in your training data that you want to make future predictions about. The column to predict must be
Yes/No
,Enum
,Ref
,Price
,Decimal
, orNumber
. - (Optional) Model Inputs: The columns in your training data that contain relevant information for making a prediction. If this is left blank, AppSheet will automatically infer which columns are relevant. If you need to override AppSheet's decision, then you can explicitly specify the relevant columns.
- Save the app.
Model training
Once the editor refreshes, you will be shown a live status of your model as it is being trained. Training generally takes less than a minute, but depends on the size of your training data.
Once your model has finished training, you will be shown feedback about your model's accuracy and information about how it makes predictions. The particular information shown will depend on the type of column that your model is predicting.
Make predictions
Once your model is trained, you can incorporate it into your app in a few different ways. The easiest way to use your model is to flip a switch in your model's configuration that will do one of the following:
- Add a virtual column to your table that will hold your model's output prediction
- Add an initial value to your prediction column
You can also use the PREDICT("Your Model Name Here")
formula to incorporate your model's predictions in other parts of your app.