1.1 - 8.10 - Attribution_MLE Input (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)

Required

Table Description
Input table Contains clickstream data for computing attributions.
ConversionEventTable Contains conversion events.
FirstModelTable Defines first model.

Optional

Table Description
1-4 additional input tables Contain additional clickstream data. Specifying these tables lets you co-group attributes from all specified input tables (for example, ad_click, impressions, and conversions).
ExcludedEventTable Contains events to exclude from attribution.
OptionalEventTable Contains optional events.
SecondModelTable Defines second model.

Input Table Schema

Column Data Type Description
userid_column INTEGER or VARCHAR User identifier.
event_column Any Event from clickstream.
time_column INTEGER, SMALLINT, BIGINT, TIMESTAMP, or TIME Event timestamp.

ConversionEventTable Schema

Column Data Type Description
conversion_events VARCHAR [Column appears once for each conversion event.] Conversion event value (string or integer).

FirstModelTable and SecondModelTable Schema

Column Data Type Description
id INTEGER Row identifier. Rows are numbered 0, 1, 2, and so on.
model VARCHAR Row 0: Model type.

Row 1, ..., n: Distribution model definition.

SIMPLE model: Model table has single row that specifies model type and parameters.

Other model types: n is number of rows or events included in model.

For model type and specification definitions, see Attribution Model Specification.

ExcludedEventTable Schema

Column Data Type Description
excluding_event VARCHAR [Column appears once for each excluded event.] Excluded event (string or integer). Cannot be a conversion event.

OptionalEventTable Schema

Column Data Type Description
optional_event VARCHAR [Column appears once for each optional event.] Optional event (string or integer). Cannot be a conversion or excluded event. Function attributes conversion event to optional event only if it cannot attribute it to regular event.