Attribution Example (Multiple Inputs) - Teradata Vantage

This example uses models to assign attribution weights to these events and channels:

Input

The following two model tables apply the distribution models by rows and by seconds, respectively.

SQL Call

SELECT * FROM Attribution@coprocessor (
  ON attribution_sample_table1 AS input1
    PARTITION BY user_id ORDER BY time_stamp
  ON attribution_sample_table2 AS input2
    PARTITION BY user_id ORDER BY time_stamp
  ON conversion_event_table AS conversion DIMENSION
  ON excluding_event_table AS excluding DIMENSION
  ON optional_event_table AS optional DIMENSION
  ON model1_table AS model1 DIMENSION
  ON model2_table AS model2 DIMENSION
  USING
  EventColumn ('event')
  TimestampColumn ('time_stamp')
  WindowSize ('rows:10&seconds:20')
) AS dt;

Output