Data warehouse Touch field types

Acquia Lift data warehouse

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) No Browser used for this touch
channel_type VARCHAR (100) No Source for this touch (for example, Web or Call Center)
city VARCHAR (50) No City for this touch, based on IP-to-location lookup
country VARCHAR (50) No Country for this touch, based on IP-to-location lookup

list of country codes

customer_site_id INT (4 bytes) Yes Customer site row reference, indicating which website sent the capture
db_last_modified_date TIMESTAMP No The UTC time and date when the row was last modified in the database
dma_code INT (4 bytes) No Designated market area code for this touch (also known as a metro code)

searchable list of DMA codes

engagement_score INT (4 bytes) No Numeric representation (calculated by customer-specific rules) of how this touch describes a person's engagement with the brand
id INT (4 bytes) Yes Unique touch ID — Profile Manager internal value
identifier VARCHAR (22) Yes Touch session identifier
java_enabled BOOLEAN No Indicates whether the browser has Java enabled or not
last_modified_date TIMESTAMP No Time and date that the row was last modified
latitude VARCHAR (50) No Latitude for this touch, based on IP-to-location lookup
longitude VARCHAR (50) No Latitude for this touch, based on IP-to-location lookup
number_of_page_views INT (4 bytes) No Number of page views
operating_system VARCHAR (50) No Operating system (OS) used for this touch
person_id INT (4 bytes) Yes Points to the associated person's person_id for this touch
person_identifier_id INT (8 bytes) No Internal Profile Manager ID for the person_identifier that was triggered by this touch
platform VARCHAR (50) No Platform used for this touch
postal_code VARCHAR (20) No Postal code for this touch, based on IP-to-location lookup
referrer VARCHAR (4000) No Referrer URL
referrer_domain VARCHAR (200) No Referrer base domain
region VARCHAR (50) No State/Province for this touch, based on IP-to-location lookup

list of region codes

search_engine VARCHAR (100) No Search engine used with this touch (for example, Google)
search_terms VARCHAR (1000) No Search terms used with this touch (for example, rent pig roaster)
touch_date TIMESTAMP Yes Touch start-date/time
touch_duration INT (4 bytes) No Touch duration in minutes
touch_duration_in_seconds INT (4 bytes) No Touch duration in seconds
url VARCHAR (4000) No Landing URL
url_domain VARCHAR (200) No Landing base domain
user_agent_string VARCHAR (2000) No Browser's agent string for this touch
utm_content VARCHAR (2000) No Campaign content for paid search, email, or other inbound marketing campaigns — associated with utm_content UTM parameter
utm_medium VARCHAR (2000) No Campaign medium (for example, email) — associated with utm_medium UTM parameter
utm_name VARCHAR (2000) No Campaign name for paid search, email, or other inbound marketing campaigns — associated with utm_campaign UTM parameter
utm_referrer VARCHAR (2000) No Campaign referrer (for example, Newsletters) — associated with utm_source UTM parameter
utm_terms VARCHAR (2000) No Campaign name for paid search, email, or other inbound marketing campaigns — associated with utm_term UTM parameter
visitor_ip VARCHAR (45) No IP address for this touch
custom_field_1 VARCHAR (1000) No User-defined field
custom_field_2 VARCHAR (1000) No User-defined field
custom_field_3 VARCHAR (1000) No User-defined field
custom_field_4 VARCHAR (1000) No User-defined field
custom_field_5 VARCHAR (1000) No User-defined field
custom_field_6 VARCHAR (1000) No User-defined field
custom_field_7 VARCHAR (1000) No User-defined field
custom_field_8 VARCHAR (1000) No User-defined field
custom_field_9 VARCHAR (1000) No User-defined field
custom_field_10 VARCHAR (1000) No User-defined field
custom_field_11 VARCHAR (1000) No User-defined field
custom_field_12 VARCHAR (1000) No User-defined field
custom_field_13 VARCHAR (1000) No User-defined field
custom_field_14 VARCHAR (1000) No User-defined field
custom_field_15 VARCHAR (1000) No User-defined field
custom_field_16 VARCHAR (1000) No User-defined field
custom_field_17 VARCHAR (1000) No User-defined field
custom_field_18 VARCHAR (1000) No User-defined field
custom_field_19 VARCHAR (1000) No User-defined field
custom_field_20 VARCHAR (1000) No User-defined field

Contact supportStill need assistance? Contact Acquia Support