Hi Amplitude community!
Your help would be greatly appreciated here! I’m trying to build a chart/dashboard that shows account growth (or decline) over a period of time but not having much luck with building this view. For context, our customers book a total number of licenses as part of their contract and I would live to monitor whether or not customers are increasing their total number of active licenses vs booked licenses over time.
For example, if ACME company purchased 10,000 licenses, then I want to monitor if ACME is using more or less of those licenses month over month. Ideally, I would like to build a dashboard that shows this growth or decline in license utilization across all customers.
Best answer by Saish RedkarView original
Happy to help with this one! We have a similar use case and I like to use the Event Segmentation chart along with a combination of the Compare to Past and the Formula features for visualizing license utilization.
Assuming you already are using some sort of a segment/cohort for ACME company using the company identifier, you can plug in the following formula in the Formula tab or use the cumulative feature to visualize the usage growth for ACME in the Event Segmentation chart
Here A is the usage event you are tracking for that account.This would give the cumulative sum of the absolute number of users under the given account over the selected time period.
If you want to track the utilization growth in terms of %, you can try using the following formula
Once you are able to do so, try using the Compare to Past feature to get the desired period over period view.
Hope I have interpreted your use case correctly.
Let me know if this helps!
Could you think of a way to build a view of all accounts % license utilization without having to input the total_licenses_purchased for each account? We are sending account’s total number of booked licenses to Amplitude already.
Thanks so much for your help already!
Saish did a great job utilizing Amplitude for this use case! To help you further you are sending a total number of booked licenses to Amplitude as an Account property value. You want to know if you can use that value on each of your Accounts to divide Saish’s formula by correct? If that is the case unfortunately you cannot dynamically have that value as the total for each Account in Amplitude currently. Most of the Custom Formulas use events to calculate their results. There are a couple that looks at property value but there is not a property Custom Formula that will take the current property value of your total number of booked licenses Account property value per Account. Take a look at the link I shared above for Custom Formulas to see the full list of formulas you can use in this section!
Hope this helps let me know if you have questions!
Thanks for adding that
If you just want to see the growth in absolute user numbers, then just grouping by the account identifier with the CUMSUM(UNIQUES, A) should help.