Tracking user adoption throughout the (internal) beta

Problem to solve

We want a quick way to track adoption of the new navigation during the internal beta. We have snowplow charts that help with this, but it's a little opaque and open to interpretation. However, because we have the toggle state stored in the database, we can get this information straight from there using the queries below.

We could set up automation to pull this data into charts, but since we need to run this less than ten times over the course of the beta, keeping this manual is probably more efficient.

Queries

This query gets a list of users using/not using the navigation

SELECT u.username, up.use_new_navigation
FROM users u
  JOIN user_preferences up
    ON u.id = up.user_id
  JOIN members
    ON u.id = members.user_id
WHERE members.source_id = 6543

This query gets the adoption count summary

SELECT 
  CASE 
    WHEN use_new_navigation = TRUE THEN 'true'
    WHEN use_new_navigation = FALSE THEN 'false'
    ELSE 'null'
  END AS use_new_navigation, 
  COUNT(*) AS count 
FROM members
  JOIN user_preferences up
    ON members.user_id = up.user_id
WHERE members.source_id = 6543
GROUP BY up.use_new_navigation