Attribution Input (Multiple Inputs) - Teradata Vantage

Machine Learning Engine Analytic Function Reference

Product
Teradata Vantage
Release Number
8.00
1.0
Published
May 2019
Language
English (United States)
Last Update
2019-11-22
dita:mapPath
blj1506016597986.ditamap
dita:ditavalPath
blj1506016597986.ditaval
dita:id
B700-4003
lifecycle
previous
Product Category
Teradata Vantageā„¢

Required

Table Description
Input table Contains clickstream data for computing attributions.
conversion Contains conversion events.
model1 Defines type and distributions of first model.

Optional

Table Description
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).
excluding Contains events to exclude from attribution.
optional Contains optional events.
model2 Defines type and distributions of second model.

Input Table Schema

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

conversion Schema

Column Data Type Description
conversion_events VARCHAR Conversion event value (string or integer).

model1 and model2 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 Model Specification.

excluding Schema

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

optional Schema

Column Data Type Description
optional_event VARCHAR [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.