电商销售数据可视化分析报表模板.xlsx

《电商销售数据可视化分析报表模板.xlsx》由会员分享，可在线阅读，更多相关《电商销售数据可视化分析报表模板.xlsx（42页珍藏版）》请在淘文阁 - 分享文档赚钱的网站上搜索。

1、天舒可视化数据大屏运营报表时间参数20202020202120211 11010111112122 23 34 45 56 67 78 89 91 1.2 2.3 3.4 45 56 67 78 89 9数据源统计周期销售金额010000200003000040000500006000070000800009000000.0020.0040.0060.0080.010.0120.0140.0160.0180.02销售金额转化率访客量0100020003000400050006000700080009000支付买家数020406080100120140160转化率00.0020.0040.006

2、0.0080.010.0120.0140.0160.0180.02数据分析当前活动转转化化率率支支付付.销销售售.退退款款率率退退款款.推推广广.推推广广.推推广广.推推广广.推推广广.收收藏藏例例(直直.客客单单价价加加购购UVUV444794448044481444824448344484444854448644487444884448944490444914449244493444944449544496444974449844499445004450144502445034450444505445064450744508日常日常日常日常日常日常日常日常日常日常双11预热双11预热 双1

3、1预热 双11预热 双11预热双11预热 双11预热 双11预热 双11预热 双11预热双11预热 双11预热 双11开门 双11开门双11开门 双11预热 双11预热 双11预热双11预热 双11预热0100200300400500600700800客单价环比同比数据占比0.84350532推广占比推广自定10.221967963推广自定20.33409611例(直播)0.443935927此页所有数值均为自动计算，无需手动填写，此模块可删除推广自定1推广自定2 例(直播)销售额9701460 1165.47销售占比19.96%30.04%39.92%ROI4.221.254.77推广费用2

4、29.981165.47406.3费比4.73%23.98%8.36%20202020202120211 11010111112122 23 34 45 56 67 78 89 91 1.2 2.3 3.4 45 56 67 78 89 9转转化化率率支支付付.销销售售.退退款款率率退退款款.推推广广.推推广广.推推广广.推推广广.推推广广.收收藏藏例例(直直.客客单单价价加加购购UVUV44479444804448144482444834448444485444864448744488444894449044491444924449344494444954449644497444984449

5、9445004450144502445034450444505445064450744508日常日常日常日常日常日常日常日常日常日常双11预热双11预热 双11预热 双11预热 双11预热双11预热 双11预热 双11预热 双11预热 双11预热双11预热 双11预热 双11开门 双11开门双11开门 双11预热 双11预热 双11预热双11预热 双11预热0100200300400500600700800客单价环比同比数据占比0.84350532推广占比推广自定10.221967963推广自定20.33409611例(直播)0.443935927月度汇总月份目标金额 销售金额UV转化率 支付

6、买家数 客单价退款金额退款率推广销售 推广费用1月30.0万28.0万2.8万1.67%486543.382.6万9.00%22.3万2.1万2月20.0万13.4万2.6万0.99%265510.771.3万10.00%10.4万1.6万3月25.0万26.4万3.1万1.28%498437.072.7万10.00%17.1万1.7万4月15.0万10.7万2.3万1.20%276358.261.1万10.00%8.5万1.6万5月25.0万25.6万4.3万1.10%437567.963.1万12.00%21.5万3.3万6月30.0万27.4万6.6万0.65%512536.204.9万

7、18.00%17.8万5.1万7月30.0万45.4万4.6万1.39%770508.736.3万14.00%28.4万4.2万8月15.0万11.3万2.4万1.08%261424.201.8万16.00%4.4万2.5万9月15.0万11.2万2.3万1.10%254425.141.0万9.00%7.6万2.4万10月25.0万22.5万3.0万1.51%461475.071.9万8.00%18.4万2.6万11月50.0万42.2万4.3万1.77%782525.005.8万14.00%32.9万4.8万12月40.0万41.1万4.4万1.35%882394.8512.3万30.00%

8、20.3万2.3万汇总320.0万305.3万42.8万1.26%5884475.5544.7万13.33%209.5万34.2万季度汇总季度目标金额 销售金额UV转化率 支付买家数 客单价退款金额退款率推广销售 推广费用Q175.0万67.8万8.5万1.32%1249496.626.6万10.00%49.7万5.4万Q270.0万63.7万13.2万0.98%1225488.369.1万14.00%47.8万10.1万Q360.0万68.0万9.3万1.19%1285452.999.0万13.00%40.4万9.1万Q4115.0万105.8万11.8万1.54%2125464.3220.

9、0万19.00%71.6万9.6万天舒可视化数据大屏运营报表时间参数20202020202120211 11010111112122 23 34 45 56 67 78 89 91 1.2 2.3 3.4 45 56 67 78 89 9数据源统计周期当前活动此表格蓝色数值均为手动填写，表格内紫色数值自动计算，无需填写，现存数值为样例无实际意义，此模块可删除ROI费比10.717%6.412%10.066%5.1915%6.5113%3.4819%6.699%1.7522%3.2121%7.2211%6.8911%8.846%6.4112.67%ROI费比9.218%4.7516%4.4213

10、%7.449%20202020202120211 11010111112122 23 34 45 56 67 78 89 91 1.2 2.3 3.4 45 56 67 78 89 9完整格式年季月日周活动节点2021/11/82021Q411846双11预热天舒可视化数据大屏运营报表20202020202120211 11010111112122 23 34 45 56 67 78 89 91 1.2 2.3 3.4 45 56 67 78 89 9数据源统计周期时间参数当前活动日期参数使用方法：在完整格式那里填写统计日期（格式20202020202120211 11010111112122

11、 23 34 45 56 67 78 89 91 1.2 2.3 3.4 45 56 67 78 89 9日期参数使用方法：在完整格式那里填写统计日期（格式统计日期销售金额UV转化率支付买家数客单价退款金额退款率收藏2020/1/15008710.00343166.67500.1172020/1/2118013540.00446196.672600.2203242020/1/354013400.0037510800202020/1/479013110.0069987.78500.0633222020/1/52694568910.008156481.163200.0119652020/1/641

12、116.616840.042271579.119833.940.2392302020/1/710291.613040.01317605.394477.290.435282020/1/86940.3513300.01216433.7722450.3235302020/1/910527.112540.016721501.29933.850.0887342020/1/109759.9911590.012915650.67500.0051262020/1/11401011330.00799445.5621100.5262172020/1/124864.879280.00979540.5426300.5

13、406142020/1/13477362333250.0286953500.9002192020/1/1435369.237940.020377459.34142990.64.0428412020/1/154053.8312900.00547579.1247401.169382020/1/1640112.372760.011382489.178403.630.2095352020/1/17341013170.00618426.2525400.7449242020/1/18151010170.00394377.520951.3874162020/1/197208720.0011172000192

14、020/1/20139013850.001426959900.7122142020/1/21150011640.0026350000202020/1/2257010880.000915707901.386142020/1/23098300000122020/1/24111012440.002433704950.4459102020/1/25086400000182020/1/261509030.003335000102020/1/277309510.0021236500222020/1/2813609610.0011136013601242020/1/2938909510.0053577817

15、500.4499272020/1/30151010190.00596251.673400.2252162020/1/3110309680.00313343.3300252020/2/148011790.001722403600.75212020/2/232011700.001721604951.5469282020/2/3294011990.00759326.677700.2619262020/2/45011860.00081503907.8142020/2/5138012510.001626900018天舒可视化数据大屏运营报表时间参数20202020202120211 1101011111

16、2122 23 34 45 56 67 78 89 91 1.2 2.3 3.4 45 56 67 78 89 9数据源统计周期当前活动日期理论上可无限延长，统计日期与日期工作表需同步调整，改标题名可自动同步，但顺序不可更改，此页蓝色数值均为手动填写，表格内紫色数值自动计算，无需填写，现存数值为样例无实际意义2020/2/6100012080.00253333.3300342020/2/7164010920.00273546.6700352020/2/8200511190.00364501.25500.0249342020/2/9157011820.0042531400282020/2/105

17、01012830.00628626.2510800.2156212020/2/11510014370.00639566.6700362020/2/12368015710.0025492000492020/2/13401013300.0068501.2500362020/2/14820013990.0114585.7114750.1799282020/2/15180012650.00453601400.0778282020/2/16399010930.00738498.758350.2093162020/2/178968.3514350.010515597.8931150.3473332020/

18、2/187803.6617570.007413600.2812200.1563302020/2/194164.2718650.005410416.4300342020/2/204150.218640.006412345.853595.290.8663242020/2/21780118010.008315520.078290.1063312020/2/22799013080.008411726.367990.1392020/2/23689013000.009212574.172000.029262020/2/24293012710.00476488.337650.2611202020/2/254

19、13015440.00911429511150.27362020/2/26176014510.0076111601000.0568252020/2/27572016150.0068115205600.0979392020/2/28508017510.006311461.827200.1417342020/2/29267516430.00376445.834950.185382020/3/11587017200.01342369035300.2224272020/3/2595017380.006912495.8300372020/3/3297019020.0047933000392020/3/4

20、505019190.006312420.8319550.3871392020/3/52053021150.014230684.333965.270.1931412020/3/61232019900.01012061623400.1899402020/3/71809020390.012325723.63400.0188412020/3/83443023420.017541839.7634100.099442020/3/9166016760.0006116608300.5282020/3/10280014560.0034556000292020/3/11206014130.003554122855

21、1.3859292020/3/12361014060.00436601.674950.1371312020/3/13318011290.0089353.337200.2264172020/3/14264011630.0026388000182020/3/1540010990.0018220010292.5725202020/3/16112011980.00253373.3300252020/3/17165011140.001828258100.4909172020/3/1854010220.0039413500142020/3/19368010470.0076846000262020/3/20

22、727010060.00991072700232020/3/21573011620.008610573500.0087252020/3/221900.0112540.00567271.4300182020/3/23314012410.00486523.3318300.5828232020/3/24911313340.011215607.531548.50.1699302020/3/254218.5113930.008612351.540.010262020/3/265664.514290.007711514.959860.1741252020/3/275380.0114220.00841244

23、8.3313640.2535152020/3/28296014170.00426493.33500.0169202020/3/29314011480.0078392.500252020/3/30183011270.0044536600242020/3/31744012650.00951262000172020/4/12090.0612320.008110209.0110700.5119272020/4/23580.0112120.0056596.672200.0615132020/4/32980.0111280.00536496.676800.2282252020/4/4425012510.0

24、0648531.2500152020/4/5822010370.0096108224000.0487162020/4/6264010750.00475528500.0189142020/4/75825.0112550.008811529.5500142020/4/81570.0112140.00334392.511060.7045282020/4/9930012360.011314664.2900232020/4/101135014700.012919597.374950.0436272020/4/11137875280020.0095265520.28300700.21811232020/4

25、/12989023490.008520494.534650.3504342020/4/13462015890.0044766016520.3576232020/4/1488514240.002132953000.339272020/4/15412011990.0056686.6718600.4515292020/4/16215011960.00334537.500172020/4/17684012630.007197607200.1053282020/4/18302011570.00617431.4300112020/4/19371012350.00739412.2200332020/4/20

26、506014900.0067105063503.030.6923242020/4/21175014890.0023583.3312250.7252020/4/22954015270.0079127959100.0954402020/4/23439013220.00456731.672700.0615352020/4/24607011980.00831060700192020/4/25189013280.0038537800172020/4/26432013330.0075104323400.0787272020/4/27254012990.0031463500162020/4/28504013

27、650.00731050400222020/4/29305013320.00537435.7115400.5049182020/4/30443011570.00789492.2212000.2709172020/5/1443913750.011616277.44629.90.1419252020/5/21309.313330.007510130.9300272020/5/33389.412900.009312282.4559.90.0177272020/5/46799.615580.009615453.316700.0985322020/5/569424.617850.0588105661.1

28、94293.080.0618452020/5/621029.615100.020531678.383304.890.1572282020/5/72161814860.023635617.6615300.0708242020/5/8566013560.00527808.57542.520.0959262020/5/9587011060.009105873092.160.5268152020/5/10185010150.00596308.339100.4919112020/5/11290010260.00586483.3300162020/5/1234208870.006865707700.225

29、182020/5/1316508580.00474412.500212020/5/1427109760.00616451.6700202020/5/15340011600.0067485.7100292020/5/16314010290.00687448.5700262020/5/17291010800.004655829000.3093282020/5/18613512190.00911557.7320800.339162020/5/19780010380.015416487.500152020/5/20121409570.019919638.955800.0478192020/5/2138

30、108650.00817544.2900212020/5/2213808310.004843456400.4638162020/5/2310108030.0025250500112020/5/2423308010.00756388.3300182020/5/2516509020.005553302800.1697142020/5/2624608970.003338208600.3496152020/5/2737507990.007566258100.216232020/5/2818208210.004944556800.3736192020/5/2973190147100.0105155472

31、.194700.00641092020/5/301226029090.008625490.4136001.1093492020/5/31152015170.0023506.6720001.3158432020/6/169377.515750.0787124559.59105.580.1312332020/6/21561916410.019532488.094448.970.2848272020/6/313878.315240.032850277.573445.560.2483252020/6/416013.714860.028943372.411598.530.0998302020/6/511

32、608.914340.027940290.222539.160.2187282020/6/6216010160.0022108000132020/6/72180.099730.014414155.7213300.6101132020/6/825809430.00747368.57399.160.1547162020/6/96208800.00343206.6713802.2258162020/6/1024808610.0076413.332000.0806122020/6/1128609730.0051557200122020/6/12154010190.003943852200.142916

33、2020/6/1327010540.0009127000212020/6/140103200000232020/6/15164012910.00233546.67338.040.2061342020/6/1674091.915130.0687104712.4214434.580.1948372020/6/178822782320.0185152580.4413797.040.1564702020/6/1878077.624170.0521126619.6610961.480.1404422020/6/1920336.717840.020236564.911493.490.0734382020/

34、6/2015538.414350.022332485.582127.870.1369272020/6/21213010430.004854266800.3192222020/6/2211609690.00414290771.780.6653172020/6/23236010100.00445906000.2542282020/6/2417297710.00655345.80062020/6/2511306550.00614282.500122020/6/2653805710.01589597.7827250.5065142020/6/272706130.001612706802.5185112

35、020/6/2819805790.010463302200.1111132020/6/2935805980.016596.675400.1508142020/6/3012405710.00885248685.890.5531112020/7/1285.46040.02151321.956202.1724102020/7/27342.96060.026416458.9300232020/7/328406570.007655685800.204292020/7/423125450.01287330.2900152020/7/54262.85820.020612355.236700.15721820

36、20/7/62150.95560.0095430.184700.218532020/7/729905570.00955981153.640.3858112020/7/814605120.007843653500.2397152020/7/940515920.01016675.1700142020/7/1048006440.0155104806300.131352020/7/1122906200.01137327.1400202020/7/1239615600.01619440.117200.1818202020/7/1318707570.00534467.500132020/7/1428816

37、860.01027411.576600.2291182020/7/1518218430.003636074400.241692020/7/163299.28090.014812274.933900.1182212020/7/1723839350.00868297.8800212020/7/18178010110.0033593.330092020/7/19336710210.00788420.887250.2153192020/7/2037509940.01011037500202020/7/2123568310.00847336.570072020/7/2221158260.00484528

38、.7500112020/7/2320818230.00615416.200172020/7/243980.57040.01289442.2800132020/7/2561567220.016612513773.50.1256112020/7/2615836700.01047226.142000.1263162020/7/2736907250.008366152000.0542152020/7/2815407060.007153080042020/7/2940747180.013910407.45400.1325172020/7/3034247380.013610342.400132020/7/

39、3114536550.00765290.600122020/8/11509.86730.01047215.6900192020/8/22249.87330.00826374.9711300.5023102020/8/34049.77370.014911368.152200.0543192020/8/46859.98070.017314489.9900402020/8/560907810.01281060923900.392492020/8/66199.77890.021517364.691016.360.1639252020/8/766907240.015211608.1800162020/8

40、/88379.99410.012812698.332000.0239252020/8/95407550.0026227000152020/8/1017007850.0064534000232020/8/112019.87550.00937288.5400142020/8/123679.88880.012411334.5300332020/8/1327208990.0056554400142020/8/146169.97650.014411560.93900.0632192020/8/157529.98040.013711684.54916.60.1217462020/8/1637107500.

41、013310371100.002792020/8/1744707650.01058558.751383.40.3095222020/8/1816307810.00776271.675600.3436152020/8/1912539.88020.027422569.9918900.1507212020/8/206009.912810.009412500.8300152020/8/2173708790.017115491.332200.0299142020/8/2271108900.014613546.9210400.146392020/8/239459.98250.020617556.46001

42、72020/8/2476907900.017714549.2922200.2887172020/8/2513879.98510.022319730.5200232020/8/2634209840.00717488.578300.2427152020/8/27610410480.00869678.222000.0328202020/8/28424010760.0074853000222020/8/2927449460.008583433280.1195322020/8/303819.99110.00888477.4900272020/8/3126908970.00676448.336400.23

43、79202020/9/17237.89070.016515482.5210600.1465152020/9/28859.69630.019719466.295620.0634242020/9/37119.89920.019219374.7300312020/9/44119.69950.013113316.896700.1626232020/9/58399.311320.020323365.192700.0321432020/9/65069.410320.015516316.849100.1795262020/9/77439.910160.014815495.9913900.1868402020

44、/9/83169.910710.010311288.1700302020/9/919509.611840.032939500.2500322020/9/1012659.910880.02325506.430500.2409332020/9/111065010230.019620532.514300.1343362020/9/1230109690.0072743000292020/9/133309.89980.0110330.9800132020/9/142449.99340.00868306.242000.0816212020/9/1524809250.00656413.3300242020/

45、9/161029010820.015717605.292300.0224262020/9/1713609.810330.024225544.393900.0287322020/9/1881049580.015715540.2710240.1264202020/9/197899.910580.011312658.3310900.138192020/9/2044109900.006167358300.1882272020/9/2177309920.016116483.132700.0349192020/9/229856.4210150.016717579.7900242020/9/23813797

46、8810.0187147553.6129800.1595652020/9/2410749.818890.010119565.78101700.9461302020/9/25826011180.014316516.2513300.161162020/9/26486010820.00748607.511600.2387192020/9/274979.910140.009910497.997800.1566452020/9/28373010090.00697532.8611920.3196322020/9/29380010560.00576633.332700.0711282020/9/309280

47、8900.0181658018200.1961212020/10/15748.38740.03228205.300212020/10/210089.19020.024422458.64149.90.4113172020/10/38068.89280.025924336.23000.0372262020/10/46159.48970.01917362.3200312020/10/56309.69330.019318350.5300312020/10/614429.99800.022422655.900222020/10/710759.710010.01616672.4817300.1608132

48、020/10/87589.711450.014817446.452300.0303232020/10/96247.712150.02834183.768100.1296252020/10/106978.111310.025629240.6215800.2264292020/10/11765911580.020724319.1316600.2167352020/10/124389.811290.008910438.9800202020/10/1352049.619250.035869754.342508.750.0482272020/10/1416039.923430.011126616.929

49、5700.5966252020/10/1536089.920820.023148751.879900.0274272020/10/1617089.611500.024328610.348000.0468332020/10/1721629.617820.017431697.737900.0365282020/10/1827489.917840.021939704.878300.0302282020/10/19917013000.011515611.3336500.398262020/10/20242090159000.0302480504.3531950.01321382020/10/21455

50、66.134420.0296102446.73961942.1111742020/10/229417.718480.009217553.9864050.6801432020/10/234740.818190.006612395.0743350.9144432020/10/243081.719910.006513237.054950.1606592020/10/252452.416770.00610245.2415600.6361462020/10/263612.117080.011119190.1122650.6271352020/10/273053.515520.00914218.11495