campaign
Table Schema
| Name | Type | Description |
|---|---|---|
| personid | VARCHAR |
Internal identifier to specify a unique instance of a person. This column is used to partition data tables in the Bulk Data API and should be included on all table joins. Use personid to join to tables in other models within the Bulk Data API. |
| participantkey | VARCHAR |
Internal identifier to specify a unique instance of a participant in an RKStudio project. Key relationship with the participant table. |
| campaignkey | VARCHAR |
Primary key. A unique, auto-generated internal identifier to specify a unique instance of campaign. |
| channel | VARCHAR |
Channel associated with the campaign |
| content | VARCHAR |
Content associated with the campaign |
| medium | VARCHAR |
Medium associated with the campaign |
| name | VARCHAR |
Name of Campaign |
| participantcreationdate | TIMESTAMP |
Date participant was created in the project |
| source | VARCHAR |
Source associated with the campaign |
| term | VARCHAR |
Term associated with the campaign |
| type | VARCHAR |
Campaign type |
| visitkey | VARCHAR |
Internal identifier to specify a unique instance of a visit. |
| visitorkey | VARCHAR |
Internal identifier to specify a unique instance of a visitor. |
