topic Re: I built a small cohort-analysis plugin - it's free! in Sales Integrations

I built a small cohort-analysis plugin - it's free!

jonojeff — Thu, 04 Apr 2024 22:32:28 GMT

Hi everyone,

After exporting HS data and having to run detailed analysis in Excel, I teamed up with a friend to build a neat little tool, Sales Studio that takes your HS deal and pipeline data and presents it in a pivot table, that's interactive. You can see it with dummy data here

It's free right now - I'm just looking for some friendly community feedback on how I can improve it 🙂

Cheers!

Re: I built a small cohort-analysis plugin - it's free!

PamCotton — Thu, 04 Apr 2024 22:33:47 GMT

Hey @jonojeff, Thank you for sharing Sales Studio with us! It sounds like you've put a lot of effort into creating a useful tool for the Community.

We're always excited to see innovative solutions like yours.

Kindly,

Pam

Re: I built a small cohort-analysis plugin - it's free!

Sebastiaan_R — Mon, 13 May 2024 13:36:45 GMT

Awesome. Would love to give it a try. Where can i find it?

Re: I built a small cohort-analysis plugin - it's free!

jonojeff — Mon, 13 May 2024 14:46:19 GMT

Hey @Sebastiaan_R - awesome! try it out here: https://sales.studio

Re: I built a small cohort-analysis plugin - it's free!

Sebastiaan_R — Wed, 15 May 2024 12:58:19 GMT

Much appreciated. Just checked it out. Currently wouldn't work for our use case. What would help:
-option for number of deals, instead of amount total
-option for weekly, instead of monthly
-option for conversion percentages in the table

It would then end up looking like attached example. Ecept this is retention. For us its about deals converting and later you would expect higher conversion. So it would be progress conversely (instead of high percentage to low, it would start low and later on in the year convert more and more)

Re: I built a small cohort-analysis plugin - it's free!

jonojeff — Wed, 15 May 2024 13:14:42 GMT

Hey Sebastiaan,

Thanks for looking into this! I'm going to send you an email as I have a few follow up questions! 🙂

Cheers

Re: I built a small cohort-analysis plugin - it's free!

dsa — Sun, 19 May 2024 09:27:37 GMT

Hi Jeff,

I tried using your tool but getting revenue cohort data only. What would be useful is number of deals. Cohort anlysis of deals created in say Feb'24 whats their conversion looking like by stage. Also, hubspot doesnt automatically change the date even if the deal is moved in the deal dashbaord from evalution to closed won.

Happy to chat and explain the scenarios.

Re: I built a small cohort-analysis plugin - it's free!

jonojeff — Mon, 20 May 2024 07:10:30 GMT

Hey @dsa,

Thanks for sharing this. We can definitely add just '#' of deals instead of a deal-value. In terms of deals created in say 'Feb 24' - isn't closed-won the only way of measuring conversions? If a deal is in another stage, wouldn't that imply it hasn't converted yet?
If the deal moves to Closed-Won we are able to automatically track the date it converts to map it.
Would love to chat with you, though! Could you DM me your email and I'll reach out? 🙏

Re: I built a small cohort-analysis plugin - it's free!

dsa — Tue, 21 May 2024 07:51:59 GMT

Hi Jeff,

I am looking to build 2 tables like below. The objective is to build the cohort data of the progress (volume breakdown and conversion rates) in each month. This is not possible with Hubspot.

Snapshot Date: July
Deal creation month	# Deals created	Stage 1	Stage 2	Stage 3	Stage 4	Stage 5	Stage 6 (lost)
Feb	52	0	7	12	17	14	2
Mar	60	2	9	15	21	12	1
Apr	70	4	12	18	22	12	2
May	75	5	18	21	20	10	1
June	80	6	24	21	23	6	0

Snapshot Date: July
Conversion Rate	# Deals created	Stage 1	Stage 2	Stage 3	Stage 4	Stage 5	Stage 6 (lost)
Feb	52	0%	13%	23%	33%	27%	4%
Mar	60	3%	15%	25%	35%	20%	2%
Apr	70	6%	17%	26%	31%	17%	3%
May	75	7%	24%	28%	27%	13%	1%
June	80	8%	30%	26%	29%	8%	0%

Re: I built a small cohort-analysis plugin - it's free!

KCastlemain5 — Wed, 19 Jun 2024 03:45:02 GMT

Super cool, except when I saw that it only allowed the importing of deals, I was disappointed because we are needing to look at the top-of-funnel data here. So number of Leads (new object) that enter a sales pipeline (we have multiple), by when, from which weekly or month <lead created date> cohort.

Re: I built a small cohort-analysis plugin - it's free!

JGaeng — Fri, 16 Aug 2024 19:57:53 GMT

Looks like the domain is expired. Is this tool still available?

Re: I built a small cohort-analysis plugin - it's free!

Ksveder — Tue, 06 May 2025 15:11:45 GMT

Hey Jonojeff, how can I give it a try? 🙂