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

{"sheet":"Marketing Plan","index":0,"n_rows":76,"n_cols":72,"rows_kept":76,"merged":[[0,1,0,3],[1,12,1,26],[1,27,1,41],[1,42,1,56],[1,57,1,71],[2,12,2,16],[2,17,2,21],[2,22,2,26],[2,27,2,31],[2,32,2,36],[2,37,2,41],[2,42,2,46],[2,47,2,51],[2,52,2,56],[2,57,2,61],[2,62,2,66],[2,67,2,71],[3,1,3,2],[3,8,3,9],[3,10,3,11],[4,1,4,2],[5,1,5,2],[5,8,5,9],[5,10,5,11],[6,1,6,2],[6,8,6,9],[6,10,6,11],[7,1,7,2],[7,8,7,9],[7,10,7,11],[8,1,8,2],[9,1,9,2],[9,8,9,9],[9,10,9,11],[10,1,10,2],[10,8,10,9],[10,10,10,11],[11,1,11,2],[11,8,11,9],[11,10,11,11],[12,1,12,2],[13,1,13,2],[14,1,14,2],[14,8,14,9],[14,10,14,11],[15,1,15,2],[15,8,15,9],[15,10,15,11],[16,1,16,2],[16,8,16,9],[16,10,16,11],[17,1,17,2],[17,8,17,9],[17,10,17,11],[18,8,18,9],[18,10,18,11],[19,8,19,9],[19,10,19,11],[20,1,20,2],[21,1,21,2],[22,1,22,2],[22,8,22,9],[22,10,22,11],[23,1,23,2],[23,8,23,9],[23,10,23,11],[24,1,24,2],[24,8,24,9],[24,10,24,11],[25,1,25,2],[25,8,25,9],[25,10,25,11],[26,1,26,2],[27,1,27,2],[27,8,27,9],[27,10,27,11],[28,1,28,2],[28,8,28,9],[28,10,28,11],[29,1,29,2],[29,8,29,9],[29,10,29,11],[30,1,30,2],[30,8,30,9],[30,10,30,11],[31,1,31,2],[31,8,31,9],[31,10,31,11],[32,1,32,2],[32,8,32,9],[32,10,32,11],[33,1,33,2],[34,1,34,2],[34,8,34,9],[34,10,34,11],[35,1,35,2],[35,8,35,9],[35,10,35,11],[36,1,36,2],[36,8,36,9],[36,10,36,11],[37,1,37,2],[37,8,37,9],[37,10,37,11],[38,1,38,2],[38,8,38,9],[38,10,38,11],[39,1,39,2],[39,8,39,9],[39,10,39,11],[40,1,40,2],[41,1,41,2],[41,8,41,9],[41,10,41,11],[42,1,42,2],[42,8,42,9],[42,10,42,11],[43,1,43,2],[43,8,43,9],[43,10,43,11],[44,1,44,2],[44,8,44,9],[44,10,44,11],[45,1,45,2],[45,8,45,9],[45,10,45,11],[46,1,46,2],[46,8,46,9],[46,10,46,11],[47,1,47,2],[47,8,47,9],[47,10,47,11],[48,1,48,2],[49,1,49,2],[49,8,49,9],[49,10,49,11],[50,1,50,2],[50,8,50,9],[50,10,50,11],[51,1,51,2],[51,8,51,9],[51,10,51,11],[52,1,52,2],[52,8,52,9],[52,10,52,11],[53,1,53,2],[53,8,53,9],[53,10,53,11],[54,1,54,2],[55,1,55,2],[55,8,55,9],[55,10,55,11],[56,1,56,2],[56,8,56,9],[56,10,56,11],[57,1,57,2],[57,8,57,9],[57,10,57,11],[58,1,58,2],[59,1,59,2],[59,8,59,9],[59,10,59,11],[60,1,60,2],[60,8,60,9],[60,10,60,11],[61,1,61,2],[61,8,61,9],[61,10,61,11],[62,1,62,2],[62,8,62,9],[62,10,62,11],[63,1,63,2],[63,8,63,9],[63,10,63,11],[64,1,64,2],[64,8,64,9],[64,10,64,11],[65,1,65,2],[66,1,66,2],[66,8,66,9],[66,10,66,11],[67,1,67,2],[67,8,67,9],[67,10,67,11],[68,1,68,2],[68,8,68,9],[68,10,68,11],[69,1,69,2],[69,8,69,9],[69,10,69,11],[70,1,70,2],[70,8,70,9],[70,10,70,11],[71,1,71,2],[71,8,71,9],[71,10,71,11],[75,2,75,6]]}
[null,"MARKETING PLAN",{"$nulls":10},"* Enter date of first Monday of each month."]
[null,"Projected Cost to Date:",{"$f":"SUM(J5,J9,J14,J22,J27,J34,J41,J49,J55,J59,J66)","v":{"v":1700,"d":"$1,700.00"}},{"$nulls":9},"Q1",{"$nulls":14},"Q2",{"$nulls":14},"Q3",{"$nulls":14},"Q4"]
[null,"Actual Cost to Date:",{"$f":"SUM(L5,L9,L14,L22,L27,L34,L41,L49,L55,L59,L66)","v":{"v":1500,"d":"$1,500.00"}},{"$nulls":9},"JANUARY",{"$nulls":4},"FEBRUARY",{"$nulls":4},"MARCH",{"$nulls":4},"APRIL",{"$nulls":4},"MAY",{"$nulls":4},"JUNE",{"$nulls":4},"JULY",{"$nulls":4},"AUGUST",{"$nulls":4},"SEPTEMBER",{"$nulls":4},"OCTOBER",{"$nulls":4},"NOVEMBER",{"$nulls":4},"DECEMBER"]
[null,"CAMPAIGN TYPE",null,"PROJECT GOALS","TARGET AUDIENCE","CLICKS / RESPONSE","NOTES","WEIGHT","PROJECTED COST",null,"ACTUAL COST",null,4,{"$f":"M4+7","v":11},{"$f":"N4+7","v":18},25,"-",1,{"$f":"R4+7","v":8},{"$f":"S4+7","v":15},22,29,7,{"$f":"W4+7","v":14},{"$f":"X4+7","v":21},28,"-",4,{"$f":"AB4+7","v":11},{"$f":"AC4+7","v":18},25,"-",2,{"$f":"AG4+7","v":9},{"$f":"AH4+7","v":16},23,30,6,{"$f":"AL4+7","v":13},{"$f":"AM4+7","v":20},27,"-",4,{"$f":"AQ4+7","v":11},{"$f":"AR4+7","v":18},25,"-",1,{"$f":"AV4+7","v":8},{"$f":"AW4+7","v":15},22,29,5,{"$f":"BA4+7","v":12},{"$f":"BB4+7","v":19},26,"-",3,{"$f":"BF4+7","v":10},{"$f":"BG4+7","v":17},24,31,7,{"$f":"BK4+7","v":14},{"$f":"BL4+7","v":21},28,"-",5,{"$f":"BP4+7","v":12},{"$f":"BQ4+7","v":19},26,"-"]
[null,"National Marketing",{"$nulls":6},"SUBTOTAL",{"$f":"SUM(I6:J8)","v":{"v":200,"d":"$200.00"}},"SUBTOTAL",{"$f":"SUM(K6:L8)","v":{"v":200,"d":"$200.00"}}]
[null,"Banner Ads",{"$nulls":6},{"v":200,"d":"$200.00"},null,{"v":200,"d":"$200.00"}]
[]
[]
[null,"Local Marketing",{"$nulls":6},"SUBTOTAL",{"$f":"SUM(I10:J13)","v":{"v":1500,"d":"$1,500.00"}},"SUBTOTAL",{"$f":"SUM(K10:L13)","v":{"v":1300,"d":"$1,300.00"}}]
[null,"Newspaper",{"$nulls":6},{"v":600,"d":"$600.00"},null,{"v":500,"d":"$500.00"}]
[null,"In-Store Marketing",{"$nulls":6},{"v":400,"d":"$400.00"},null,{"v":200,"d":"$200.00"}]
[null,"POP",{"$nulls":6},{"v":500,"d":"$500.00"},null,{"v":600,"d":"$600.00"}]
[]
[null,"Public Relations",{"$nulls":6},"SUBTOTAL",{"$f":"SUM(I15:J21)","v":0},"SUBTOTAL",{"$f":"SUM(K15:L21)","v":0}]
[null,"Public Events"]
[null,"Sponsorships"]
[null,"Press Releases"]
[null,"Webinars"]
[null,"Conferences"]
[null,"Client Events"]
[]
[null,"Content Marketing",{"$nulls":6},"SUBTOTAL",{"$f":"SUM(I23:J26)","v":0},"SUBTOTAL",{"$f":"SUM(K23:L26)","v":0}]
[null,"Sponsored Content"]
[null,"Landing Page"]
[null,"White Papers / ebooks"]
[]
[null,"Social Media",{"$nulls":6},"SUBTOTAL",{"$f":"SUM(I28:J33)","v":0},"SUBTOTAL",{"$f":"SUM(K28:L33)","v":0}]
[null,"Twitter"]
[null,"Facebook"]
[null,"Pinterest"]
[null,"Instagram"]
[null,"Google+"]
[null,"LinkedIn"]
[null,"Online",{"$nulls":6},"SUBTOTAL",{"$f":"SUM(I35:J40)","v":0},"SUBTOTAL",{"$f":"SUM(K35:L40)","v":0}]
[null,"Blog"]
[null,"Website"]
[null,"Mobile App"]
[null,"Mobile Alerts"]
[null,"Email Newsletter"]
[]
[null,"Advertising",{"$nulls":6},"SUBTOTAL",{"$f":"SUM(I42:J48)","v":0},"SUBTOTAL",{"$f":"SUM(K42:L48)","v":0}]
[null,"Online"]
[null,"Print"]
[null,"Outdoor"]
[null,"Radio"]
[null,"Television"]
[]
[]
[null,"Web",{"$nulls":6},"SUBTOTAL",{"$f":"SUM(I50:J54)","v":0},"SUBTOTAL",{"$f":"SUM(K50:L54)","v":0}]
[null,"Development"]
[null,"Pay-Per-Click Marketing"]
[null,"SEO"]
[]
[]
[null,"Market Research",{"$nulls":6},"SUBTOTAL",{"$f":"SUM(I56:J58)","v":0},"SUBTOTAL",{"$f":"SUM(K56:L58)","v":0}]
[null,"Surveys"]
[null,"Impact Studies"]
[]
[null,"Sales Campaigns",{"$nulls":6},"SUBTOTAL",{"$f":"SUM(I60:J65)","v":0},"SUBTOTAL",{"$f":"SUM(K60:L65)","v":0}]
[null,"Campaign A"]
[null,"Campaign B"]
[null,"Campaign C"]
[null,"Campaign D"]
[null,"Campaign E"]
[]
[null,"Other",{"$nulls":6},"SUBTOTAL",{"$f":"SUM(I67:J72)","v":0},"SUBTOTAL",{"$f":"SUM(K67:L72)","v":0}]
[null,"Premiums"]
[null,"Corporate Branding"]
[null,"Business Cards"]
[null,"Signage"]
[]
[]
[]
[]
[]
[null,null,"CLICK HERE TO CREATE MARKETING PLAN TEMPLATES IN SMARTSHEET"]