Personalization
Data warehouse Touch field types
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 |
If this content did not answer your questions, try searching or contacting our support team for further assistance.
If this content did not answer your questions, try searching or contacting our support team for further assistance.
Personalization