Attribution (Multiple-Input Version) (version 2.3) - Aster Analytics

Teradata Aster Analytics Foundation User Guide

Product
Aster Analytics
Release Number
6.21
Published
November 2016
Language
English (United States)
Last Update
2018-04-14
dita:mapPath
kiu1466024880662.ditamap
dita:ditavalPath
AA-notempfilter_pdf_output.ditaval
dita:id
B700-1021
lifecycle
previous
Product Category
Software
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;