AI for Database
🎯

Analytics Integration

Query your CleverTap campaign and event data with natural language.

Growth marketers, CRM managers, and product analysts at consumer-facing companies in APAC/MEA who use CleverTap for engagement and need deeper analytics beyond the built-in dashboard.

Connect CleverTapSee connection options

Connect your CleverTap data to AI for Database and query campaign performance, user segments, and behavioral events in plain English. CleverTap's Partner Export delivers your data to S3, GCS, or Azure — connect the warehouse where that data lands and start asking questions immediately.

CleverTap powers engagement for some of the largest consumer apps in Asia-Pacific and the Middle East. AI for Database makes that engagement data queryable without SQL expertise.

What data you can query

Events

All tracked user actions — app launches, purchases, custom events with properties

identitytseventNameep.Amountep.Categoryplatformos

User Profiles

User demographics, device info, custom attributes, and subscription preferences

identityNameEmailPhoneplatformos_versioncustom_attributes

Campaign Metrics

Delivery, open, click, and conversion data per campaign

campaign_idcampaign_namesentdeliveredopenedclickedconverted

Problems this solves

Dashboard doesn't support custom cross-cuts

CleverTap's built-in analytics are channel-focused. Cross-channel or cross-campaign analysis requires exporting data.

Data is locked in proprietary format

Querying CleverTap data outside the platform requires Partner Exports and ETL pipelines.

Campaign ROI is hard to measure end-to-end

Connecting campaign sends to actual purchases or retention requires joining multiple data sources.

How AI for Database helps

Ask questions in plain English. Get answers backed by real queries.

Campaign performance analysis

Compare campaigns across channels without building individual CleverTap reports.

> Show me the top 10 push notification campaigns by click-through rate in the last 30 days

User segment deep-dives

Analyze behavior within specific user segments.

> What's the average purchase frequency for users in the 'High Value' segment compared to 'At Risk'?

Cross-channel attribution

Understand which channels drive the most conversions.

> Compare the conversion rate of email vs push vs in-app campaigns for our Q1 sale

Pre-built dashboard templates

Campaign Performance Dashboard

Track all campaign metrics in one view

  • Campaign sends vs opens trend (line)
  • CTR by channel (bar)
  • Top 10 campaigns by conversions (table)
  • Delivery rate trend (line)

Automated workflows

Low delivery rate alert

Alert when email delivery rate drops below 90%

Trigger: Daily at 10 AM

Weekly campaign digest

Email the marketing team a summary of all campaign performance

Trigger: Weekly on Monday

Key metrics you can track

Campaign CTRDelivery rateConversion rateUninstall rateRevenue per campaignUser segment sizeEngagement scoreReachability rate

Example queries

> Which campaigns had the highest open rate this month?

Groups campaign events by campaign_name, calculates opens/sends ratio, orders descending

> How many users made a purchase within 24 hours of receiving a push notification?

Joins push_delivered events with purchase events within 24-hour window, counts distinct users

Connection options

Warehouse via S3 Partner Export

CleverTap exports data to S3 (or GCS/Azure). Load it into your warehouse, then connect.

Pros

  • + Incremental exports
  • + Parquet format for performance
  • + Full historical data

Cons

  • - Requires ETL from S3 to warehouse
  • - GCS export is Enterprise only
  • - 4-hour minimum export interval

Setup steps:

1
Enable Partner Export — In CleverTap, go to Settings → Integrations → Export → configure S3 or GCS
2
Load into warehouse — Use Glue, BigQuery Transfer Service, or your ETL tool to load exported data
3
Connect in AI for Database — Add your warehouse as a connection, select CleverTap as the platform

How to set up CleverTap data export

1

Log in to the CleverTap Dashboard

2

Go to Settings → Integrations → Export

3

Configure Partner Export to your S3 or GCS bucket

4

Set format to Parquet (recommended) and schedule (4h or 24h)

5

Load the data into your warehouse using your preferred ETL tool

Tip: Use Parquet format for 5-10x faster query performance compared to JSON or CSV.

View official CleverTap documentation →

Frequently asked questions

Does this work without a warehouse?

CleverTap's API has limited export capabilities (5000 rows per request). For production use, warehouse export via S3 is strongly recommended.

How is the timestamp stored?

CleverTap uses Unix epoch integers (ts field). AI for Database automatically converts these to readable timestamps in queries.

Can I query the ep (event properties) JSON?

Yes. The AI generates correct JSON extraction syntax for whatever warehouse you use.

All integrations

Start querying your CleverTap data

Connect in minutes. Ask questions in plain English. Get answers instantly.

Start freeView pricing