Required
| Table | Description |
|---|---|
| Input tables (maximum of five) | Contains clickstream data for computing attributions. |
| ConversionEventTable | Contains conversion events. |
| FirstModelTable | Defines type and distributions of first model. |
Optional
| Table | Description |
|---|---|
| ExcludedEventTable | Contains events to exclude from attribution. |
| OptionalEventTable | Contains optional events. |
| SecondModelTable | 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 | Conversion event value (string or integer). |
FirstModelTable and SecondModelTable 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 | Excluded event (string or integer). Cannot be a conversion event. |
OptionalEventTable Schema
| Column | Data Type | Description |
|---|---|---|
| optional_event | VARCHAR | 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. |