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 |