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 | Data type | Sortable | Description |
---|---|---|---|
browser | VARCHAR (50) | π | Browser used for this touch |
channel_type | VARCHAR (100) | π | Source for this touch (for example, Web or Call Center ) |
city | VARCHAR (50) | π | City for this touch, based on IP-to-location lookup |
country | VARCHAR (50) | π | Country for this touch, based on IP-to-location lookup (list of country codes) |
customer_site_id | INT (4 bytes) | β | Customer site row reference, indicating which website sent the capture |
db_last_modified_date | TIMESTAMP | π | The UTC time and date when the row was last modified in the database |
dma_code | INT (4 bytes) | π | Designated market area code for this touch (also known as a metro code) (searchable list of DMA codes) |
engagement_score | INT (4 bytes) | π | Numeric representation (calculated by customer-specific rules) of how this touch describes a personβs engagement with the brand |
id | INT (4 bytes) | β | Unique touch ID: Personalization internal value |
identifier | VARCHAR (22) | β | Touch session identifier |
java_enabled | BOOLEAN | π | Indicates whether the browser has Java enabled or not |
last_modified_date | TIMESTAMP | π | Time and date the row was last modified |
latitude | VARCHAR (50) | π | Latitude for this touch, based on IP-to-location lookup |
longitude | VARCHAR (50) | π | Latitude for this touch, based on IP-to-location lookup |
number_of_page_views | INT (4 bytes) | π | Number of Page Views |
operating_system | VARCHAR (50) | π | Operating system (OS) used for this touch |
person_id | INT (4 bytes) | β | Points to the associated personβs person_id for this touch |
person_identifier_id | INT (8 bytes) | π | Internal Personalization ID for the person_identifier that was triggered by this touch |
platform | VARCHAR (50) | π | Platform used for this touch |
postal_code | VARCHAR (20) | π | Postal code for this touch, based on IP-to-location lookup |
referrer | VARCHAR (4000) | π | Referrer URL |
referrer_domain | VARCHAR (200) | π | Referrer base domain |
region | VARCHAR (50) | π | State/Province for this touch, based on IP-to-location lookup (list of region codes) |
search_engine | VARCHAR (100) | π | Search engine used with this touch (for example, Google ) |
search_terms | VARCHAR (1000) | π | Search terms used with this touch (for example, rent pig roaster ) |
touch_date | TIMESTAMP | β | Touch start-date/time |
touch_duration | INT (4 bytes) | π | Touch duration in minutes |
touch_duration_in_seconds | INT (4 bytes) | π | Touch duration in seconds |
url | VARCHAR (4000) | π | Landing URL |
url_domain | VARCHAR (200) | π | Landing base domain |
user_agent_string | VARCHAR (2000) | π | Browserβs agent string for this touch |
utm_content | VARCHAR (2000) | π | Campaign content for paid search, email, or other inbound marketing campaignsβassociated with utm_content UTM parameter |
utm_medium | VARCHAR (2000) | π | Campaign medium (for example, email)βassociated with utm_medium UTM parameter |
utm_name | VARCHAR (2000) | π | Campaign name for paid search, email, or other inbound marketing campaignsβassociated with utm_campaign UTM parameter |
utm_referrer | VARCHAR (2000) | π | Campaign referrer (for example, Newsletters)βassociated with utm_source UTM parameter |
utm_terms | VARCHAR (2000) | π | Campaign name for paid search, email, or other inbound marketing campaignsβassociated with utm_term UTM parameter |
visitor_ip | VARCHAR (45) | π | IP address for this touch |
custom_field_1 | VARCHAR (1000) | π | User-defined field |
custom_field_2 | VARCHAR (1000) | π | User-defined field |
custom_field_3 | VARCHAR (1000) | π | User-defined field |
custom_field_4 | VARCHAR (1000) | π | User-defined field |
custom_field_5 | VARCHAR (1000) | π | User-defined field |
custom_field_6 | VARCHAR (1000) | π | User-defined field |
custom_field_7 | VARCHAR (1000) | π | User-defined field |
custom_field_8 | VARCHAR (1000) | π | User-defined field |
custom_field_9 | VARCHAR (1000) | π | User-defined field |
custom_field_10 | VARCHAR (1000) | π | User-defined field |
custom_field_11 | VARCHAR (1000) | π | User-defined field |
custom_field_12 | VARCHAR (1000) | π | User-defined field |
custom_field_13 | VARCHAR (1000) | π | User-defined field |
custom_field_14 | VARCHAR (1000) | π | User-defined field |
custom_field_15 | VARCHAR (1000) | π | User-defined field |
custom_field_16 | VARCHAR (1000) | π | User-defined field |
custom_field_17 | VARCHAR (1000) | π | User-defined field |
custom_field_18 | VARCHAR (1000) | π | User-defined field |
custom_field_19 | VARCHAR (1000) | π | User-defined field |
custom_field_20 | VARCHAR (1000) | π | User-defined field |