Visit our new documentation site! This documentation page is no longer updated.

Data Enrichment by Audience Builder

Audience Builder enriches your customer data. The following is a list of enrichment actions.

Table of Contents

Customer Attribute Enrichment

Last Access Date

Description

Adds the most recent customer access date.

Source Columns

This enrichment is triggered when one of the behavior table has the column names below.

  • td_client_id

Output Columns

Adds the following columns to attributes.

  • td_last_access_date

Last IP Information Enrichment

Description

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

Source Columns

This enrichment is triggered when one of the behavior table has the column names below.

  • td_ip

Output Columns

Adds the following columns to attributes.

  • 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

Content Affinity Engine

Description

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.

Source Columns

This enrichment is triggered when one of the behavior tables has the following column names:

  • td_host
  • td_path
  • td_title
  • td_description

Output Columns

Adds the following columns to attributes.

  • td_interest_words
  • td_affinity_categories
  • td_affinity_category_scores
  • td_affinity_sub_categories
  • td_affinity_sub_category_scores

Customer Behavior Enrichment

User Agent Parsing

Description

Audience Builder automatically parses user_agent string.

Source Columns

This enrichment is triggered when one of the behavior tables has the following column name:

  • td_user_agent

Output Columns

Add the following columns to behaviors:

  • td_user_agent_category
  • td_user_agent_name
  • td_user_agent_os
  • td_user_agent_os_version
  • td_user_agent_vendor
  • td_user_agent_version

utm_ Parameters Parsing

Description

Audience Builder automatically extracts utm_campaign, utm_medium, utm_source URL parameters. These parameters are commonly used for online campaign attributions.

Source Columns

This enrichment is triggered when one of the behavior tables has the following column name:

  • td_url

Output Columns

Adds the following columns to behaviors:

  • td_utm_campaign
  • td_utm_medium
  • td_utm_source

IP Information Enrichment

Description

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

Source Columns

This enrichment is triggered when one of the behavior table has the following column name:

  • td_ip

Output Columns

Adds the following columns to behaviors:

  • 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

Web Crawler Access Exclusion

Description

Audience Builder automatically removes access information from the web crawlers to ensure customer profiles have only ‘real human’ data sets.

Source Columns

This enrichment is triggered when one of the behavior table has the following column name:

  • td_user_agent

Output Columns

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


Last modified: May 03 2018 20:33:55 UTC

If this article is incorrect or outdated, or omits critical information, let us know. For all other issues, access our support channels.