{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["How to Use this SLA Template","SLA EXAMPLE","Create Your Own SLA"],"read":"whole","date_system":"1900"}

{"sheet":"How to Use this SLA Template","index":0,"n_rows":42,"n_cols":1,"rows_kept":42}
["How to Calculate Your Leads Goal for Sales and Marketing Alignment"]
["Introduction: What is a SLA?"]
["There is a long history of pain and misalignment between sales and marketing teams. These two groups often suffer from a lack of transparency, and are judged on different metrics and timelines – which devolves into finger pointing and blame sessions."]
["But, sales and marketing teams are not doomed to that fate. Effective alignment of sales and marketing is critical to a seamless customer experience. And according to the Aberdeen Group, companies with good sales and marketing alignment achieved 20% annual revenue growth. Essential to a productive relationship is establishing concrete metrics and mutual responsibilities for both marketing and sales. This is where a Service Level Agreement (SLA) comes into play."]
["With clear expectation on how many quality leads marketing will generate each month, and how sales will follow up with those leads, a SLA defines the expectations and provides hard numbers for both teams to measure their success.  "]
[]
["How to Use This Template"]
["This template is designed to help delve deeply into your pipeline numbers and create your own Service Level Agreement with your sales team. Using our four step process you will: define your customer close rates, determine a dollar value for your leads, identify how many monthly leads both sales and marketing need to hit your monthly numbers, and tally your monthly productivity against these goals."]
["In order to fill out this template, you should have your sales and marketing analytics in front of you. Look at your historical marketing performance and Salesforce, or your own CRM, closing histories to make sure you have a clear picture of how leads proceed through your funnel. Most of these insights are available in integrated marketing software platforms like HubSpot and your sales CRM tools."]
[]
["Sheet 1: Example SLA "]
["On the first sheet, we provide a SLA example. In this hypothetical example, we filled in data points based on general HubSpot sales and marketing details to show you what a real-world sales agreement might look like. (Note: This is not our actual HubSpot SLA data.)"]
["You will notice that our example SLA is broken out by both channel and personas. Not all leads are created equally, and they will all have different close rates. For example, your email leads should close faster than those from PPC ads. Email leads are generally nurtured in a campaign while PPC leads have simply clicked on a single ad. Similarly, different types of target customers – what we call personas – will produce different total dollar values per deal."]
["Sheet 2: Create Your Own SLA "]
["On the second sheet, we'll take you through each step towards building your own SLA. Here's a breakdown of each step."]
[]
["Step 1"]
["The first step of your sales-marketing SLA is to examine your sales closing rates, and specifically tease out what percentage of your leads ultimately become customers. This analysis looks at the historical performance of both your marketing and sales, and fills these holes in with actual performance data."]
["To tease out your overall % closing rates, look at your last six months of sales data for each channel that you use to generate marketing leads."]
["In the SLA example sheet, we include several inbound sources including organic, social, email and PPC, as well as outbound calling. Additionally, we include our three customer personas: small businesses, medium businesses and enterprise companies. When you move to your SLA worksheet, be sure to cover every channel that your company uses, and add a column to include all your customer personas.  "]
["Take the average close rate and add it to the correct cell in the document. Remember to update this spreadsheet on a monthly basis as your channel performance will change over time."]
[]
["Step 2"]
["The second step in your SLA development is to determine the value of each lead source. Knowing the value of your leads is pivotal in evaluating your overall pipeline, and deciding where to allocate your scarce sales and marketing resources."]
["While important, calculating the value of your leads is simple. First, identify your average sale price for each of your core personas. Again, find this data in your marketing software and sales CRM tools. As you can see in the SLA Example, your average small business sale may be $200, but a larger enterprise company may double that number."]
["Input your average sale value into the top \"average sale price\" row for each persona. Our SLA template will automatically calculate the value of your leads based upon the % close rates you filled in for step one."]
["Again, revisit your average sale prices for your personas on a regular basis to make sure you are holding your teams to the right numbers."]
[]
["Step 3"]
["Step three helps your marketing team track its monthly lead generation by channel. By looking at actual monthly data in real time, you can see which channels are performing each month, and which need to be addressed to enable your team to hit its projected numbers. Monthly lead tracking gets the whole team on the same page, offers insight into which strategies are working, and helps pinpoint underperforming channels in near real time."]
["The SLA Example shows a snapshot of a month’s productivity. For maximum visibility, update these leads on an ongoing basis. HubSpot managers often monitor these numbers daily, and we send the marketing team a daily summary of our month-to-date performance."]
["In step three, you will see the template includes an additional row on the right of the persona averages, which tallies the total leads your team generates each month. While its valuable to look at your monthly numbers by individual channel, your marketing team’s ultimate success is determined by your team’s total numbers – and this is the statistic that you want to have at hand for your sales conversations.  "]
[]
["Final SLA Calculation"]
["The final section of our calculator will tally your SLA commitments. As you fill in steps one through three, the SLA calculator will automatically populate the total SLA fields for each channel and persona. This worksheet will sum your channel and persona SLA, and your overall monthly totals."]
["Ultimately, the total monthly SLA you commit to should equal the total potential revenue each lead segment can produce per month.  "]
["As you fill out your tables each month, the SLA calculator will show how you are tracking towards your monthly SLA goal.  "]
[]
["Conclusion"]
["Armed with actual dollar values for your lead generation efforts, you know how many types of leads you need in order to reach quota. This eliminates any confusion over what leads marketing is responsible for each month and creates alignment between your sales and marketing teams."]
["Use this SLA as a tool to hold sales accountable for following up with these leads. With this data, your sales team can identify exactly how many times they need to attempt contact with their leads in order to deliver on their numbers."]
["Finally, close the loop in your reporting, and build this SLA into your reporting structures, so that this tool becomes a resource for both marketing and sales teams to measure your mutual success. "]

