16.20 - Attribution Input - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ - NewSQL Engine Analytic Functions

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Release Date
July 2019
Content Type
Programming Reference
Publication ID
B035-1206-162K
Language
English (United States)

Required

Table Description
Input tables (maximum of five) Contain clickstream data for computing attributions.
ConversionEventTable Contains conversion events.
FirstModel Defines type and distributions of first model.

Optional

Table Description
ExcludedEventTable Contains events to exclude from attribution.
OptionalEventTable Contains optional events.
SecondModel Defines type and distributions of second model.

Input Table Schema

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

ConversionEventTable Schema

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

FirstModel and SecondModel 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.

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.