DataChannel

Workflow Automation

Overview

DataChannel is a cloud-based ETL platform that allows businesses to integrate and load data from various sources, such as CleverTap, into data warehouses such as Amazon Redshift, Google BigQuery, or Snowflake.

With CleverTap and DataChannel integration, you can:

  • 360-Degree Customer View: Sync CleverTap user profiles (demographics, preferences, activity) with a data warehouse to unify customer data across multiple sources for better personalization.
  • Behavioral Analytics & Funnel Optimization: Export CleverTap event data (app visits, purchases, drop-offs) to analyze user journeys, identify friction points, and optimize conversion funnels.
  • Cross-Channel Attribution & Campaign Performance: Merge CleverTap events (email opens, push notifications, in-app actions) with CRM and ad platform data to measure marketing impact and refine targeting.

This powerful combination boosts customer engagement and drives impactful marketing and business results.

Prerequisites for Integration

The following are the prerequisites:

  • Ensure you have a DataChannel account.
  • Ensure you have a destination data warehouse (for example, Amazon Redshift, Google BigQuery, Snowflake) set up and accessible in DataChannel account.
  • Ensure you have a CleverTap account with a valid Account ID, Passcode, and Region.

๐Ÿšง

Support For Integration

This integration is managed and continuously improved by DataChannel. The CleverTap and DataChannel integration has undergone stringent testing to ensure seamless functionality. For any questions or issues, contact DataChannel for support and resolution.

Integrate DataChannel with CleverTap

This process involves the following three major steps:

  1. Add CleverTap as a Source on DataChannel
  2. Configure the Data Warehouse as a Destination on DataChannel
  3. Create and Configure Data Pipelines

Add CleverTap as a Source on DataChannel

To add CleverTap as a source in DataChannel for exporting data from CleverTap to Datachannel:

  1. Go to Exporte Connections from your DataChannel dashboard and search for CleverTap.
  2. Click Edit Icon icon to create a new pipeline.
Add CleverTap as a Source on DataChannel

Add CleverTap as a Source on DataChannel

  1. Enter the following details:
FieldDescription
Account IDLocate the Project ID under Settings > Project from the CleverTap dashboard.
Account PasscodeLocate the Passcode under Settings > Project from the CleverTap dashboard. For more information, refer to Account Passcode.
RegionLocate 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.
Connect CleverTap as a source

Connect CleverTap as a source

  1. Click Save to add CleverTap as a source once the connection is verified.

Configure the Data Warehouse as Destination on DataChannel

After adding CleverTap as a source, configure the data warehouse to store the extracted data from CleverTap. To do so, follow these steps:

โ—๏ธ

Data Warehouse selection

Data Warehouse once selected cannot be changed.

  1. Navigate to the Connect Your DataSource section in DataChannel.
  2. Select your preferred Data Warehouse from the available options (for example, Amazon Redshift, Google BigQuery, Snowflake, Azure Synapse, and MySQL).
Connect DataSource

Connect DataSource

  1. Add your data warehouse as a destination by providing the required connection details and click Continue.

Create and Configure Data Pipelines

Once CleverTap is connected and the data warehouse is set up, configure data pipelines to determine what data should be extracted from CleverTap and sent to the data warehouse.

Considering a use case to create and configure data pipelines:

Tracking User Engagement Trends: To illustrate the process, consider a business that wants to track daily user engagement trends from CleverTap and store them in Google BigQuery for analysis. To do so, follow these steps:

  1. Define Data Sources: Select a data pipeline that suits your use case, and refer to List of Available. In this use case, we will select Trend Analysis - Daily to track daily user engagement trends from CleverTap
Define Data Sources

Define Data Sources

  1. Report Details Configuration: This pipeline can be used to request and retrieve the details of user events from CleverTap. Enter the following details:
ParametersDescription
Event NameThe event type needed includes both standard and custom events.
Number of DaysThe number of days for which you wish to get the data in each run.
Insert ModeUPSERT will insert only new records or records with changes; APPEND will insert all fetched data at the end; REPLACE will drop the existing table and recreate a fresh one.
Report Details Configuration

Report Details Configuration

  1. Schedule Data Sync: Choose a schedule for running the data pipeline:
    • Manual Run: Manually trigger the pipeline whenever required.
    • Scheduled Run: Select a predefined schedule from the dropdown options.
Schedule Data Sync

Schedule Data Sync

  1. Entering Dataset Details:
    1. Provide a Name for the dataset.
    2. (Optionally) Add a Description for better identification.
    3. Check mark the Run after save to save the integration.
Finalize Setup

Finalize Setup

  1. Click Submit to finalize the setup and run the data export.
  2. Select Numbers of Runs to monitor the pipeline and check the status of your pipeline in the dashboard.
    The statuses include:
    • Running
    • Successful
    • Error (if there are issues)
Monitor the pipeline

Monitor the Pipeline

  1. Select Data Preview to preview the data once the pipeline has successfully run.
Data Preview

Data Preview

FAQs

What should I do if my data is not syncing properly?

If your data is not syncing, try the following steps:

  1. Check Pipeline Status โ€“ Ensure the data pipeline is active.
  2. Verify Destination Setup โ€“ Confirm that the data warehouse is correctly configured.
  3. Review Logs โ€“ Check logs in DataChannel for errors or failures.
  4. Confirm API Access โ€“ Make sure CleverTap API access is enabled.
  5. Check Sync Schedule โ€“ Ensure the pipeline is running at the scheduled time.

If the issue persists, contact DataChannel Support for assistance.