Measure Product analytics for retention and check the results
To measure product analytics for retention, choose one workflow and its owner. Define the events, test them with known inputs, and write a query that answers a specific question.
- 1
Choose when to log
Define the activation moment for the product.
- 2
Capture the outcome
Begin with onboarding_step_completed, first_meaningful_action_completed, feature_used and document the grain of each event.
- 3
Check the stored rows
Build dashboards for activation, weekly active teams, adoption, and upgrade intent.
- 4
Make the decision
Which first action best predicts retained teams?
Use case versus template
Choose what to measure
Use this guide to choose what to measure and when to log it. For a shorter setup prompt, open the matching template.
Related use cases
Check which events this guide covers
- Use this guide to measure activation, feature adoption, and return visits.
- Use SaaS revenue analytics when the source of truth is subscription MRR movement and revenue retention.
- Use telemetry data quality to check event freshness, required fields, types, and duplicates.
Agent prompt
Paste this into your coding agent
Replace YOUR_API_KEY after signup, then ask the agent to run the product flow and verify the first events.
Product analytics for retention setup prompt
Instrument product usage and retention with Telemetry.
Use /skill.md and this Telemetry API key: YOUR_API_KEY
Please add structured events for:
1. Signup, onboarding step completion, team creation, first successful integration, and first meaningful product action.
2. Core feature usage with feature_name, action, surface, team_id, user_id, status, latency_ms, and error_type when relevant.
3. Retention milestones: second active day, first saved dashboard, first shared artifact, first alert created, and first return after seven days.
4. Expansion signals: invited teammate, upgraded plan intent, billing page viewed, usage limit reached, and support requested.
Create a dashboard for activation rate, weekly active teams, feature adoption, retained teams by first action, and upgrade-intent events.Setup steps
- 1Define the activation moment for the product.
- 2Ask an agent to instrument onboarding, core feature usage, and return events.
- 3Send test events for a new account and a returning account.
- 4Build dashboards for activation, weekly active teams, adoption, and upgrade intent.
Events to capture
Questions you can answer
- Which first action best predicts retained teams?
- Which features are adopted by accounts that later upgrade?
- Where does onboarding lose otherwise qualified users?
Example event schemas
Event schemas for this workflow
Check what each event records, when to send it, and which field types it needs. Review the example payload and privacy checklist before using it in production.
user_signed_up
One accepted signup per user and account.
View schemaproduct_milestone_completed
One completed milestone per actor, account, and occurrence.
View schemafeature_rollout_evaluated
One effective feature evaluation per actor, feature, assignment version, and material change.
View schemaUse these queries in Telemetry
Learn about Dashboards
Save a product or revenue query to a dashboard your team can check.
Related SQL recipes
More SQL recipes
Run the query using this workflow's event fields and check the example result. Save the result to a dashboard or set up an alert.
Build a signup-to-activation funnel in SQL
Where do new users leave before reaching first value?
Open recipeCalculate weekly cohort retention
What percentage of each signup cohort returns in weeks one through twelve?
Open recipeCalculate DAU, WAU, and product stickiness
What share of weekly active users returns on an average day?
Open recipeMeasure time to activation
How long does it take new users to reach the first meaningful action?
Open recipeFind features used before upgrade
Which features are most commonly adopted before an account upgrades?
Open recipeCompare experiment conversion and revenue lift
Did the experiment improve conversion and revenue per assigned participant?
Open recipeMeasure product journey drop-off by session
Where do sessions leave the path from landing page to first query?
Open recipeCompare feature rollout error rate
Is the feature-flag rollout less reliable than its control cohort?
Open recipeCustomer evidence
Related customer stories
Next step
Create the API key your agent will use
The free plan is enough to run the prompt, send test events, and review the first dashboard.
Related pages
Cursor Telemetry setup
Paste this prompt into Cursor to add event tables, track signup steps, and build dashboards.
Open pageSaaS revenue analytics with SQL
Track subscription revenue changes alongside invoices, entitlements, and product events. Reconcile the totals with your billing provider before reporting MRR.
Open pageClaude Code observability
Ask Claude Code to add event logging while it implements a feature, then verify the events in Telemetry.
Open page