I’ve decided to go forward with the big data purge mentioned by me a number of times over the years, although I’m still refining the rules.<\/p>\n
The basic concept is that most visitors realize after a while that when listening to a syndicated talk show, it doesn’t really matter which station you’re listening to – as long as the station carries the show when you want to hear it, the audio quality is good, and the commercials are not too obnoxious. You probably don’t listen to your local radio station for “local news” as they probably carry national news at the top of the hour. If you’re lucky, you hear 30 seconds of “local news” that the station ripped off by paraphrasing the local newspaper front page at 5 am (three days ago).<\/p>\n
Maintaining 260 schedule entries for Rush Limbaugh – 245 of which are from Noon-3PM (ET) – is a lot of work for little to no benefit to the visitors. I refuse to spend significant time listening to Rush talking about birth control.<\/p>\n
\r\n+------------+----------+--------+\r\n| lstarttime | lendtime | scount |\r\n+------------+----------+--------+\r\n| 1200 | 1500 | 245 |\r\n| 1200 | 1300 | 5 |\r\n| 1300 | 1600 | 3 |\r\n| 1400 | 1700 | 3 |\r\n| 1200 | 1400 | 1 |\r\n| 1400 | 1600 | 1 |\r\n| 0 | 500 | 1 |\r\n| 1600 | 1900 | 1 |\r\n+------------+----------+--------+\r\n<\/pre>\nYou might actually want to know the station that carries Rush at 4 PM (ET) or overnight. <\/p>\n
So which stations do people actually listen to Rush on when visiting this web site? If you’re a radio industry consultant, you’ll immediately answer “WABC-AM of course!”, but you could NOT BE MORE WRONG.<\/p>\n
People that live in the New York City area don’t need to go to Google to find a station carrying Rush Limbaugh – they go right to the station’s web site. Visitors here are people who CANNOT find a syndicated show on a local radio station, or can hear the station, but not inside their office building at work, or the local station carries the show at a time they can’t listen and they don’t want to pay for a podcast subscription<\/p>\n
So here is the top 50 list for Rush (this is all time – I’m going to refine this to be only recent activity):<\/p>\n
\r\n+------------+------------------+--------+-------------+----------+\r\n| streamname | CityName | Statex | listencount | pctTotal |\r\n+------------+------------------+--------+-------------+----------+\r\n| WVNN AM | ATHENS | AL | 238149 | 16.6404 |\r\n| WCOA AM | PENSACOLA | FL | 228242 | 15.9482 |\r\n| WRVA AM\/HD | RICHMOND | VA | 72280 | 5.0505 |\r\n| KID AM | IDAHO FALLS | ID | 49539 | 3.4615 |\r\n| WSBA AM | YORK | PA | 45508 | 3.1798 |\r\n| KOA AM\/HD | DENVER | CO | 40729 | 2.8459 |\r\n| KFAY AM | FARMINGTON | AR | 30953 | 2.1628 |\r\n| WTVN AM\/HD | COLUMBUS | OH | 29288 | 2.0465 |\r\n| KOGO AM\/HD | SAN DIEGO | CA | 25477 | 1.7802 |\r\n| WHAM AM\/HD | ROCHESTER | NY | 20277 | 1.4168 |\r\n| WHO AM\/HD | DES MOINES | IA | 20228 | 1.4134 |\r\n| WAAV AM | LELAND | NC | 19460 | 1.3597 |\r\n| WISN AM\/HD | MILWAUKEE | WI | 18903 | 1.3208 |\r\n| WBAP AM | FORT WORTH | TX | 17423 | 1.2174 |\r\n| WLS AM | CHICAGO | IL | 17334 | 1.2112 |\r\n| KLBJ AM | AUSTIN | TX | 17240 | 1.2046 |\r\n| WMXI FM | LAUREL | MS | 15633 | 1.0923 |\r\n| WMAC AM | MACON | GA | 14225 | 0.9940 |\r\n| WBCK FM | BATTLE CREEK | MI | 13221 | 0.9238 |\r\n| KTWO AM | CASPER | WY | 12431 | 0.8686 |\r\n| KRMG AM | TULSA | OK | 11932 | 0.8337 |\r\n| KBOI AM\/HD | BOISE | ID | 11901 | 0.8316 |\r\n| WPGB FM\/HD | PITTSBURGH | PA | 10272 | 0.7177 |\r\n| KSCO AM | SANTA CRUZ | CA | 10255 | 0.7166 |\r\n| WMMB AM\/HD | MELBOURNE | FL | 10042 | 0.7017 |\r\n| WFLN AM | ARCADIA | FL | 9742 | 0.6807 |\r\n| WROK AM | ROCKFORD | IL | 9441 | 0.6597 |\r\n| WFNC AM | FAYETTEVILLE | NC | 9067 | 0.6335 |\r\n| KMAJ AM | TOPEKA | KS | 8232 | 0.5752 |\r\n| WLAC AM\/HD | NASHVILLE | TN | 8216 | 0.5741 |\r\n| KCRS AM | MIDLAND | TX | 8186 | 0.5720 |\r\n| WOKV AM | JACKSONVILLE | FL | 7277 | 0.5085 |\r\n| WKRC AM | CINCINNATI | OH | 7050 | 0.4926 |\r\n| WMT AM\/HD | CEDAR RAPIDS | IA | 6714 | 0.4691 |\r\n| KEX AM\/HD | PORTLAND | OR | 6650 | 0.4647 |\r\n| KNRS FM\/HD | CENTERVILLE | UT | 6638 | 0.4638 |\r\n| WOOD AM | GRAND RAPIDS | MI | 6383 | 0.4460 |\r\n| WREC AM\/HD | MEMPHIS | TN | 6342 | 0.4431 |\r\n| WSPC AM | ALBEMARLE | NC | 5952 | 0.4159 |\r\n| WFLA AM\/HD | TAMPA | FL | 5622 | 0.3928 |\r\n| KSFA AM | NACOGDOCHES | TX | 5396 | 0.3770 |\r\n| KNZZ AM | GRAND JUNCTION | CO | 5379 | 0.3759 |\r\n| KREI AM | FARMINGTON | MO | 5368 | 0.3751 |\r\n| WNTK FM | NEW LONDON | NH | 5104 | 0.3566 |\r\n| WMAL AM | WASHINGTON | DC | 4924 | 0.3441 |\r\n| WOWO AM\/HD | FORT WAYNE | IN | 4663 | 0.3258 |\r\n| WHAS AM\/HD | LOUISVILLE | KY | 4553 | 0.3181 |\r\n| KVOR AM\/HD | COLORADO SPRINGS | CO | 4375 | 0.3057 |\r\n| WJBO AM | BATON ROUGE | LA | 4373 | 0.3056 |\r\n| WTVN AM\/HD | COLUMBUS | OH | 4342 | 0.3034 |\r\n+------------+------------------+--------+-------------+----------+\r\n\r\n<\/pre>\nI’m undecided how to set the cutoff – “Less than x% of the total” would be pretty easy to do – I would like something more along the lines of “the top 5”, but that is not so easy to do in MySQL (at least with my skill level)<\/p>\n
This probably will happen in a day or two. This is your last chance to provide your input so I can ignore it.<\/p>\n","protected":false},"excerpt":{"rendered":"
I’ve decided to go forward with the big data purge mentioned by me a number of times over the years, although I’m still refining the rules. The basic concept is that most visitors realize after a while that when listening … Continue reading