终端制式用户分析.xls

端制式用户分析报表 查询条件 日分析 地域 内内容容类类型型 使使用用用用户户数数 人人 iphone2G2G智智能能终终端端TDTD智智能能终终端端 新闻资讯类别78969056416111484002 沟通交流类别83456582889722508789 休闲娱乐类别69380267536642030990 生活服务类别95170490388172766107 文化教育类别2044624026164167 未知类别74520772576172073704 合计 98140496679072963574 使使用用流流量量 MB MB 2G2G非非智智能能终终端端TDTD非非智智能能终终端端其其他他iphone 81357764770433526275309 69 16894231162216535531300766 77 118990491020553302706433 23 2141061239046741230578410 31 588173576173661539 87 3227644124527868202329882 99 406805325903810127693192342 86 端制式用户分析报表 查询条件 日分析 地域 使使用用用用户户数数 人人 2G2G智智能能终终端端TDTD智智能能终终端端2G2G非非智智能能终终端端TDTD非非智智能能终终端端 1485663 18498501 24138407 1319900 10 8911143 222993918 48984609 5584777 42 5696521 783414581 67770338 92182648 14 7234367 293492139 371057858 37176938 23 22490 176749 486091 35382 74 2862405 051822538 06542919 34159984 84 26212590 6912228428 303500224 68624631 47 端制式用户分析报表 查询条件 日分析 地域 使使用用流流量量 MB MB 户户均均流流量量 MB MB 人人 其其他他iphone2G2G智智能能终终端端TDTD智智能能终终端端 119970 330 350 260 34 732473 421 561 081 19 655287 771 020 841 68 867775 470 610 801 26 1664 280 080 090 11 445752 880 440 390 88 2822924 153 252 714 13 端制式用户分析报表 查询条件 日分析 地域 使使用用流流量量 MB MB 上上行行流流量量 MB MB 2G2G非非智智能能终终端端TDTD非非智智能能终终端端其其他他iphone 0 170 310 2817467 12 0 580 731 12102403 46 0 652 011 1842544 92 0 490 741 1787621 18 0 100 110 10181 21 0 171 280 5143857 35 0 862 412 79294075 24 端制式用户分析报表 查询条件 日分析 地域 户户均均流流量量 MB MB 人人 2G2G智智能能终终端端TDTD智智能能终终端端2G2G非非智智能能终终端端TDTD非非智智能能终终端端 134403 6645527 8314875 381773 80 893305 15298471 63117934 689056 34 422309 08174858 9572638 588780 36 1147853 24372830 35165554 6518170 97 3504 48957 76860 4758 72 412132 54144492 05117790 519731 73 3013508 141037138 57489654 2747571 93 端制式用户分析报表 查询条件 日分析 地域 上上行行流流量量 MB MB 下下行行流流量量 MB MB 其其他他iphone2G2G智智能能终终端端TDTD智智能能终终端端 11903 82257842 571351259 52452973 41 78928 931198363 318017838 082695446 85 44162 44663888 315274212 703239722 72 127588 40490789 136086514 063119309 02 241 701358 6618985 695791 72 57397 99286025 642450272 511678046 00 320223 282898267 6223199082 5611191289 73 端制式用户分析报表 查询条件 日分析 地域 上上行行流流量量 MB MB 流流量量占占比比 2G2G非非智智能能终终端端TDTD非非智智能能终终端端其其他他iphone 123531 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 8910 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 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 COUNT AS GSM INTEL USER COUNT T1 TD INTEL USER COUNT AS TD INTEL USER COUNT 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 AS GSM INTELI FLOW T1 TD INTEL UP FLOW T1 TD INTEL DOWN FLOW 1024 1024 AS TD INTELI FLOW T1 GSM UNINTEL UP FLOW T1 GSM UNINTEL DOWN FLOW 1024 1024 AS GSM UNINTELI FLOW T1 TD UNINTEL UP FLOW T1 TD UNINTEL DOWN FLOW 1024 1024 AS TD UNINTEL FLOW T1 TERM NET OTHER UP FLOW T1 OTHER DOWN FLOW 1024 1024 AS OTHER FLOW T1 IPHONE 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 AS GSM INTEL AVG T1 TD INTEL UP FLOW T1 TD INTEL DOWN FLOW T1 TD INTEL USER COUNT 1024 1024 AS TD INTEL AVG T1 GSM UNINTEL UP FLOW T1 GSM UNINTEL DOWN FLOW T1 GSM UNINTEL USER COUNT 1024 1024 AS GSM UNINTEL AVG T1 TD UNINTEL UP FLOW T1 TD UNINTEL DOWN FLOW T1 TD UNINTEL USER COUNT 1024 1024 AS TD UNINTEL AVG T1 TERM NET OTHER UP FLOW T1 OTHER DOWN FLOW T1 TERM NET OTHER USER COUNT 1024 1024 AS OTHER AVG T1 IPHONE UP FLOW 1024 1024 AS IPHONE 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 1024 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 FLOW T1 IPHONE UP FLOW T1 IPHONE DOWN FLOW 1024 1024 3192342 8586 AS IPHONE FLOW PRECENT T1 GSM INTEL UP FLOW T1 GSM INTEL DOWN FLOW 1024 1024 26212590 6945 AS GSM INTEL FLOW PRECENT T1 TD INTEL UP FLOW T1 TD INTEL DOWN FLOW 1024 1024 12228428 3012 AS TD INTEL PRECENT T1 GSM UNINTEL UP FLOW T1 GSM UNINTEL DOWN FLOW 1024 1024 3500224 6764 AS GSM UNINTEL FLOW PRECENT T1 TD UNINTEL UP FLOW T1 TD UNINTEL DOWN FLOW 1024 1024 624631 4701 AS TD UNINTEL FLOW PRECENT T1 TERM NET OTHER UP FLOW T1 OTHER DOWN FLOW 1024 1024 2822924 1483 AS OTHER PRECENT FROM TASST TAS