{"text_format":"2","workbook":"xlsx","n_sheets":3,"sheets":["月计划表","第一周计划","第二周计划"],"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":36,"n_cols":25,"rows_kept":36,"cut":false,"hidden":false,"merged":[[0,0,0,23],[1,3,1,15],[1,17,1,20],[1,21,1,24],[5,5,35,5],[3,6,4,6],[5,6,6,6],[3,16,5,16],[6,16,10,16],[11,16,14,16],[15,16,17,16],[3,17,8,17],[10,17,15,17],[4,18,16,18],[23,20,27,20],[30,20,34,20],[15,22,30,22],[3,23,5,23],[8,23,9,23],[30,23,33,23]]}
["babysafe30天工作流程表"]
["日期",null,null,"推广/运营",{"$nulls":13},"美工",null,null,null,"客服"]
[null,"自定义","自定义","竞争分析","确定销售目标/销量预估","新品每天数据监控（必须完成）","自然流量","直通车","钻展","淘宝客","官方活动","第三方平台","店内活动","关联搭配","老客户营销","其他（SNS/呵呵）","文案","前期准备","上架时间","首页/专题页/详情页制作","推广素材制作","客户反馈采集","店铺活动配合通知","同行购物体验分析/调查表填写","防撞条推介统计"]
["2015-09-07",null,null,null,12,null,"宝贝标题优化","添加关键词。推广标题优化（老板说暂时养2个词）","美工，钻展素材收集（长期）","佣金调整","试用防撞条     （聚划算防撞条、防撞角）","51返利网（老板未定日期）","满160用5块优惠劵…..","买护栏送防撞条",null,"朋友圈9.9三条包邮（补单方案）","防撞条详情文案","搜集同行详情页和活动页面","制定新品上新计划","制定详情页","钻展素材制作上传",null,null,"购买同行产品","个"]
["2015-09-08",null,null,null,14,"关键词流量占比关键词排名",null,"创意图点击率优化","钻展投放测试（老板说暂时不投放）","如意投，设置到第一页","免费试用",null,null,null,"微信群发\n短信通知\nGMR软件通知\n公众号发朋友圈免费领\n",null,null,null,"每天上一款防撞条（不同主图，详情，主图颜色具体文件）",null,"直通车创意图制作","新品客户反馈给运营美工产品有销售问题",null,null,"个"]
["2015-09-09",null,null,null,17,"关键词流量占比关键词排名","所有热词配件标题优化",null,"每天监控点击率",{"$nulls":15},"个"]
["2015-09-10",null,null,null,21,null,null,null,"监控点击率",{"$nulls":7},"防撞条详情文案",{"$nulls":7},"个"]
["2015-09-11",null,null,null,25,null,"新品关键词优化",null,"监控点击率",{"$nulls":11},"钻展图",null,null,null,"个"]
["2015-09-12",null,null,null,30,null,"新品关键词优化",{"$nulls":16},"同行调查表登记","个"]
["2015-09-13",null,null,null,36,{"$nulls":19},"个"]
["2015-09-14","周会",null,"重新修正销量和竞争对手",21,null,"新品关键词优化",null,"钻展优化（推广页面调试反馈给美工）",{"$nulls":5},"测试效果",{"$nulls":4},"调试率分析首页/专题/钻展页面优化","钻展图",null,null,null,"个"]
["2015-09-15",null,null,null,25,{"$nulls":6},"51返利正式上线（为期7天）第一天防撞条上线",null,null,"微信群发\n短信通知\nGMR软件通知",null,"防撞角详情文案",{"$nulls":7},"个"]
["2015-09-16",null,null,null,30,null,"新品关键词优化",{"$nulls":13},"直通车创意图制作",null,null,null,"个"]
["2015-09-17",null,null,null,36,null,"新品关键词优化",{"$nulls":17},"个"]
["2015-09-18",null,null,null,43,null,"新品关键词优化",{"$nulls":17},"个"]
["2015-09-19",null,null,null,52,null,"新品关键词优化","优化关键词和质量得分，投放平台，投放地域",null,"淘客佣金调整",{"$nulls":6},"门栏详情文案",{"$nulls":5},"店内活动通知在线咨询客户",null,"个"]
["2015-09-20",null,null,null,57,{"$nulls":19},"个"]
["2015-09-21","周会",null,"重新修正销量和竞争对手",36,null,null,"加词控制付费流量占30%",{"$nulls":4},"开会定下中秋店内活动优惠",null,"微信老客户通知免费领取防撞条活动",null,null,null,"观察每个宝贝的自然流量变化","中秋节活动页面",null,null,null,"通知客户店铺中秋活动","个"]
["2015-09-22",null,null,null,41,null,"关键词优化",{"$nulls":5},"中秋活动开始",{"$nulls":7},"钻展图",null,null,null,"个"]
["2015-09-23",null,null,null,47,null,"新品关键词优化",null,"增加投放资源位",{"$nulls":8},"竞争对手店铺分析",{"$nulls":6},"个"]
["2015-09-24",null,null,null,54,null,"新品关键词优化","点击率优化",{"$nulls":16},"个"]
["2015-09-25",null,null,null,63,null,"新品关键词优化",null,null,"优化通投跟如意投",{"$nulls":9},"调试率分析首页/专题/钻展页面优化","直通车创意图","新品客户反馈",null,null,"个"]
["2015-09-26",null,null,null,72,{"$nulls":19},"个"]
["2015-09-27",null,null,null,83,{"$nulls":15},"钻展素材制作",null,null,null,"个"]
["2015-09-28","周会",null,"重新修正销量和竞争对手",54,null,null,"优化关键词和质量得分，投放平台，投放地域",{"$nulls":6},"微信老客户通知免费领取防撞条活动",{"$nulls":4},"详情页制作",{"$nulls":4},"个"]
["2015-09-29",null,null,null,63,null,null,null,"钻展优化",{"$nulls":15},"个"]
["2015-09-30",null,null,null,72,{"$nulls":19},"个"]
["2015-10-01",null,null,null,83,{"$nulls":19},"个"]
["2015-10-02",null,null,null,95,{"$nulls":19},"个"]
["2015-10-03",null,null,null,110,{"$nulls":16},"新品客户反馈给美工",null,null,"个"]
["2015-10-04","周会",null,"重新修正销量和竞争对手",132,null,null,"关键词优化",{"$nulls":11},"页面优化","钻展素材制作",null,null,"新竞争对手店铺商品购买","个"]
[{"$nulls":4},1424,{"$nulls":19},"个"]
["2015-10-05",null,null,null,83,null,null,null,"增加投放人群",{"$nulls":15},"个"]
["2015-10-06",null,null,null,95,{"$nulls":19},"个"]
["2015-10-07",null,null,null,110,{"$nulls":19},"个"]
["总销量",null,null,null,{"$f":"E32+288","v":1712},null,"根据销量选择重点关键词","关键词优化","钻展优化",{"$nulls":11},"直通车创意图",null,null,null,"个"]

