What is workspace activity rate, and how do you measure it in Metabase?

Workspace activity rate is the share of eligible workspaces with enough recent human activity to count as active. A workspace can be a board, channel, site, space, folder, project, base, or document container.

Definition

Choose a window, qualifying event types, and a threshold. The example treats a workspace as active when at least two people generate five qualifying events in 30 days.

Data needed

• Workspace inventory with archived/test flags
• Activity events with workspace, actor, type, and timestamp
• Human/bot or automated-event classification
• Workspace owner, team, purpose, and lifecycle stage

SQL pattern

WITH activity AS (
  SELECT
    workspace_id,
    COUNT(*) AS qualifying_events,
    COUNT(DISTINCT actor_id) AS contributors
  FROM collaboration_events
  WHERE occurred_at >= CURRENT_DATE - INTERVAL '30 days'
    AND is_automated = FALSE
  GROUP BY workspace_id
)
SELECT
  ROUND(
    100.0 * COUNT(*) FILTER (
      WHERE COALESCE(a.qualifying_events, 0) >= 5
        AND COALESCE(a.contributors, 0) >= 2
    ) / NULLIF(COUNT(*), 0),
    2
  ) AS workspace_activity_rate
FROM workspaces w
LEFT JOIN activity a ON a.workspace_id = w.workspace_id
WHERE w.archived_at IS NULL;

Pitfalls

Related

FAQ