17.05 - Attribution Input - Teradata Database

Teradata Vantage™ - Advanced SQL Engine Analytic Functions

prodname
Advanced SQL Engine
Teradata Database
vrm_release
17.00
17.05
created_date
June 2020
category
Programming Reference
featnum
B035-1206-170K

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.