Attribution Syntax (Multiple Inputs) - Aster Analytics

Teradata Aster® Analytics Foundation User GuideUpdate 2

Product
Aster Analytics
Release Number
7.00.02
Published
September 2017
Language
English (United States)
Last Update
2018-04-17
dita:mapPath
uce1497542673292.ditamap
dita:ditavalPath
AA-notempfilter_pdf_output.ditaval
dita:id
B700-1022
lifecycle
previous
Product Category
Software
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;