The data warehouse uses the Touch field layout to describe a series of contiguous events (such as content views) with a duration between events of no more than 30 minutes. Each touch has a Person record as its parent.
Field name | Sortable | Description | |
---|---|---|---|
| VARCHAR (50) | π | Browser used for this touch |
| VARCHAR (100) | π | Source for this touch (for example, |
| VARCHAR (50) | π | City for this touch, based on IP-to-location lookup |
| VARCHAR (50) | π | Country for this touch, based on IP-to-location lookup (list of country codes) |
| INT (4 bytes) | β | Customer site row reference, indicating which website sent the capture |
| TIMESTAMP | π | The UTC time and date when the row was last modified in the database |
| INT (4 bytes) | π | Designated market area code for this touch (also known as a metro code) (searchable list of DMA codes) |
| INT (4 bytes) | π | Numeric representation (calculated by customer-specific rules) of how this touch describes a personβs engagement with the brand |
| INT (4 bytes) | β | Unique touch ID: Personalization internal value |
| VARCHAR (22) | β | Touch session identifier |
| BOOLEAN | π | Indicates whether the browser has Java enabled or not |
| TIMESTAMP | π | Time and date the row was last modified |
| VARCHAR (50) | π | Latitude for this touch, based on IP-to-location lookup |
| VARCHAR (50) | π | Latitude for this touch, based on IP-to-location lookup |
| INT (4 bytes) | π | Number of Page Views |
| VARCHAR (50) | π | Operating system (OS) used for this touch |
| INT (4 bytes) | β | Points to the associated personβs
|
| INT (8 bytes) | π | Internal Personalization ID for the |
| VARCHAR (50) | π | Platform used for this touch |
| VARCHAR (20) | π | Postal code for this touch, based on IP-to-location lookup |
| VARCHAR (4000) | π | Referrer URL |
| VARCHAR (200) | π | Referrer base domain |
| VARCHAR (50) | π | State/Province for this touch, based on IP-to-location lookup (list of region codes) |
| VARCHAR (100) | π | Search engine used with this touch (for example, |
| VARCHAR (1000) | π | Search terms used with this touch (for example, |
| TIMESTAMP | β | Touch start-date/time |
| INT (4 bytes) | π | Touch duration in minutes |
| INT (4 bytes) | π | Touch duration in seconds |
| VARCHAR (4000) | π | Landing URL |
| VARCHAR (200) | π | Landing base domain |
| VARCHAR (2000) | π | Browserβs agent string for this touch |
| VARCHAR (2000) | π | Campaign content for paid search, email, or other inbound marketing
campaignsβassociated with |
| VARCHAR (2000) | π | Campaign medium (for example, email)βassociated with
|
| VARCHAR (2000) | π | Campaign name for paid search, email, or other inbound marketing
campaignsβassociated with |
| VARCHAR (2000) | π | Campaign referrer (for example, Newsletters)βassociated with
|
| VARCHAR (2000) | π | Campaign name for paid search, email, or other inbound marketing
campaignsβassociated with |
| VARCHAR (45) | π | IP address for this touch |
| VARCHAR (1000) | π | User-defined field |
| VARCHAR (1000) | π | User-defined field |
| VARCHAR (1000) | π | User-defined field |
| VARCHAR (1000) | π | User-defined field |
| VARCHAR (1000) | π | User-defined field |
| VARCHAR (1000) | π | User-defined field |
| VARCHAR (1000) | π | User-defined field |
| VARCHAR (1000) | π | User-defined field |
| VARCHAR (1000) | π | User-defined field |
| VARCHAR (1000) | π | User-defined field |
| VARCHAR (1000) | π | User-defined field |
| VARCHAR (1000) | π | User-defined field |
| VARCHAR (1000) | π | User-defined field |
| VARCHAR (1000) | π | User-defined field |
| VARCHAR (1000) | π | User-defined field |
| VARCHAR (1000) | π | User-defined field |
| VARCHAR (1000) | π | User-defined field |
| VARCHAR (1000) | π | User-defined field |
| VARCHAR (1000) | π | User-defined field |
| VARCHAR (1000) | π | User-defined field |