M
MoEngage · Analytics Platform

AI for MoEngage.

Query your MoEngage engagement data with AI. No SQL needed.

Read-only · Flexible connection options

Read-only query
> Which push campaigns had the highest click rate this month?
✓ Read-only · APISetup time varies by connection

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_attributes

Campaign Interactions

Push clicks, email opens, SMS deliveries, in-app impressions

event_namecampaign_idcampaign_namechanneluser_id

User Profiles

Customer attributes, subscription preferences, and opt-in state

customer_idemailphonecustom_attributessubscription_state

Problems 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

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'?

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

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%

Daily at 11 AM

Weekly engagement report

Email a summary of all channel performance to the marketing lead

Weekly on Monday

Key metrics

Push CTREmail open rateIn-app conversion rateSMS delivery rateCampaign ROIOpt-in rateReachabilityUnsubscribe rate

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

01
Enable data exportIn MoEngage, go to Settings → Data Export → configure Snowflake or BigQuery
02
Verify data is landingCheck your warehouse for moe_events tables
03
Connect in AI for DatabaseAdd your warehouse connection and select MoEngage as the platform

How to set up MoEngage data export

01

Log in to the MoEngage Dashboard

02

Go to Settings → APIs

03

Note your Workspace ID and Data Center (DC1-DC4)

04

Under Data Export, configure Snowflake or BigQuery export

05

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.

View official MoEngage documentation →

FAQ

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.

Your MoEngage speaks English now.

Free plan available · No credit card required