{"sheet":"第一周计划","index":1,"n_rows":35,"n_cols":27,"rows_kept":35,"cut":false,"hidden":false,"merged":[[0,0,0,25],[1,2,1,17],[1,19,1,22],[1,23,1,26],[3,18,4,18],[5,18,9,18],[10,18,13,18],[14,18,16,18],[3,19,7,19],[9,19,14,19],[3,20,15,20],[22,22,26,22],[29,22,33,22],[14,24,29,24],[3,25,4,25],[7,25,8,25],[29,25,32,25]]}
["babysafe7天工作流程表"]
["日期",null,"推广/运营",{"$nulls":16},"美工",null,null,null,"客服"]
[null,"查看叶子行业走势","竞争分析","预期销量达标数","确定销售目标/销量预估","新品每天数据监控","自然流量","直通车","钻展","淘宝客","官方活动","免费使用"," 站外活动","店内活动","活动KPI跟踪（监督售前售后客服）","关联搭配","老客户营销","防撞条客服推介（每天统计件数）","文案","前期准备","上架时间","首页/专题页/详情页制作","推广素材制作","客户反馈采集","店铺活动配合通知","同行购物体验分析/调查表填写","防撞条推介统计"]
["2015-09-08",null,null,null,14,"监控每天流量入口占比","每天上新标题优化","晚上养词   补转化   ","钻展3张","淘宝客调佣金",{"$nulls":5},"爆款防撞条（到本店消费者加1块即可获得防撞条1条）","微信群发\nGMR软件通知\n微信朋友圈散播\n","因有些不算销量没有记录件",null,null,"每天上一款防撞条（不同主图，详情，主图颜色具体文件）",null,"直通车创意图制作","新品客户反馈给运营美工产品有销售问题","到本店消费者加1块即可获得防撞条1条",null,"个"]
["2015-09-09",null,null,null,17,"监控每天流量入口占比","每天上新标题优化",null,"钻展文案",{"$nulls":6},"所有宝贝销量关联上爆款链接，测试内页跳转峰值",null,"件（记录每天客服最多能推介多小条，做好预算防止活动后销量承接）",{"$nulls":6},"配合测试，权利推介防撞条看每天能带来多小销量",null,"个"]
["2015-09-10",null,null,null,21,"监控每天流量入口占比","全店标题铺关键词排名跟踪记录产品流入口是否有变化",null,"钻展文案",{"$nulls":8},"件","防撞条详情文案",{"$nulls":7},"个"]
["2015-09-11",null,null,null,25,"监控每天流量入口占比","关键词排名跟踪记录产品流入口是否有变化",null,"钻展1张",{"$nulls":6},"测试流量增加多小转化多小跟客服协调推介力度，防止销量超过计划","测试效果","件",{"$nulls":4},"钻展图",null,null,null,"个"]
["2015-09-12",null,null,null,30,"监控每天流量入口占比","关键词排名跟踪记录产品流入口是否有变化","增加关键词","钻展文案","查看淘宝客效果做调整（佣金行业2陪看能带来销量效果）",{"$nulls":5},"站外活动前设置好低单价的配件关联",null,"件",{"$nulls":7},"同行调查表登记","个"]
["2015-09-13",null,null,null,36,"监控每天流量入口占比","关键词排名跟踪记录产品流入口是否有变化",null,"钻展文案",{"$nulls":8},"件",null,"钻展收集输出每天2张",{"$nulls":6},"个"]
[{"$nulls":21},"调试率分析首页/专题/钻展页面优化","钻展图",null,null,null,"个"]
[{"$nulls":18},"防撞角详情文案",{"$nulls":7},"个"]
[{"$nulls":22},"直通车创意图制作",null,null,null,"个"]
[{"$nulls":26},"个"]
[{"$nulls":26},"个"]
[{"$nulls":18},"门栏详情文案",{"$nulls":5},"店内活动通知在线咨询客户",null,"个"]
[{"$nulls":26},"个"]
[{"$nulls":20},"观察每个宝贝的自然流量变化",{"$nulls":5},"个"]
[{"$nulls":22},"钻展图",null,null,null,"个"]
[{"$nulls":19},"竞争对手店铺分析",{"$nulls":6},"个"]
[{"$nulls":26},"个"]
[{"$nulls":21},"调试率分析首页/专题/钻展页面优化","直通车创意图","新品客户反馈",null,null,"个"]
[{"$nulls":26},"个"]
[{"$nulls":22},"钻展素材制作",null,null,null,"个"]
[{"$nulls":21},"详情页制作",{"$nulls":4},"个"]
[{"$nulls":26},"个"]
[{"$nulls":26},"个"]
[{"$nulls":26},"个"]
[{"$nulls":26},"个"]
[{"$nulls":23},"新品客户反馈给美工",null,null,"个"]
[{"$nulls":21},"页面优化","钻展素材制作",null,null,"新竞争对手店铺商品购买","个"]
[{"$nulls":26},"个"]
[{"$nulls":26},"个"]
[{"$nulls":26},"个"]
[{"$nulls":26},"个"]
[{"$nulls":22},"直通车创意图",null,null,null,"个"]

