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
Google Cloud Machine Learning
Behind the scenes, AppSheet uses Google Cloud's Machine Learning Engine to create predictive models. This means that during the training phase, your data is accessed by AppSheet's code running on a Google Cloud service. During the prediction phase, your model is privately hosted on another Google Cloud service.
Creating a New Predictive Model
Each predictive model has three parts:
Training Data Table: This is the table in your app that holds your historical data that 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, or Number.
(Optional) Input Columns: 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.
To create a predictive model, navigate to Intelligence > Predictive Models. Once you've configured your model, press save and your model will begin 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.
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 either:
Add a virtual column to your table that will hold your model's output prediction, or
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.
These videos show a few examples of how to use predictive models.