In Master Segments, you can execute a list of enrichment actions by adding specific td_ columns to either the attribute or behavior tables in the TD Console as shown in this example:


Attribute Enrichment

For these types of enrichment, add the source column to the Attribute table definition as part of defining your master segment.

Enrichment type

Description

Source Column

Added Output Columns

Column Description

Last Access Date

Adds the most recent customer access date.

  • td_client_id

td_last_access_date

-

Last IP Information Enrichment

Adds additional customer information by IP. The enrichment is done by TD_IP_TO_*functions.

  • td_ip

td_ip

-

td_country_name

country name converted from IP address.

Supported Presto and TD Functions#TD_IP_TO_COUNTRY_NAME

td_ip_city_name

city name converted from IP address.

Supported Presto and TD Functions#TD_IP_TO_CITY_NAME

td_ip_city_latitude

latitude  converted from IP address.

Supported Presto and TD Functions#TD_IP_TO_LATITUDE

td_ip_city_longitude

longitude converted from IP address.

Supported Presto and TD Functions#TD_IP_TO_LONGITUDE

td_ip_city_metro_code

metro code(US only) converted from IP address.

Supported Presto and TD Functions#TD_IP_TO_METRO_CODE(USOnly)

td_ip_city_postal_code

postal code converted from IP address.

Supported Presto and TD Functions#TD_IP_TO_POSTAL_CODE

td_ip_least_specific_subdivision_name

the least specific subdivisions (e.g. US states, JP prefectures, etc) converted from IP address.

Supported Presto and TD Functions#TD_IP_TO_LEAST_SPECIFIC_SUBDIVISION_NAME

td_ip_most_specific_subdivision_name

the most specific subdivisions (e.g. US states, JP prefectures, etc) converted from IP address.

Supported Presto and TD Functions#TD_IP_TO_MOST_SPECIFIC_SUBDIVISION_NAME

td_ip_subdivision_names

subdivisions (e.g. US states, JP prefectures, etc) converted from IP address.

Supported Presto and TD Functions#TD_IP_TO_SUBDIVISION_NAMES

td_ip_connection_type

connection type (dial-up, cable/DSL, corporate or cellular) converted from IP address.

Supported Presto and TD Functions#TD_IP_TO_CONNECTION_TYPE

td_ip_domain

domain converted from IP address.

Supported Presto and TD Functions#TD_IP_TO_DOMAIN

Content Affinity Engine

Based on the content’s title and description, Treasure Data adds words of interest and estimates to each customer’s interest categories. We use OpenRTB’s list of categories as a master category list.

  • td_host

  • td_path

  • td_title

  • td_description

td_interest_words

-
td_affinity_categories-
td_affinity_category_scores-
td_affinity_sub_categories-
td_affinity_sub_category_scores-


Behavior Enrichment

For these types of enrichment, add the source column to the Behavior table definition as part of defining your master segment.

Enrichment type

Description

Source Column

Added Output Columns

Column Description

User Agent Parsing

Master Segments can automatically parse the user_agent string.

td_user_agent

td_user_agent_category

category of td_user_agent

i.e. element_at(td_parse_agent(td_user_agent), 'category')

td_user_agent_name

name of td_user_agent

i.e. element_at(td_parse_agent(td_user_agent), 'name')

td_user_agent_os

os of td_user_agent

i.e. element_at(td_parse_agent(td_user_agent), 'os')

td_user_agent_os_version

os_version of td_user_agent

i.e. element_at(td_parse_agent(td_user_agent), 'os_version')

td_user_agent_vendor

vender of td_user_agent

i.e. element_at(td_parse_agent(td_user_agent), 'vender')

td_user_agent_version

version of td_user_agent

i.e. element_at(td_parse_agent(td_user_agent), 'version')

utm_Parameters Parsing

Master Segments can automatically extract utm_campaign, utm_medium, utm_source URL parameters. These parameters are commonly used for online campaign attributions.

td_url

td_utm_campaign

campaign name
td_utm_mediummedia(e.g. mail, CPC ads etc)
td_utm_sourcesource (e.g. google, facebook etc)

IP Information Enrichment

Adds additional customer information by IP. The enrichment is done by TD_IP_TO_* functions.

td_ip

  • td_country_name

  • td_ip_city_name

  • td_ip_city_latitude

  • td_ip_city_longitude

  • td_ip_city_metro_code

  • td_ip_city_time_zone

  • td_ip_city_postal_code

  • td_ip_least_specific_subdivision_name

  • td_ip_most_specific_subdivision_name

  • td_ip_subdivision_names

  • td_ip_connection_type

  • td_ip_domain

See Attribute Enrichment

Web Crawler Access Exclusion

Master Segments can automatically remove access information from the web crawlers to ensure profiles have only ‘real human’ data sets.

td_user_agent

This enrichment removes the behaviors, and no additional columns are added.

-

Content Affinity Engine Example

Based on the content’s title and description, Treasure Data adds words of interest and estimates to profile interest categories. OpenRTB’s list of categories is used as a master category list.



  • No labels