--- title: "AI for Amplitude — Query Amplitude Data in Plain English" description: "Query your Amplitude event data in plain English. No SQL required." canonical: "https://www.aifordatabase.com/integrations/amplitude/" --- # AI for Amplitude. A Amplitude · Analytics Platform Query your Amplitude event data in plain English. No SQL required. [Connect Amplitude](https://app.aifordatabase.com/signup)[Connection options](https://www.aifordatabase.com/integrations/amplitude/#connection) Read-only · Flexible connection options Read-only query ``` > How many users completed onboarding this week? ``` ✓ Read-only · APISetup time varies by connection 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_id``event_type``event_time``event_properties``user_properties``platform``country` ### User Properties User-level attributes that persist across sessions `user_id``plan``signup_date``company``role``device_type` ### Sessions Session-level data including duration, entry/exit events, and session IDs `session_id``user_id``start_time``duration_ms``event_count` ### Merged Identities Maps multiple device/anonymous IDs to a single user for cross-device analysis `amplitude_id``merged_amplitude_id``merge_server_time` ## Problems 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 ### 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? ## 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 ## 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 Daily at 10 AM ### New feature adoption tracker Track adoption of a newly shipped feature, report to Slack daily Daily at 5 PM ### Conversion rate monitor Alert when the signup-to-activation funnel drops below 30% Every 6 hours ### Weekly product metrics email Email the product team a summary of DAU, WAU, top features, and retention Weekly on Monday at 9 AM ## Key metrics DAU / WAU / MAUEvents per userSession durationRetention (D1 / D7 / D30)Conversion rateFeature adoptionStickiness (DAU/MAU)Time to first actionBounce rateRevenue per user ## 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 01 Configure data export — In Amplitude, go to Settings → Data Destinations → set up S3, Snowflake, or BigQuery export 02 Wait for first export — Initial export may take a few hours depending on data volume 03 Connect in AI for Database — Add a new connection using your warehouse credentials 04 Select Amplitude as platform — Choose 'Analytics Platform (Warehouse)' → Amplitude for auto-detection ### 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 01 Get API credentials — In Amplitude, go to Settings → Projects → copy API Key and Secret Key 02 Connect in AI for Database — Add a new connection, select 'Analytics Platform (API)' → Amplitude 03 Paste credentials — Enter your API Key, Secret Key, and select your region ## How to find your Amplitude credentials 01 Log in to analytics.amplitude.com 02 Click the gear icon → Settings → Projects 03 Select your project 04 Copy the API Key (visible) and Secret Key (click 'Show') 05 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. [View official Amplitude documentation →](https://www.docs.developers.amplitude.com/analytics/find-api-credentials/) ## FAQ ### 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. [← All integrations](https://www.aifordatabase.com/integrations/) ## Your Amplitude 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/amplitude/