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. |