--- title: "AI for CleverTap — Query CleverTap Data in Plain English" description: "Query your CleverTap campaign and event data with natural language." canonical: "https://www.aifordatabase.com/integrations/clevertap/" --- # AI for CleverTap. C CleverTap · Analytics Platform Query your CleverTap campaign and event data with natural language. [Connect CleverTap](https://app.aifordatabase.com/signup)[Connection options](https://www.aifordatabase.com/integrations/clevertap/#connection) Read-only · Flexible connection options Read-only query ``` > Which campaigns had the highest open rate this month? ``` ✓ Read-only · APISetup time varies by connection 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 `identity``ts``eventName``ep.Amount``ep.Category``platform``os` ### User Profiles User demographics, device info, custom attributes, and subscription preferences `identity``Name``Email``Phone``platform``os_version``custom_attributes` ### Campaign Metrics Delivery, open, click, and conversion data per campaign `campaign_id``campaign_name``sent``delivered``opened``clicked``converted` ## 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 ### 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 ## 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 ## 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% Daily at 10 AM ### Weekly campaign digest Email the marketing team a summary of all campaign performance Weekly on Monday ## Key metrics Campaign CTRDelivery rateConversion rateUninstall rateRevenue per campaignUser segment sizeEngagement scoreReachability rate ## 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 01 Enable Partner Export — In CleverTap, go to Settings → Integrations → Export → configure S3 or GCS 02 Load into warehouse — Use Glue, BigQuery Transfer Service, or your ETL tool to load exported data 03 Connect in AI for Database — Add your warehouse as a connection, select CleverTap as the platform ## How to set up CleverTap data export 01 Log in to the CleverTap Dashboard 02 Go to Settings → Integrations → Export 03 Configure Partner Export to your S3 or GCS bucket 04 Set format to Parquet (recommended) and schedule (4h or 24h) 05 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 →](https://docs.clevertap.com/docs/export-data) ## FAQ ### 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](https://www.aifordatabase.com/integrations/) ## Your CleverTap speaks English now. [Start free](https://app.aifordatabase.com/signup)[View pricing](https://www.aifordatabase.com/pricing/) Free plan available · No credit card required Source: https://www.aifordatabase.com/integrations/clevertap/