Activation And Retention Template: implementation to decision
Treat the prompt as an implementation brief. The useful artifact is not copied code alone, but a reviewed event contract that produces a trustworthy answer.
- 1
Select the boundary
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
This page is the implementation brief
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 surfaces.Events to capture
Verification checklist
What a complete instrumentation pass leaves behind
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
Prompts, bodies, credentials, signatures, and private content were checked for redaction.
Event schema starting points
Event contracts for this workflow
Review the row grain, emit boundary, required types, privacy classes, example payload, and validation checklist before adapting a query or snippet to production.
Related product capability
Continue this workflow in Dashboards
Turn a validated product or revenue query into a focused decision surface.
Related SQL recipes
Answer the next question with SQL
Run the query against the structured fields from this workflow, inspect the example result, and turn a useful answer into a dashboard or 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