Streamline facility management with our pipeline tracking spreadsheet for Facilities

How to create outlook signature

hi ever wondered how to build a sales funnel spreadsheet that is a sales funnel in a spreadsheet let me show you a few tips my first tip is don't use a free cloud-based CRM or a proper serum instead but if you really have to set up the columns to track the basic data create a stacked bar chart and I'll show you how to do that the moment add columns for the buyers journey for each stage in the buyers journey including leaked learn how to analyze for lag and leakage by stage again I'll show you how to do that and add fields for salesperson and lead source so that you can do comparison by each of those let me show you how to do all of that now there's a nifty set of steps that you can take to create a funnel-like image in a spreadsheet that automatically formats I'll include a link to this great article from Excel campus in the show notes after a brief explanation of what funnel means basically you created stacked bar chart you then invert the stacked bar chart because it's upside down you create these spaces and basically spaces are fillers that creates this orange-scented details not important for now it's all spelled out in the article there we go with negative funnel looking kind of funnel like and then you can hide the blue and change the gap to 0 so the effect of that is to create a funnel that looks kind of like that you can format it for presentation including numbers it auto floor mats of course neat little trick i also found for you a little article on building a spreadsheet to manager funnel basically the argument here is that it gives you good grounding in opportunity management 101 if you don't need good grounding skip it if you're Niko grounding maybe consider this article and its recommendations again in the show notes some of the options that I found and again including the show notes and quite as automated as others but give you a good breakdown by product let me show you what I mean by that zoom this in a bit basically you can look at opportunities by product by service line all by client if it's spreadsheet is set up correctly this one shows you a download that you can consider in a moment I'll tell you why you shouldn't do that but if you really want to do it you can download the spreadsheet and it gives you a breakdown by product as well as by company next what I found is basically a really good argument as to why you shouldn't even bother and it's that that I think is the most useful advice basically building a sales funnel spreadsheet is a dumb idea do it in CRM in fact let me show you just quickly another article I found you far the 25 best free crm applications basically don't build a spreadsheet do it in a free CRM so basically don't use a spreadsheet there are many excellent CRMs and even some free ones that are good enough but if you really have to set up columns to track the basic opportunity data that you would normally then create a stacked bar chart I showed you how to do that including the hidden field spaces to center of arts add columns for each stage in the buyers journey including leaked formatted for date to calculate lag by stage learn how to analyze the lag and leakage by stage and add fields for salesperson and lead source so you can compare those lag and leakage data for each of those new values let me show you what I mean about lag and leakage in this spreadsheet I've added in the very basic information that you always have enclosed etc added salesperson a lead source and then I put in a date field for each of the stages in the buyers which you can then populate including a date field for leaked so if the opportunity only got as far as in this case column J which is offer understood and then leaked will record the date that we considered defeat in this opportunity had leaked here's the point if the opportunity has not leaked we want to calculate the lag how long does it normally take for an opportunity to progress through each stage then the math for that it looks a little weird but it's actually not too weird basically if this field leaked is blank m2m toes blank then give me the difference between h2 and g2 well that is gap acknowledged and interest established h2g2 gap acknowledged interests established took 31 days of Israel pretty close two months because I chillin is put in really simple dates here but you get the idea so if leaked is blank it means it hasn't leaked and therefore it's still live how long has it taken to move between each stage and up here another liberal a geeky maths begin looks weird on is see lag for interests established 23 lag for and g1 interest established and then a bit of space that's just a space and then round down to zero decimals the average of these values that's it so a little bit of analysis lets you work out your lag and leakage by stage now for leakage basically you want to do some maths on in this case we've had three opportunities of which one leaked at this stage so a leakage rate would be one in 33 from that stage that's it for the basic spreadsheet calculator a little insight into getting lag and leakage are one thing I forgot to show you i put in filters here so that you can show this only by select salespeople or indeed by select sources if you really want to do in a spreadsheet that's the way I would do it if you do use a CRM we can load that data from your CRM into your funnel plan which means that we can compare what two things we can actually show some amazing insights from your CRM right inside funnel plan but also it means that we can compare your plan to your actual and that's quite powerful we can identify the areas that you most need to focus on and that means that the weekly coaching emails that you get for free in funnel plan can actually look at your actual data as well as your plans data and to highlight things that you might want to consider changing to improve the performance of your overall sales marketing funnel that's it for this week I hope you had lots of fun I did look forward to seeing you next week until then may your funnel be full and always flowing thanks this week to Tyler Owen for research thank you for our computers thank you Anna kagabi full production my name is here palin and it's been my absolute pleasure to script and prevent this week's show you