电商运营销售数据分析表

Statistics of e-commerce sales data,序号商品名称商品类别商品编号商品规格单位销量单价销售额日期门店渠道备注辅助列,A商品SP021401XXL337.032.256176747710870.331564,SP021402M138.018.59585281812566.2276889,化妆品类SP021403431.036.539081998215748.3443412,D商品化妆品类SP021404380.06.219526602712363.42010903门店十,SP021405米413.00.740542348615305.843989978,SP021406Kg269.08.798840554962366.8881092843871.0,SP021407373.07.56106927312820.2788388743871.0,SP021408498.025.217173528312558.152417143872.0,SP021409121.010.71143911941296.0841334543872.0,SP02141048.026.91121209581291.738180643901.0,SP021411165.033.62715881555548.48120456,SP02141289.044.12173972313926.83483536,13.0SP02141322.042.6861181887939.09460015,14.0D商品SP021414479.023.297890812811159.6896993,15.0SP021415153.030.2749181814632.062481743933.0渠道5,16.0SP021416154.06.34333423413976.873472057,17.0SP021417463.045.047977642220857.2136483,18.0SP02141839.030.69639388221197.15936141,19.0SP02141918.030.206859311543.723467598,20.0SP02142041.85763733891297.5867575,21.0SP021421469.030.307378298314214.1604219,22.0SP021422236.032.84472826367751.35587022,23.0SP021423261.042.815066662611174.7323989,24.0SP021424347.04.059030545261408.4835992,25.0SP021425171.034.87599222675963.79467077,26.0SP021426163.016.06868925982619.19634934,27.0SP02142732.029.6386094153948.43550129,28.0SP021428116.034.01424326043945.6522182,29.0SP021429433.049.757787578121545.1220213,30.0SP02143062.035.37998762822193.5592329544026.0,SP02143121.043.7049470116917.80388724344027.0,32.0SP021432266.029.07811153237734.7776675844029.0,33.0SP021433363.07.234933651552626.2809155144029.0,34.0SP021434432.027.057601708811688.8839382,35.0SP021435178.048.21300383548581.91468271,36.0SP021436198.013.07667115442589.18088856,37.0SP021437319.038.951870962412425.646837,38.0SP021438102.010.96962812521118.90206877渠道8,39.0SP021439463.01.25434039355580.759602214,40.0SP021440355.037.678492698613375.864908,41.0SP02144131.3902757544973.098548386,42.0SP02144224.0953025441144.571815265,43.0SP021443132.047.2503784586237.04995646,44.0SP021444457.043.942494972820081.7202026,45.0SP02144549.04.1842616361205.028820169,46.0SP02144651.045.72606269262332.02919732,47.0SP021447102.029.90638286093050.4510518144153.0,48.0SP021448270.011.07840108492991.1682929244153.0,49.0SP02144968.016.74381841931138.5796525144183.0,50.0SP021450417.049.84311718820784.579867444183.0门店十, Statistics of e-commerce sales data,月份1.02.03.04.05.06.07.08.09.010.011.012.0合计,销量目标981.0787.0663.0509.01072.01052.0716.01104.0935.0965.01033.01152.010969.0,销量完成1699.01261.0803.0827.01344.0915.0712.01127.0957.0689.0372.0485.011191.0,销量完成率1.731906218141.602287166451.211161387631.624754420431.253731343280.8697718631180.9944134078211.020833333331.023529411760.7139896373060.3601161665050.4210069444441.02023885495,金额目标33688.024374.023931.027892.029958.036401.016778.021723.021168.024395.024193.012774.0297275.0,金额完成31854.167693119041.403498722865.8385228207.032431135846.319047735022.200760913472.421703335285.626346516193.196942628855.82817656041.6193447221923.1595199294608.813985,金额完成率0.9455642274130.7812178345240.9554903062971.011294723621.196552475060.9621219406320.8029813865351.624344075240.7649847384091.182858297870.2497259267031.716232935640.991031247111, Statistics of e-commerce sales data,开始日期截至日期,43831.044195.011191.0294608.813985,门店一门店二门店三门店四门店五门店六门店七门店八门店九门店十,894.01631.01373.01425.01171.01387.0524.01428.0561.0797.0,28122.961572445605.001829832597.239253637098.142295820641.324231940192.066990320730.585228137997.2094768476.2831306823147.9999764,电器类化妆品类家居类食品类类别5类别6类别7类别8类别9类别10,2028.0811.01888.0510.0942.0732.01082.01260.0524.01414.0,31487.722608118111.764450261652.95170810052.271590821166.207018232559.603809122967.746408525296.404079320730.585228150583.5570847,手机端网页端Pad端电视端渠道3渠道4渠道5渠道6渠道7渠道8,1159.03095.01106.0836.01207.01638.0153.0639.01256.0102.0,35134.632801759165.067679443389.8136848679.4925320215056.273092958671.33712564632.062481722900.03299245861.1995271118.90206877,商品类别单位门店渠道,电器类个门店一手机端,化妆品类只门店二网页端,家居类箱门店三Pad端,食品类提门店四电视端,类别5米门店五渠道3,类别6Kg门店六渠道4,类别7门店七渠道5,类别8门店八渠道6,类别9门店九渠道7,类别10门店十渠道8