Got 2 great questions on my guide to running renewals in HubSpot 💡 1. Where is the value for {{ deal.next_renewal_year }} coming from? 2. How are you parsing out the year from a date? In the renewal playbook we’re using the “Next Renewal Year” property inside of the CloneNer app to include the correct renewal year in the name of subsequent renewal deals. Here’s to set it up: 1. Create a new HubSpot property: Name: Next Renewal Year Object Type: Deal Group: Deal Information 2. Define your property Type: Calculation Output Format: Number Number Format: Unformatted Number 3. Add a custom formula → (year([properties.renewal_date]) + 1) 4. Test your formula by selecting a date and clicking Test. You should get back the next year. Eg. Date in 2024 → 2025 For more on managing renewals and recurring revenue in HubSpot check out the full playbook over in the ConnectedGTM newsletter (link in my profile) Here’s the highlights from part 1 of the renewals playbook: → Define your renewal process in a dedicated HubSpot deal pipeline and trigger the right milestone or time-based playbook for each customer. → Automatically move deals through your renewal pipeline as they make progress towards their renewal date. → Discover 2 simple methods for creating subsequent renewal deals and transferring the required context to the next phase of the customer journey. Any other questions let me know in the comments ✌️
Can't beleive i missed this after waiting so patiently :) The 1 click deploy option is that a coming thing or did i miss it?
This is a great one, but actually, how do you calculate the actual renewal date? I know you can use dates in HubSpot to calculate this property but it always misses the mark. For example, my client signs a contract on January 1, 2024 for 1 year. It will renew January 1, 2025. If I use « add 365 days » in a property calculator or a workflow, this will give me January 1, 2024 + 365 days = December 31, 2024. This is because 2024 is a leap year, so it has 366 days. Adding 365 days from January 1, 2024, lands me on the day before January 1, 2025. Same issue using quarterly properties > January 1 + 1 quarter. Considering there is 30 days in a month, I would use a calculation that give me January 1 + 30 days but I would land on March 31 instead of April 1.
I will certainly have more questions 😆
Useful tips
Thanks, Stuart Balcombe, for featuring #CloneNer here! 🚀 If anyone needs help or guidance, feel free to DM me—happy to assist! 🙌
CEO at Glare Marketing Technologies | HubSpot Expert
1moSo you are saying to use renewal year and not date?