{"text_format":"2","workbook":"xlsx","n_sheets":3,"sheets":["方案","Sheet2","Sheet3"],"not_rendered":{"charts":0,"images":9,"macros":0,"external_links":0,"defined_names":0,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"方案","index":0,"n_rows":50,"n_cols":10,"rows_kept":50,"cut":false,"hidden":false,"merged":[[0,0,0,2],[0,3,0,5],[0,6,0,9],[1,7,1,9],[2,7,2,9],[3,7,3,9],[4,7,4,9],[5,7,5,9],[10,1,10,6],[14,1,14,3],[14,4,14,7],[15,0,15,8],[30,1,30,7],[30,8,30,9],[30,10,30,15],[31,1,31,7],[31,8,31,9],[31,10,31,15],[32,1,32,7],[32,8,32,9],[32,10,32,15],[33,1,33,7],[33,8,33,9],[33,10,33,15],[34,1,34,7],[34,8,34,9],[34,10,34,15],[35,1,35,7],[35,8,35,9],[35,10,35,15],[36,1,36,7],[36,8,36,9],[36,10,36,15],[37,1,37,7],[37,8,37,9],[37,10,37,15],[38,1,38,7],[38,8,38,9],[38,10,38,15],[39,1,39,7],[39,8,39,9],[39,10,39,15],[40,1,40,7],[40,8,40,9],[40,10,40,15],[41,1,41,7],[41,8,41,9],[41,10,41,15],[42,1,42,7],[42,8,42,9],[42,10,42,15],[43,1,43,7],[43,8,43,9],[43,10,43,15],[44,1,44,7],[44,8,44,9],[44,10,44,15],[45,1,45,7],[45,8,45,9],[45,10,45,15],[46,1,46,7],[46,8,46,9],[46,10,46,15],[47,1,47,7],[47,8,47,9],[47,10,47,15],[48,1,48,7],[48,8,48,9],[48,10,48,15],[49,1,49,7],[49,8,49,9],[49,10,49,15],[50,1,50,7],[51,1,51,7],[52,1,52,7],[53,1,53,7],[54,1,54,7],[55,1,55,7],[31,0,32,0],[33,0,36,0],[37,0,46,0],[47,0,49,0],[18,9,21,9]]}
["流量需求",null,null,"推广计划",null,null,"促销方案【五重好礼】"]
["流量细项",null,"预计费用",null,"直通车","钻展","大礼1","免 第一名成功付款享受免单，点击开团提醒"]
["预计销量",800,null,"活动前",400,1200,"大礼2","减 第2-50名立即减300元"]
["预计转化率",0.1,null,"活动中",400,800,"大礼3","减 第51-100名立即减200元"]
["需求流量",{"$f":"B3/B4","v":8000},null,"累计",{"$f":"SUM(E3:E4)","v":800},{"$f":"SUM(F3:F4)","v":2000},"大礼4","增 第100-500名立即减100元"]
["预估活动流量",5000,50000,null,null,null,"大礼5","五分好评截图返现20元（20字以上好评直接返现到支付宝）"]
["店铺流量（自然搜索）",200]
["直通车（ppc 3元）",800,2400]
["钻展(ppc 1元）",2000,2000]
[null,null,{"$f":"SUM(C6:C9)","v":54400}]
[null,"预热",{"$nulls":5},"活动当天"]
[null,1,2,3,4,5,6,7,"累计"]
["直通车",50,60,60,60,70,100,400,{"$f":"SUM(B13:H13)","v":800}]
["钻展",300,180,180,220,180,200,800,{"$f":"SUM(B14:H14)","v":2060}]
[null,"测图",null,null,"砸点击率最高的图"]
["成本核算"]
["进价",1999,1999,1999,1999,1999,null,"促销方案成本"]
["售价",2780,2780,2780,2780,2780,null,"促销方案成本","单项成本","备注"]
["扣点（5%）",{"$f":"B18*0.05","v":139},{"$f":"C18*0.05","v":139},139,139,{"$f":"F18*0.05","v":139},null,"大礼1（免）",2699]
["快递费用",35,35,35,35,35,null,"大礼2（减）",{"$f":"49*300","v":14700}]
["好评返现",20,20,20,20,20,null,"大礼3（减）",{"$f":"50*200","v":10000}]
["毛利额",{"$f":"B18-B17-B19-B20-B21","v":587},{"$f":"C18-C17-C19-C20-C21","v":587},587,587,{"$f":"F18-F17-F19-F20-F21","v":587},null,"大礼4（增）",{"$f":"400*100","v":40000}]
["估计销量",100,200,300,400,500,null,"大礼5（返）",{"$f":"20*500","v":10000},"可不计入"]
["备货需求",600,600,600,600,600,null,null,{"$f":"SUM(I19:I22)","v":67399},"不含返现"]
["预计销售额",{"$f":"B23*B18","v":278000},{"$f":"C23*C18","v":556000},834000,1112000,{"$f":"F23*F18","v":1390000}]
["预计毛利额（不含广告促销费用）",{"$f":"B23*B22","v":58700},{"$f":"C23*C22","v":117400},176100,234800,{"$f":"F23*F22","v":293500}]
["促销方案成本",67399,67399,67399,67399,67399]
["流量成本",54400,54400,54400,54400,54400]
["预计毛利额（含广告促销费用）",{"$f":"B26-B27-B28","v":-63099},{"$f":"C26-C27-C28","v":-4399},54301,113001,{"$f":"F26-F27-F28","v":171701}]
["人员方案"]
[null,"活动前",{"$nulls":6},"活动中"]
["仓库","活动款前3天备好货"]
[null,"前2天打包好300单独包，可直接贴面单"]
["客服","单品知识再次熟悉培训，店长负责培训"]
[null,"关联产品推荐技巧熟悉"]
[null,"售后安装知识考核"]
[null,"活动要点，好评返现等重要内容必须熟知流程"]
["美工","聚划算平台详情页页设计（三套方案）"]
[null,"聚划算平台主图设计（三套方案）"]
[null,"店铺内页二级页内页设计（2套方案）"]
[null,"店铺海报方案（5个方案）"]
[null,"推广直通车图（10个方案），点击率不低于1%"]
[null,"钻展图（15个方案）点击率不低于2%，投首焦"]
[null,"店铺首页（前三屏活动预热、点击进入活动二级页面）"]
[null,"店招设计（点击进入活动二级页面）"]
[null,"店铺关联产品设计"]
[null,"详情页侧栏预热方案（高度500）"]
["推广","直通车预热，提前一周预热，每日150uv进店"]
[null,"钻展预热，提前一周预热，进阶式投放，7天至少进店1000uv"]
[null,"每日数据监控，流量不足，广告费用补上"]

{"sheet":"Sheet2","index":1,"n_rows":59,"n_cols":17,"rows_kept":59,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,null,null,"直通车出8个方案"]
[null,null,null,"钻展出15个方案",null,"创意cool"]
{"$rows_empty":52}
[{"$nulls":16},"出门要体面"]
[{"$nulls":16},"回家要干净"]

{"sheet":"Sheet3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}