{"sheet":"SLA EXAMPLE","index":1,"n_rows":41,"n_cols":9,"rows_kept":41,"merged":[[0,0,1,1],[2,0,3,2],[2,7,8,10],[9,0,10,1],[11,0,12,2],[12,7,18,10],[20,0,21,1],[22,0,23,2],[23,8,29,11],[31,0,32,1],[33,0,34,2],[34,8,40,11]]}
["STEP 1"]
[]
["% Of Closing Lead To Customer",{"$nulls":3},"Persona 1","Persona 2","Persona 3","Look at the last 6 months of sales data to see how well you were able to close your leads from each persona category and each source. Take the average close rate and add it to the correct cell.  Update this on a monthly basis as your channels will change over time"]
[{"$nulls":3},"Persona","Small Business ","Medium Business ","Enterprise Company "]
[{"$nulls":3},"Inbound: Organic",{"v":0.02,"d":"2%"},{"v":0.06,"d":"6%"},{"v":0.03,"d":"3%"}]
[{"$nulls":3},"Inbound: Social",{"v":0.06,"d":"6%"},{"v":0.03,"d":"3%"},{"v":0.02,"d":"2%"}]
[{"$nulls":3},"Inbound: Email",{"v":0.41,"d":"41%"},{"v":0.02,"d":"2%"},{"v":0.02,"d":"2%"}]
[{"$nulls":3},"Inbound: PPC",{"v":0.05,"d":"5%"},{"v":0.56,"d":"56%"},{"v":0.02,"d":"2%"}]
[{"$nulls":3},"Outbound: Call/ Sales Rep",{"v":0.3,"d":"30%"},{"v":0.01,"d":"1%"},{"v":0.05,"d":"5%"}]
["STEP 2"]
[]
["Value Of A Lead",{"$nulls":3},"Persona 1","Persona 2","Persona 3"]
[{"$nulls":3},"Persona","Small Business ","Medium Business ","Enterprise Company ","Look at the average sale price of each persona type and add that to the top cell in their respective column.  This should also be updated on a regular basis."]
[{"$nulls":3},"Average Sale Price",{"v":200,"d":"$200"},{"v":300,"d":"$300"},{"v":400,"d":"$400"}]
[{"$nulls":3},"Inbound: Organic",{"$f":"E$14*E5","v":{"v":4,"d":"$4"}},{"v":18,"d":"$18"},{"v":12,"d":"$12"}]
[{"$nulls":3},"Inbound: Social",{"v":12,"d":"$12"},{"v":9,"d":"$9"},{"v":8,"d":"$8"}]
[{"$nulls":3},"Inbound: Email",{"v":82,"d":"$82"},{"v":6,"d":"$6"},{"v":8,"d":"$8"}]
[{"$nulls":3},"Inbound: PPC",{"v":10,"d":"$10"},{"v":168.00000000000003,"d":"$168"},{"v":8,"d":"$8"}]
[{"$nulls":3},"Outbound: Call/ Sales Rep",{"v":60,"d":"$60"},{"v":3,"d":"$3"},{"v":20,"d":"$20"}]
[]
["STEP 3"]
[]
["Monthly Leads Generated",{"$nulls":3},"Persona 1","Persona 2","Persona 3"]
[{"$nulls":3},"Persona","Small Business ","Medium Business ","Enterprise Company ","Total","Regularly add the number of leads you are generating this month from each persona category and source.  HubSpot managers monitor these numbers on a daily and sometimes hourly basis"]
[{"$nulls":3},"Inbound: Organic",675,534,21,{"$f":"SUM(E25:G25)","v":{"v":1230,"d":"1,230"}}]
[{"$nulls":3},"Inbound: Social",537,67,6,610]
[{"$nulls":3},"Inbound: Email",53,4,37,94]
[{"$nulls":3},"Inbound: PPC",357,9,87,453]
[{"$nulls":3},"Outbound: Call/ Sales Rep",123,12,53,188]
[{"$nulls":3},"Total",{"$f":"SUM(E25:E29)","v":{"v":1745,"d":"1,745"}},{"$f":"SUM(F25:F29)","v":626},{"$f":"SUM(G25:G29)","v":204},{"v":2575,"d":"2,575"}]
[]
["FINAL"]
[]
["Total Monthly SLA",{"$nulls":3},"Persona 1","Persona 2","Persona 3"]
[{"$nulls":3},"Persona","Small Business ","Medium Business ","Enterprise Company ","Total","Once all of the other fields have been filled out this table shows you how you are tracking towards your monthly SLA goal.   You can assume that the total monthly SLA should equal the potential revenue that can come in from the leads collected."]
[{"$nulls":3},"Inbound: Organic",{"$f":"E25*E15","v":{"v":2700,"d":"$2,700.00"}},{"$f":"F25*F15","v":{"v":9612,"d":"$9,612.00"}},{"$f":"G25*G15","v":{"v":252,"d":"$252.00"}},{"$f":"SUM(E36:G36)","v":{"v":12564,"d":"$12,564.00"}}]
[{"$nulls":3},"Inbound: Social",{"$f":"E26*E16","v":{"v":6444,"d":"$6,444.00"}},{"v":603,"d":"$603.00"},{"v":48,"d":"$48.00"},{"$f":"SUM(E37:G37)","v":{"v":7095,"d":"$7,095.00"}}]
[{"$nulls":3},"Inbound: Email",{"v":4346,"d":"$4,346.00"},{"v":24,"d":"$24.00"},{"v":296,"d":"$296.00"},{"$f":"SUM(E38:G38)","v":{"v":4666,"d":"$4,666.00"}}]
[{"$nulls":3},"Inbound: PPC",{"v":3570,"d":"$3,570.00"},{"v":1512.0000000000002,"d":"$1,512.00"},{"v":696,"d":"$696.00"},{"$f":"SUM(E39:G39)","v":{"v":5778,"d":"$5,778.00"}}]
[{"$nulls":3},"Outbound: Call/ Sales Rep",{"v":7380,"d":"$7,380.00"},{"v":36,"d":"$36.00"},{"v":1060,"d":"$1,060.00"},{"$f":"SUM(E40:G40)","v":{"v":8476,"d":"$8,476.00"}}]
[{"$nulls":3},"TOTAL",{"$f":"SUM(E36:E40)","v":{"v":24440,"d":"$24,440.00"}},{"$f":"SUM(F36:F40)","v":{"v":11787,"d":"$11,787.00"}},{"$f":"SUM(G36:G40)","v":{"v":2352,"d":"$2,352.00"}},{"$f":"SUM(H36:H40)","v":{"v":38579,"d":"$38,579.00"}}]

