1.0 - 8.00 - HMMDecoder Example 2: Customer Loyalty Prediction (from Supervised Learner) - Teradata Vantage

Input

The input table, customer_loyalty_newseq, is a collection of three new test sequences (seq_id 4, 5, 6) for user_id 1. HMMSupervised trained multiple users and obtained the trained model files (pi_loyalty, A_loyalty and B_loyalty). This example uses these model files with the input to determine the loyalty levels of customers from the new sequence of purchases. The loyalty levels are low (L), normal (N), and high (H).

SQL Call

SELECT * FROM HMMDecoder (
  ON pi_loyalty AS InitStateProb PARTITION BY user_id ORDER BY user_id, state
  ON A_loyalty AS TransProb PARTITION BY user_id
  ON B_loyalty AS EmissionProb PARTITION BY user_id
  ON customer_loyalty_newseq AS observation PARTITION BY user_id
    ORDER BY user_id, seq_id, purchase_date ASC
  USING
  InitStateModelColumn ('user_id')
  InitStateColumn ('state')
  InitStateProbColumn ('probability')
  TransAttributeColumn ('user_id')
  TransFromStateColumn ('from_state')
  TransToStateColumn ('to_state')
  TransProbColumn ('probability')
  EmitModelColumn ('user_id')
  EmitStateColumn ('state')
  EmitObsColumn ('observed')
  EmitProbColumn ('probability')
  ModelColumn ('user_id')
  SeqColumn ('seq_id')
  ObsColumn ('observation')
  Accumulate ('purchase_date')
) AS dt ORDER BY 1, 2, 5;

Output

The output table shows the decoded loyalty levels for the new sequence. For seq_id 5, the loyalty level increased towards the end of the sequence (from L to H; for the other sequences (seq_id 4 and seq_id 6), the loyalty level did not change.