Now that you’ve started to put together your client data all in one place, you should have gained some more insight into how your business is situated as a whole, and what opportunities are waiting within.
The majority of the time, gathering the data serves as a good exercise and reminder about things that you were already holding in your head, but hadn’t yet put down into a format like this. Hopefully this gives you some relief and more head-space to work with on this transformative journey.
Last time we spoke about this, we left it fairly open ended with regards to the format of your spreadsheet and the data that we needed from you. Now, we’re going to get into the nitty gritty bits that will help us to help you.
There are a few crucial metrics that we will need going forward, in order to make the most of our analysis and time spent learning about you and your clients. Often this will involve certain metrics, but just as importantly, we need to understand the nuance behind it all. For example, if there’s a client that you have a great relationship with, let us know, or if there’s someone who’s been on this journey with you form the beginning, we also want to know about that. You really are painting a picture at this step, so the more detail you can include for us, the better.
This is by no means a small amount of data, or effort required on your part, so before we jump any further ahead in the process, make sure that you let us know if you are having trouble with anything, or need some more time to pull it all together.
We’re here to work with you, so if you need 30 minutes to get your head around what it is we’re actually after, or can’t figure out how to make your CRM do what you need it to, just give us a call or shoot us an email and we’ll be more than happy to jump in and assist where we can. It’s worth it for us to wait a couple of extra days for the data to review it in it’s entirety then doing bits and pieces throughout a few weeks.
Although, with that being said there are a few golden rules we like to follow when it comes to putting spreadsheets together, especially when it comes to numbers and finances.
We have included this template from last time in case you need to copy over some headings to get you started with some structure for your spreadsheet. Click to the right and you will be taken to the Google Sheet template.
Lastly, we strongly suggest that you make your spreadsheet a cloud document. That is to say you use Microsoft OneDrive for Excel or Google Sheets so that your document is in the cloud as opposed to being saved on your computer.
An alternate method would be to use desktop Excel and to save your document in Dropbox.
The reason for this is so that you can share it with us at The Social Adviser. You may even choose to share it with your peers for input (although there is no requirement to do so).
Additionally, you will be referring to this spreadsheet throughout our work together, and making changes as you proceed, so make this a working copy that is separate to what you may already be using as a business tool internally.
Monthly and weekly updates to this data will be something that we discuss once we get together to go through this, but keep them in the back of your mind for now.