23
complete SQL recipes
6
operational and product categories
1:1
query-to-result visualizations
Recipe collection
API reliability
Calculate API Error Rate by Route
Use SQL to rank API routes by 5xx error rate while protecting the result from low-volume noise.
See SQL and resultCalculate p50, p95, and p99 API Latency
Compare median and tail latency by endpoint with DataFusion-compatible percentile SQL.
See SQL and resultCalculate API Error-Budget Burn Rate
Turn hourly request failures into an SLO burn-rate series that shows how quickly the allowed error budget is being consumed.
See SQL and resultCompare API Reliability by Release
Compare traffic, 5xx rate, and p95 latency across application releases without attributing every post-deploy change to the deploy.
See SQL and resultRank Error Fingerprints by Customer Impact
Rank normalized application errors by occurrences and affected accounts instead of letting one retry loop dominate the incident view.
See SQL and resultRecipe collection
Background jobs
Measure Background Job Retry and Failure Rate
Find unreliable jobs by comparing successful runs, retries, failures, and tail duration.
See SQL and resultFind Stalled Background Jobs With SQL
Join job start and finish events to identify work that exceeded its expected completion window.
See SQL and resultMeasure Queue Wait Time by Job
Separate time spent waiting in a queue from execution duration and compare p50 and p95 delay by job name.
See SQL and resultRecipe collection
Webhooks
Measure Webhook Retry Recovery
Separate permanent webhook failures from deliveries that recovered on a later attempt.
See SQL and resultMeasure Webhook Latency and Duplicate Rate
Compare processing latency, duplicate deliveries, and failures by webhook provider and event type.
See SQL and resultRecipe collection
AI and LLM
Calculate LLM Cost by Feature and Model
Attribute model spend, tokens, request volume, and cost per request to product features.
See SQL and resultMeasure Accepted AI Outputs per Dollar
Connect model spend to accepted, saved, or otherwise useful product outcomes.
See SQL and resultMeasure LLM Cache Savings and Retry Cost
Compare cached requests, retry volume, and estimated spend by model to find avoidable AI cost.
See SQL and resultRecipe collection
Product analytics
Build a Signup-to-Activation Funnel in SQL
Calculate unique-user conversion through signup, onboarding, integration, and first-value milestones.
See SQL and resultCalculate Weekly Cohort Retention
Group users by first activity week and measure the percentage returning in later weeks.
See SQL and resultFind Features Used Before Upgrade
Join feature events to upgrade events and rank behaviors that occur before paid conversion.
See SQL and resultCalculate DAU, WAU, and Product Stickiness
Measure daily and weekly active users together and calculate DAU-to-WAU stickiness from a consistent activity definition.
See SQL and resultCompare Funnel Conversion by Acquisition Source
Measure signup-to-activation conversion by acquisition source while deduplicating repeated milestone events.
See SQL and resultMeasure Time to Activation
Calculate the distribution of elapsed time between signup and a user’s first meaningful product action.
See SQL and resultMeasure Churn and Reactivation by Cohort
Classify accounts as retained, churned, or reactivated from recurring meaningful product activity.
See SQL and resultRecipe collection
Structured events
Detect Missing Service Heartbeats
Find services, workers, or scheduled tasks that stopped reporting before a failure event appeared.
See SQL and resultQuery Nested AI Tool-Call Events
Filter dotted nested fields and rank failing tools without flattening the original event payload.
See SQL and resultDetect Error-Rate Spikes With a Rolling Baseline
Compare each hourly API error rate with a rolling seven-bucket average instead of relying on one permanent threshold.
See SQL and resultUse your own events
Replace the sample table and keep the analysis pattern
Telemetry creates tables from structured events. Once the fields are flowing, adapt a recipe, save the result, and turn it into a shared dashboard or alert.