Attribution_MLE Input (Multiple Inputs)

Attribution_MLE Input (Multiple Inputs) - Teradata Vantage

Machine Learning Engine Analytic Function Reference

Product

Teradata Vantage

Release Number

8.10

1.1

Published

October 2019

Language

English (United States)

Last Update

2019-12-31

dita:mapPath

ima1540829771750.ditamap

dita:ditavalPath

jsj1481748799576.ditaval

dita:id

B700-4003

lifecycle

Product Category

Teradata Vantage™

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

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.

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.

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

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.

Column

Data Type

Description

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.

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

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.