打爆款推广螺旋计划及推广费盈亏测算.xlsx

1、新品螺旋推广打爆螺旋计划盈亏测算周期日期原日销数+计划日销还需完成日销量老客户活动所需总流量数免费流量对冲预估新增免费流量完成销量推广成交量第一周12/1311714337001712/25015353033721312/36931386297342812/481305160011062412/596405680914773312/6100386276618492912/711249639772201138第二周12/8116-14130-23825715012/9139-28167-46928117012/10147-28175-47430618012/11154-66220-1095330

2、20012/12162-58220-96735521012/131703014049537923712/14193-7200-119404240第三周12/151742415036342828012/162081733526664132714612/1722022033823972619412/1823123135603822520712/1924324337383662421912/2025525539163512323212/21289289445133522267第四周12/2220820829763202218612/2325025035713542522512/24272272388

3、83882724512/2528028040074223025112/2628928941264553225712/2729429442054893426012/28350350499952337313第五周12/2925025033335574220812/3030030039996064525412/313273274355655492771/13373374488704532841/23473474621753562901/33533534710802602931/4420420559985164356第六周1/590017153130403849-14-28-28-66-5830-72

4、4173220231243255289208250272280289294350250300327337347353420计计划划日日销销量量12/112/2 12/312/412/5 12/612/712/8 12/9 12/10 12/11 12/12 12/13 12/14 12/15 12/16 12/17 12/18 12/19 12/20 12/21 12/22 12/23 12/24 12/25 12/26 12/27 12/28 12/29 12/30 12/311/11/21/31/4-100 0 100 200 300 400 500 17153130403849-14-2

5、8-28-66-5830-724173220231243255289208250272280289294350250300327337347353420计计划划日日销销量量12/112/2 12/312/412/5 12/612/712/8 12/9 12/10 12/11 12/12 12/13 12/14 12/15 12/16 12/17 12/18 12/19 12/20 12/21 12/22 12/23 12/24 12/25 12/26 12/27 12/28 12/29 12/30 12/311/11/21/31/4-100 0 100 200 300 400 500 总盈亏-

6、40546执行期间实际数据直通车点击量预估每日花费销售额老客户成本推广费缩减产品利润预测盈亏访客数转化率3371214926252191127420513%266958150463017214167218%5551999208368435723265638%49017632430918341234110908%662238228931008459293113627%582209630091116435277719806%757272533561134555330424455%003819234002340186210.69%004582300603006227211%0048373150031

7、5031279%005091396003960306311.30%005346396003960293411%11634856012520426244232668%00636436000360036449.83%0065962700455224548217%2253563379156303346291737536%29857463835504245321846446%3179794787940446934783372843092340469237383566891496740491639984115102881099305586470226565311937305473162321764341

8、1247065671343500700112247071511503585717112622073701993671734112997075892483716743213247077353034476895115746091942432776499611997073132317339361081439708776266837006659156760955628973784681116156098493038386869631663601014131783908703416956010336330247488546201550122863740158918.13128540新品螺旋推广打爆螺旋计

9、划盈亏测算17153130403849-14-28-28-66-5830-724173220231243255289208250272280289294350250300327337347353420计计划划日日销销量量12/112/2 12/312/412/5 12/612/712/8 12/9 12/10 12/11 12/12 12/13 12/14 12/15 12/16 12/17 12/18 12/19 12/20 12/21 12/22 12/23 12/24 12/25 12/26 12/27 12/28 12/29 12/30 12/311/11/21/31/4-100 0

10、100 200 300 400 500 17153130403849-14-28-28-66-5830-724173220231243255289208250272280289294350250300327337347353420计计划划日日销销量量12/112/2 12/312/412/5 12/612/712/8 12/9 12/10 12/11 12/12 12/13 12/14 12/15 12/16 12/17 12/18 12/19 12/20 12/21 12/22 12/23 12/24 12/25 12/26 12/27 12/28 12/29 12/30 12/311/11

11、/21/31/4-100 0 100 200 300 400 500 总买家数买家数件数真实转化率UV价值销售额真实销售额手淘搜索搜索转化率客单价搜索UV价值2814156.8%6.2112726982751.89%4724.45621292.9%2.0915068632478.91%272.443550.9%1.4179415214622.00%184.18635573.2%2.062246138446013.48%263.59236442.6%1.992714162459411.95%273.211957752.9%1.894073247312166.74%302.011956712.3%

