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.
What does a workspace activity rate chart look like in Metabase?
Chart active workspaces as a share of all eligible workspaces each month, with "active" defined by real human events rather than bot noise. The climb means adoption is broadening, while a dip like Feb 2026's often follows a bulk provisioning of new workspaces — the denominator grows before the new spaces have had time to become active.
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;