{"sheet":"第二周计划","index":2,"n_rows":10,"n_cols":28,"rows_kept":10,"cut":false,"hidden":false,"merged":[[0,0,0,26],[1,2,1,18],[1,20,1,23],[1,24,1,27],[5,19,9,19],[7,26,8,26]]}
["babysafe7天工作流程表"]
["日期",null,"推广/运营",{"$nulls":17},"美工",null,null,null,"客服"]
[null,"查看叶子行业走势","竞争分析","预期销量达标数","确定销售目标/销量预估","爆款每天数据监控","自然流量","直通车","钻展","淘宝客","官方活动","免费使用"," 站外活动","店内活动","活动KPI跟踪（监督售前售后客服）","新上宝贝","关联搭配","老客户营销","防撞条客服推介（每天统计件数）","文案","前期准备","上架时间","首页/专题页/详情页制作","推广素材制作","客户反馈采集","店铺活动配合通知","同行购物体验分析/调查表填写","防撞条推介统计"]
["2015-09-14",null,null,null,21,"监控每天流量入口占比","查看成交关键词、搜索关键词","直通车继续养计划 （上周直通车销量转化统计） ","钻展文案","上周淘客销量统计","通知可报名活动（聚划算报名新品防撞条）","新品试用循环",null,null,"统计售前售后KPI（可解决却未解决问题）","上周的链接每天冲3单进去，监控店铺动销率防止下滑","关联销售搭配效果统计（不行开始换低价配搭）","上周成功呼唤老顾客统计","上周客户推介爆款统计",null,"中秋活动页面制作、活动寻宝图",null,"51返利活动制作（运营提供51文案素材）当天上架、首页图上线","钻展素材5张（运营提供资源文件）","爆款客户不成交问题有哪些",null,"不成交问题统计后，去妙心、棒棒猪哪里装客人反问他们。总结别人回答的问题","个"]
["2015-09-15",null,null,null,25,"监控每天流量入口占比",null,null,"钻展文案","招募淘宝准备21号继续推送爆款防撞条",null,null,"51返利活动开场",null,"采集一年的数据数据含，报名时间         品牌，    报名价格，报名数量，报名货值，报名什么团报名规格，报名产出，报名售磬率",{"$nulls":4},"活动寻宝图（文案）",null,null,"根据新文案制作爆款详情","车图素材5张（随便逛，主要要有创意）",null,null,null,"个"]
["2015-09-16",null,null,null,30,"监控每天流量入口占比","51第一天后流量排名情况",null,"钻展文案",{"$nulls":13},"钻展车图每天各2张","钻展素材5张",null,null,null,"个"]
["2015-09-17",null,null,null,36,"监控每天流量入口占比",null,null,"钻展1张",{"$nulls":4},"中秋活动文案（布置）",{"$nulls":8},"无线端首页装修","直通车素材5张",null,null,null,"个"]
["2015-09-18",null,null,null,43,"监控每天流量入口占比",{"$nulls":16},"钻展车图每天各2张","钻展素材5张",null,null,null,"个"]
["2015-09-19",null,null,null,52,"监控每天流量入口占比",null,null,"21号51完结，确定钻展开通时间",{"$nulls":4},"中秋活动页面上线",{"$nulls":6},"中秋活动页面、活动寻宝图上线","替换爆款详情","钻展车图每天各2张","直通车素材5张",null,"通知新老客户中秋节活动开始",null,"个"]
["2015-09-20",null,null,null,57,"监控每天流量入口占比","成交于搜索关键词统计（准备下星期一关键词优化）","加直通车词表的词，根据标题主打关键词推广推到第一",{"$nulls":19},"个"]