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

Data Modeling by Audience Builder

You define your data model with Audience Builder. The data model produces unified customer views, which contains two elements: Customer Profiles and associated Customer Behaviors, linked by the common Customer ID.

Table of Contents

Source Tables

To produce the customer data model, Treasure Data Audience Builder asks you to specify 3 types of tables within Treasure Data: Master Table, Attribute Tables, and Behavior Tables.

The 3 tables are most commonly created by Treasure Workflow. Treasure workflow pre-processes the raw data.

When the tables are defined, Treasure Data Audience Builder automatically generates a series of workflows to produce the unified customer profiles.

Master Table

Master Table contains a master list of customers. The customer list is typically imported from CRM. The Master table typically contains the following information:

  • First Name
  • Last Name
  • Email
  • Cookie ID (most commonly Treasure‚Äôs Anonymous IDs)

Attribute Tables (Optional)

Attribute Tables contain additional attributes of the customers, and enrich the information in Master Table. Attribute Tables are optional entities. The example of attributes are:

  • Demographic Information
    • age
    • gender
    • income
    • interests

Behavior Tables (Optional)

Behavior Tablers contain behaviors of the customers. Behavior Tables are optional entities. The example of behaviors are:

  • Website Visits
  • Purchase Logs
  • Support Inquiries
  • Device Usage Logs
  • etc.

How to use Audience Builder

First, click Audience tab on the left. In this screen, you specify Master Table, Attribute Tables, and Behavior Tables.

Step 1: Set Master Table

Specify Database Name and Table Name.

Step 2: Set Attribute Tables (Optional)

Specify Database Name and Table Name first. Then you can specify Foreign Key and Join Key, which is used to join Master Table with Attribute Tables. You can add as many tables as you want.

You can also add All Columns within an attribute table, or specify specific columns. Use the Name field to give a user-friendly name to the specific column.

Step 3: Set Behavior Tables (Optional)

Specify Database Name and Table Name first. Then you can specify Foreign Key and Join Key, which are used to join Master Table with Behavior Tables. You can add as many tables as you want.

As with the Attribute table, you can add All Columns within an attribute table, or just specify columns. Use the Name field to give a user-friendly name to the specific column.

Step 4: Schedule & Timezone

You can specify the schedule by which the audience data is refreshed. We recommend to run a refresh on a daily basis, to renew the dataset. Note that underlying table needs to be updated as well, before audience creation begins.

The default timezone can be also specified for the audience.

Step 4: Save and Run

Finally, click Save to save the configuration. Then, click Run to launch the series of processes that unify the tables.

When the process is finished, you can check the unified customer view under Customers tab in the left nav.

System Database, Tables and Workflow

When you save the Audience Builder settings, Audience Builder automatically creates the following entities within your accounts. Do not edit or modify these system-generated entities, otherwise your audience creation process will fail.

  • Database: cdp_audience_(AUDIENCE_ID)
    • Table: customers
    • Table: partitioned_customers
    • Table: behavior_(XYZ)
    • Table: activities
    • Table: cdp_new_web_access_(SEGMENT_ID)
  • Workflow: cdp_audience_(AUDIENCE_ID)

Data Enrichment

While unifying the customer data, Treasure Data also applies data enrichment to enrich customer information. Refer to the following article to review the list of data enrichment actions that are automatically applied.


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.