Single-Input Attribution Example 2: Multiple Regular Models, One Optional Model - Teradata Vantage

This example specifies one distribution model for each type of regular event and one distribution model for optional events.

Input

• attribution_sample_table, as in Single-Input Attribution Example 1: One Regular Model, Multiple Optional Models

SQL Call

SELECT * FROM Attribution@coprocessor (
  ON attribution_sample_table
    PARTITION BY user_id
    ORDER BY time_stamp
  USING
  EventColumn ('event')
  ConversionEvents ('SocialNetwork', 'PaidSearch')
  OptionalEvents ('OrganicSearch', 'Direct', 'Referral')
  TimestampColumn ('time_stamp')   WindowSize ('rows:10&seconds:20')
  Model1 ('EVENT_REGULAR', 'Email:0.19:LAST_CLICK:NA',
          'impression:0.81:UNIFORM:NA')
  Model2 ('EVENT_OPTIONAL', 'ALL:1:EXPONENTIAL:0.5,ROW')
) AS dt;

Output

The only difference between this output and the output of Example 1 is the attribution of the optional events.