Use Calculated Properties To Conduct Pipeline Health Checks

HubSpot Alumni

"How healthy is my pipeline" is a question I get asked a lot by sales users.  It's something that is important for both sales reps and their managers. Reps want to know so they can be sure that their pipeline has deals within in that are likely to close so they don't waste their time on dud deals, while managers want to be sure that their reps are following company playbooks and processes. 


I've read a lot of different health check playbooks for pipelines, and one that I'm a big fan of is MEDDIC. MEDDIC stands for "Metrics, Economic Buyer, Decision Criteria, Decision Process, Identify Pain and Champion". By ensuring that you have ideitifed all of these areas, you be sure that you are speaking with the right person and that they will see the value behind your solution. To be honest, it works really nicely with the Inbound Sales methodology. Recently, myself and another HubSpot decided to try build out a MEDDIC criteria list in their portal to help see how healthy their pipeline is, and the results were fantastic. 


Our goal was to build what we called "A MEDDIC Health Score", which was a score out of 100 which determined how healthy a deal was. We build this out using deal properties and a calculated property. 


First, we created the properties for our MEDDIC score:




Each of these were simple to follow. We used checkboxes for when a rep would identify their internal champion and their economic buyer/decision maker. We used single line texts for reps to add the details of said contacts, and dropdown selected for the other criteria. So for example in the "Identify Pain" property the dropdown includes options like "Costs", "Technical Limitations" or "Cyber Security". By having these as a dropdown it ensured that reps were only inputting data that is neccasry and helps keep our reporting clean and void of human error or interpretation. 


Once this was built, we moved onto the second stage, which was to create a number property that we called "MEDDIC Score", and a calculated property called "MEDDIC Health Percentage".  The formula we used for health was designed to give us a score out of 100, or a percentage of completed properties,  to determine how healthy the deal is. It looks like this:












We use the number 7 because we created 7 different properties in our MEDDIC group that our sales team need to complete. So this number should be the number of properties you create, not including the MEDDIC Score or the calculated property. We multiple by 100 to give us a percentage.


Last piece of the puzzle is a workflow to populate the MEDDIC Score. The workflow is a deal type that simple increases the MEDDIC Score each time a property is populated. It looks like this:





And we are set! This only took 30 minutes to build out, but now the team use the calculated property to gauge how healthy their deals and their pipeline are, and it also ensures that if a deal reaches a certain stage it should have a certain amount of these details populated to help ensure an accurate forecast.

8 Replies 8
HubSpot Moderator

Simply amazing. Thanks for sharing your knowledge @SeanReid .



This is really great Sean!


This is one of the reasons why I picked HubSpot for MEDDICC's CRM platform because you folks are super innovative with this kind of thing.


There is a real resurgence of Sellers picking up MEDDIC right now. 


I have created some definitions for confidence at each stage too if you'd be keen to learn more I'd love to chat. You can get me via my website which is linked above 🙂



@SeanReid this is great: Easy and immediately applicable. Just reflecting the MEDDIC methodology itself. Some of our clients at MEDDIC Academy have done similar implementations. 
Of course the idea can be further developed for a more sophisticated scoring with more details, but this is a great start, amazingly done in 30 minutes. Kudos!

HubSpot Employee

Thanks for that @SeanReid !


I've actually just used this as a reference to help a HubSpot user with their pipeline 😀


Hi @SeanReid, this is fantastic! My only question is whether I actually need the last step (the workflow) if my MEDDIC Score property is a "score" type?


Would there be an advantage to using the workflow instead of the score type property?

Thank you!

Member | Partner

@SeanReid thanks for the share, very useful.

but still question I have some trouble to implement the workflow, especially to calculate the Score.

It Seems that it does not calculate well.


It does not decrease or increase. Can you help?







Sean: This is great work you've done. How can our company incorporate what you've developed for MEDDIC in Hubspot ...? This ius exactly what we need. Thank you, John Ferraro, VP Sales, Honcho

Top Contributor | Diamond Partner

Hey @JFerraro, where are you at with the buildout? Love to help where I can. GC