{"text_format":"2","workbook":"xlsx","n_sheets":6,"sheets":["运营计划","店铺年度运营规划","店铺常规月度运营计划","主推商品、新品测试监控表","店铺月度自诊模板","Sheet1"],"not_rendered":{"charts":1,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"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":38,"n_cols":15,"rows_kept":38,"cut":false,"hidden":false,"merged":[[0,0,0,14],[1,2,1,14],[2,2,2,4],[2,5,2,7],[2,8,2,10],[2,11,2,13],[3,0,3,1],[4,0,4,1],[1,0,2,0],[5,0,10,0],[11,0,16,0],[17,0,22,0],[23,0,24,0],[25,0,27,0],[28,0,36,0]]}
["2016年运营计划"]
["方向策略","年度发展重点","把用户体验和产品线研发放在首位，提供最优质的产品，销售只是水到渠成的事情"]
[null,"季度发展重点",{"$nulls":12},"汇总"]
["月份",null,"1月","2月","3月","4月","5月","6月","7月","8月","9月","10月","11月","12月"]
["日均销售额"]
["销售目标","常规销售额（万）"]
[null,"聚划算销售额（万）"]
[null,"店铺UV"]
[null,"客单价"]
[null,"转化率"]
[null,"销售笔数"]
["流量占比","自然搜索流量"]
[null,"直通车"]
[null,"钻展硬广"]
[null,"淘客"]
[null,"站外"]
[null,"其他流量"]
["营销费用","直通车"]
[null,"钻展硬广"]
[null,"淘客"]
[null,"站外"]
[null,"赠品"]
[null,"其他"]
["活动","活动策划"]
[null,"折扣力度"]
["货品","在线SPU数"]
[null,"动销率"]
[null,"上新数"]
["人力资源","产品开发人员"]
[null,"运营"]
[null,"客服"]
[null,"设计"]
[null,"推广"]
[null,"策划"]
[null,"摄影"]
[null,"视频制作"]
[null,"会计"]
[null,"商务"]

{"sheet":"店铺年度运营规划","index":1,"n_rows":37,"n_cols":15,"rows_kept":37,"cut":false,"hidden":false,"merged":[[0,0,0,14],[1,2,1,14],[2,2,2,4],[2,5,2,7],[2,8,2,10],[2,11,2,13],[3,0,3,1],[4,0,4,1],[1,0,2,0],[5,0,10,0],[11,0,16,0],[17,0,22,0],[23,0,24,0],[25,0,28,0],[29,0,36,0],[3,14,4,14]]}
["2016年运营规划"]
["方向策略","年度发展重点","把用户体验和产品线研发放在首位，提供给用户最优质的产品，销售只是水到渠成的事情"]
[null,"季度重点","Q1重点",null,null,"Q2重点",null,null,"Q3重点",null,null,"Q4重点",null,null,"汇总"]
["月份",null,"1月","2月","3月","4月","5月","6月","7月","8月","9月","10月","11月","12月"]
["日均销售额"]
["营销目标","常规销售额（万）"]
[null,"聚划算销售额（万）"]
[null,"店铺UV"]
[null,"客单价（元）"]
[null,"销售笔数"]
[null,"转化率"]
["流量占比","自然搜索流量"]
[null,"直通车"]
[null,"钻展硬广"]
[null,"淘客"]
[null,"站外"]
[null,"其他免费流量"]
["营销费用\n（万元）","直通车"]
[null,"钻展硬广"]
[null,"淘客"]
[null,"站外"]
[null,"老客户、礼品"]
[null,"其他"]
["活动促销","活动主题"]
[null,"折扣力度"]
["货品","在线SPU数"]
[null,"动销率"]
[null,"售罄率"]
[null,"上新数"]
["人员配置\n（人）","产品开发相关人员"]
[null,"运营"]
[null,"客服"]
[null,"物流"]
[null,"美工"]
[null,"推广"]
[null,"行政"]
[null,"财务"]

{"sheet":"店铺常规月度运营计划","index":2,"n_rows":29,"n_cols":56,"rows_kept":29,"cut":false,"hidden":false,"merged":[[0,3,0,56],[1,13,1,20],[1,28,1,35],[1,49,1,56],[2,1,2,2],[2,3,2,56],[3,1,3,2],[3,3,3,20],[3,21,3,27],[3,36,3,56],[4,1,4,2],[4,3,4,12],[4,13,4,20],[4,21,4,27],[4,28,4,35],[4,36,4,48],[4,49,4,56],[5,1,5,2],[5,3,5,12],[5,13,5,20],[5,21,5,27],[5,28,5,35],[5,36,5,48],[5,49,5,56],[6,1,6,2],[6,3,6,12],[6,13,6,20],[6,21,6,27],[6,28,6,35],[6,36,6,48],[6,49,6,56],[7,1,7,2],[7,3,7,12],[7,13,7,20],[7,21,7,27],[7,28,7,35],[7,36,7,48],[7,49,7,56],[8,1,8,2],[8,3,8,12],[8,13,8,20],[8,21,8,27],[8,28,8,35],[8,36,8,48],[8,49,8,56],[9,1,9,2],[9,3,9,56],[10,1,10,2],[10,3,10,12],[10,13,10,20],[10,21,10,27],[10,28,10,35],[10,36,10,48],[10,49,10,56],[11,1,11,2],[11,3,11,12],[11,13,11,20],[11,21,11,27],[11,28,11,35],[11,36,11,48],[11,49,11,56],[12,1,12,2],[12,13,12,20],[12,21,12,27],[12,28,12,35],[12,36,12,48],[12,49,12,56],[13,1,13,2],[13,3,13,12],[13,13,13,20],[13,21,13,27],[13,28,13,35],[13,36,13,48],[13,49,13,56],[14,1,14,2],[14,3,14,12],[14,13,14,20],[14,21,14,27],[14,28,14,35],[14,36,14,48],[14,49,14,56],[15,1,15,2],[15,13,15,20],[15,21,15,27],[15,28,15,35],[15,36,15,48],[15,49,15,56],[16,1,16,2],[16,3,16,12],[16,13,16,20],[16,21,16,27],[16,36,16,48],[16,49,16,56],[17,1,17,2],[17,3,17,12],[17,13,17,20],[17,21,17,27],[17,28,17,35],[17,36,17,48],[17,49,17,56],[18,1,18,2],[18,3,18,12],[18,13,18,20],[18,21,18,27],[18,28,18,35],[18,36,18,48],[18,49,18,56],[19,1,19,2],[19,13,19,16],[19,17,19,20],[19,28,19,31],[19,32,19,35],[19,49,19,52],[19,53,19,56],[20,3,20,12],[20,13,20,14],[20,15,20,16],[20,17,20,18],[20,19,20,20],[20,21,20,27],[20,28,20,29],[20,30,20,31],[20,32,20,33],[20,34,20,35],[20,36,20,48],[20,49,20,50],[20,51,20,52],[20,53,20,54],[20,55,20,56],[21,3,21,12],[21,13,21,14],[21,15,21,16],[21,17,21,18],[21,19,21,20],[21,21,21,27],[21,28,21,29],[21,30,21,31],[21,32,21,33],[21,34,21,35],[21,36,21,48],[21,49,21,50],[21,51,21,52],[21,53,21,54],[21,55,21,56],[22,13,22,14],[22,15,22,16],[22,17,22,18],[22,19,22,20],[22,28,22,29],[22,30,22,31],[22,32,22,33],[22,34,22,35],[22,49,22,50],[22,51,22,52],[22,53,22,54],[22,55,22,56],[23,13,23,14],[23,15,23,16],[23,17,23,18],[23,19,23,20],[23,28,23,29],[23,30,23,31],[23,32,23,33],[23,34,23,35],[23,49,23,50],[23,51,23,52],[23,53,23,54],[23,55,23,56],[24,13,24,14],[24,15,24,16],[24,17,24,18],[24,19,24,20],[24,28,24,29],[24,30,24,31],[24,32,24,33],[24,34,24,35],[24,49,24,50],[24,51,24,52],[24,53,24,54],[24,55,24,56],[25,13,25,14],[25,15,25,16],[25,17,25,18],[25,19,25,20],[25,28,25,29],[25,30,25,31],[25,32,25,33],[25,34,25,35],[25,49,25,50],[25,51,25,52],[25,53,25,54],[25,55,25,56],[26,13,26,14],[26,15,26,16],[26,17,26,18],[26,19,26,20],[26,28,26,29],[26,30,26,31],[26,32,26,33],[26,34,26,35],[26,49,26,50],[26,51,26,52],[26,53,26,54],[26,55,26,56],[27,13,27,14],[27,15,27,16],[27,17,27,18],[27,19,27,20],[27,28,27,29],[27,30,27,31],[27,32,27,33],[27,34,27,35],[27,49,27,50],[27,51,27,52],[27,53,27,54],[27,55,27,56],[28,13,28,14],[28,15,28,16],[28,17,28,18],[28,19,28,20],[28,28,28,29],[28,30,28,31],[28,32,28,33],[28,34,28,35],[28,49,28,50],[28,51,28,52],[28,53,28,54],[28,55,28,56],[0,0,1,0],[2,0,8,0],[9,0,10,0],[12,0,18,0],[19,0,28,0],[20,1,21,1],[20,2,21,2],[0,1,1,2]]}
["部门","时间",null,"2016年9月份运营计划"]
[null,null,null,1,2,3,4,5,6,7,8,9,10,"实际完成",{"$nulls":7},11,12,13,14,15,16,17,"实际完成",{"$nulls":7},18,19,20,21,22,23,24,25,26,27,28,29,30,"实际完成"]
["目标","总目标",null,500000]
[null,"阶段",null,"第一阶段",{"$nulls":17},"第二阶段",{"$nulls":14},"第三阶段"]
[null,"阶段销售目标"]
[null,"阶段访客目标"]
[null,"阶段客单目标"]
[null,"阶段转化率目标"]
[null,"聚划算销量目标"]
["货品","结构"]
[null,"主推商品（货号）"]
["策划","活动"]
["视觉（提早制作）","首页"]
[null,"专辑"]
[null,"banner"]
[null,"活动页"]
[null,"宝贝分类页"]
[null,"宝贝搜索页"]
[null,"详情页"]
["引流","时间",null,1,2,3,4,5,6,7,8,9,10,"投入",null,null,null,"流量",null,null,null,11,12,13,14,15,16,17,"投入",null,null,null,"流量",null,null,null,18,19,20,21,22,23,24,25,26,27,28,29,30,"投入",null,null,null,"流量"]
[null,"推广渠道","月度总流量分解","阶段目标流量",{"$nulls":9},"预算",null,"实际",null,"预估",null,"实际",null,"阶段目标流量",{"$nulls":6},"预算",null,"实际",null,"预估",null,"实际",null,"阶段目标流量",{"$nulls":12},"预算",null,"实际",null,"预估",null,"实际"]
[]
[null,"免费流量"]
[null,"钻展"]
[null,"直通车"]
[null,"淘客"]
[null,"活动"]
[null,"其他"]
[null,"合计"]

{"sheet":"主推商品、新品测试监控表","index":3,"n_rows":16,"n_cols":16,"rows_kept":16,"cut":false,"hidden":false,"merged":[[0,8,0,15],[0,0,2,0],[3,0,8,0],[10,0,15,0],[0,1,2,1],[3,1,8,1],[10,1,15,1],[0,2,2,2],[3,2,8,2],[10,2,15,2],[0,3,2,3],[3,3,8,3],[10,3,15,3],[0,4,2,4],[3,4,8,4],[10,4,15,4],[0,5,2,5],[3,5,8,5],[10,5,15,5],[0,6,2,6],[3,6,8,6],[10,6,15,6],[0,7,2,7]]}
["品类","货品名称","货号","上架时间","定价","销售价区间","主要推广方式","详情","第一周"]
[{"$nulls":8},"9-1","9-2","9-3","9-4","9-5","9-6","9-7"]
[{"$nulls":8},"周一","周二","周三","周四","周五","周六","周日","汇总"]
[{"$nulls":7},"售价"]
[{"$nulls":7},"推广费用"]
[{"$nulls":7},"流量"]
[{"$nulls":7},"转化率"]
[{"$nulls":7},"ROI"]
[{"$nulls":7},"成交额"]
[]
[{"$nulls":7},"售价"]
[{"$nulls":7},"推广费用"]
[{"$nulls":7},"流量"]
[{"$nulls":7},"转化率"]
[{"$nulls":7},"ROI"]
[{"$nulls":7},"成交额"]

{"sheet":"店铺月度自诊模板","index":4,"n_rows":76,"n_cols":9,"rows_kept":76,"cut":false,"hidden":false,"merged":[[4,0,4,3],[5,1,5,3],[6,1,6,3],[7,1,7,3],[8,1,8,3],[9,1,9,3],[12,0,12,8],[28,0,28,7],[29,2,29,7],[30,2,30,7],[31,2,31,7],[32,2,32,7],[35,0,35,8],[36,2,36,6],[37,2,37,6],[38,2,38,6],[39,2,39,6],[40,2,40,6],[41,2,41,6],[42,2,42,6],[43,2,43,6],[13,0,14,0],[15,0,16,0],[17,0,18,0],[19,0,20,0],[21,0,22,0],[23,0,24,0],[30,0,32,0]]}
["商家名称","主营类目","主营商品","诊断时间","诊断周期","竞品店铺"]
[]
[]
[]
["店铺基本情况分析"]
["月销件数"]
["月转化率"]
["月客单价"]
["上新spu数"]
["聚划算单品/品牌团参团情况"]
[]
[]
["数据详情解读"]
["成交额相关","成交额","客单价","客件数","期内未付款流失交易额","流量TOP10产品成交金额"]
[]
["店内流量","店铺UV","店铺PV","宝贝IPV_UV","支付宝成交金额TOP10宝贝IPV","支付宝成交金额TOP10宝贝IPV-UV","自主访问PV"]
[]
["流量结构","淘宝搜索PV","天猫搜索PV","直通车PV","自主访问店铺的PV","淘客PV","钻展PV","聚划算PV"]
[]
["视觉相关","日均访问深度","店铺浏览转化率","Detail页面跳失率","店铺首页跳失率","首页平均停留时间"]
[]
["营销相关","成交转化率","人均支付宝购买件数","客单价","购买UV","UV价值","询单转化率","期内熟客数","期内熟客率"]
[]
["店铺相关","退款率","DSR均值","描述相符dsr","卖家服务dsr","发货速度dsr",null,"退款纠纷率","发货时长"]
[]
[]
[]
[]
["店铺问题总结"]
["问题模块","问题细分","问题描述"]
["例：客单价低","客件数低"]
[null,"熟客率低"]
[null,"货单价低"]
[]
[]
["▲改进计划"]
["事项","时间","内容",{"$nulls":4},"优先级","完成情况"]
["例：老客维护","2014-09-01","提交维护规划，包括客户分层、对应营销策略、执行时间表",{"$nulls":4},"P1","未出第一版方案"]
{"$rows_empty":35}
[null,"UV：即Unique Visitors，也就是访问者(独立访问者)，不可以累加或相减。"]
[null,"IPV：商品详细页面的PV，也称Detail PV，页面url内带有item-detail这个关键词。"]
[null,"IPV UV：浏览过商品详情页面的访问者(独立访问者)"]

{"sheet":"Sheet1","index":5,"n_rows":20,"n_cols":15,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
["1月","2月","3月","4月","5月","6月","7月","8月","9月","10月","11月","12月",null,null,20000000]
[0.08,0.03,0.06,0.06,0.06,0.07,0.06,0.06,0.08,0.12,0.18,0.14]
[{"$f":"O1*A2","v":1600000},{"$f":"O1*B2","v":600000},{"$f":"O1*C2","v":1200000},{"$f":"O1*D2","v":1200000},{"$f":"O1*E2","v":1200000},{"$f":"O1*F2","v":1400000},{"$f":"O1*G2","v":1200000},{"$f":"O1*H2","v":1200000},{"$f":"O1*I2","v":1600000},{"$f":"O1*J2","v":2400000},{"$f":"O1*K2","v":3600000},{"$f":"O1*L2","v":2800000}]
[]
[1600000,600000,1200000,1200000,1200000,1400000,120000,1200000,1600000,2400000,3600000,2800000]
[]
[]
[]
[]
[]
[null,"1月","2月","3月","4月","5月","6月","7月","8月","9月","10月","11月","12月"]
["访客",424000,204000,332800,344500,382500,425000,396400,356000,393200,561300,755700,663000]
["直通车",0.23,0.24,0.22,0.22,0.23,0.22,0.24,0.24,0.23,0.22,0.22,0.22]
["钻展",0.26,0.27,0.26,0.26,0.26,0.26,0.28,0.28,0.26,0.26,0.23,0.26]
["直通车",{"$f":"B12*B13","v":97520},{"$f":"C12*C13","v":48960},{"$f":"D12*D13","v":73216},75790,87975,93500,95136,85440,90436,123486,166254,145860]
["钻展",{"$f":"B12*B14","v":110240},{"$f":"C12*C14","v":55080},{"$f":"D12*D14","v":86528},89570,99450,110500,110992,99680,102232,145938,173811,172380]
["直通车",1.8,1.6,1.8,2,2,2.2,2,2,2.3,2.4,2.4,2.4]
["钻展",0.8,0.7,1.2,1.2,1,1,1.4,1.4,1.6,1.6,1.6,1.6]
["直通车",17,8,13,15,18,20,20,18,20,30,40,35]
["钻展",10,4,10,10,10,10,15,14,15,23,27,27]