We group our users into “customers” in the Accounts Addon in Amplitude, given we are a B2B service.
Now I would like to understand the average number of new users (there is an event “user created” for that) per customer.
Meaning, NOT the rolling average of each customer’s new users. But the average across the customers. So the average of CustomerA:5, CustomerB: 10 → 7.5 new users.
Best answer by kornelius
HI
Not sure if that works. The problem is, that PROPCOUNTAVG(A) is always 1, given that every user is just within 1 company. So Average is also always 1.
Basically what I ended up dogin was rather simple.
A: User Created events (uniques, while totals would not differ)
B: Any Active Event grouped by customer_name
Then I divide the two by
UNIQUES(A) / PROPCOUNT(B)
So I get the number of Users Created per number of Customers.
+6Hi
Would that not just calculate the avg of the userids? Like there is user 10, user 20 so the avg would be 15? So irrelevant to actually get the average of how many events were triggered?
+6Good point! In that case I think PROPCOUNTAVG (returns the average number of distinct values) would suit. Thoughts?
This unfortunately also does not work.
The problem is, that average is either per group (so I have many averages) or per user (which only gives the average how often a user performed this). I would like to see one average on the average of the groups.
+6Hi
PROPCOUNTAVG(A)*UNIQUES(B)/PROPCOUNT(A)
The PROPCOUNTAVG formula is applied to event A, and event A is grouped by 'Group name (Playlists)’. So the PROPCOUNTAVG(A) in this chart returns the average number of playlists that a user joins.
The numerator shows total users (non-deduplicated) across provided playlists, which is equivalent to 'average number of playlists that a user joins' (PROPCOUNTAVG(A)) multiplied by 'total unique users' (UNIQUES(B)).
As the denominator is the number of workspaces, this chart returns the average number of users across playlists.
HI
Not sure if that works. The problem is, that PROPCOUNTAVG(A) is always 1, given that every user is just within 1 company. So Average is also always 1.
Basically what I ended up dogin was rather simple.
A: User Created events (uniques, while totals would not differ)
B: Any Active Event grouped by customer_name
Then I divide the two by
UNIQUES(A) / PROPCOUNT(B)
So I get the number of Users Created per number of Customers.
If you don't have an Amplitude account, you can create an Amplitude Starter account for free and enjoy direct access to the Community via SSO. Create an Amplitude account. You can also create a Guest account below!
If you don't have an Amplitude account, you can create an Amplitude Starter account for free and enjoy direct access to the Community via SSO. Create an Amplitude account. Want to sign up as a guest? Create a Community account.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
