《终端制式用户分析.xls》由会员分享，可在线阅读，更多相关《终端制式用户分析.xls（11页珍藏版）》请在taowenge.com淘文阁网|工程机械CAD图纸|机械工程制图|CAD装配图下载|SolidWorks_CaTia_CAD_UG_PROE_设计图分享下载上搜索。
1、端制式用户分析报表【查询条件：日分析、地域】内内容容类类型型使使用用用用户户数数(人人)iphone2G2G智智能能终终端端TDTD智智能能终终端端新闻资讯类别78969056416111484002沟通交流类别83456582889722508789休闲娱乐类别69380267536642030990生活服务类别95170490388172766107文化教育类别2044624026164167未知类别74520772576172073704合计:98140496679072963574使使用用流流量量(MB)(MB)2G2G非非智智能能终终端端TDTD非非智智能能终终端端其其他他iphon
2、e81357764770433526275309.6916894231162216535531300766.77118990491020553302706433.232141061239046741230578410.31588173576173661539.873227644124527868202329882.99406805325903810127693192342.86使使用用用用户户数数(人人)2G2G智智能能终终端端TDTD智智能能终终端端2G2G非非智智能能终终端端TDTD非非智智能能终终端端1485663.18498501.24138407.1319900.108911143.
3、222993918.48984609.5584777.425696521.783414581.67770338.92182648.147234367.293492139.371057858.37176938.2322490.176749.486091.35382.742862405.051822538.06542919.34159984.8426212590.6912228428.303500224.68624631.47使使用用流流量量(MB)(MB)户户均均流流量量(MB/(MB/人人)其其他他iphone2G2G智智能能终终端端TDTD智智能能终终端端119970.330.350.260
4、.34732473.421.561.081.19655287.771.020.841.68867775.470.610.801.261664.280.080.090.11445752.880.440.390.882822924.153.252.714.13上上行行流流量量(MB)(MB)2G2G非非智智能能终终端端TDTD非非智智能能终终端端其其他他iphone0.170.310.2817467.120.580.731.12102403.460.652.011.1842544.920.490.741.1787621.180.100.110.10181.210.171.280.5143857.3
5、50.862.412.79294075.24端制式用户分析报表【查询条件：日分析、地域】户户均均流流量量(MB/(MB/人人)2G2G智智能能终终端端TDTD智智能能终终端端2G2G非非智智能能终终端端TDTD非非智智能能终终端端134403.6645527.8314875.381773.80893305.15298471.63117934.689056.34422309.08174858.9572638.588780.361147853.24372830.35165554.6518170.973504.48957.76860.4758.72412132.54144492.05117790.5
6、19731.733013508.141037138.57489654.2747571.93上上行行流流量量(MB)(MB)下下行行流流量量(MB)(MB)其其他他iphone2G2G智智能能终终端端TDTD智智能能终终端端11903.82257842.571351259.52452973.4178928.931198363.318017838.082695446.8544162.44663888.315274212.703239722.72127588.40490789.136086514.063119309.02241.701358.6618985.695791.7257397.992860
7、25.642450272.511678046.00320223.282898267.6223199082.5611191289.73流流量量占占比比(%)(%)2G2G非非智智能能终终端端TDTD非非智智能能终终端端其其他他iphone123531.7518126.30108066.518.62%866674.8775721.08653544.4940.75%697700.35173867.78611125.3322.13%892303.73158767.26740187.0718.12%5230.89324.021422.580.05%425128.83150253.10388354.891
8、0.33%3010570.41577059.542502700.87-下下行行流流量量(MB)(MB)2G2G智智能能终终端端TDTD智智能能终终端端2G2G非非智智能能终终端端TDTD非非智智能能终终端端5.67%4.08%3.95%3.19%34.00%24.48%28.13%13.57%21.73%27.92%22.01%29.24%27.60%28.56%30.22%28.33%0.09%0.06%0.17%0.06%10.92%14.90%15.51%25.61%-流流量量占占比比(%)(%)其其他他4.25%25.95%23.21%30.74%0.06%15.79%-SELECT
9、IF(T1.CONT_APP_TYPE=-9,999999,T1.CONT_APP_TYPE)AS CONT_ID,IF(D1.CONT_APP_TYPE_NAME IS NULL,IF(T1.CONT_APP_TYPE=-9,未知,T1.CONT_APP_TYPE),D1.CONT_APP_TYPE_NAME)AS CONT_NAME,T1.IPHONE_USER_COUNT AS IPHONE_USER_COUNT,T1.GSM_INTEL_USER_COUNTAS GSM_INTEL_USER_COUNT,T1.TD_INTEL_USER_COUNT AS TD_INTEL_USER_C
10、OUNT,T1.GSM_UNINTEL_USER_COUNT AS GSM_UNINTEL_USER_COUNT,T1.TD_UNINTEL_USER_COUNT AS TD_UNINTEL_USER_COUNT,T1.TERM_NET_OTHER_USER_COUNT AS OTHER_USER_COUNT,(T1.IPHONE_UP_FLOW+T1.IPHONE_DOWN_FLOW)/1024/1024 AS IPHONE_FLOW,(T1.GSM_INTEL_UP_FLOW+T1.GSM_INTEL_DOWN_FLOW)/1024/1024 ASGSM_INTELI_FLOW,(T1.T
11、D_INTEL_UP_FLOW+T1.TD_INTEL_DOWN_FLOW)/1024/1024 ASTD_INTELI_FLOW,(T1.GSM_UNINTEL_UP_FLOW+T1.GSM_UNINTEL_DOWN_FLOW)/1024/1024 ASGSM_UNINTELI_FLOW,(T1.TD_UNINTEL_UP_FLOW+T1.TD_UNINTEL_DOWN_FLOW)/1024/1024 ASTD_UNINTEL_FLOW,(T1.TERM_NET_OTHER_UP_FLOW+T1.OTHER_DOWN_FLOW)/1024/1024 ASOTHER_FLOW,(T1.IPHO
12、NE_UP_FLOW+T1.IPHONE_DOWN_FLOW)/T1.IPHONE_USER_COUNT/1024/1024 AS IPHONE_AVG,(T1.GSM_INTEL_UP_FLOW+T1.GSM_INTEL_DOWN_FLOW)/T1.GSM_INTEL_USER_COUNT/1024/1024 ASGSM_INTEL_AVG,(T1.TD_INTEL_UP_FLOW+T1.TD_INTEL_DOWN_FLOW)/T1.TD_INTEL_USER_COUNT/1024/1024 ASTD_INTEL_AVG,(T1.GSM_UNINTEL_UP_FLOW+T1.GSM_UNIN
13、TEL_DOWN_FLOW)/T1.GSM_UNINTEL_USER_COUNT/1024/1024 ASGSM_UNINTEL_AVG,(T1.TD_UNINTEL_UP_FLOW+T1.TD_UNINTEL_DOWN_FLOW)/T1.TD_UNINTEL_USER_COUNT/1024/1024 ASTD_UNINTEL_AVG,(T1.TERM_NET_OTHER_UP_FLOW+T1.OTHER_DOWN_FLOW)/T1.TERM_NET_OTHER_USER_COUNT/1024/1024 ASOTHER_AVG,T1.IPHONE_UP_FLOW/1024/1024 AS IP
14、HONE_UP_FLOW,T1.GSM_INTEL_UP_FLOW/1024/1024 AS GSM_INTEL_UP_FLOW,T1.TD_INTEL_UP_FLOW/1024/1024 AS TD_INTEL_UP_FLOW,T1.GSM_UNINTEL_UP_FLOW/1024/1024 AS GSM_UNINTEL_UP_FLOW,T1.TD_UNINTEL_UP_FLOW/1024/1024 AS TD_UNINTEL_UP_FLOW,T1.TERM_NET_OTHER_UP_FLOW/1024/1024 AS OTHER_UP_FLOW,T1.IPHONE_DOWN_FLOW/10
15、24/1024 AS IPHONE_DOWN_FLOW,T1.GSM_INTEL_DOWN_FLOW/1024/1024 AS GSM_INTEL_DOWN_FLOW,T1.TD_INTEL_DOWN_FLOW/1024/1024 AS TD_INTEL_DOWN_FLOW,T1.GSM_UNINTEL_DOWN_FLOW/1024/1024 AS GSM_UNINTEL_DOWN_FLOW,T1.TD_UNINTEL_DOWN_FLOW/1024/1024 AS TD_UNINTEL_DOWN_FLOW,T1.OTHER_DOWN_FLOW/1024/1024 AS OTHER_DOWN_F
16、LOW,(T1.IPHONE_UP_FLOW+T1.IPHONE_DOWN_FLOW)/1024/1024/3192342.8586 ASIPHONE_FLOW_PRECENT,(T1.GSM_INTEL_UP_FLOW+T1.GSM_INTEL_DOWN_FLOW)/1024/1024/26212590.6945AS GSM_INTEL_FLOW_PRECENT,(T1.TD_INTEL_UP_FLOW+T1.TD_INTEL_DOWN_FLOW)/1024/1024/12228428.3012 ASTD_INTEL_PRECENT,(T1.GSM_UNINTEL_UP_FLOW+T1.GS
17、M_UNINTEL_DOWN_FLOW)/1024/1024/3500224.6764 ASGSM_UNINTEL_FLOW_PRECENT,(T1.TD_UNINTEL_UP_FLOW+T1.TD_UNINTEL_DOWN_FLOW)/1024/1024/624631.4701AS TD_UNINTEL_FLOW_PRECENT,(T1.TERM_NET_OTHER_UP_FLOW+T1.OTHER_DOWN_FLOW)/1024/1024/2822924.1483 AS OTHER_PRECENT FROM TASST.TAS_CONT_DIM_TERM_INTELI_NET_DM_201401 T1 LEFT OUTER JOINTASDIM.DIM_CONT_APP_TYPE D1 ON T1.CONT_APP_TYPE=D1.CONT_APP_TYPE_ID WHERE T1.STATIS_DATE=20140101 AND (T1.CONT_APP_TYPE!=-1 ANDT1.CONT_APP_ID=-1 AND T1.CLASSIFY_ID1=-1)AND T1.CITY_ID=999 AND T1.COUNTY_ID=999 AND T1.SECTION_ID=999