PC端日期3/13/23/33/43/53/63/73/83/93/103/113/123/133/143/153/163/173/183/193/203/213/223/233/243/253/263/273/283/293/30月总和平均值星期二三四五六日一二三四五六日一二三四五六日一二三四五六日一二三访客数5,4675,9206,3846,5564,3654,9727,6745,8494,5994,3874,2473,0293,1005,7995,3256,0906,0225,8003,7783,62410,1678,98011,86410,4764,4482,9152,7726,2506,281160,8595,745回访客回访率1,1141,1031,2481,3398761,0441,8801,3851,0841,0401,0096786501,4651,2021,2661,2371,1727937211,7711,7121,9581,5951,1756566051,6781,54831,7781,17720.38%18.63%19.55%20.42%20.07%21.00%24.50%23.68%23.57%23.71%23.76%22.38%20.97%25.26%22.57%20.79%20.54%20.21%20.99%19.90%17.42%19.06%16.50%15.23%26.42%22.50%21.83%26.85%24.65%38.62%21.18%跳失率47.10%46.74%48.78%49.02%49.37%49.34%43.47%45.99%47.71%47.34%47.85%50.64%50.42%42.90%45.35%46.88%46.65%47.66%51.72%51.08%50.16%52.24%53.62%54.77%49.39%50.57%51.12%45.57%45.66%48.81%48.81%新下单客老客户占成交用成交老客户数户数比户数件数4727282810119140974731473527575064685144476946195173583529736101,6696229221316105482513220241420644051444822126341976233232066661,0073738.16%44.90%31.71%36.36%50.00%31.21%36.94%34.46%40.51%39.22%33.80%28.57%42.55%52.89%44.44%44.35%39.29%48.48%33.33%20.34%47.73%47.13%33.22%26.38%36.26%39.66%40.82%47.48%51.97%38.62%38.62%7649414420173222148795171494712190115112996659132872922359158491391272,6769923715893123383817194562421622401471254784814073893761781633942659856692881551684333858517315$500,000.00$450,000.00$464,322.41$400,000.00$350,000.00$300,000.00$322,428.57$250,000.00$200,000.00$248$150,000.00$100,000.00$165,378.15$50,000.00$100,386.76$97,399.90$84,155.71$74,578.83$0.00$0.002016/03/012016/03/022016/03/032016/03/042016/03/052016/03/062016/03/072016160,000 140,000 120,000 100,000 80,000 60,000 40,000 20,000 0 105,085 90,652 89,245 88,124 103,28586,486 85,892 2016/03/012016/03/022016/03/032016/03/042016/03/052016/03/062016/03/04.00%3.00%2.00%3.23%2.20%1.06%1.00%0.00%0.72%0.77%0.72%0.64%2016/03/012016/03/022016/03/032016/03/042016/03/052016/03/062016/03/072200.00 150.00 100.00 172.27 156.61 143.45 135.74 134.62 136.97 142.10 50.00 0.00 2016/03/012016/03/022016/03/032016/03/042016/03/052016/03/062016/03/072016年3月XX店铺数据手机端成交金额$13,624.90$8,289.23$5,152.24$6,437.76$1,931.99$19,720.60$34,852.90$22,224.27$11,881.97$8,838.45$12,830.17$8,577.98$7,468.42$22,145.69$19,003.27$18,653.05$20,028.62$18,429.81$10,003.56$8,169.92$22,039.36$14,863.24$43,641.43$30,669.51$16,527.82$9,615.99$8,560.47$23,205.85$18,587.61$465,976.08$15,710.47客单价179.28169.17125.66146.3196.60113.99157.00150.16150.40173.30180.71175.06158.90183.02211.15162.20178.83186.16151.57138.47166.96170.84149.46130.51181.62165.79174.70166.95146.36174.13158.51成交转化率1.39%0.83%0.64%0.67%0.46%3.48%2.89%2.53%1.72%1.16%1.67%1.62%1.52%2.09%1.69%1.89%1.86%1.71%1.75%1.63%1.30%0.97%2.46%2.24%2.05%1.99%1.77%2.22%2.02%1.66%1.73%访客数85,18583,32581,74079,93081,527100,11395,61185,84569,97960,07960,36661,27975,59573,40468,19874,33974,38672,34878,86285,70889,20477,744124,080104,43756,14957,35267,89279,75080,0042,124,67778,692回访客23,21022,73122,49022,07924,01930,10628,44525,75120,80318,92518,42118,80822,05122,49419,73320,87021,73721,71223,61624,83427,62324,32728,17725,99619,70717,69621,82225,45025,028618,18322,896回访率27.25%27.28%27.51%27.62%29.46%30.07%29.75%30.00%29.73%31.50%30.52%30.69%29.17%30.64%28.93%28.07%29.22%30.01%29.95%28.98%30.97%31.29%22.71%24.89%35.10%30.86%32.14%31.91%31.28%29.42%29.42%跳失率48.17%48.30%49.02%48.73%45.90%44.84%45.78%46.34%48.33%46.41%46.87%45.97%44.02%42.06%44.38%44.53%44.71%45.71%43.84%44.08%41.41%44.37%54.99%56.98%45.15%47.99%44.13%42.54%42.80%46.41%46.41%新下单客老客户占老客户数户数比5934234404443832,1661,3741,1445344444874695126066076997247827307687556221,5891,20254750456873073520,1167452911691981321511,0516734972582281972052324323163473363212803064503437454792672252624243559,39134832.92%28.55%31.03%22.92%28.28%32.67%32.88%30.29%32.58%33.93%28.80%30.42%31.18%41.62%34.24%33.17%31.70%29.10%27.72%28.49%37.34%35.54%31.92%28.49%32.80%30.86%31.57%36.74%32.57%31.52%31.52%总成交金额7$248,131.37$196,687.36$185,165.00$1$166,223.20$132,204.69$122,338.58$109,400.38$108,725.34$105,983.152016/03/082016/03/092016/03/102016/03/112016/03/122016/03/132016/03/142016/03/152016/03/1620访客数3,285 91,694 74,578 64,466 64,613 64,308 78,695 79,203 73,5/03/072016/03/082016/03/092016/03/102016/03/112016/03/122016/03/132016/03/142016/0全店转化率1.95%1.17%1.12%1.17%1.12%1.46%1.01%1.38%072016/03/082016/03/092016/03/102016/03/112016/03/122016/03/132016/03/142016/03/15客单价.10 138.70 151.78 146.59 144.90 150.38 154.66 169.70 164.09 03/072016/03/082016/03/092016/03/102016/03/112016/03/122016/03/132016/03/142016/03/1铺数据报表综成交用成交件户数数8845926385765343,2172,0471,6417926726846747441,0389231,0461,0601,1031,0101,0741,2059652,3341,6818147298301,1541,09029,5071,0932,7981,7341,7461,4241,2978,8095,7394,4442,2911,7961,8241,8272,1423,5532,8973,4583,2693,5722,9253,3203,6382,8506,9924,8122,2372,0262,4103,6893,36985,8303179成交金额$151,753.25$92,097.53$92,247.66$77,717.95$72,646.84$444,601.81$287,575.67$225,907.10$120,322.72$97,144.70$96,570.21$100,147.36$114,870.16$174,541.67$147,219.93$166,511.95$159,260.42$171,212.14$150,013.27$167,504.21$195,634.78$153,119.65$325,765.12$220,916.24$120,658.63$111,240.58$130,758.52$195,091.48$174,388.69$4,367,960.07$161,776.30客单价171.67155.57144.59134.93136.04138.20140.49137.66151.92144.56141.18148.59154.40168.15159.50159.19150.25155.22148.53155.96162.35158.67139.57131.42148.23152.59157.54169.06159.99148.03148.03成交转化率1.04%0.71%0.78%0.72%0.65%3.21%2.14%1.91%1.13%1.12%1.13%1.10%0.98%1.41%1.35%1.41%1.42%1.52%1.28%1.25%1.35%1.24%1.88%1.61%1.45%1.27%1.22%1.45%1.36%1.39%1.39%访客数90,65289,24588,12486,48685,892105,085103,28591,69474,57864,46664,61364,30878,69579,20373,52380,42980,40878,14882,64089,33299,37186,724135,944114,91360,59760,26770,66486,00086,2852,279,28684,418回访客回访率24,32423,83423,73823,41824,89531,15030,32527,13621,88719,96519,43019,48622,70123,95920,93522,13622,97422,88424,40925,55529,39426,03930,13527,59120,88218,35222,42727,12826,576649,96124,07326.83%26.71%26.94%27.08%28.98%29.64%29.36%29.59%29.35%30.97%30.07%30.30%28.85%30.25%28.47%27.52%28.57%29.28%29.54%28.61%29.58%30.03%22.17%24.01%34.46%30.45%31.74%31.54%30.80%28.86%28.86%全店转老访客化率数1.06%0.72%0.77%0.72%0.64%3.23%2.20%1.95%1.17%1.12%1.17%1.12%1.01%1.46%1.38%1.44%1.46%1.54%1.30%1.27%1.35%1.21%1.93%1.67%1.49%1.31%1.24%1.50%1.41%1.41%1.41%3201912111481611,10575554829024822121925249635639838036930231851338484254130024828249042110,3980.62%交金额$369,406.55$251,585.75$217,674.14$189,641.95.00$179,289.04$175,674.13$167,982.89$160,016.83$137,186.4/162016/03/172016/03/182016/03/192016/03/202016/03/212016/03/222016/03/232016/03/242016/03/21389,332 99,371 73,523 80,429 80,408 78,148 82,640 86,724 016/03/152016/03/162016/03/172016/03/182016/03/192016/03/202016/03/212016/03/22201转化率1.93%1.44%1.46%1.54%1.30%1.27%1.35%1.21%/152016/03/162016/03/172016/03/182016/03/192016/03/202016/03/212016/03/222016/03/234.09 159.49 152.98 157.77 148.71 155.05 162.81 159.68 140.6/03/152016/03/162016/03/172016/03/182016/03/192016/03/202016/03/212016/03/222016/03责任人综合老访客数占成交件成交用客单价比数户数33.33%29.80%31.08%23.87%29.06%32.60%33.27%30.63%33.30%34.30%29.27%30.29%31.86%42.80%35.14%34.28%32.42%30.70%28.07%28.07%38.37%36.50%32.06%28.24%33.15%31.51%32.08%37.90%34.59%32.28%32.36%3,0351,8921,8391,5471,3359,1906,4584,9002,5331,9582,0641,9742,2674,0313,3783,8653,6583,9483,1033,4834,0323,1157,9775,4812,5252,1812,5784,1223,75494,3473,4949606416796205543,3902,2691,7898717237557237911,1591,0131,1611,1721,2021,0761,1331,3371,0522,6261,9169057878791,2931,21732,1831,192172.27156.61143.45135.74134.62136.97142.10138.70151.78146.59144.90150.38154.66169.70164.09159.49152.98157.77148.71155.05162.81159.68140.67131.31151.59153.57158.50168.83158.57148.90148.90付费总成交金额$165,378.15$100,386.76$97,399.90$84,155.71$74,578.83$464,322.41$322,428.57$248,131.37$132,204.69$105,983.15$109,400.38$108,725.34$122,338.58$196,687.36$166,223.20$185,165.00$179,289.04$189,641.95$160,016.83$175,674.13$217,674.14$167,982.89$369,406.55$251,585.75$137,186.45$120,856.57$139,318.99$218,297.33$192,976.30$4,792,142.69$177,486.770.000.000.00#DIV/0!#DIV/0!直通车淘客小计投入产出比#DIV/0!#DIV/0!#DIV/0!总成交金额$218,297.33$192,976.30$139,318.99186.45$120,856.57/03/252016/03/262016/03/272016/03/282016/03/292016/03/30135,944 114,913 70,664 访客数60,597 60,267 2016/03/232016/03/242016/03/252016/03/262016/03/271.67%1.49%1.31%1.24%全店转化率/232016/03/242016/03/252016/03/262016/03/27140.67 131.31 151.59 153.57 158.50 客单价16/03/232016/03/242016/03/252016/03/262016/03/27