Analytics Integration
Query your Amplitude event data in plain English. No SQL required.
Product teams, growth analysts, and data engineers who use Amplitude to understand user behavior and want faster, more flexible access to their event data.
Connect your Amplitude analytics data to AI for Database and get instant answers from your behavioral data. Ask questions about user journeys, conversion funnels, and product engagement — and get results backed by real queries, not approximations.
Amplitude captures every interaction in your digital product. AI for Database makes that data accessible to anyone who can describe what they want to know, without writing SQL or navigating Amplitude's chart builder.
What data you can query
Events
Every tracked user action — pageviews, button clicks, transactions, custom events
user_idevent_typeevent_timeevent_propertiesuser_propertiesplatformcountryUser Properties
User-level attributes that persist across sessions
user_idplansignup_datecompanyroledevice_typeSessions
Session-level data including duration, entry/exit events, and session IDs
session_iduser_idstart_timeduration_msevent_countMerged Identities
Maps multiple device/anonymous IDs to a single user for cross-device analysis
amplitude_idmerged_amplitude_idmerge_server_timeProblems this solves
Chart builder is slow for ad-hoc questions
Building a new chart in Amplitude for every question takes time. Sometimes you just want a number.
Complex queries need SQL anyway
Amplitude's segmentation is powerful but limited. For multi-step funnels with custom logic, you end up exporting to SQL.
Cross-source analysis is manual
Amplitude knows behavior but not revenue details, support interactions, or backend metrics. Getting the full picture requires ETL work.
Event properties are hard to query
event_properties and user_properties are nested JSON. Querying specific properties in your warehouse requires verbose SQL.
How AI for Database helps
Ask questions in plain English. Get answers backed by real queries.
Instant behavioral analysis
Ask any question about user behavior and get an answer in seconds, not minutes of chart configuration.
> What are the top 10 most common user actions in the last 7 days, and how many unique users performed each?
Custom funnel analysis
Build funnels with custom logic that goes beyond Amplitude's built-in funnel chart.
> Show me the conversion rate from 'view_product' → 'add_to_cart' → 'checkout_complete' by platform (iOS vs Android) this month
Cohort comparison
Compare behavior across user segments without creating separate Amplitude cohorts.
> Compare the 30-day retention of users who completed onboarding in under 5 minutes vs those who took longer
Revenue attribution
Connect Amplitude behavior data to revenue outcomes.
> Which features are most used by users who upgraded to paid in the last 90 days? Show me the top 10 events by frequency.
Cross-device analysis
Leverage merge_ids for accurate cross-device user counts.
> How many truly unique users (after identity merging) were active last week?
Pre-built dashboard templates
User Engagement Dashboard
Track daily engagement metrics across your product
- Daily active users trend (line)
- Events per user (line)
- Top events by count (horizontal bar)
- Session duration percentiles (table)
- New vs returning users (stacked bar)
Conversion Funnel Dashboard
Monitor key conversion funnels in real time
- Signup funnel conversion rates (bar)
- Funnel drop-off by step (waterfall)
- Conversion rate by country (map/table)
- Time to convert distribution (histogram)
Product Health Dashboard
Overview of product health and usage patterns
- WAU trend (line)
- Feature usage breakdown (treemap)
- Error event rate (line)
- Platform distribution (pie)
- Weekly retention curve (line)
Automated workflows
Engagement drop alert
Alert when DAU drops more than 15% compared to the same day last week
Trigger: Daily at 10 AM
New feature adoption tracker
Track adoption of a newly shipped feature, report to Slack daily
Trigger: Daily at 5 PM
Conversion rate monitor
Alert when the signup-to-activation funnel drops below 30%
Trigger: Every 6 hours
Weekly product metrics email
Email the product team a summary of DAU, WAU, top features, and retention
Trigger: Weekly on Monday at 9 AM
Key metrics you can track
Example queries
> How many users completed onboarding this week?
Counts DISTINCT user_id from events where event_type = 'onboarding_complete' in the last 7 days
> What's the most common first action after signup?
For each user, finds the first event after 'signup' event_type, then counts and ranks by frequency
> Show me the retention curve for the January cohort
Computes day-N activity rates for users whose first event was in January, out to 30 days
> Which platform has the highest conversion rate?
Groups funnel completion by platform field, calculates percentage, orders descending
Connection options
Warehouse Export (Recommended)
Connect your Snowflake, BigQuery, or S3 bucket where Amplitude exports data. Best for production use.
Pros
- + Full historical data
- + No API limits
- + Best query performance
- + S3 export available on free plan
Cons
- - Requires warehouse setup
- - Data freshness depends on export schedule
Setup steps:
Direct API
Connect directly via Amplitude's Export API. Fast to set up, good for exploration.
Pros
- + Quick setup
- + Available on all plans
- + Real-time data
Cons
- - 4 GB response cap
- - Not suitable for large datasets
- - Rate limited
Setup steps:
How to find your Amplitude credentials
Log in to analytics.amplitude.com
Click the gear icon → Settings → Projects
Select your project
Copy the API Key (visible) and Secret Key (click 'Show')
Note your region: US or EU (check your URL)
Tip: The API Key is public (used in your tracking SDK). The Secret Key is private — keep it safe.
Frequently asked questions
Can I use this on Amplitude's free plan?
Yes. S3 export is available on all plans including Free. Direct API also works on all plans.
How do you handle Amplitude's merged identities?
We automatically detect the merge_ids table and provide guidance for identity resolution in queries.
Can I query event_properties JSON fields?
Yes. The AI automatically generates the correct JSON extraction syntax for your warehouse (Postgres, BigQuery, etc.).
What about Amplitude's privacy controls?
AI for Database queries your warehouse — it respects whatever data filtering Amplitude applies before export.
Start querying your Amplitude data
Connect in minutes. Ask questions in plain English. Get answers instantly.