建立帳戶啟用渠道

產品分析中級

建立帳戶啟用渠道

有多少註冊帳戶連線資料、執行第一個查詢並建立儀表板？

加入帳戶佇列以訂購產品里程碑，以便分母包括每個符合條件的帳戶，包括那些從未取得進展的帳戶。

只讀 SQL

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;

資料集和查詢保留在此瀏覽器中。

Published expected result

註冊到儀表板啟用漏斗

圖表值

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

如何讀取查詢

帳戶資料表獨立於產品事件量來建立群組。
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.

SQL 無法做出的決定

1在編寫 SQL 之前，選擇帳戶、使用者或工作區作為漏斗單元。
2設定佇列視窗並允許每個帳戶都有相同的啟用機會。
3This funnel allows later successful retries and treats equal timestamps as ordered. Use stricter timestamps if your product requires them.

繼續本課

啟用 SQL 查詢範例 SQL漏斗分析保留用例

保留結果

對您自己的事件執行此查詢

僅當您準備好儲存查詢、連線真實事件並監視結果時，才建立空閒工作區。不需要信用卡。

儲存我的活動