# Report Date Filters **URL:** \ **Category:** Reporting & Analytics\ **Tags:** reports, object\ **Created:** [April 14, 2021, 8:30pm UTC](https://community.hubspot.com/t/report-date-filters/35538 "2021-04-14T20:30:52Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![NStones](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/nstones/32/79644_2.png) [@NStones](https://community.hubspot.com/u/NStones)\ **Post date:** [April 14, 2021, 8:30pm UTC](https://community.hubspot.com/t/report-date-filters/35538/1 "2021-04-14T20:30:52Z")
I want to track how many deals hit each stage in the last month. What is best practice, filter by “created date” or “last activity”? Each time I run it the numbers are obviously different, but what is best practice in sales? Also, for quarterly reports, do sales teams like to look at everything “created” that quarter, or had “activity” that quarter. ![40912i651E05C632A4E17E.png](https://d2qpr2jzcazej7.cloudfront.net/original/3X/e/0/e0bffb04ef93118df19974064948a97fc29c4ee0.png) ---
**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:** [April 15, 2021, 4:20am UTC](https://community.hubspot.com/t/report-date-filters/35538/2 "2021-04-15T04:20:44Z")
Hi @NStones, HubSpot’s not very good at answering the question of how many deals entered a certain stage in a given month. What is much easier to answer is how deals created in a month are distributed across deal stages in this very moment. You would simply navigate to _Menu_ \> _Reports_ \> _Reports_ \> _Report library_ \> search for “Deal stage funnel with deal totals and conversion rates” \> Click _Edit in builder_ \> Click _Filters_ on the upper left of the screen \> Adjust timeframe to your liking. If that works for you, you could ignore the rest of my answer below. If however you really need to now how many deals entered a certain stage in a month, we would have to get technical. This data is not explicitly available in a HubSpot property so we would have to get it there first. Let’s look at existing properties first: Create _date_ would not be sufficient. It would only document the deal entering the first stage, but not keep track of the dates when the deal enters any of the following stages. _Last activity_ includes notes, chat conversations, calls, emails, meetings – so there are a lot of things which could update this. We would have to create date properties for when each deal enters a certain stage. This is unfortunately a bit more complicated than it should be. For contacts and _Lifecycle stage_, there is a date property called _Became a [lifecycle stage] date_ which is automatically stamped by HubSpot. For deals, this does not exist and has to be created and maintained manually (Free and Starter versions of HubSpot) or automatically (Professional and Enterprise versions of HubSpot.) In both cases, you would first create a custom date property for each stage. Similar to the _Became a [lifecycle stage] date_ properties for contacts, I usually name these _Entered [deal stage] date_. For each stage, create a custom date property. For the manual solution, you’d ideally place all of these new properties in the left deal sidebar so that sales reps can update this date when they update the deal stage. [Customize records](https://knowledge.hubspot.com/crm-setup/customize-record-sidebars) This additional step is far from perfect but it is what it is. A workflow solution that automatically does this could look like this: ![40929i38DFB9463583444A.png](https://d2qpr2jzcazej7.cloudfront.net/original/3X/b/1/b19f56535339b4cc11902938c72cd97b3d5457d2.png) You would have to repeat this process for each stage, either in multiple workflows like this (less prone to error) or one combined one: ![40930i04C5DB011093FD26.png](https://d2qpr2jzcazej7.cloudfront.net/original/3X/2/6/264b2e860184ebdfe0b17097d347f0d74697c3f1.png) Optionally, you could create yet another custom property (_Last deal stage update date_) which gets a time stamp at the end of each of the branches. When switching this live, do not choose to enroll existing records that match the criteria. Otherwise all old records will be stamped with the current date (today’s date). (For historic values, things get even more complicated. You would have to export the property history for _Deal stage_, following the instructions [here](https://community.hubspot.com/t5/Tips-Tricks-Best-Practices/Reverting-Bulk-Property-Changes-by-Importing-Historical-Property/td-p/332929). This is the only way to access the information when a deal moved to another stage. In step 2 of the instruction linked above, your goal is not get the latest value of the _Deal stage_ property. You are looking for a final Excel file that includes a column for the email address, followed by columns of all of the custom date properties created above.) You would now have date properties that you could use in your custom deal reports. Before you launch into this endeavor, again, I’d recommend checking out the report library (_Menu_ \> _Reports_ \> _Reports_ \> _Report library_). You might find something that you weren’t looking for but which is equally informative. Let me know if this answers your question! ---
**Author:** ![NStones](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/nstones/32/79644_2.png) [@NStones](https://community.hubspot.com/u/NStones)\ **Post date:** [April 15, 2021, 4:26pm UTC](https://community.hubspot.com/t/report-date-filters/35538/3 "2021-04-15T16:26:46Z")
Thank you so much, extremely thorough and gave me lots of good ideas. Appreciate your help. ---
**Author:** ![system](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/system/32/124_2.png) [@system](https://community.hubspot.com/u/system)\ **Post date:** [April 15, 2021, 10:11am UTC](https://community.hubspot.com/t/report-date-filters/35538/4 "2021-04-15T10:11:16Z")
Hi @NStones , Create date will only bring in deals on the date they were created in the portal and last activity pulls in deals with emails, notes, calls etc… not based on stage updates. So, what we can can do is create a funnel report to see how many deals have gone through each deal stage in a specific pipeline like this one here: ![40971i4A0479567F11D58D.png](https://d2qpr2jzcazej7.cloudfront.net/original/3X/f/6/f6cc82e09be26cc38b1ac1799b2673695d508c47.png) For example- 2 deals have gone through all stages until TL ROUND (interviews) for the Interviews deal pipeline (see screenshot) You can see more on funnel reports here: [Create custom (legacy) funnel reports](https://knowledge.hubspot.com/reports/create-custom-funnel-reports) ![40972i19CB89574BC830CE.png](https://d2qpr2jzcazej7.cloudfront.net/original/3X/d/e/def4247d6c2b1d108b03bd8872a776b3bdd1d129.png) Hope this helps! If we were able to answer your query, kindly help the community by marking it as a solution. Thanks and Regards. ---
**Author:** ![NStones](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/nstones/32/79644_2.png) [@NStones](https://community.hubspot.com/u/NStones)\ **Post date:** [April 15, 2021, 4:28pm UTC](https://community.hubspot.com/t/report-date-filters/35538/5 "2021-04-15T16:28:13Z")
Super helpful, I ended up going this route, but selecting “any”, because our deals don’t always go in a linear fashion. Appreciate your help! ---
**Author:** ![shaikhzeba23](https://avatars.discourse-cdn.com/v4/letter/s/e9bcb4/32.png) [@shaikhzeba23](https://community.hubspot.com/u/shaikhzeba23)\ **Post date:** [December 15, 2023, 6:45am UTC](https://community.hubspot.com/t/report-date-filters/35538/6 "2023-12-15T06:45:23Z")
In tracking deals for the last month, it’s generally considered best practice to filter by “last activity” rather than “created date” if your goal is to capture the current state of your sales pipeline. “Last activity” provides a more dynamic view, focusing on deals that have had recent engagement or progression. This approach is especially valuable for assessing the real-time status of active deals.