# Churn report based on date a property changes? **URL:** \ **Category:** CRM\ **Tags:** reports, enterprise\ **Created:** [July 23, 2024, 6:58pm UTC](https://community.hubspot.com/t/churn-report-based-on-date-a-property-changes/112667 "2024-07-23T18:58:16Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![Jenny26](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/jenny26/32/39891_2.png) [@Jenny26](https://community.hubspot.com/u/Jenny26)\ **Post date:** [July 23, 2024, 6:58pm UTC](https://community.hubspot.com/t/churn-report-based-on-date-a-property-changes/112667/1 "2024-07-23T18:58:16Z")
Hello, I want to create a report that helps calculate churn. Because of how we’re using deals at the moment, it’s not currently possible to use HubSpot’s churn report. We have a property that gives us the status of a customer’s account. It’s called “Customer Status” and has the options of _ **yes** _ and _ **expired.** _ (We use this along with an expiration date property, license type property and deal stages.) Can I run a report that filters accounts by the date that the Customer Status property changes to _ **expired** _? I’ve been working with the custom report builder and so far I haven’t been able to do this - I’m hoping it’s possible. Thanks in advance for your help! Jenny ---
**Author:** ![PamCotton](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/pamcotton/32/47916_2.png) [@PamCotton](https://community.hubspot.com/u/PamCotton)\ **Post date:** [July 24, 2024, 1:34pm UTC](https://community.hubspot.com/t/churn-report-based-on-date-a-property-changes/112667/2 "2024-07-24T13:34:40Z")
Hey @Jenny26, thank you for posting in our Community! To create a churn report based on when the “Customer Status” changes to “expired,” you can use a workflow to update a custom date property (e.g., “Churn Date”) when the status changes. Then, build a custom report filtering accounts by this “Churn Date” property. This should give you the data you need. To our top experts, @KubaNowakowski and @danmoyle any recommendations for @Jenny26 matter? Thank you, Pam ---
**Author:** ![KubaNowakowski](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/kubanowakowski/32/11604_2.png) [@KubaNowakowski](https://community.hubspot.com/u/KubaNowakowski)\ **Post date:** [July 24, 2024, 1:44pm UTC](https://community.hubspot.com/t/churn-report-based-on-date-a-property-changes/112667/3 "2024-07-24T13:44:57Z")
Your solution looks good to me @PamCotton . We actualy did something simillar in our HS. On company record we store info in **lead status** field if someone is an **exclient** and in the other field called **become exclient date** what day they terminated their services. Then we have a report displaying by become exclient date how nay companies with lead staus exclient we have and boom your churn is displayed. You can build a cutom report on companied and deals to report on what products added to their deals the customers had to get further info ---
**Author:** ![Jenny26](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/jenny26/32/39891_2.png) [@Jenny26](https://community.hubspot.com/u/Jenny26)\ **Post date:** [July 24, 2024, 4:38pm UTC](https://community.hubspot.com/t/churn-report-based-on-date-a-property-changes/112667/4 "2024-07-24T16:38:17Z")
Thank you,@PamCotton and @KubaNowakowski ! This was very helpful! I think this will work wonderfully. Question - what if an expired client decides to subscribe to our software again? How do we track that change? ---
**Author:** ![himanshurauthan](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/himanshurauthan/32/53076_2.png) [@himanshurauthan](https://community.hubspot.com/u/himanshurauthan)\ **Post date:** [July 25, 2024, 6:07am UTC](https://community.hubspot.com/t/churn-report-based-on-date-a-property-changes/112667/5 "2024-07-25T06:07:33Z")
Hi @Jenny26, Creating a custom churn report in HubSpot is definitely possible, even if you’re not using the default churn report. Since you have a “Customer Status” property, here’s a simple way to set up your report: 1. **Track Expired Status** : 2. **Monitor Re-Subscriptions** : 3. **Build the Report** : This setup will help you track churn by showing you how many customers have expired status over time. To track re-subscriptions, you can filter by “Re-Subscription Date” as needed. For more detailed steps and additional guidance, check out HubSpot’s [custom report builder guide](https://knowledge.hubspot.com/reports/use-the-custom-report-builder). Best regards, Did this post resolve your question? If so, please help the community by marking it as the accepted solution. ---
**Author:** ![Jenny26](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/jenny26/32/39891_2.png) [@Jenny26](https://community.hubspot.com/u/Jenny26)\ **Post date:** [July 29, 2024, 9:50pm UTC](https://community.hubspot.com/t/churn-report-based-on-date-a-property-changes/112667/6 "2024-07-29T21:50:52Z")
Thank you!