Skip to main content
Helper ⭐️
Jun 22, 2020 6:59 AM UTC
Question

Creating a report that shows data points per month

Hey all,

 

We are trying to create a report that will show the growth in accounts per month, meaning - for each month to show how many new accounts we have, how many churned (0, of course!) and how many active accounts we have overall each month.

At the moment we are doing this report manually in Klipfolio as it doesn’t seem like GS allows for historic data representation in graphs, but perhaps there is a way around it? Any suggestions?

This is an example of what the graph should look like visually, just ignore the parameters and imagine it shows - new accounts / churned accounts / overall accounts - per month.
 

 

Any suggestions would be highly appreciated!

12 replies

sai_ram
Expert ⭐️⭐️
Jul 14, 2020 9:29 AM UTC

@matthew_lind Thanks for your quick response here! Did you get a chance to view comments posted by @TalAmor ?

 

Translate
matthew_lind
VIP ⭐️⭐️⭐️⭐️⭐️
Jul 14, 2020 1:13 PM UTC

@TalAmor Sorry...I missed the additional replies.

On the filters, you’re exactly right. “Less or equal to last day of previous month” would be much more logical.

On the # of existing accounts, I would build a Bionic Rule. Use COUNT against the number of existing customers you have (using whatever criteria denotes a current customer in your instance), then push that value on a monthly basis to the MDA object you generated in an earlier step.

Translate
Making people their best....currently disguised as a CS Ops Architect. How can I contribute to your success?