Single-Input Attribution Example 4: Window Models - Teradata Vantage

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')
  ExcludeEvents ('Email')
  OptionalEvents ('OrganicSearch', 'Direct', 'Referral')
  TimestampColumn ('time_stamp')
  WindowSize ('rows:10&seconds:20')
  Model1 ('SEGMENT_ROWS', '3:0.5:EXPONENTIAL:0.5,ROW',
          '4:0.3:WEIGHTED:0.4,0.3,0.2,0.1', '3:0.2:FIRST_CLICK:NA')
  Model2 ('SEGMENT_SECONDS', '6:0.5:UNIFORM:NA', '8:0.3:LAST_CLICK:NA',
          '6:0.2:FIRST_CLICK:NA')
) AS dt;

Output