Set up Activation and retention template and check the results
Use the prompt to add events, then check the stored fields and query results. Review the event definitions before relying on the numbers.
- 1
Choose when to log
Instrument the point where signup_completed becomes final.
- 2
Create the contract
Start with signup_completed, onboarding_step_completed, first_meaningful_action_completed and keep every field typed, bounded, and privacy-reviewed.
- 3
Run a fixture
Exercise known success, failure, retry, and empty-result cases before relying on aggregate results.
- 4
Answer the question
Which first action predicts week-two retention?
Template versus use case
Use this template to add events
Copy this template when the measurement goal is already clear. Use the matching use-case guide to review event boundaries, success definitions, and the decisions the resulting SQL should support.
Template
Paste this into your coding agent
Replace YOUR_API_KEY, run the flow locally, then verify the generated events and dashboards.
Activation and retention template
Instrument product activation and retention with Telemetry.
Use /skill.md and this Telemetry API key: YOUR_API_KEY
Log signup, onboarding, first successful integration, first meaningful action, core feature usage, invited teammate, dashboard/shared artifact creation, billing page viewed, upgrade intent, and seven-day return.
Create dashboards for visitor to signup, signup to activated account, activation to retained account, feature adoption, and upgrade-intent events by cohort.
Keep event names and properties consistent across client, server, and worker code.Events to capture
Verification checklist
Check the events, queries, and dashboard
Events
Synthetic events reach the intended table with stable names and field types.
Queries
The first SQL queries return plausible rows with an explicit time window.
Views
A dashboard uses the real fields and includes enough context to explain a change.
Safety
You checked that events exclude prompts, bodies, credentials, signatures, and private content.
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.
Use 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 recipeMeasure churn and reactivation by cohort
How many accounts churned, stayed active, or returned this month?
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 recipeMore templates