ClearBrain enables you to both identify the users predicted to perform an action, as well as export those users and their predicted scores to your Amazon Redshift database. 

If you have a Redshift Connection enabled on your ClearBrain account, all of your predictions will automatically sync in batch on Sunday PM PST to your connected Redshift account.

ClearBrain creates a schema in your Redshift titled "clearbrain". This schema will contain two tables: "models" and "predictions".

The "models" table will contain a list of all the predictions being exported, with the following fields:

  • model_id: the unique ID for the prediction exported
  • prediction_name: the name of the prediction exported
  • source: the Connection source from which the target goal is selected
  • feature: the action selected as the target goal for the prediction 
  • type: whether the prediction is of type "Action" or "Status"
  • period_start_at: the start date of the calendar week for which the prediction is valid
  • period_end_at: the end date of the calendar week for which the prediction is valid

The "predictions" table will contain a list of every user score for every prediction, with the following fields:

  • primary_key: the primary key (userID or email) for the associated user
  • prediction_name: the name of the prediction exported
  • probability: the ClearBrain score for the associated user-prediction between 0 - 1.
  • prediction_50_percent: a boolean value for whether the user's ClearBrain Score is > 0.5

Note: As Redshift Connections are an enterprise feature, please contact support@clearbrain.com to enable a Redshift Export

Did this answer your question?