Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Aug 24, 2024 11:48 AM
Hi, I coud use some help on what I think is a relatively simple few concepts.
I have a base called "Sales Pipeline" where I am tracking:
Let's say there are 100 total records, each with a Deal Name, a Pipeline Stage and an Opp Status
I'd like to be able to:
I suspect I can do this using a 1) separate base, that 2) is linked to my Sales pipeline, where I can then 3) use Rollups to count the # of records at each pipeline stage, or opportunity status and calculate that in the table. From there I can create Interface charts to reflect he overall conversion metrics.
Is this the right approach? I am stuck trying to rollup the "deals" in the sales pipeline, but also not sure if this is the right approach either way.
Aug 24, 2024 12:29 PM
Hey!
If you want to see that on an interface, you might want to check out this discussion, addressing this same situation! Otherwise, your suggested approach (diff table for stages and rollups) will work!
I hope this helps!
Aug 24, 2024 11:33 PM
Hmm, when you say separate base I believe you may be referring to a separate table instead?
If so, I've put something together here for how I'd do it
I think I'd just use Count fields instead of rollups actually
How you calculate things is also quite dependent on your business logic. In the screenshot above, I got the number 62 by counting all the deals that did not have a "Pipeline Status" of "Intro", which implied that they had went past that stage. I don't know whether that holds up for your workflows though
Similarly, for the "Intro > Qualified (Active)" conversion, I counted all the deals that were "Qualified" that were "Active"
Aug 25, 2024 08:15 PM
Is there a way to have all opportunities automatically show up in the Linked column? I see that I can manually click to link each one, but what happens when a new Opportunity record comes in?
Once I solve that then I think I can look into trying the Count method, too
thanks appreciate the help!
Aug 29, 2024 01:49 AM
I'd recommend an automation that triggers when a new Opportunity record comes in, and its action would be to link itself to the Summary record!