https://www.growthbook.io/ logo
#announcements
Title
# announcements
f

freezing-finland-88631

06/11/2022, 7:19 PM
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:
Copy code
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.
f

future-teacher-7046

06/11/2022, 7:20 PM
Yes, that looks correct.
It's common to have both a binomial and count metric with almost the exact same query
f

freezing-finland-88631

06/11/2022, 7:22 PM
cool, that makes sense!
18 Views