1.1 - 8.10 - Attribution_MLE Syntax (Multiple Inputs) - Teradata Vantage

Teradata Vantage™ - Machine Learning Engine Analytic Function Reference

Product
Teradata Vantage
Release Number
1.1
8.10
Release Date
October 2019
Content Type
Programming Reference
Publication ID
B700-4003-079K
Language
English (United States)

Version 2.10

SELECT * FROM Attribution_MLE (
  ON { table | view | (query) } PARTITION BY user_id ORDER BY timestamp_column 
  [ ON { table | view | (query) } PARTITION BY user_id ORDER BY timestamp_column ][,...]
  ON conversion_event_table AS ConversionEventTable DIMENSION
  [ ON excluding_event_table AS ExcludedEventTable DIMENSION ]
  [ ON optional_event_table AS OptionalEventTable DIMENSION ]
  ON first_model_table AS FirstModelTable DIMENSION
  [ ON second_model_table AS SecondModelTable DIMENSION ]
  USING
  EventColumn ('event_column')
  TimeColumn ('timestamp_column')
  WindowSize ({ 'rows:K' | 'seconds:K' | 'rows:K&seconds:K2' })
) AS alias ORDER BY user_id,time_stamp;