12、1.674091216614815.60%311.720474904.0%3.456428187885115.39%304.624578903.4%3.7485393529142213.71%334.63011262024.0%3.66114534628177412.23%344.23641442114.7%4.41135215331194513.21%364.73471271734.3%4.38128584278164515.02%385.82691291633.9%4.23138114561121114.54%639.13601601944.4%4.95181545314126516.44

13、%589.63572073014.3%3.99208619911133110.74%758.02702352596.3%2.52947263227289.75%515.02832833296.1%1.667702770212725.66%301.700.0%0.000.0%0.000.0%0.000.0%0.000.0%0.000.0%0.000.0%0.000.0%0.000.0%0.000.0%0.000.0%0.000.0%0.000.0%0.000.0%0.000.0%0.000.0%0.000.0%0.000.0%0.00017153130403849-14-28-28-66-583

14、0-724173220231243255289208250272280289294350250300327337347353420计计划划日日销销量量12/112/2 12/312/412/5 12/612/712/8 12/9 12/10 12/11 12/12 12/13 12/14 12/15 12/16 12/17 12/18 12/19 12/20 12/21 12/22 12/23 12/24 12/25 12/26 12/27 12/28 12/29 12/30 12/311/11/21/31/4-100 0 100 200 300 400 500 执行期间实际数据1715313

15、0403849-14-28-28-66-5830-724173220231243255289208250272280289294350250300327337347353420计计划划日日销销量量12/112/2 12/312/412/5 12/612/712/8 12/9 12/10 12/11 12/12 12/13 12/14 12/15 12/16 12/17 12/18 12/19 12/20 12/21 12/22 12/23 12/24 12/25 12/26 12/27 12/28 12/29 12/30 12/311/11/21/31/4-100 0 100 200 300

16、400 500 打爆款计划运算设置【红色必填】手淘首页直通车点击量实际推广费情况备注净利润目标实现销量倍数递增0176499-581第一周540改变左边04551800-2101第二周10802.00225800-1427第三周16201.514181350-1621第四周19441.235491800-2309第五周23331.217542300访客数有补流单-2565四周合计销量518476971800-21282-5周合计销量697745671700-275055291600-3316每单都要扣的成本126732000-2254成本运费扣点06702000-2935152.50.50%2

17、7152000-348007122000-2183211143000-3819021696000-2888215094500-129414254500185300000000000000000012/112/312/512/712/912/1112/1312/1512/1712/1912/2112/2312/2512/2712/2912/311/21/40 500 1000 1500 2000 2500 3000 3500 4000 4500 5000 直通车点击量免费流量对冲预估付费PPC转化率客单价单件利润销售额UV价值利润率止亏投产比转化成本3.65.00%3011.4162001.53

18、8%2.647236.00%3314.3356402.043%2.30502.56.50%3819.3615602.551%1.973827.00%4526.3874803.258%1.71291.87.50%4829.31119743.661%1.6424原始日销原始搜索00第一周其他成本老客户成本七天螺旋递增系数可选更快118Day10.40.72Day20.650.78Day30.90.92Day41.051.01Day51.251.15Day61.31.18Day71.451.24总和=77.00第二周到第三周七天螺旋递增系数Day10.75Day20.9Day30.95Day41Da

19、y51.05Day61.1Day71.25总和=77第四周到第五周七天螺旋递增系数Day10.75Day20.9Day30.98Day41.01Day51.04Day61.06Day71.26总和=77打爆款计划运算设置【红色必填】12/112/312/512/712/912/1112/1312/1512/1712/1912/2112/2312/2512/2712/2912/311/21/40 500 1000 1500 2000 2500 3000 3500 4000 4500 5000 直通车点击量免费流量对冲预估每单转化盈亏-61-36-19-25SKU30天销售额占比销量SKU成本26,011.1433%2196013,270.6317%1196010,200.7413%109008,790.0011%79607,600.0010%69604,120.005%49002,528.003%29501,330.002%19501,330.002%19501,330.002%19501,200.002%195010001%190078710.5130天货物成本客单价平均每单成本201601250991.01056030销售量平均每单利润900063259.06720576036001900毛利率95020.7%95095095090062400