When a CSM leaves for another opportunity, it’s always a scramble to collect notes on each of their customers, then reassign those customers evenly amongst the rest of the team.
At my last job, we ran this process out of Google Sheets. It was not the most user friendly experience. First, we would export a list of all the leaving CSM’s customers from our CRM into Google sheets. We’d add in columns for them to take notes. These notes had no structure to them - just anything that came to mind.
Then, we’d have a second, unconnected Google Sheet that showed our team’s capacity. We would compare the two sheets to determine which account would be assigned to which CSM.
Finally, we would manually update each account in SFDC with the new CSM.
With Coda, we can bring this entire process into one doc.
We can import the accounts that need to be transferred and the team’s capacity into the same doc -