---
title: "AI for MoEngage — Query MoEngage Data in Plain English"
description: "Query your MoEngage engagement data with AI. No SQL needed."
canonical: "https://www.aifordatabase.com/integrations/moengage/"
---

# AI for MoEngage.

M

MoEngage · Analytics Platform



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

[Connect MoEngage](https://app.aifordatabase.com/signup)[Connection options](https://www.aifordatabase.com/integrations/moengage/#connection)

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_name``event_time``user_id``event_attributes``user_attributes`

### Campaign Interactions

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

`event_name``campaign_id``campaign_name``channel``user_id`

### User Profiles

Customer attributes, subscription preferences, and opt-in state

`customer_id``email``phone``custom_attributes``subscription_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 export — In MoEngage, go to Settings → Data Export → configure Snowflake or BigQuery

02

Verify data is landing — Check your warehouse for moe\_events tables

03

Connect in AI for Database — Add 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 →](https://docs.moengage.com/docs/data-export)

## 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.

[← All integrations](https://www.aifordatabase.com/integrations/)

## Your MoEngage 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/moengage/