Sales Creatio, commerce edition
PDF
This documentation is valid for Creatio version 7.16.0. We recommend using the newest version of Creatio documentation.

Lookup value prediction

You can set up a machine learning model that will predict the value in a specific lookup field. The prediction will be based on the data available in the record and existing records, where the predicted field has already been populated.

Case

You can create a model that will predict the most likely category of a customer account.

I. Create a lookup value prediction model

1.Click btn_system_designer.png to open the System Designer.

2.Open the [ML models] section and click [New model].

3.Populate the mini page for creating the ML model (Fig. 1):

Fig. 1 Mini-page for lookup value prediction model

chapter_predicting_lookup_value_model_minicard.png 

a.[Name] – enter the name of the prediction model, which will help you easily identify it in the list of the [ML models] section and when selecting a model for the [Data prediction] process element.

b.[Type] – specify the task to be resolved via the ML model. For example, “Lookup prediction”.

c.[Object] – the prediction model will be configured for the records of this object (section, detail, or lookup). For example, to predict values for the [Accounts] section, select the “Account” object in this field.

II. Lookup value prediction model parameters

Once the initial fields are populated, click [Next] and go to the [Parameters] tab and specify additional model parameters (Fig. 2):

Fig. 2 Additional parameters of the prediction model

chapter_predicting_lookup_value_model_additional_parameters.png 

1.[What value should be predicted?] – select the field to be predicted. The list contains all lookup fields of the selected object. For example, to predict the account category, select the [Category] field from the list. The result of the prediction will be displayed as one of the [Category] lookup values.

2.[Which columns does the predicted value depend on?] – specify the columns that Creatio will correlate with the value of the predicted field. For example, if you normally determine an account’s category based on the number of company employees, revenue, and the industry that the account operates in — add the [No of employees], [Annual revenue], and [Industry] columns here. Creatio will analyze how the [No of employees], [Annual revenue], and [Industry] columns were populated for existing records and how this correlates with the corresponding values in the [Category] column.

3.[Advanced tools to add columns] – if necessary, use queries to add additional training data to the prediction model. This functionality is intended for the developers. More information about creating data queries for machine learning models is available in the Development guide.

4.[Which records should be included in the training dataset?] – specify the filter for selecting records for “model training”. Creatio will use these records to determine the correlation between the predicted value and the columns that the prediction is based upon. For example, to train an account category prediction model, we would need to analyze only the records where the [Category] field is populated.

Note

You can add columns from the connected objects to the training selection.

5.[What column to use for saving prediction result?] – Usually, the prediction result is saved in the column whose value was predicted. If you prefer that Creatio does not modify the predicted column, select a different column here.

6.Populate automatic model training settings. Creatio will periodically “retrain” by analyzing the updated training dataset.

a.In the [Retrain after, days] field, specify the interval between model training sessions. After the set number of days, the model will be retrained using records that match the filter. The first model training session starts automatically when the [Prediction enabled] checkbox is selected.

b.In the [Quality metric lower limit] field, specify the lowest quality metric of the prediction model. When the model is trained for the first time, this threshold will determine the minimum acceptable quality that the model needs to reach before it can be used in Creatio. If the quality of a model drops below the lower limit, the model is deemed unusable. We recommend setting the quality metric lower limit to at least 0.50. The accuracy score of the machine learning model ranges from 0.00 to 1.00 (1.00 being the highest, and 0.00 being the lowest). The accuracy of machine learning models is calculated by dividing the number of successful predictions by the total number of predictions to evaluate the success rate of its learning patterns. Please refer to the following article to learn more about how the prediction accuracy score is calculated.

Note

The quality of the prediction model may decrease during subsequent training sessions if, for example, certain columns are no longer being populated on the record page, but are still specified in the [Which columns does the predicted value depend on?] field. To prevent this from happening, make sure that the columns used in the prediction model are relevant before each training session to prevent it from reaching the lowest quality threshold.

III. Lookup value prediction model advanced settings

Click the [Advanced settings] tab if you want to specify additional prediction model parameters.

1.Use the [Advanced tools to add columns] area to set up a query for the selection of additional columns that the predicted value depends on. Note that creating queries requires coding. Learn more in the “Creating data queries for the machine learning model” article.

2.The values in the [Advanced model parameters] field group are populated automatically. You can edit them and change their values, if necessary.

a.[Minimum training record count] – the minimal number of records needed for training a model. The training will not be performed if the number of historical records is insufficient.

b.[Maximum training record count] – the maximal number of records needed for training a model. If the data set by the configured filter has more records than specified in this field, Creatio will only use the maximal number of records. The rest will not be truncated.

c.[Predicted value selection method] – the algorithm for populating the fields with predicted values.

ML Engine Significance” – an algorithm that determines the forecast quality at the level of the ML service. If one of the quality values is high and the other is low, Creatio will populate the field with the high quality value. If several quality values are high or all of them are low, the field will not be populated. However, the model will generate a list of recommended candidate values.

Maximum probability” – an algorithm that determines if the probability of prediction matches the quality metric lower limit. If the probability quality matches or exceeds the quality metric lower limit, Creatio will populate the field automatically. If the prediction quality is below of the quality metric lower limit, the field will not be populated. However, the model will generate a list of recommended candidate values. When this algorithm is selected, the new [Lower limit of probability for predicted value selection] field displays. Use it to specify the acceptable prediction probability, from 0 to 1.

3.Click [Save].

4.Once the model is fully configured, click [Train model] to start the training process. See the training result in the [Training] tab and the model status in the section list (Fig. 3).

Fig. 3 Displaying model status in the [ML models] section list

scr_chapter_predicting_model_training_status.png 

5.If you plan to modify the model, clear the [Prediction enabled] checkbox. We recommend configuring the model fully before enabling it. The prediction itself will start only when the model is trained up to sufficient quality, specified in the [Quality metric lower limit] field.

As a result, a new ML model will be added to Creatio. When triggered by a business process, the model will predict and populate the values for the needed records.

The account category prediction model will analyze the values in the [No of employees], [Annual revenue], and [Industry] columns of accounts whose [Category] column is populated. The more data it analyzes, the higher quality metric will become.

Once the quality is high enough, the model will predict the value in the [Category] field, based on the values in the [No of employees], [Annual revenue], and [Industry] fields.

Note

Use the [Training] tab to view the history of model training, and get the necessary information regarding each model training iteration (e.g., the number of records used for training, quality metric evaluations, etc.).

See also

Basic predictive analysis glossary

Numeric field value prediction

Predictive scoring

Recommendation prediction

Configure a prediction business process

Machine learning model training

Did you find this information useful?

How can we improve it?