Analytics Integration
Query your MoEngage engagement data with AI. No SQL needed.
Marketing managers, product analysts, and CRM teams at mobile-first companies using MoEngage for push, email, SMS, and in-app messaging.
Connect your MoEngage data to AI for Database and ask questions about campaigns, user segments, and behavioral events in natural language. MoEngage natively exports to Snowflake and BigQuery — connect your warehouse and start querying immediately.
MoEngage powers multi-channel engagement for mobile-first companies across Asia-Pacific. AI for Database makes that engagement data queryable by anyone on your team.
What data you can query
Events
All custom events and campaign interaction events in a single table
event_nameevent_timeuser_idevent_attributesuser_attributesCampaign Interactions
Push clicks, email opens, SMS deliveries, in-app impressions
event_namecampaign_idcampaign_namechanneluser_idUser Profiles
Customer attributes, subscription preferences, and opt-in state
customer_idemailphonecustom_attributessubscription_stateProblems this solves
Single-table schema is hard to query
MoEngage exports all events to one table. Finding specific events or campaigns requires complex WHERE clauses.
JSON attributes need manual extraction
event_attributes and user_attributes are JSON blobs. Getting specific values requires SQL JSON functions.
Cross-channel reporting is manual
Comparing push vs email vs in-app performance requires building separate reports in MoEngage.
How AI for Database helps
Ask questions in plain English. Get answers backed by real queries.
Campaign performance comparison
Compare all channels in one query without building separate MoEngage reports.
> Compare the click-through rates of push, email, and in-app campaigns from the last 30 days
User journey analysis
Track user behavior across touchpoints.
> Show me the most common sequence of events for users who made their first purchase this month
Segment performance analysis
Analyze engagement by user segment.
> What's the average email open rate for users in the 'Dormant' segment vs 'Active'?
Pre-built dashboard templates
Multi-Channel Engagement Dashboard
Compare all engagement channels side by side
- Sends by channel (stacked bar)
- CTR by channel trend (line)
- Top campaigns this week (table)
- Opt-in rates by channel (bar)
Automated workflows
Campaign performance alert
Alert when any campaign's CTR drops below 2%
Trigger: Daily at 11 AM
Weekly engagement report
Email a summary of all channel performance to the marketing lead
Trigger: Weekly on Monday
Key metrics you can track
Example queries
> Which push campaigns had the highest click rate this month?
Filters events by event_name = 'push_click', groups by campaign_name from event_attributes, calculates CTR
> How many users received both a push and an email this week?
Finds DISTINCT user_ids with push_delivered AND email_delivered events, counts the intersection
Connection options
Native Warehouse Export (Recommended)
MoEngage exports directly to Snowflake or BigQuery hourly. Connect your warehouse and start querying.
Pros
- + Native integration — no ETL needed
- + Hourly data freshness
- + Full event history
Cons
- - Requires MoEngage Enterprise plan for some export options
Setup steps:
How to set up MoEngage data export
Log in to the MoEngage Dashboard
Go to Settings → APIs
Note your Workspace ID and Data Center (DC1-DC4)
Under Data Export, configure Snowflake or BigQuery export
Use your warehouse credentials to connect in AI for Database
Tip: MoEngage uses a single table for all events. AI for Database handles the WHERE event_name filtering automatically.
Frequently asked questions
Why is everything in one table?
MoEngage exports all events (custom + campaign) to a single table with an event_name column. AI for Database handles the filtering automatically.
What about the timestamp suffix on table names?
MoEngage creates tables like moe_events_20240301. We detect these patterns and query across all matching tables.
Can I query campaign-specific attributes?
Yes. Campaign details are stored in the event_attributes JSON. AI for Database extracts them automatically.
Start querying your MoEngage data
Connect in minutes. Ask questions in plain English. Get answers instantly.