Skip to content
Telemetry
Event tracking template

Activation and retention template

See which users finish onboarding, return to the product, and show interest in upgrading.

Reviewed by the Telemetry product team on . We checked the event names, suggested fields, questions to query, and data to exclude. Who reviews this page

Questions you can answer
  • Which first action predicts week-two retention?
  • Which onboarding step loses qualified users?
  • Which features appear before upgrade intent?
How to test this template

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. 1

    Choose when to log

    Instrument the point where signup_completed becomes final.

  2. 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. 3

    Run a fixture

    Exercise known success, failure, retry, and empty-result cases before relying on aggregate results.

  4. 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.

Read Product analytics for retention

Template

Paste this into your coding agent

Replace YOUR_API_KEY, run the flow locally, then verify the generated events and dashboards.

activation-retention

Activation and retention template

text
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

signup_completedonboarding_step_completedfirst_meaningful_action_completedfeature_usedretention_milestone_reached

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

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.

Browse all recipes
Recipe collectionsProduct analytics SQL

More templates