Onboarding Flow Analytics

const ONBOARDING_STEPS = [
  'account_created',
  'email_verified',
  'workspace_named',
  'first_integration_connected',
  'teammate_invited',
  'onboarding_completed',
] as const;

function trackOnboardingStep(
  step: typeof ONBOARDING_STEPS[number],
  userId: string,
  metadata?: Record<string, unknown>
) {
  analytics.track('onboarding_step_completed', {
    step,
    step_index: ONBOARDING_STEPS.indexOf(step),
    user_id: userId,
    ...metadata,
  });
}

// Fire on the actual completion of the underlying action, not on
// screen render -- e.g., after a successful API connection test,
// not just when the "Connect Integration" screen is displayed.
trackOnboardingStep('first_integration_connected', userId, {
  integration_type: 'salesforce',
  time_since_signup_sec: 342,
});

SELECT
  u.user_id,
  u.signup_timestamp,
  MIN(e.event_timestamp) AS first_value_timestamp,
  TIMESTAMP_DIFF(MIN(e.event_timestamp), u.signup_timestamp, MINUTE) AS ttfv_minutes
FROM users u
JOIN events e
  ON e.user_id = u.user_id
  AND e.event_name = 'core_value_event' -- e.g., "first_report_generated"
GROUP BY u.user_id, u.signup_timestamp
HAVING ttfv_minutes IS NOT NULL
ORDER BY ttfv_minutes;