# Using Hubspot Formulas in Reports for Conversion Rates

**URL:** <https://community.hubspot.com/t/using-hubspot-formulas-in-reports-for-conversion-rates/128201>\
**Category:** 💬 RevOps Discussions\
**Tags:** revops\
**Created:** [March 18, 2025, 6:56pm UTC](https://community.hubspot.com/t/using-hubspot-formulas-in-reports-for-conversion-rates/128201 "2025-03-18T18:56:35Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![CWat44](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/cwat44/32/22565_2.png) [@CWat44](https://community.hubspot.com/u/CWat44)\
**Post date:** [March 18, 2025, 6:56pm UTC](https://community.hubspot.com/t/using-hubspot-formulas-in-reports-for-conversion-rates/128201/1 "2025-03-18T18:56:35Z")

</div>

Hello,  
I am trying to calculate conversion rates for MQL:SAL and MQL:STG2. I have a custom object that creates a record for every MQL and then stamps known SAL date and STG2 dates if the deal is created within 90 days of said conversion.  
I want to only count SALs or STG2 that were created AFTER the MQL date (I do have a proptery that says b4 SAL or B4 STG2). The thing I am trying to figure out is that the custom report should look at the total count of MQLs in a given tiemframe (easy enought to set up).

However, for SAL/STG2 I only want the distinct count to sum IF there is a Conversion:Deal of “B4 Deal Create”.

I am struggling to figure out how to run the formula. My current set up has the report excluding MQLs that never have a deal created or STG2 created so everything is 100% converted.  
Here is the current report filter with a circle on what I need to be part of the SAL or STG2 count If scenario. It’s possible I may need to run datasets for something like this.

 ![CWatson12_0-1742324092832.png](https://d2qpr2jzcazej7.cloudfront.net/original/2X/e/e56b60f9d4e528d72a3444a7f169d39fec9e8b75.png)

And these are my current formulas (the third is just dividing these two counts):

**MQL count:** DISTINCT\_COUNT([p539405\_marketing\_conversion.hs\_createdate])

**STG2 count:** DISTINCT\_COUNT([p539405\_marketing\_conversion.deal\_stg2\_date])

---

<div class="post-metadata">

**Author:** ![CWat44](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/cwat44/32/22565_2.png) [@CWat44](https://community.hubspot.com/u/CWat44)\
**Post date:** [March 18, 2025, 8:08pm UTC](https://community.hubspot.com/t/using-hubspot-formulas-in-reports-for-conversion-rates/128201/2 "2025-03-18T20:08:34Z")

</div>

Just kidding, I realized I could make 2 new properties 1 to stamp yes if conversion is 90 days before deal create, and 1 for stg2 and those those to count for the SAL number, then drop the extra filters on the report itself!

---

<div class="post-metadata">

**Author:** ![Akash\_Vi\_R](https://avatars.discourse-cdn.com/v4/letter/a/c37758/32.png) [@Akash\_Vi\_R](https://community.hubspot.com/u/Akash_Vi_R)\
**Post date:** [March 29, 2025, 5:06am UTC](https://community.hubspot.com/t/using-hubspot-formulas-in-reports-for-conversion-rates/128201/3 "2025-03-29T05:06:09Z")

</div>

This is a Hubspot limitation.  
If you wanna go crazy with formulas (or have even more complex ones), try pushing data to a spreadsheet (Excel/G-Sheets) and use spreadsheets’ functionalities.  
You can potentially build crazy dashboards as well.  
There are a bunch of connectors - [Superjoin](https://www.superjoin.ai/integrations/hubspot?utm_source=hubspot_community&utm_medium=post&utm_campaign=formula) is my fave. Works well 100% of the time.