运营 1-电商常用表格 2.0年度规划表4.0版本

cccc旗舰店，目标1000万，100万直通车费用，保底1000万，冲1500万,,,,,,,,,,

,,,,,,,,,,,

月份,当月目标营业额,每日销售额,当月销售额年度占比,直通车预算比例,直通车投入,客单价,订单数,,,

201601,300000,10000,3.00%,10.00%,30000,85,3529,,,

201602,100000,3448,1.00%,10.00%,10000,85,1176,,,

201603,800000,26667,8.00%,10.00%,80000,85,9412,,,

201604,800000,26667,8.00%,10.00%,80000,85,9412,,,

201605,600000,20000,6.00%,10.00%,60000,85,7059,,,

201606,500000,16667,5.00%,10.00%,50000,85,5882,,,

201607,500000,16667,5.00%,10.00%,50000,85,5882,,,

201608,500000,16667,5.00%,10.00%,50000,85,5882,,,

201609,800000,26667,8.00%,10.00%,80000,85,9412,,,

201610,1000000,33333,10.00%,10.00%,100000,85,11765,,,

201611,3000000,100000,30.00%,10.00%,300000,85,35294,,,

201612,1100000,36667,11.00%,10.00%,110000,85,12941,,,

小计,10000000,,100.00%,,1000000.00,1020,,,,

,,,,,,,,,,,

营销节点,销售额,占比,,,,,,,,

双11,2000000,20.00%,,,,,,,,

双12,300000,3.00%,,,,,,,,

品类拆分,,,,,,,,,,

,,,,,,,,,,,

月度计划,,品类占比,,,品类销售拆分（销售额，单位元）,,,上新计划（单位：款）,,

月份,月度销售额,连衣裙,套装,半身裙,连衣裙,套装,半身裙,连衣裙,套装,半身裙

201601,300000,10%,0,90%,30000,0,270000,30,5,0

201602,100000,100%,0,0,100000,0,0,0,0,0

201603,800000,90%,10%,0,720000,80000,0,10,3,5

201604,800000,80%,20%,0,640000,160000,0,10,5,3

201605,600000,60%,40%,0,360000,240000,0,10,5,5

201606,500000,60%,40%,0,300000,200000,0,5,5,3

201607,500000,60%,30%,10%,300000,150000,50000,5,5,3

201608,500000,60%,10%,30%,300000,50000,150000,5,5,3

201609,800000,90%,0,10%,720000,0,80000,40,0,5

201610,1000000,80%,0,20%,800000,0,200000,20,0,10

201611,3000000,80%,0,20%,2400000,0,600000,5,0,0

201612,1100000,80%,0,20%,880000,0,220000,0,0,0

小计,10000000,,,,0,,,140,33,37

价格走势,,,,,,,,,,

属性,,,价格区间,,,,,,,

,,,0-49,50-79,80-99,109-159,159+,,,

,分类,材质,,活动款,常销款/畅销款,利润款/形象款,,,,

,,,,活动价格,日销价格,上新价,,,,

女裤,连衣裙,雪纺,,,,,,,,

,,蕾丝,,,,,,,,

,,针织,,,,,,,,

,套装,针织,,