{"text_format":"2","workbook":"xlsx","n_sheets":3,"sheets":["上架规则","2016年第17周工作计划","电商工作分配"],"not_rendered":{"charts":0,"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":66,"n_cols":10,"rows_kept":66,"cut":false,"hidden":false,"merged":[[1,1,1,9],[2,1,2,9],[3,4,3,5],[3,6,3,7],[4,8,4,9],[5,1,5,9],[18,1,18,5],[18,6,18,9],[25,1,25,5],[25,6,25,9],[32,1,32,5],[32,6,32,9],[41,1,41,9],[42,1,42,9],[66,2,66,5],[66,6,66,8],[67,1,67,8],[68,1,68,8],[3,1,4,1],[6,1,17,1],[19,1,24,1],[26,1,31,1],[33,1,40,1],[44,1,66,1],[3,2,4,2],[6,2,7,2],[8,2,9,2],[10,2,11,2],[12,2,13,2],[14,2,15,2],[16,2,17,2],[19,2,20,2],[21,2,22,2],[23,2,24,2],[26,2,27,2],[28,2,29,2],[30,2,31,2],[33,2,34,2],[35,2,36,2],[37,2,38,2],[39,2,40,2],[3,3,4,3],[6,3,7,3],[8,3,9,3],[10,3,11,3],[12,3,13,3],[14,3,15,3],[16,3,17,3],[19,3,20,3],[21,3,22,3],[23,3,24,3],[26,3,27,3],[28,3,29,3],[30,3,31,3],[33,3,34,3],[35,3,36,3],[37,3,38,3],[39,3,40,3],[6,4,7,4],[8,4,9,4],[10,4,11,4],[12,4,15,4],[16,4,17,4],[19,4,24,4],[26,4,29,4],[30,4,31,4],[33,4,34,4],[35,4,38,4],[39,4,40,4],[44,4,45,4],[52,4,54,4],[55,4,60,4],[61,4,63,4],[6,5,17,5],[19,5,24,5],[26,5,31,5],[33,5,34,5],[35,5,38,5],[39,5,40,5],[44,5,65,5],[6,6,7,6],[8,6,9,6],[10,6,11,6],[12,6,13,6],[14,6,15,6],[16,6,17,6],[19,6,20,6],[21,6,22,6],[23,6,24,6],[26,6,27,6],[28,6,29,6],[30,6,31,6],[33,6,34,6],[37,6,38,6],[39,6,40,6],[44,6,45,6],[50,6,51,6],[56,6,57,6],[58,6,59,6],[60,6,61,6],[62,6,63,6],[64,6,65,6],[33,7,34,7],[37,7,40,7],[44,7,65,7],[6,8,7,8],[8,8,9,8],[10,8,11,8],[12,8,15,8],[16,8,17,8],[19,8,24,8],[26,8,31,8],[33,8,38,8],[39,8,40,8],[44,8,47,8],[50,8,65,8],[6,9,7,9],[8,9,9,9],[10,9,11,9],[12,9,13,9],[14,9,15,9],[16,9,17,9],[19,9,20,9],[21,9,22,9],[23,9,24,9],[26,9,27,9],[28,9,29,9],[30,9,31,9],[33,9,34,9],[35,9,36,9],[37,9,38,9],[39,9,40,9],[52,9,54,9],[55,9,60,9],[61,9,63,9],[35,6,36,7]]}
[]
[null,"上架规则（推进计划表）"]
[]
[null,"分类","产品组合","价格","推广方式",null,"时间点",null,"    活动频率/月","说明"]
[{"$nulls":4},"主推平台","配套动作","上架时间","积累说明"]
[]
[null,"第3方\n平台\n导购\n推广\n","525ml油污净\n530ml洁厕净\n全能清洁剂525ml\n冰箱除味剂60g\n洗衣机槽清洁剂125*3\n（厨卫清洁5件套）","标价：\n69/116\n\n活动价：49","平台活动\n\n（折800、卷皮、返利网）","补单破零\n补单评价\n补单销售数据\n\n快速提升宝贝评分","2016.4.27","2016.4.27--2016.5.7","“折800、卷皮、返利”\n 导购活动各上一次"]
[{"$nulls":7},"1.不少于10个的基础数据；\n2.不少3个购物评价；\n3.宝贝评份4.8以上；"]
[null,null,"活氧除味管家520ml\n木质地板油精520ml\n真皮护理油精520ml","标价：\n59/108\n\n活动价：49","平台活动\n\n（折800、返利网）",null,"2016.\n5.3","2016.5.3--2016.5.13","“折800、返利”\n 导购活动各上一次"]
[{"$nulls":7},"1.不少于10个的基础数据；\n2.不少3个购物评价；\n3.宝贝评份4.8以上；"]
[null,null,"\n清新剂芳香珠300g\n汽车除味剂60g*2\n多功能去污膏350g","标价：\n69/113\n\n活动价：49","平台活动\n\n（折800、返利网）",null,"2016.5.3","2016.5.3--2016.5.13","“折800、返利”\n 导购活动各上一次"]
[{"$nulls":7},"1.不少于10个的基础数据；\n2.不少3个购物评价；\n3.宝贝评份4.8以上；"]
[null,null,"袖领净320ML*3\n衣物柔顺剂500ml*2","标价：\n69/109\n\n活动价：49","平台活动\n\n（折800、卷皮、返利网）",null,"2016.4.29","2016.4.30--2016.5.10","“折800、卷皮、返利”\n 导购活动各上一次"]
[{"$nulls":7},"1.不少于10个的基础数据；\n2.不少3个购物评价；\n3.宝贝评份4.8以上；"]
[null,null,"宝宝专用洗衣液1L*3\n妇婴内衣洗衣剂*2","标价：\n69/162\n\n活动价：49",null,null,"2016.4.30","2016.4.30--2016.5.10"]
[{"$nulls":7},"1.不少于10个的基础数据；\n2.不少5个购物评价；\n3.宝贝评份4.8以上；"]
[null,null,"全能清洁剂525ml*3","标价：\n39/69\n\n活动价：29","平台活动\n（折800、返利网）",null,"2016.4.30","2016.4.30--2016.5.10","“折800、返利”\n 导购活动各上一次"]
[{"$nulls":7},"1.不少于10个的基础数据；\n2.不少3个购物评价；\n3.宝贝评份4.8以上；"]
[]
[null,"返利\n导购\n推广","1.5L消毒液\n680ML消毒水*2","标价：\n59/108\n\n活动价：49","平台活动\n（返利网）\n+\n直通车/卡周边产品（关键词）","补单破零\n及评价\n","2016.4.30","2016.5.1--2016.5.10","“返利网+淘客活动”\n "]
[{"$nulls":7},"1.不少于5个的基础数据；\n2.不少2个购物评价；\n3.宝贝评份4.8以上；"]
[null,null,"\n衣物柔顺剂500ml\n漂白去渍剂680g\n护色彩漂液680g\n","标价：\n39/69\n\n活动价：29",null,null,"2016.4.29","2016.4.29--2016.5.6"]
[{"$nulls":7},"1.不少于5个的基础数据；\n2.不少2个购物评价；\n3.宝贝评份4.8以上；"]
[null,null,"\n内衣手洗洗衣液1L\n袖领净320ML*3\n\n\n","标价：59/109\n（活动价：49）",null,null,"2016.5.5","2016.5.5--2016.5.15"]
[{"$nulls":7},"1.不少于5个的基础数据；\n2.不少2个购物评价；\n3.宝贝评份4.8以上；"]
[]
[null,"\n直通\n车\n主推\n","2.108kg全效护色皂液*3\n1kg内衣手洗皂液*2\n90g小样*3","标价：\n139/260\n\n活动价：109","直通车+补单（卡关键词）\n+\n重点打造的官方活动款","补单破零\n补单评价\n补单销售数据","2016.4.29","2016.4.30--2016.5.15","\n返利网+淘客活动\n（6月15号前）\n+\n官方活动（后期）\n+\n店铺内“0抢购”"]
[{"$nulls":7},"1.不少于70个的基础数据；\n2.不少20个购物评价；\n3.宝贝评份4.8以上；"]
[null,null,"2.108kg全效护色皂液*3\n90g小样*2","标价：\n89/207\n\n活动价：79",null,null,"已上架","2016.4.26--2016.5.10"]
[{"$nulls":7},"1.不少于90个的基础数据；\n2.不少30个购物评价；\n3.宝贝评份4.8以上；"]
[null,null,"专业洗衣液2L*3\n全效洗衣液3kg*1\n17斤","标价：\n119/180\n\n活动价：99","直通车+补单（卡关键词）\n+\n重点打造的官方活动款",null,"2016.5.3","2016.5.3--2016.5.18"]
[{"$nulls":7},"1.不少于80个的基础数据；\n2.不少23个购物评价；\n3.宝贝评份4.8以上；"]
[]
[null,"常规\n组合\n","2.108kg全效护色皂液*2\n1kg内衣手洗皂液*2\n90g小样*2","标价：\n119/216\n\n活动价：99","返利网+淘客活动\n（官方活动补充款）","补单破零\n补单评价\n（优惠卷动销）","2016.5.7","1.每月破零，适度补单热度\n2.不少3个购物评价；\n3.宝贝评份4.8以上；","返利网+淘客活动"]
[]
[null,null,"全能洗衣液1kg*1\n全能洗衣液500g*3","标价：\n36/79\n\n活动价：29","返利网+淘客活动\n（官方清仓活动）","库存处理","已完成"]
[]
[null,null,"全能洗衣液2kg*1\n全能洗衣液500g*3\n1kg内衣手洗液*1\n90皂液*3","标价：\n59/110\n\n活动价：49.9",null,null,"2016.5.7","1.每月破零，适度补单热度\n2.不少3个购物评价；\n3.宝贝评份4.8以上"]
[]
[null,null,"愛留香coco1.8ml*2\n香氛洗衣液小样*3","标价：86/178\n（活动价：73）","淘客活动\n（官方活动补充款）","补单破零\n补单评价\n（优惠卷动销）","已完成\n[待优化图片文宣",null,"淘客活动"]
[]
[]
[null,"常规单品补充"]
[null,"  ","产品","价格","出售方式","配套动作","上架时间","积累说明","活动方式","说明"]
[null,"单品\n补充","全效洗衣液3kg","\n标价：38/58\n","拍2瓶减10，拍3瓶减20\n（购物车工具）","补单破零\n补单评价","2016.5.10","1.每月破零，适度补单热度\n2.保持不少于3个购物评价；\n3.宝贝评份4.8以上","淘客活动"]
[null,null,"除菌洗衣液2l ","标价：32/56"]
[null,null,"袖领净520ml","标价：16.8/28","拍2送1",null,"2016.5.15"]
[null,null,"衣物柔顺剂500ml","标价：13/18","拍2送1",null,"2016.5.19"]
[null,null,"丝毛洁柔净660ml","标价：23/38","拍2送1",null,"2016.5.21",null,"返利网+淘客活动"]
[null,null,"羽绒服（干洗）洗涤剂320ml","标价：15/23","拍2送1",null,"2016.5.25"]
[null,null,"宝宝专用洗衣液1L","标价：28/38","拍2瓶减10，拍3瓶减20\n（购物车工具）",null,"2016.5.13",null,"返利网+淘客活动"]
[null,null,"妇婴内衣洗剂660ml","标价：26/32","拍2送1"]
[null,null,"清新剂芳香珠300g","标价：13.8/32",null,null,"2016.5.15"]
[null,null,"消毒液1.5L","标价：39/69",null,null,"2016.5.25"]
[null,null,"680ML消毒水","标价：16/27",null,null,"2016.5.28"]
[null,null,"真皮护理油精 520ml","标价：27/38","拍2送1",null,"2016.5.28"]
[null,null,"全能地板净1L","标价：27/36",null,null,"2016.6.2"]
[null,null,"活氧洁净管家520ml","标价：23/36"]
[null,null,"空调清洁剂525ml","标价：23/39",null,null,"2016.6.5"]
[null,null,"洁厕净 525ml","标价：18/26"]
[null,null,"强效油污 525ml","标价：19/29",null,null,"2016.6.8"]
[null,null,"冰箱除味剂60g*2","标价：19/39"]
[null,null,"衣柜除湿剂250*2","标价：16/36",null,null,"2016.6.11"]
[null,null,"甲醛克星60*2","标价：19.8/38"]
[null,null,"餐具净600ml","标价：19.8/38","拍2送1",null,"2016.6.15"]
[null,null,"除菌洗手液500ml ","标价：10.8/26"]

{"sheet":"2016年第17周工作计划","index":1,"n_rows":33,"n_cols":13,"rows_kept":33,"cut":false,"hidden":false,"merged":[[0,5,0,11],[0,0,1,0],[2,0,8,0],[9,0,15,0],[16,0,19,0],[20,0,22,0],[23,0,30,0],[31,0,33,0],[0,1,1,1],[2,1,8,1],[9,1,15,1],[16,1,19,1],[20,1,22,1],[23,1,30,1],[31,1,33,1],[0,2,1,2],[0,3,1,3],[28,3,29,3],[0,4,1,4],[2,4,8,4],[9,4,15,4],[16,4,19,4],[20,4,22,4],[23,4,30,4],[31,4,33,4],[0,12,1,12]]}
["项目","岗位","工作内容","工作描述","协助人","2016年第17周电商工作计划",{"$nulls":6},"备注"]
[{"$nulls":5},4.25,4.26,4.27,4.28,4.29,4.3,5.1]
[null,"经理","制定5月份细分任务表","根据制作月销售任务，分解工作推进计划表"]
[null,null,"规划洁宜佳旗舰PC店首页布局","聚焦主推导流，引导PC端顾客至手淘支付，提升手淘主推品权重"]
[null,null,"规划洁宜佳旗舰手淘店首页布局","调整手淘首页结构及表现力，设置活动，提升浏览时长"]
[null,null,"规划洁宜佳旗舰手淘店详情页表现结构","优化结构，布局详情面引导（路径营销设置），提升互导深度"]
[null,null,"把握新上架详情页及主图表现力","与美工探讨，梳理表现力"]
[null,null,"收集同行品牌数据分析，改进引流计划方案","实时关注线上零售业态信息，不断提升方案有效性"]
[]
[null,"助理","做好5月份推广费用申请"]
[null,null,"实施测试主推补单计划 ","监察并把握补单的真实有效"]
[null,null,"优化直通车","实时整改低展现、低点击、无转化关键词"]
[null,null,"申报第三方活动","根据现实店铺商品申报，稳定流量、成交额"]
[null,null,"根据主推计划做好5月份商品补货计划","根据上架推进计划，做好商品备货下单"]
[null,null,"新品上架发布，标题SEO设置","属性信息核对填定、商品标题选词"]
[]
[null,"客服","售中、售后服务","实时解释顾客咨询，达成成交； 配合仓解决售后事宜…","文案"]
[null,null,"收集素材，编写上架详情页框架“上架计划C13、C7、C20”","根据产品说明，结合同行品牌的详情页、自营C店信息，收集编构"]
[null,null,"校对 店铺界面、详情页信息","校对 美工设计的活动版面、详情页信息，实时反馈"]
[]
[null,"文案","编写“上架计划C13”详情页文宣","根据产品说明，结合同行品牌的详情页、自营C店信息，编写提炼"]
[null,null,"每周的发布1档，衣物洗护知识文宣","根据品牌产品特点，及专业知识，科普受众顾客"]
[null,null,"审核并提炼 客服编写详情页框架"]
[null,"美工\n2员","制作“上架计划C13”详情页/手淘详情页","快速上手，把握洗涤商品属性特点， 根据详情页框架制作、上传"]
[null,null,"设计重排版：手淘洁宜佳旗舰店首页","根据规划模版，制作细调版面，提高浏览时长"]
[null,null,"设计重排版：PC洁宜佳旗舰店首页","根据规划模版，制作细调版面，引导顾客致手淘支付成交"]
[null,null,"直通车图片处理及其他","配合助理，实时设计调整"]
[]
[null,null,"制作“上架计划C7”详情页/手淘详情页"," 根据详情页框架制作、上传"]
[null,null,"制作“上架计划C20”详情页/手淘详情页"]
[]
[null,"仓储","售后服务","实时与客服沟通处理好售后事宜"]
[null,null,"捡单发货","16：00前订单当天发出，确保24小内发出包裹"]

{"sheet":"电商工作分配","index":2,"n_rows":17,"n_cols":10,"rows_kept":17,"cut":false,"hidden":false,"merged":[[0,0,0,9],[1,0,1,9],[2,0,2,1],[2,2,2,7],[3,0,3,9],[18,0,18,9],[4,8,5,8],[6,8,7,8],[8,8,9,8],[10,8,11,8],[12,8,13,8],[14,8,15,8],[16,8,17,8],[4,9,5,9],[6,9,7,9],[8,9,9,9],[10,9,11,9],[12,9,13,9],[14,9,15,9],[16,9,17,9],[14,0,15,1],[14,2,15,7],[16,0,17,1],[16,2,17,7],[10,0,11,1],[10,2,11,7],[12,0,13,1],[12,2,13,7],[6,0,7,1],[6,2,7,7],[8,0,9,1],[8,2,9,7],[4,0,5,1],[4,2,5,7]]}
["电商职能20160423版--主要工作分配"]
[]
["电商岗位",null,"工作内容",{"$nulls":5},"主要对接人员","备注"]
[]
["电商总经理",null,"电商渠道布局、战略方向，渠道秩序、政策规定；资源保障、运营决策；全面管理监督工作。",{"$nulls":5},"全体成员"]
[]
["电商经理",null,"销售目标、运营方案制定（规划店铺商品结构、流量结构、预算计划等），店铺视觉指导、页面布局（路径营销）、详情页优化，店内活动策划、官方及第三方活动申报、活动全面跟踪、商品页属性信息核对，店铺核心数据监察、评估、调整。",{"$nulls":5},"电商助理、美工、文案"]
[]
["电商助理",null,"产品直通车计划，淘客返利活动申报，直通车钻展推广费用预算、流量预估，新品属性信息核对发布、标韪SEO优化，对点击率、PPC、ROI负责，店铺数据报表、售后评价处理、商品库存及下单，新品属性信息核对发布、标韪SEO优化。",{"$nulls":5},"美工、客服、仓储"]
[]
["美工",null,"店铺素材拍摄、处理，店铺界面排版、详情页设计处理，活动页、海报制做，直通车图、主图优化调整； 要善于积累设计素材、参考别人的视觉作品、快速把握表达要点。",{"$nulls":5},"电商经理、助理、文案"]
[]
["文案",null,"微淘文宣、新品详情页文案、产品卖点提炼、活动主题文宣提炼， 微信微博软文及其他推广\n文宣工作等",{"$nulls":5},"电商总经理、经理、美工"]
[]
["客服",null,"上架详情页的框架素材整理，校对仓库中宝贝信息（准备上架），售前语术准备（快捷语）、在线解答顾客疑问、与仓储协调处理售后事宜，退款统计、提供热销滞销数据。",{"$nulls":5},"电商助理、文案、仓储"]
[]
["仓储",null,"管理仓库进销盘点，货品物料储备安置，统计损耗数据、退货数据，仓储库存预警反应；16：00前订单当天发出，确保24小内发出包裹；出售缺货及时与客服沟通处理…",{"$nulls":5},"电商助理、客服"]