{"text_format":"2","workbook":"xlsx","n_sheets":1,"sheets":["直通车预算及跟踪"],"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":24,"n_cols":40,"rows_kept":24,"cut":false,"hidden":false,"merged":[[0,32,0,39],[0,1,0,2],[0,3,0,4],[0,5,0,6],[0,8,0,15],[0,16,0,23],[0,24,0,31]]}
["项目解释","销量固定",null,"ROI固定",null,"费用固定",null,null,"第一周",{"$nulls":7},"第二周",{"$nulls":7},"第三周",{"$nulls":7},"第四周"]
[null,"目标销量","宝贝一","参数 ","宝贝一","参数 ","宝贝一",null,null,"2013-08-01","2013-08-02","2013-08-03","2013-08-04","2013-08-05","2013-08-06","2013-08-07",null,"2013-08-08","2013-08-09","2013-08-10","2013-08-11","2013-08-12","2013-08-13","2013-08-14",null,"2013-08-15","2013-08-16","2013-08-17","2013-08-18","2013-08-19","2013-08-20","2013-08-21",null,"2013-08-21","2013-08-22","2013-08-23","2013-08-24","2013-08-25","2013-08-26","2013-08-27"]
[null,"直通车客单价（元）",58,"直通车客单价（元）",58,"直通车客单价（元）",58,null,"需要成交量",{"$nulls":7},"需要成交量",{"$nulls":7},"需要成交量",{"$nulls":7},"需要成交量"]
[null,"产品成本（元）",30,"产品成本（元）",30,"产品成本（元）",30,null,"昨日成交量",{"$nulls":7},"昨日成交量",{"$nulls":7},"昨日成交量",{"$nulls":7},"昨日成交量"]
["去掉邮费礼物杂费","产品利润率/纯",{"$f":"(C3-C4-7.5-1.5)/C3","v":0.32758620689655171},"产品利润率",{"$f":"(E3-E4-7.5-1.5)/E3","v":0.32758620689655171},"产品利润率",{"$f":"(G3-G4-7.5-1.5)/G3","v":0.32758620689655171},null,"点击费用PPC",{"$nulls":7},"点击费用PPC",{"$nulls":7},"点击费用PPC",{"$nulls":7},"点击费用PPC"]
[null,"每流量费用PPC（元）",1.28,"每流量费用PPC（元）",1.28,"每流量费用PPC（元）",1.28,null,"直通车日花费",{"$nulls":7},"直通车日花费",{"$nulls":7},"直通车日花费",{"$nulls":7},"直通车日花费"]
[null,"市场转化率（魔方）",2.8799999999999999E-2,"市场转化率（魔方）",2.8799999999999999E-2,"市场转化率（魔方）",2.8799999999999999E-2,null,"直通成交金额",{"$nulls":7},"直通成交金额",{"$nulls":7},"直通成交金额",{"$nulls":7},"直通成交金额"]
["首选参考","直通车转化率",2.5000000000000001E-2,"直通车转化率",4.58E-2,"直通车转化率",2.58E-2,null,"当日成交转化率",{"$nulls":7},"当日成交转化率",{"$nulls":7},"当日成交转化率",{"$nulls":7},"当日成交转化率"]
[null,"总销量笔数",1600,"总销量笔数",1600,"总销量笔数",{"$f":"G8*G16/G6","v":907.03125},null,"当日直通车收藏",{"$nulls":7},"当日直通车收藏",{"$nulls":7},"当日直通车收藏",{"$nulls":7},"当日直通车收藏"]
[null,"推广周期（天）",30,"运作周期（天）",30,"运作周期（天）",30,null,"主图点击率/%",{"$nulls":7},"主图点击率/%",{"$nulls":7},"主图点击率/%",{"$nulls":7},"主图点击率/%"]
[null,"需要流量UV",{"$f":"C9/C8","v":64000},"总共获取流量UV",{"$f":"E9/E8","v":34934.497816593888},"总共获取流量UV",{"$f":"G9/G8","v":35156.25}]
[null,"日均流量UV",{"$f":"C11/30","v":2133.3333333333335},"日均流量UV",{"$f":"E11*30","v":1048034.9344978166},"日均流量UV",{"$f":"G11/30","v":1171.875}]
[null,"日均车费（元）",{"$f":"C12*C6","v":2730.666666666667},"日均车费（元）",{"$f":"E12*E6","v":1341484.7161572052},"日均车费（元）",{"$f":"G16/30","v":1500}]
[null,"日均销量",{"$f":"C9/30","v":53.333333333333336},"日均销量",{"$f":"E9/30","v":53.333333333333336},"日均销量",{"$f":"G9/30","v":30.234375},null,"汇总","2013-08-01","2013-08-02","2013-08-03","2013-08-04","2013-08-05","2013-08-06","2013-08-07","2013-08-08","2013-08-09","2013-08-10","2013-08-11","2013-08-12","2013-08-13","2013-08-14","2013-08-15","2013-08-16","2013-08-17","2013-08-18","2013-08-19","2013-08-20","2013-08-21","2013-08-22","2013-08-23","2013-08-24","2013-08-25","2013-08-26","2013-08-27","2013-08-28","2013-08-29","2013-08-30","2013-08-31"]
[null,"转化成本（订单成本）",{"$f":"C6/C7","v":44.44444444444445},"转化成本（订单成本）",{"$f":"E6/E7","v":44.44444444444445},"转化成本（订单成本）",{"$f":"G6/G8","v":49.612403100775197},null,"需要成交量"]
[null,"直通车推广投入（元）",{"$f":"C11*C6","v":81920},"直通车推广投入（元）",{"$f":"E11*E6","v":44716.157205240175},"直通车推广投入（元）",45000,null,"昨日成交量"]
[null,"总投入（元）",{"$f":"C4*C9+C16","v":129920},"总投入（元）",{"$f":"E4*E9+E16","v":92716.157205240175},"总投入（元）",{"$f":"G4*G9+G16","v":72210.9375},null,"点击费用PPC"]
[null,"总销量（元）",{"$f":"C3*C9","v":92800},"总销量（元）",{"$f":"E3*E9","v":92800},"总销量（元）",{"$f":"G3*G9","v":52607.8125},null,"直通车日花费"]
[null,"毛利润（元）",{"$f":"C3*C5*C9","v":30400},"毛利润（元）",{"$f":"E3*E5*E9","v":30400},"毛利润（元）",{"$f":"G3*G5*G9","v":17233.59375},null,"直通成交金额"]
[null,"纯利润（元）",{"$f":"C18-C4*C9-C16","v":-37120},"纯利润（元）",{"$f":"E18-C4*E9-E16","v":83.842794759824756},"纯利润（元）",{"$f":"G18-G4*G9-G16","v":-19603.125},null,"当日成交转化率"]
[null,"投入产出比ROI",{"$f":"C18/C16","v":1.1328125},"投入产出比ROI",{"$f":"E18/E16","v":2.0753124999999999},"投入产出比ROI",{"$f":"G18/G16","v":1.1690624999999999},null,"当日直通车收藏"]
["流量价值=利润/流量","流量价值（元）",{"$f":"C6/C8","v":51.199999999999996},"流量价值",{"$f":"E6/E8","v":27.94759825327511},"流量价值",{"$f":"G6/G8","v":49.612403100775197},null,"主图点击率/%"]
[]
["黄色背景部分预先填入，即可得到下面的所有数据 未考虑的情况：1、直通车带来的关联销售、二次销售、购买多件 包括自然流量成交。",{"$nulls":7},"以上均可根据自己每日需求进行一份拟定 调整整条直通车策略 包括自己的玩法 做好每一步细节 能够更清晰的看清现在直通车处境状况"]