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