At Pipedream, one core metric we want to monitor is the number of workflows (automations) that users create. I want to make sure I’m correctly defining this metric. Since we have a record of all workflows created, I’m selecting the

user_id

, the

timestamp

of creation, and a value of

1

, since creating a workflow should increment the measure:

SELECT
  user_id,
  created_at AS timestamp,
  1 AS value
FROM workflows

Is that correct? Separately we’re tracking a binomial metric on the users that reach the state of “created at least one workflow”, but since the goal of some experiments is to move the total count of workflows, and the goal of others is to move the rate of users that reach the state of creating at least one workflow, we thought both metrics were appropriate.

Yes, that looks correct.

cool, that makes sense!