# Tracking lifecycle stages and reporting (MQL to SQL)

**URL:** <https://community.hubspot.com/t/tracking-lifecycle-stages-and-reporting-mql-to-sql/66420>\
**Category:** Sales Hub Tools\
**Tags:** enterprise\
**Created:** [October 4, 2022, 10:11am UTC](https://community.hubspot.com/t/tracking-lifecycle-stages-and-reporting-mql-to-sql/66420 "2022-10-04T10:11:04Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![PMgoUrban](https://avatars.discourse-cdn.com/v4/letter/p/7ba0ec/32.png) [@PMgoUrban](https://community.hubspot.com/u/PMgoUrban)\
**Post date:** [October 4, 2022, 10:11am UTC](https://community.hubspot.com/t/tracking-lifecycle-stages-and-reporting-mql-to-sql/66420/1 "2022-10-04T10:11:04Z")

</div>

Thank you for getting back to me.

As a Sales Operations Manager at goUrban, I am trying to create a report/chart/dashboard view showing the progress of the sales team/individual sales reps from the MQL stage to the SQL stage of the lifecycle.

My priority is establishing a SQL/MQL ratio to understand the team’s progress rate over the last few months and to use this as baseline to create forecast/goals.

What I have in mind is a time series showing the number of MQLs and SQL in the pipeline each month, with a trendline charting the ratio across the time series, like below:

 ![PMgoUrban_0-1664878238748.png](https://d2qpr2jzcazej7.cloudfront.net/original/3X/2/d/2d87123bf6b5b4eec4abcb267f787d53b92c0bfa.png)

The issues I face are as follows:

I have created 2 lists in Hubspot:

- One listing the deals that went through the MQL stage,
- One listing the deals that have reached or gone through the SQL stage.

Please see the criteria used below:

 ![PMgoUrban_1-1664878238784.png](https://d2qpr2jzcazej7.cloudfront.net/original/3X/1/2/12f6416e1cad1d5873322296b429050ca9994b24.png)

 ![PMgoUrban_2-1664878238791.png](https://d2qpr2jzcazej7.cloudfront.net/original/2X/c/c8b5f165d242511c0fdcee0b8c682e15de69680a.png)

What I wanted to know is whether it is possible to create a ratio from the two lists and to visualize it into one chart?

---

<div class="post-metadata">

**Author:** ![deepikaverma](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/deepikaverma/32/671_2.png) [@deepikaverma](https://community.hubspot.com/u/deepikaverma)\
**Post date:** [October 4, 2022, 11:24am UTC](https://community.hubspot.com/t/tracking-lifecycle-stages-and-reporting-mql-to-sql/66420/2 "2022-10-04T11:24:38Z")

</div>

Hi @PMgoUrban

It won’t be possible to achieve this, although Hubspot offers a Datasets feature to make calculations and visualize those into the report, that also does the calculation on number fields, like Amount/ Revenue.

 ![deepikaverma_0-1664882648925.png](https://d2qpr2jzcazej7.cloudfront.net/original/2X/b/b96b05a8137f8c6dab53d7dab0f6b7cac82a2442.png)

- Datasets are not doing the calculation on the list count.  
Here is the reference article.

> **[Build and activate datasets in Data Studio](https://knowledge.hubspot.com/data-management/build-and-activate-datasets-in-data-studio)**
>
> Learn how HubSpot Data Studio consolidates external customer data to provide a unified platform for synchronization, integration, and activation across your technology stack.

I hope it helps!  
Thank you

---

<div class="post-metadata">

**Author:** ![PMgoUrban](https://avatars.discourse-cdn.com/v4/letter/p/7ba0ec/32.png) [@PMgoUrban](https://community.hubspot.com/u/PMgoUrban)\
**Post date:** [October 4, 2022, 11:46am UTC](https://community.hubspot.com/t/tracking-lifecycle-stages-and-reporting-mql-to-sql/66420/3 "2022-10-04T11:46:25Z")

</div>

Thank you, I’ll look into it now!