For teams that run on HubSpot
HubSpot deal changes: what moved this week
HubSpot keeps the history of each property on a deal, and most reports show where deals stand today. Seeing what moved this week often means saving last week's export and comparing the two.
How it goes today
- Export the open deals every Monday and keep the file.
- Export them again the next week.
- Match the two files on the deal with a lookup formula.
- Highlight the rows where the stage, amount or close date differs.
How it can go
See which deals changed stage, amount or close date since last week.
Every Monday you get one overview of the deals that changed in the past week: new deals, deals that moved forward or back a stage, amounts that went up or down, and close dates that were pushed out, with the owner and the old and new value side by side. It is built from the history HubSpot keeps per deal, so no file needs to be saved by hand.
Say this in ChatGPT, Claude or Copilot
Your chat gets connected to Hypamoon first, with this request filled in. You paste your HubSpot key in the portal, never in the chat.
With Hypamoon, every Monday morning, email me and our sales lead an overview of the HubSpot deals that changed last week: new deals, stage changes forward and back, amount changes and close dates moved, with the owner and the old and new values side by side, and the totals per stage.
A super admin creates the HubSpot service key under Development, Keys, and picks what it may read and change. It stays yours.
More for teams on HubSpot
- I merge duplicate contacts one by one.
- I clear old tasks by hand after a deal or ticket closes.
- I clone won deals by hand to set up the renewal.
- I change our workflows every time someone goes on holiday.
- I work out our ticket times in business days in Excel.
- I add the contacts of a company to each new deal by hand.
- I export our HubSpot reports to send to people without a login.
- I take our own test entries off the form counts every month.
- I move contacts to another company one by one.
- I calculate our stage conversion rates by hand.
- I copy notes and calls out of HubSpot record by record.
- I move open tasks by hand when records change owner.
- I check by hand which won deals have no products.
- I clean up names, countries and company fields in HubSpot every week.
- I go through the pipeline by hand to find deals that went quiet.
- I calculate commission from HubSpot exports in a spreadsheet.
- I export each object from HubSpot by hand to keep a copy.
- I add the country code to phone numbers by hand.
- I set the subscription by hand for people who already confirmed.
- I track the time zones of my contacts in a spreadsheet.
- I write the formal greeting by hand for each contact.
- I split full names into first and last name in a spreadsheet.
- I cannot show what a form said when someone signed up.
- I type our exchange rates into HubSpot by hand.
- I rename product lines by hand on quotes in other languages.
- I check customer VAT numbers by hand on the VIES site.
- I add the VAT rate by hand to each line.
- I rebuild HubSpot invoices elsewhere to send an e-invoice.
- I make our invoices again elsewhere to get a Factur-X file.
- I link branch records to their parent company one by one.
- I look up each customer's prices and change the deal lines by hand.
- I keep the reseller and end user in text fields on each deal.
- I build our Gift Aid claim in a spreadsheet from HubSpot exports.
- I export HubSpot to a spreadsheet every week.
- I copy deal details into our contract template by hand.
- I tick off event attendees by hand from a list.
- I keep a branch per postcode in our workflow to route leads.
- I number our deals by hand from a counter in a spreadsheet.
- I work out renewal and follow-up dates by hand.
- I keep prepaid hours in a spreadsheet next to our tickets.
- I print the notification email to keep a copy of each form.
- I copy NPS scores from another survey tool into HubSpot.
- I work out deal margins in a spreadsheet.
- Everything for HubSpot