Model Specification | Attribution | Teradata Vantage - Model Specification - Teradata Vantage

Teradata® VantageCloud Lake

Deployment
VantageCloud
Edition
Lake
Product
Teradata Vantage
Published
January 2023
Language
English (United States)
Last Update
2024-04-03
dita:mapPath
phg1621910019905.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
phg1621910019905

Model Types and Specification Definitions

Row 0: Model Type Row 1, ..., n: Distribution Model Specification Additional Information
SIMPLE MODEL:PARAMETERS Distribution model for all events. For MODEL and PARAMETER definitions, see following table.
EVENT_REGULAR EVENT:WEIGHT:MODEL:PARAMETERS Distribution model for a regular event.

EVENT cannot be a conversion, excluded, or optional event.

For MODEL and PARAMETER definitions, see following table.

Sum of WEIGHT values must be 1.0.

For example, suppose that model table has these specifications:

  email:0.19:LAST_CLICK:NA

  impression:0.81:UNIFORM:NA

Within WindowSize of a conversion event, 19% of conversion event is attributed to last email event and 81% is attributed uniformly to all impression events.

EVENT_OPTIONAL EVENT:WEIGHT:MODEL:PARAMETERS Distribution model for an optional event.

EVENT must be in optional event table.

For MODEL and PARAMETER definitions, see following table.

Sum of WEIGHT values must be 1.0.

SEGMENT_ROWS Ki:WEIGHT:MODEL:PARAMETERS Distribution model by row. Sum of Ki values must be value K specified by 'rows:K' in WindowSize syntax element.

Function considers rows from most to least recent. For example, suppose that function call has these syntax elements:

WindowSize ('rows:10')

Model1 ('SEGMENT_ROWS',

'3:0.5:UNIFORM:NA',

'4:0.3:LAST_CLICK:NA',

'3:0.2:FIRST_CLICK:NA')

Attribution for a conversion event is divided among attributable events in 10 rows immediately preceding conversion event. If conversion event is in row 11, first model specification applies to rows 10, 9, and 8; second applies to rows 7, 6, 5, and 4; and third applies to rows 3, 2, and 1.

Half attribution (5/10) is uniformly divided among rows 10, 9, and 8; 3/10 to last click in rows 7, 6, 5, and 4 (that is, in row 7), and 2/10 to first click in rows 3, 2, and 1 (that is, in row 1).

SEGMENT_SECONDS Ki:WEIGHT:MODEL:PARAMETERS Distribution model by time in seconds. Sum of Kivalues must be value K specified by 'seconds:K' in WindowSize syntax element.

Function considers rows from most to least recent. For example, suppose that function call has these syntax elements:

WindowSize ('seconds:20')

Model1 ('SEGMENT_SECONDS',

'6:0.5:UNIFORM:NA',

'8:0.3:LAST_CLICK:NA',

'6:0.2:FIRST_CLICK:NA')

Attribution for a conversion event is divided among attributable events in 20 seconds immediately preceding conversion event. If conversion event is at second 21, first model specification applies to seconds 20-15 (counting backward); second applies to seconds 14-7; and third applies to seconds 6-1.

Half attribution (5/10) is uniformly divided among seconds 20-15; 3/10 to last click in seconds 14-7, and 2/10 to first click in seconds 6-1.

MODEL Values and Corresponding PARAMETER Values

MODEL values are case-sensitive. Attributable events are those whose types are not specified in excluding events table.

MODEL PARAMETERS Description
'LAST_CLICK' 'NA' Conversion event is attributed entirely to most recent attributable event.
'FIRST_CLICK' 'NA' Conversion event is attributed entirely to first attributable event.
'UNIFORM' 'NA' Conversion event is attributed uniformly to preceding attributable events.
'EXPONENTIAL' 'alpha,type' where alpha is a decay factor in range (0, 1) and type is ROW, MILLISECOND, SECOND, MINUTE, HOUR, DAY, MONTH, or YEAR.

When alpha is in range (0, 1), sum of series wi=(1-alpha)*alphai is 1. Function uses wi as exponential weights.

Conversion event is attributed exponentially to preceding attributable events (the more recent the event, the higher the attribution).
'WEIGHTED' You can specify any number of weights. If there are more attributable events than weights, extra (least recent) events are assigned zero weight. If there are more weights than attributable events, then function renormalizes weights. Conversion event is attributed to preceding attributable events with weights specified by PARAMETERS.SEGMENT_SECONDS (when you specify 'rows:K&seconds:K' in WindowSize syntax element)

Allowed FirstModelTable/SecondModelTable Combinations

FirstModelTable Type SecondModelTable Type
SIMPLE Not allowed
EVENT_REGULAR  
EVENT_REGULAR EVENT_OPTIONAL (when you specify optional events table)
SEGMENT_ROWS SEGMENT_SECONDS (when you specify 'rows:K&seconds:K' in WindowSize syntax element)
SEGMENT_ROWS  
SEGMENT_SECONDS Not allowed