数据可视化分析报表数据分析报表.xlsx

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

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.0060

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

3、预热 双11预热 双11预热双11预热 双11预热 双11预热 双11预热 双11预热双11预热 双11预热 双11开门 双11开门双11开门 双11预热 双11预热 双11预热双11预热 双11预热0100200300400500600700800客单价环比同比数据占比推广占比推广自定10.234565084推广自定20.374718222例(直播)0.390716694此页所有数值均为自动计算，无需手动填写，此模块可删除LOGO推广自定1推广自定2 例(直播)销售额503630804550115229.8销售占比 14.91%23.82%24.84%ROI6.066.986.46推广费用8

4、3131.72 115229.8129956.33费比2.46%3.41%3.85%20202020202120211 11010111112122 23 34 45 56 67 78 89 91 1.2 2.3 3.4 45 56 67 78 89 9转转化化率率支支付付.销销售售.退退款款率率退退款款.推推广广.推推广广.推推广广.推推广广.推推广广.收收藏藏例例(直直.客客单单价价加加购购UVUV4447944480444814448244483444844448544486444874448844489444904449144492444934449444495444964449744

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

6、数 客单价退款金额退款率推广销售 推广费用ROI1月30.0万69.3万8.2万0.79%1398439.7418.9万27.00%13.8万9.6万1.442月20.0万11.3万4.1万0.56%234461.121.9万17.00%8.8万3.0万2.893月25.0万19.6万4.5万0.69%334553.212.8万14.00%16.2万3.4万4.784月15.0万27.3万6.6万0.64%509542.165.1万19.00%24.4万5.3万4.655月25.0万29.3万5.0万1.00%554496.943.9万13.00%25.5万3.0万8.556月30.0万44.

7、0万4.0万1.63%833430.857.5万17.00%36.5万5.6万6.557月30.0万9.2万2.2万1.10%234416.920.9万10.00%6.0万2.0万2.988月15.0万16.3万2.6万1.24%322479.481.6万10.00%12.9万2.7万4.819月15.0万29.4万3.8万1.45%583491.994.3万15.00%23.3万3.6万6.5710月25.0万59.6万6.2万1.82%1290407.8114.9万25.00%34.5万6.7万5.1711月50.0万137.1万7.0万2.13%2253431.7618.0万13.00%

8、53.2万4.1万13.0312月40.0万23.2万3.1万1.27%451472.062.3万10.00%16.2万1.9万8.41汇总320.0万475.8万57.4万1.19%8995468.6782.0万15.83%271.4万50.8万5.82季度汇总季度目标金额 销售金额UV转化率 支付买家数 客单价退款金额退款率推广销售 推广费用ROIQ175.0万100.3万16.7万0.68%1966485.2123.7万24.00%38.7万16.0万2.42Q270.0万100.6万15.7万1.09%1896490.0616.5万16.00%86.5万13.8万6.26Q360.0万

9、55.0万8.7万1.26%1139462.486.8万12.00%42.3万8.3万5.12Q4115.0万219.9万16.3万1.74%3994437.2735.1万16.00%103.9万12.7万8.1920202020202120211 11010111112122 23 34 45 56 67 78 89 91 1.2 2.3 3.4 45 56 67 78 89 9统计周期此表格绿色色数值均为手动填写，表格内紫色数值自动计算，无需填写，现存数值为样例无实际意义，此模块可删除公司名称数据大屏运营报表时间参数数据源当前活动LOGO费比14%27%17%19%10%13%22%16%

10、12%11%3%8%14.33%费比16%14%15%6%20202020202120211 11010111112122 23 34 45 56 67 78 89 91 1.2 2.3 3.4 45 56 67 78 89 9完整格式年季月日周活动节点2020/11/82020Q411846双11预热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数据源统计周期时间参数当前活动日期参数使用方法：在完

11、整格式那里填写统计日期（格式勿换）然后整体下拉复制，想统计到哪个日期就下拉到哪里，活动节点自行手动填写，使用过程中日期表会自动折叠隐藏，请勿在此表添加其他内容，如不显示切片器请更新最新版WPS！LOGO20202020202120211 11010111112122 23 34 45 56 67 78 89 91 1.2 2.3 3.4 45 56 67 78 89 9日期参数使用方法：在完整格式那里填写统计日期（格式勿换）然后整体下拉复制，想统计到哪个日期就下拉到哪里，活动节点自行手动填写，使用过程中日期表会自动折叠隐藏，请勿在此表添加其他内容，如不显示切片器请更新最新版WPS！统计日期销售

12、金额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/641116.6116840.042271579.119833.940.2392302020/1/710291.5913040.01317605.394477.290.435

13、282020/1/86940.3513300.01216433.7722450.3235302020/1/910527.1212540.016721501.29933.850.0887342020/1/109759.9911590.012915650.67500.0051262020/1/11401011330.00799445.5621100.5262172020/1/124864.879280.00979540.5426300.5406142020/1/13477361.9333250.0286953500.9002192020/1/1435369.1837940.020377459.34

14、142990.554.0428412020/1/154053.8312900.00547579.1247401.169382020/1/1640112.2672760.011382489.178403.630.2095352020/1/17341013170.00618426.2525400.7449242020/1/18151010170.00394377.520951.3874162020/1/197208720.0011172000192020/1/20139013850.001426959900.7122142020/1/21150011640.0026350000202020/1/2

15、257010880.000915707901.386142020/1/23098300000122020/1/24111012440.002433704950.4459102020/1/25086400000182020/1/261509030.003335000102020/1/277309510.0021236500222020/1/2813609610.0011136013601242020/1/2938909510.0053577817500.4499272020/1/30151010190.00596251.673400.2252162020/1/3110309680.0031334

16、3.3300252020/2/148011790.001722403600.75212020/2/232011700.001721604951.5469282020/2/3294011990.00759326.677700.261926公司名称数据大屏运营报表时间参数20202020202120211 11010111112122 23 34 45 56 67 78 89 91 1.2 2.3 3.4 45 56 67 78 89 9数据源统计周期当前活动LOGO2020/2/45011860.00081503907.8142020/2/5138012510.0016269000182020/

17、2/6100012080.00253333.3300342020/2/7164010920.00273546.6700352020/2/8200511190.00364501.25500.0249342020/2/9157011820.0042531400282020/2/10501012830.00628626.2510800.2156212020/2/11510014370.00639566.6700362020/2/12368015710.0025492000492020/2/13401013300.0068501.2500362020/2/14820013990.0114585.711

18、4750.1799282020/2/15180012650.00453601400.0778282020/2/16399010930.00738498.758350.2093162020/2/178968.3514350.010515597.8931150.3473332020/2/187803.6617570.007413600.2812200.1563302020/2/194164.2718650.005410416.4300342020/2/204150.218640.006412345.853595.290.8663242020/2/21780118010.008315520.0782

19、90.1063312020/2/22799013080.008411726.367990.1392020/2/23689013000.009212574.172000.029262020/2/24293012710.00476488.337650.2611202020/2/25413015440.00911429511150.27362020/2/26176014510.0076111601000.0568252020/2/27572016150.0068115205600.0979392020/2/28508017510.006311461.827200.1417342020/2/29267

20、516430.00376445.834950.185382020/3/11587017200.01342369035300.2224272020/3/2595017380.006912495.8300372020/3/3297019020.0047933000392020/3/4505019190.006312420.8319550.3871392020/3/52053021150.014230684.333965.270.1931412020/3/61232019900.01012061623400.1899402020/3/71809020390.012325723.63400.01884

21、12020/3/83443023420.017541839.7634100.099442020/3/9166016760.0006116608300.5282020/3/10280014560.0034556000292020/3/11206014130.0035541228551.3859292020/3/12361014060.00436601.674950.1371312020/3/13318011290.0089353.337200.2264172020/3/14264011630.0026388000182020/3/1540010990.0018220010292.57252020

22、20/3/16112011980.00253373.3300252020/3/17165011140.001828258100.4909172020/3/1854010220.0039413500142020/3/19368010470.0076846000262020/3/20727010060.00991072700232020/3/21573011620.008610573500.0087252020/3/221900.0112540.00567271.4300182020/3/23314012410.00486523.3318300.5828232020/3/24911313340.0

23、11215607.531548.50.1699302020/3/254218.5113930.008612351.540.010262020/3/265664.514290.007711514.959860.1741252020/3/275380.0114220.008412448.3313640.2535152020/3/28296014170.00426493.33500.0169202020/3/29314011480.0078392.500252020/3/30183011270.0044536600242020/3/31744012650.00951262000172020/4/12

24、090.0612320.008110209.0110700.5119272020/4/23580.0112120.0056596.672200.0615132020/4/32980.0111280.00536496.676800.2282252020/4/4425012510.00648531.2500152020/4/5822010370.0096108224000.0487162020/4/6264010750.00475528500.0189142020/4/75825.0112550.008811529.5500142020/4/81570.0112140.00334392.51106

25、0.7045282020/4/9930012360.011314664.2900232020/4/101135014700.012919597.374950.0436272020/4/11137875280020.0095265520.28300700.21811232020/4/12989023490.008520494.534650.3504342020/4/13462015890.0044766016520.3576232020/4/1488514240.002132953000.339272020/4/15412011990.0056686.6718600.4515292020/4/1

26、6215011960.00334537.500172020/4/17684012630.007197607200.1053282020/4/18302011570.00617431.4300112020/4/19371012350.00739412.2200332020/4/20506014900.0067105063503.030.6923242020/4/21175014890.0023583.3312250.7252020/4/22954015270.0079127959100.0954402020/4/23439013220.00456731.672700.0615352020/4/2

27、4607011980.00831060700192020/4/25189013280.0038537800172020/4/26432013330.0075104323400.0787272020/4/27254012990.0031463500162020/4/28504013650.00731050400222020/4/29305013320.00537435.7115400.5049182020/4/30443011570.00789492.2212000.2709172020/5/1443913750.011616277.44629.90.1419252020/5/21309.313

28、330.007510130.9300272020/5/33389.412900.009312282.4559.90.0177272020/5/46799.615580.009615453.316700.0985322020/5/569424.5917850.0588105661.194293.080.0618452020/5/621029.6315100.020531678.383304.890.1572282020/5/72161814860.023635617.6615300.0708242020/5/8566013560.00527808.57542.520.0959262020/5/9

29、587011060.009105873092.160.5268152020/5/10185010150.00596308.339100.4919112020/5/11290010260.00586483.3300162020/5/1234208870.006865707700.225182020/5/1316508580.00474412.500212020/5/1427109760.00616451.6700202020/5/15340011600.0067485.7100292020/5/16314010290.00687448.5700262020/5/17291010800.00465

30、5829000.3093282020/5/18613512190.00911557.7320800.339162020/5/19780010380.015416487.500152020/5/20121409570.019919638.955800.0478192020/5/2138108650.00817544.2900212020/5/2213808310.004843456400.4638162020/5/2310108030.0025250500112020/5/2423308010.00756388.3300182020/5/2516509020.005553302800.16971

31、42020/5/2624608970.003338208600.3496152020/5/2737507990.007566258100.216232020/5/2818208210.004944556800.3736192020/5/2973190147100.0105155472.194700.00641092020/5/301226029090.008625490.4136001.1093492020/5/31152015170.0023506.6720001.3158432020/6/169377.5315750.0787124559.59105.580.1312332020/6/21

32、5618.9616410.019532488.094448.970.2848272020/6/313878.3315240.032850277.573445.560.2483252020/6/416013.7214860.028943372.411598.530.0998302020/6/511608.8814340.027940290.222539.160.2187282020/6/6216010160.0022108000132020/6/72180.099730.014414155.7213300.6101132020/6/825809430.00747368.57399.160.154

33、7162020/6/96208800.00343206.6713802.2258162020/6/1024808610.0076413.332000.0806122020/6/1128609730.0051557200122020/6/12154010190.003943852200.1429162020/6/1327010540.0009127000212020/6/140103200000232020/6/15164012910.00233546.67338.040.2061342020/6/1674091.9315130.0687104712.4214434.580.1948372020

34、/6/1788227.0382320.0185152580.4413797.040.1564702020/6/1878077.5824170.0521126619.6610961.480.1404422020/6/1920336.7317840.020236564.911493.490.0734382020/6/2015538.4114350.022332485.582127.870.1369272020/6/21213010430.004854266800.3192222020/6/2211609690.00414290771.780.6653172020/6/23236010100.004

35、45906000.2542282020/6/2417297710.00655345.80062020/6/2511306550.00614282.500122020/6/2653805710.01589597.7827250.5065142020/6/272706130.001612706802.5185112020/6/2819805790.010463302200.1111132020/6/2935805980.016596.675400.1508142020/6/3012405710.00885248685.890.5531112020/7/1285.46040.02151321.956

36、202.1724102020/7/27342.96060.026416458.9300232020/7/328406570.007655685800.204292020/7/423125450.01287330.2900152020/7/54262.85820.020612355.236700.1572182020/7/62150.95560.0095430.184700.218532020/7/729905570.00955981153.640.3858112020/7/814605120.007843653500.2397152020/7/940515920.01016675.170014

37、2020/7/1048006440.0155104806300.131352020/7/1122906200.01137327.1400202020/7/1239615600.01619440.117200.1818202020/7/1318707570.00534467.500132020/7/1428816860.01027411.576600.2291182020/7/1518218430.003636074400.241692020/7/163299.28090.014812274.933900.1182212020/7/1723839350.00868297.8800212020/7

38、/18178010110.0033593.330092020/7/19336710210.00788420.887250.2153192020/7/2037509940.01011037500202020/7/2123568310.00847336.570072020/7/2221158260.00484528.7500112020/7/2320818230.00615416.200172020/7/243980.57040.01289442.2800132020/7/2561567220.016612513773.50.1256112020/7/2615836700.01047226.142

39、000.1263162020/7/2736907250.008366152000.0542152020/7/2815407060.007153080042020/7/2940747180.013910407.45400.1325172020/7/3034247380.013610342.400132020/7/3114536550.00765290.600122020/8/11509.86730.01047215.6900192020/8/22249.87330.00826374.9711300.5023102020/8/34049.77370.014911368.152200.0543192

40、020/8/46859.98070.017314489.9900402020/8/560907810.01281060923900.392492020/8/66199.77890.021517364.691016.360.1639252020/8/766907240.015211608.1800162020/8/88379.99410.012812698.332000.0239252020/8/95407550.0026227000152020/8/1017007850.0064534000232020/8/112019.87550.00937288.5400142020/8/123679.8

41、8880.012411334.5300332020/8/1327208990.0056554400142020/8/146169.97650.014411560.93900.0632192020/8/157529.98040.013711684.54916.60.1217462020/8/1637107500.013310371100.002792020/8/1744707650.01058558.751383.40.3095222020/8/1816307810.00776271.675600.3436152020/8/1912539.88020.027422569.9918900.1507

42、212020/8/206009.912810.009412500.8300152020/8/2173708790.017115491.332200.0299142020/8/2271108900.014613546.9210400.146392020/8/239459.98250.020617556.4600172020/8/2476907900.017714549.2922200.2887172020/8/2513879.98510.022319730.5200232020/8/2634209840.00717488.578300.2427152020/8/27610410480.00869

43、678.222000.0328202020/8/28424010760.0074853000222020/8/2927449460.008583433280.1195322020/8/303819.99110.00888477.4900272020/8/3126908970.00676448.336400.2379202020/9/17237.89070.016515482.5210600.1465152020/9/28859.69630.019719466.295620.0634242020/9/37119.89920.019219374.7300312020/9/44119.69950.0

44、13113316.896700.1626232020/9/58399.311320.020323365.192700.0321432020/9/65069.410320.015516316.849100.1795262020/9/77439.910160.014815495.9913900.1868402020/9/83169.910710.010311288.1700302020/9/919509.611840.032939500.2500322020/9/1012659.910880.02325506.430500.2409332020/9/111065010230.019620532.5

45、14300.1343362020/9/1230109690.0072743000292020/9/133309.89980.0110330.9800132020/9/142449.99340.00868306.242000.0816212020/9/1524809250.00656413.3300242020/9/161029010820.015717605.292300.0224262020/9/1713609.810330.024225544.393900.0287322020/9/1881049580.015715540.2710240.1264202020/9/197899.91058

46、0.011312658.3310900.138192020/9/2044109900.006167358300.1882272020/9/2177309920.016116483.132700.0349192020/9/229856.4210150.016717579.7900242020/9/2381379.0478810.0187147553.6129800.1595652020/9/2410749.818890.010119565.78101700.9461302020/9/25826011180.014316516.2513300.161162020/9/26486010820.007

47、48607.511600.2387192020/9/274979.910140.009910497.997800.1566452020/9/28373010090.00697532.8611920.3196322020/9/29380010560.00576633.332700.0711282020/9/3092808900.0181658018200.1961212020/10/15748.38740.03228205.300212020/10/210089.19020.024422458.64149.90.4113172020/10/38068.89280.025924336.23000.

48、0372262020/10/46159.48970.01917362.3200312020/10/56309.69330.019318350.5300312020/10/614429.99800.022422655.900222020/10/710759.710010.01616672.4817300.1608132020/10/87589.711450.014817446.452300.0303232020/10/96247.712150.02834183.768100.1296252020/10/106978.111310.025629240.6215800.2264292020/10/1

49、1765911580.020724319.1316600.2167352020/10/124389.811290.008910438.9800202020/10/1352049.619250.035869754.342508.750.0482272020/10/1416039.923430.011126616.9295700.5966252020/10/1536089.920820.023148751.879900.0274272020/10/1617089.611500.024328610.348000.0468332020/10/1721629.617820.017431697.73790

50、0.0365282020/10/1827489.917840.021939704.878300.0302282020/10/19917013000.011515611.3336500.398262020/10/20242089.7159000.0302480504.3531950.01321382020/10/2145566.134420.0296102446.73961942.1111742020/10/229417.718480.009217553.9864050.6801432020/10/234740.818190.006612395.0743350.9144432020/10/243