# Report showing the time between MQL to SQL **URL:** \ **Category:** Reporting & Analytics\ **Tags:** professional\ **Created:** [July 15, 2022, 4:59am UTC](https://community.hubspot.com/t/report-showing-the-time-between-mql-to-sql/61031 "2022-07-15T04:59:37Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![ManagementOne](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/managementone/32/24300_2.png) [@ManagementOne](https://community.hubspot.com/u/ManagementOne)\ **Post date:** [July 15, 2022, 4:59am UTC](https://community.hubspot.com/t/report-showing-the-time-between-mql-to-sql/61031/1 "2022-07-15T04:59:37Z")
Hello, We’re looking to generate a report that tells us how long each contact sits in the MQL stage before converting up to SQL. I know there’s a timestamp for each, but I’m not sure how to structure the data query and calculation. Any help would be appreciated. -M1 ---
**Author:** ![karstenkoehler](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/karstenkoehler/32/68554_2.png) [@karstenkoehler](https://community.hubspot.com/u/karstenkoehler)\ **Post date:** [July 15, 2022, 5:02am UTC](https://community.hubspot.com/t/report-showing-the-time-between-mql-to-sql/61031/2 "2022-07-15T05:02:40Z")
Hi @ManagementOne, There are different ways to approach this, one tutorial is laid out nicely here: [Tracking the number of days contacts spend in a particular Lifecycle Stage](https://community.hubspot.com/t5/Tips-Tricks-Best-Practices/Tracking-the-number-of-days-contacts-spend-in-a-particular/m-p/362681) Hope this helps! ---
**Author:** ![ManagementOne](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/managementone/32/24300_2.png) [@ManagementOne](https://community.hubspot.com/u/ManagementOne)\ **Post date:** [July 15, 2022, 5:06am UTC](https://community.hubspot.com/t/report-showing-the-time-between-mql-to-sql/61031/3 "2022-07-15T05:06:34Z")
That was a really FAST reply- thank you I will look into that.