{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"not_rendered":{"images":1},"read":"whole","date_system":"1900"}

{"sheet":"Sheet1","index":0,"n_rows":20,"n_cols":7,"rows_kept":20,"merged":[[2,2,2,6],[3,2,3,6],[4,2,4,6],[5,2,5,6],[18,2,18,3],[19,3,19,5],[19,6,19,9]]}
[null,"CREATED BY"]
[]
[null,null,"LEADS PROJECTIONS CALCULATOR "]
[null,null,"<add your company name>"]
[null,null,"How many leads do we need to meet revenue goals?"]
[null,null,"Note: Change the numbers highlighted in Yellow cells only. Rest of the numbers will change automatically through embedded formula."]
[null,null,"WITH CURRENT CONVERSION RATES",null,null,"WITH IMPROVED CONVERSION RATES"]
[null,null,"Last year new business revenue ",{"v":1000000,"d":"1,000,000"},null,{"$f":"D8","v":{"v":1000000,"d":"1,000,000"}},"Last year new business revenue "]
[null,null,"This year new business revenue goal",{"v":5000000,"d":"5,000,000"},null,{"$f":"D9","v":{"v":5000000,"d":"5,000,000"}},"This year new business revenue goal"]
[null,null,"Average order/deal value",{"v":100000,"d":"100,000"},null,{"$f":"D10","v":{"v":100000,"d":"100,000"}},"Average order/deal value"]
[null,null,"Number of new deals to be closed for the year",{"$f":"D9/D10","v":50},null,{"$f":"D11","v":50},"Number of new deals to be closed for the year"]
[null,null,"Average conversion rate - qualified opportunities converted to deals won (typically 5-40%)",{"v":0.2,"d":"20%"},null,{"v":0.3,"d":"30%"},"With improved sales process, effective tools and relevant content you are able to increase the conversion rate by 2 to 4 times."]
[null,null,"Number of SQL (Sales Qualified Leads) needed",{"$f":"(100%*D11)/D12","v":250},null,{"$f":"(100%*F11)/F12","v":{"v":166.66666666666669,"d":"167"}},"Number of SQL (Sales Qualified Leads) needed"]
[null,null,"Average conversion rate from MQL (Marketing Qualified Leads)to SQL leads (Typically 10-20%)",{"v":0.1,"d":"10%"},null,{"v":0.3,"d":"30%"},"With optimized website, content and converstion points, you should be able to increase the ratio of sales ready leads by"]
[null,null,"Number of MQL (Marketing Qualified Leads) needed for the year ",{"$f":"(100%*D13)/D14","v":2500},null,{"$f":"(100%*F13)/F14","v":{"v":555.5555555555557,"d":"556"}},"Number of MQL (Marketing Qualified Leads) needed for the year "]
[null,null,"Average monthly MQLs ",{"$f":"D15/12","v":{"v":208.33333333333334,"d":"208"}},null,{"$f":"F15/12","v":{"v":46.296296296296305,"d":"46"}},"Average monthly MQLs "]
[]
[null,null,"Looking for help with recommendations on how to meet your qualified leads goals month after month? "]
[null,null,"Schedule time to discuss with one of our lead generation experts."]
[null,"© 2020 Bold Dialogue. All Rights Reserved ",{"$nulls":4},"www.bolddialogue.com"]