Treasure Data

Customer Data Platform

Overview

πŸ“˜

Public Beta

This feature is released in Public Beta. For more information about this feature or any queries, contact Treasure Data Support.

Treasure Data, a Customer Data Platform (CDP), streamlines data transfer between systems. It enables businesses to consolidate data from one source and push it to multiple destinations, such as CleverTap, without requiring manual integration of each system.

The CleverTap and Treasure Data integration allows seamless data synchronization, enabling businesses to efficiently manage customer profiles and enhance targeted marketing efforts across platforms. If you have any issues with this integration, write to Treasure Data support.

πŸ“˜

Cloud Mode Integration

This integration uses Cloud-mode integration, which facilitates efficient data synchronization between Treasure Data and CleverTap. If you require a Device-mode integration for more granular control or specific use cases, contact Treasure Data.

Integrate Treasure Data with CleverTap

The integration process involves the following steps:

  1. Configure CleverTap Project on Treasure Data.
  2. Configure a Query Result for Import. OR
    Activate a Segment from Audience Studio.

Configure CleverTap Project on Treasure Data

To configure CleverTap on Treasure Data:

  1. Open TD Console and log in to your Treasure Data account.

  2. Select Integrations Hub from the top navigation menu.

  3. Click Catalog to view available integrations from the Integrations Hub.

  4. Search and select CleverTap from the list.

Configure CleverTap Project On Treasure Data Dashboard

Configure CleverTap Project On Treasure Data Dashboard

  1. Click Create Authentication and enter the required credential information as follows:
FieldDescription
Account IDAccess the CleverTap dashboard and locate the Project ID under Settings > Project.
Account PasscodeAccess the CleverTap dashboard and locate the Passcode under Settings > Project. For more information, refer to Account Passcode.
RegionAccess the CleverTap dashboard and locate Region for the API endpoint you want to select under Settings > Project. To find the API endpoint for your region, refer to API endpoints based on your data center region.
  1. Click Continue. You are prompted to enter a name for the authentication setup.
  2. Enter a Name for the Authentication and click Done.

Once the setup is complete, save any changes and verify that the integration is successfully set up. For more information, refer to the Treasure Data document.

Configure a Query Result for Import

This section provides information about steps to import user profiles, events, and segments from Treasure Data to CleverTap. This involves running a data query and setting options for the format and destination of the results. This process enables users to easily transfer and share data with other systems or tools.

The following are the steps to import data from the Treasure Data:

  1. Go to Data Workbench > Queries.
  2. Select New Query and define your SQL query.
  3. Click Export Results to configure the data import and enter the required details.
Connector Configuration Parameters

Connector Configuration Parameters

ParameterDescription
Target Data EntityIndicates the CleverTap Import Target Data Entity. Supported Values:

  • User Profiles: Upload the data related to user profiles.
  • User Events: Upload the data related to user events.
  • User Audiences - Custom List: Upload custom list segment.
For more information about each Target Data Entity, refer to Detailed Guide for Each Target Data Entity.
Thread Count NumberIndicates the number of concurrent requests to the CleverTap server. The minimum is 1, the maximum is 10, and the default is 5. This parameter only applies to Target Data Entity: User Profiles and User Events.
Skip on Invalid Record?Select if the job must skip the invalid record and continue to handle the next record. Otherwise, the job will stop if it encounters an invalid record.
  1. Select or create a CleverTap authentication and click Done.

For more information about each Target Data Entity, refer to Detailed Guide for Each Target Data Entity.

Activate a Segment from Audience Studio

You can also import segment data to CleverTap by creating an activation in the Audience Studio.

  1. Go to Audience Studio and select a parent segment.
  2. Right-click the target segment and select Create Activation.
  3. Enter and configure an activation name based on the above configuration parameters from the Details section.
  4. Customize the activation output from the Output Mapping section.
Customize Activation Output from Output Mapping section

Customize Activation Output from Output Mapping section

  • Attribute Columns
    • Toggle ON the Export All Columns to import all columns without making any changes.
    • Click + Add Columns to add specific columns for the import. The Output Column Name pre-populates with the same Source column name. You can update the Output Column Name. Continue to select + Add Columns to add new columns for your activation output.
  • String Builder
    Add string to create strings for export. Select from the following values:
    • String: Choose any value; use text to create a custom value.
    • Timestamp: The date and time of the export.
    • Segment Id: The segment ID number.
    • Segment Name: The segment name.
    • Audience Id: The parent segment number.
  1. Set a Schedule. Define your schedule and include optional email notifications.
Define Schedule to Activate a Segment

Define Schedule to Activate a Segment

  1. Click Create to finalize the activation.

You are now ready to import data into the CleverTap dashboard.