7.00.02 - Attribution Syntax (Multiple Inputs) - Aster Analytics

Teradata Aster® Analytics Foundation User GuideUpdate 2

Product
Aster Analytics
Release Number
7.00.02
Published
September 2017
Content Type
Programming Reference
User Guide
Publication ID
B700-1022-700K
Language
English (United States)
Last Update
2018-04-17
Version 2.3
SELECT * FROM Attribution (
  ON { input_table | view | (query) }
    PARTITION BY user_id 
    ORDER BY timestamp_column 
  [ ON { input_table_n | view_n | (query_n) }
    PARTITION BY user_id 
    ORDER BY timestamp_column [,...] ]
  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 ]
  EventColumn ('event_column')
  TimestampColumn ('timestamp_column')
  WindowSize ({ 'rows:K' | 'seconds:K' | 'rows:K&seconds:K2' })
) ORDER BY user_id,time_stamp;