{"text_format":"2","workbook":"xlsx","n_sheets":5,"sheets":["预估计划表","活动检查表","客服话术设计","客服话术案例1","物流提醒，客户引导"],"not_rendered":{"charts":0,"images":8,"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":26,"n_cols":12,"rows_kept":26,"cut":false,"hidden":false,"merged":[[0,0,0,11],[3,0,3,11],[4,0,4,1],[4,2,4,3],[5,4,5,11],[25,0,25,3],[6,0,11,0],[12,0,17,0],[18,0,20,0],[21,0,24,0]]}
["量化流量来源预估和销量分解"]
["目标成交额","活动价","客单价","预估备货量","所需UV","预估活动UV","流量缺口","购买转化率","卖出订单数","平均购买件数","流量补缺计划","最总流量缺口"]
[1000000,59,{"$f":"B3*J3","v":118},{"$f":"A3/59","v":16949.1525423729},{"$f":"I3/H3","v":28248.5875706215},20000,{"$f":"E3-F3","v":8248.58757062147},0.3,{"$f":"A3/C3","v":8474.57627118644},2,5000,{"$f":"G3-K3","v":3248.58757062147}]
[]
["来源预估跟销量产出分解评估",null,"预估带来流量值",null,"流量UV总和","平均点击成本","所需花费","转化率","成交人数","人均成交件数","售出数量","成交金额"]
[null,"流量来源入口","预热期间","活动期间","根据行业值"]
["站内付费流量","直通车",200,800,{"$f":"C7+D7","v":1000},3,{"$f":"F7*E7","v":3000},0.05,{"$f":"H7*E7","v":50},3,{"$f":"J7*I7","v":150},{"$f":"B3*K7","v":8850}]
[null,"钻展",500,1000,{"$f":"C8+D8","v":1500},1,{"$f":"F8*E8","v":1500},0.03,{"$f":"H8*E8","v":45},3,{"$f":"J8*I8","v":135},{"$f":"K8*B3","v":7965}]
[null,"淘宝客",500,500,1000,6.8,6800,0.07,70,2,140,{"$f":"K9*B3","v":8260}]
[null,"天猫首焦(或淘金币）",500,1000,1500,1,1500,0.03,45,3,135,{"$f":"K10*B3","v":7965}]
[null,"天猫无线端首焦",500,1000,1500,1,1500,0.03,45,3,135,{"$f":"K11*B3","v":7965}]
[null,"其他",null,null,0,null,0,null,0,null,0,0]
["站外付费流量","返利/导航网站",500,1000,1500,1.8,2700,0.018,27,3,81,{"$f":"K13*B3","v":4779}]
[null,"QQ空间 微博",500,1000,1500,0.8,1200,0.03,45,3,135,{"$f":"K14*B3","v":7965}]
[null,"新浪微博推广",500,1000,1500,0.75,1125,0.03,45,3,135,{"$f":"K15*B3","v":7965}]
[null,"百度竞价",null,null,0,null,0,null,0,null,0,0]
[null,"论坛文字链",null,null,0,null,0,null,0,null,0,0]
[null,"其他",null,null,0,null,0,null,0,null,0,0]
["免费流量","自然搜索",150,350,500,0,0,0.05,25,3,75,{"$f":"K19*B3","v":4425}]
[null,"预热优惠券",1000,1500,2500,5,12500,0.15,375,3,{"$f":"J20*I20","v":1125},{"$f":"K20*B3","v":66375}]
[null,"老客户",500,2000,2500,1.7,4250,0.1,250,3,750,{"$f":"K21*B3","v":44250}]
["活动平台流量","活动平台-首页",2000,3000,5000,0,0,0.3,1500,3,4500,{"$f":"K22*B3","v":265500}]
[null,"活动平台-分类页",3500,5500,9000,0,0,0.3,2700,3,8100,{"$f":"K23*B3","v":477900}]
[null,"活动平台-无线端",800,2500,3300,0,0,0.3,990,3,2970,{"$f":"K24*B3","v":175230}]
[null,"其他"]
["汇总",null,null,null,{"$f":"SUM(E7:E25)","v":33800},null,{"$f":"SUM(G7:G25)","v":36075},null,{"$f":"SUM(I7:I25)","v":6212},null,18566,1095394]

{"sheet":"活动检查表","index":1,"n_rows":40,"n_cols":2,"rows_kept":40,"cut":false,"hidden":false,"merged":[[0,0,6,0],[7,0,13,0],[14,0,25,0],[26,0,27,0],[28,0,30,0],[31,0,33,0],[34,0,36,0],[37,0,39,0]]}
["平台预估","活动平台"]
[null,"活动价格"]
[null,"预估流量"]
[null,"预估销量"]
[null,"预估转化"]
[null,"PC流量"]
[null,"无线流量"]
["平台要求","预存款"]
[null,"保证金"]
[null,"保底费用"]
[null,"技术服务费用"]
[null,"淘宝客设置"]
[null,"上下架通知"]
[null,"活动页面设置"]
["商品准备","主图"]
[null,"直通车图"]
[null,"标题"]
[null,"广告词"]
[null,"SKU图片"]
[null,"SKU价格"]
[null,"SKU库存"]
[null,"SKU命名"]
[null,"仓库对接"]
[null,"ERP对接"]
[null,"是否限购"]
[null,"详情页布局"]
["优化方向","PC端"]
[null,"无线端"]
["营销方案","初始方案"]
[null,"预备方案1"]
[null,"预留方案2"]
["话术准备","初始方案"]
[null,"预留方案1"]
[null,"预留方案2"]
["商品连带","店招广告"]
[null,"套餐搭配"]
[null,"关联商品"]
["最后准备","老客户通知"]
[null,"查看第一评价"]
[null,"预留一定好评"]

{"sheet":"客服话术设计","index":2,"n_rows":23,"n_cols":1,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
["一、产品角度"]
["1.       品牌？"]
["2.       产品的质量？"]
["3.       宝贝的材质？"]
["4.       款式的介绍？"]
["5.       宝贝优势？"]
["二、客户角度"]
["1.       是实拍吗？"]
["2.       存在色差吗？"]
["3.       能给包邮吗？"]
["4.       有赠品吗？"]
["5.       适合多大尺码？"]
["6.       什么时候能发货？"]
["7.       有质量保障吗？"]
["8.       退换货运费谁承担？"]
["三、客服角度"]
["1.       活动的大小？"]
["2.       优惠的力度？"]
["3.       明确的要求？"]
["四、运营角度"]
["1.       活动连带？"]
["2.       优化方向？"]
["3.       时间段的数据？"]

{"sheet":"客服话术案例1","index":3,"n_rows":23,"n_cols":2,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
["一、产品角度","客服话术"]
["1.       品牌？","亲，小天鹅全心全意只做洗衣机，品牌信得过哦，您放心购买。"]
["2.       产品的质量？","亲，小天鹅全心全意37年只做洗衣机，品质信得过哦。"]
["3.       宝贝的材质？","亲，洗衣机外卡是渗锌钢板哦，不会生锈哦"]
["4.       款式的介绍？","亲，三口之家建议，卖7公斤的波轮洗衣机，性价比超高哦。"]
["5.       宝贝优势？","亲，此款小天鹅洗衣机脱水转速高达1200哦，洗衣更洁净。"]
["二、客户角度"]
["1.       是实拍吗？","亲，所有产品都是实体拍摄，没有P过哦"]
["2.       存在色差吗？","亲，洗衣机在厕所里面由于光线问题，机体颜色可能稍微偏暗哦"]
["3.       能给包邮吗？","亲，能拍下就能送，能送就能上门，信我哦"]
["4.       有赠品吗？","亲，小天鹅品牌洗衣机，我们最关注的是您的使用感觉，如果觉得好记得好评哦"]
["5.       适合多大尺码？"]
["6.       什么时候能发货？"]
["7.       有质量保障吗？","亲，小天鹅品牌保证，全国联保，三年整机包修"]
["8.       退换货运费谁承担？","亲，洗衣机由于是物流运输成本较高，天猫规则若无质量问题，退货是要收取相关运费的，请您谅解。"]
["三、客服角度"]
["1.       活动的大小？","亲，本次活动是聚划算，低于平时售价200元哦"]
["2.       优惠的力度？","亲，这几天做活动哦，价格比较优惠，有些地区已经没有货了，喜欢的话就抓紧拍吧。"]
["3.       明确的要求？","亲，您的要求我们反映给我们的售后部门，如有需求一会我们售后人员会联系您的，亲，稍微等待一下。"]
["四、运营角度"]
["1.       活动连带？","高低客单各找一款，做活动备选"]
["2.       优化方向？","无货仓库顾客引导向库存量大的仓库"]
["3.       时间段的数据？","紧盯流量趋势，随时调整引流力度"]

{"sheet":"物流提醒，客户引导","index":4,"n_rows":3,"n_cols":1,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
[]
[]
["(本文出自《义乌普鲁皮具厂2015冬季淘宝分销培训课程》转载请注明出处)\r\n全国运费5.5元 一件代发　　http://pluvip.1688.com\r\n钱包工厂诚招代理 免费装修 / 100%盈利 / 活动报名 / 运营指导 / 提供数据包/图片包/刷单买家秀"]