{"sheet":"Create Your Own SLA","index":2,"n_rows":41,"n_cols":9,"rows_kept":41,"merged":[[0,0,1,1],[2,0,3,2],[2,7,8,10],[9,0,10,1],[11,0,12,2],[12,7,18,10],[20,0,21,1],[22,0,23,2],[23,8,29,11],[31,0,32,1],[33,0,34,2],[34,8,40,11]]}
["STEP 1"]
[]
["% Of Closing Lead To Customer",{"$nulls":3},"Persona 1","Persona 2","Persona 3","Look at the last 6 months of sales data to see how well you were able to close your leads from each persona category (or product) and each source.   Take the average close rate and add it to the correct cell.  Update this on a monthly basis as your channels will change over time"]
[{"$nulls":3},"Persona"]
[{"$nulls":3},"Inbound: Organic"]
[{"$nulls":3},"Inbound: Social"]
[{"$nulls":3},"Inbound: Email"]
[{"$nulls":3},"Inbound: PPC"]
[{"$nulls":3},"Outbound: Call/ Sales Rep"]
["STEP 2"]
[]
["Value Of A Lead",{"$nulls":3},"Persona 1","Persona 2","Persona 3"]
[{"$nulls":3},"Persona",{"$nulls":3},"Look at the average sale price of each persona type and add that to the top cell in their respective column.  This should also be updated on a regular basis."]
[{"$nulls":3},"Average Sale Price"]
[{"$nulls":3},"Inbound: Organic",{"$f":"E$14*E5","v":{"v":0,"d":"$0"}},{"v":0,"d":"$0"},{"v":0,"d":"$0"}]
[{"$nulls":3},"Inbound: Social",{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"}]
[{"$nulls":3},"Inbound: Email",{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"}]
[{"$nulls":3},"Inbound: PPC",{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"}]
[{"$nulls":3},"Outbound: Call/ Sales Rep",{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"}]
[]
["STEP 3"]
[]
["Monthly Leads Generated",{"$nulls":3},"Persona 1","Persona 2","Persona 3"]
[{"$nulls":3},"Persona",{"$nulls":3},"Total","Regularly update the number of leads you are generating this month from each persona category and source.  HubSpot managers monitor these numbers on a daily and sometimes hourly basis"]
[{"$nulls":3},"Inbound: Organic",{"$nulls":3},{"$f":"SUM(E25:G25)","v":0}]
[{"$nulls":3},"Inbound: Social",{"$nulls":3},0]
[{"$nulls":3},"Inbound: Email",{"$nulls":3},0]
[{"$nulls":3},"Inbound: PPC",{"$nulls":3},0]
[{"$nulls":3},"Outbound: Call/ Sales Rep",{"$nulls":3},0]
[{"$nulls":3},"Total",{"$f":"SUM(E25:E29)","v":0},{"$f":"SUM(F25:F29)","v":0},{"$f":"SUM(G25:G29)","v":0},0]
[]
["FINAL"]
[]
["Total Monthly SLA",{"$nulls":3},"Persona 1","Persona 2","Persona 3"]
[{"$nulls":3},"Persona","Ollie","Mary","Erin","Total","Once all of the other fields have been filled out this table shows you how you are tracking towards your monthly SLA goal.   You can assume that the total monthly SLA should equal the potential revenue that can come in from the leads collected."]
[{"$nulls":3},"Inbound: Organic",{"$f":"E25*E15","v":0},{"$f":"F25*F15","v":0},{"$f":"G25*G15","v":0},{"$f":"SUM(E36:G36)","v":0}]
[{"$nulls":3},"Inbound: Social",{"$f":"E26*E16","v":0},0,0,{"$f":"SUM(E37:G37)","v":0}]
[{"$nulls":3},"Inbound: Email",0,0,0,{"$f":"SUM(E38:G38)","v":0}]
[{"$nulls":3},"Inbound: PPC",0,0,0,{"$f":"SUM(E39:G39)","v":0}]
[{"$nulls":3},"Outbound: Call/ Sales Rep",0,0,0,{"$f":"SUM(E40:G40)","v":0}]
[{"$nulls":3},"TOTAL",{"$f":"SUM(E36:E40)","v":0},{"$f":"SUM(F36:F40)","v":0},{"$f":"SUM(G36:G40)","v":0},{"$f":"SUM(H36:H40)","v":0}]