Cree un embudo de activación de cuenta

Análisis de productoIntermedio

Cree un embudo de activación de cuenta

¿Cuántas cuentas registradas conectan datos, ejecutan una primera consulta y crean un panel?

Únase a la cohorte de cuentas para alcanzar los hitos del producto ordenado para que el denominador incluya todas las cuentas elegibles, incluidas aquellas que nunca progresan.

SQL de solo lectura

WITH signups AS (
  SELECT a.account_id, MIN(p.timestamp_utc) AS signed_up_at
  FROM accounts AS a
  LEFT JOIN product_events AS p
    ON p.account_id = a.account_id
    AND p.event_name = 'account_signed_up' AND p.status = 'success'
  GROUP BY a.account_id
),
connections AS (
  SELECT s.account_id, s.signed_up_at, MIN(p.timestamp_utc) AS connected_at
  FROM signups AS s
  LEFT JOIN product_events AS p
    ON p.account_id = s.account_id
    AND p.event_name = 'integration_connected' AND p.status = 'success'
    AND p.timestamp_utc >= s.signed_up_at
  GROUP BY s.account_id, s.signed_up_at
),
first_queries AS (
  SELECT c.account_id, c.signed_up_at, c.connected_at,
    MIN(p.timestamp_utc) AS first_query_at
  FROM connections AS c
  LEFT JOIN product_events AS p
    ON p.account_id = c.account_id
    AND p.event_name = 'first_query_completed' AND p.status = 'success'
    AND p.timestamp_utc >= c.connected_at
  GROUP BY c.account_id, c.signed_up_at, c.connected_at
),
milestones AS (
  SELECT q.account_id, q.signed_up_at, q.connected_at, q.first_query_at,
    MIN(p.timestamp_utc) AS dashboard_at
  FROM first_queries AS q
  LEFT JOIN product_events AS p
    ON p.account_id = q.account_id
    AND p.event_name = 'dashboard_created' AND p.status = 'success'
    AND p.timestamp_utc >= q.first_query_at
  GROUP BY q.account_id, q.signed_up_at, q.connected_at, q.first_query_at
),
stages AS (
  SELECT 1 AS step, 'Signed up' AS stage, COUNT(signed_up_at) AS accounts
  FROM milestones
  UNION ALL
  SELECT 2, 'Connected data', COUNT(connected_at) FROM milestones
  UNION ALL
  SELECT 3, 'Ran first query', COUNT(first_query_at) FROM milestones
  UNION ALL
  SELECT 4, 'Created dashboard', COUNT(dashboard_at) FROM milestones
)
SELECT
  stage,
  accounts,
  ROUND(100.0 * accounts
    / NULLIF(MAX(CASE WHEN step = 1 THEN accounts END) OVER (), 0), 1)
    AS conversion_pct
FROM stages
ORDER BY step;

El conjunto de datos y la consulta permanecen en este navegador.

Published expected result

Embudo de activación de registro en el panel

Valor del gráfico

Signed up

100%

Connected data

83,3%

Ran first query

66,7%

Created dashboard

50%

stage	accounts	conversion_pct
Signed up	6	100
Connected data	5	83,3
Ran first query	4	66,7
Created dashboard	3	50

Cómo leer la consulta

La tabla de cuentas establece la cohorte independientemente del volumen de evento-producto.
Each stage selects the first successful milestone at or after the previous eligible stage; repeated events count once.
A missing or out-of-order milestone blocks every later stage. A later successful retry can restore valid progression.

Decisiones que el SQL no puede tomar

1Elija la cuenta, el usuario o el espacio de trabajo como unidad de embudo antes de escribir SQL.
2Establezca una ventana de cohorte y permita que cada cuenta tenga la misma oportunidad de activación.
3This funnel allows later successful retries and treats equal timestamps as ordered. Use stricter timestamps if your product requires them.

Continuar de esta lección

Receta de activación SQL Análisis de embudo SQL Caso de uso de retención

mantener el resultado

Ejecute esta consulta en sus propios eventos

Cree un espacio de trabajo libre solo cuando esté listo para guardar la consulta, conectar eventos reales y monitorear el resultado. No se requiere tarjeta de crédito.

Ahorra con mis eventos