Predictive models

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.

Create a new predictive model

Each predictive model has three parts:

  1. Training Data Table: This is the table in your app that holds your historical data that as input to the machine learning algorithm.
  2. 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.
  3. (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.

Predictive Models tab of the Intelligence section showing a predictive model configuration

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.

Preparing training data message in the Model Summary section

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.

Shows results of predictive model training under Model Summary

Making 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 either:

  1. Add a virtual column to your table that will hold your model's output prediction, or
  2. Add an initial value to your prediction column


Use your model section of the Predictive Model configuration

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.


Was this helpful?
How can we improve it?
Clear search
Close search
Google apps
Main menu
Search Help Center