ContextFlo Blog

Amplitude integration is here

Query your Amplitude product analytics — retention, funnels, user behavior, revenue — in natural language, right alongside your SQL data.

March 12, 20263 min readContextFlo

ContextFlo now connects to Amplitude. Ask questions about your product analytics — retention, funnels, user behavior, revenue — in natural language, right alongside your SQL data.

No more switching between Amplitude dashboards and your data warehouse. One conversation, both sources.

What you can ask

Once connected, you can query Amplitude the same way you'd ask a colleague:

Q

What does our signup-to-purchase funnel look like this month?

Q

What's our D1, D7, and D30 retention?

Q

Which features do our most active users use?

Q

How many sessions per user are we averaging this week?

Q

Show me the top events by volume

Q

Look up user [email protected] and show me their recent activity

ContextFlo figures out which Amplitude endpoints to call, passes the right parameters, and gives you a clear answer.

14 endpoints, fully covered

The integration covers the full Amplitude Dashboard REST API:

Event Segmentation

Counts, uniques, DAU%, with grouping and filters

Funnel Analysis

Step-by-step conversion rates between events

Retention

D1/D7/D30 retention with pre-calculated percentages

Revenue LTV

ARPU, ARPPU, total revenue, paying users

User Search

Find users by email, user ID, or Amplitude ID

User Activity

Full event stream for a specific user

User Composition

Breakdown by country, platform, device, etc.

User Counts

Active and new user trends over time

Event List

All tracked events with volume

Session Length

Distribution histogram of session durations

Avg Session Length

Average session duration over time

Sessions Per User

Average sessions per user over time

Real-time Active Users

Live count of currently active users

Chart Results

Pull data from saved Amplitude charts

Cross-source answers

The real power is combining Amplitude with your SQL data in a single conversation.

“What's the conversion rate from signup to purchase in Amplitude, and what's the average order value for converted users in our database?”

What happens:

  1. Queries Amplitude funnel API for signup → purchase conversion
  2. Queries your SQL warehouse for average order value
  3. Combines both into a single answer

Before this, answering that question meant opening Amplitude, building a funnel chart, exporting it, switching to your SQL tool, running a query, and manually combining the results. Now it's one prompt.

Getting started

Connect Amplitude in your ContextFlo settings — you'll need your Amplitude API Key and Secret Key (found under your Amplitude project settings). Once connected, the endpoints are immediately available in your MCP client.

Works with Claude, Cursor, and any other MCP-compatible client.