A few years ago, I got fed up with the large amount of useless information in the database – schedule items that needed constant testing and maintenance that no visitor to the web site had tried to use in over a year. I did a massive purge at that time – the main casualties were Public Radio Shows, local hosts and things like Classical music. People don’t need to come here to find those things and Google doesn’t send them here.<\/p>\n
I just ran a similar analysis (but not yet purge) showing the count of schedule items (a program on a specific station at a specific time) that have not been used since January 1st 2013 (or never used). The instinct of volunteers is almost always “Let’s put everything in for every station”, which sounds nice until the volunteer loses interest.<\/p>\n
So here is the current list:<\/p>\n
\r\n+------------------------+-----------+\r\n| show | deadcount |\r\n+------------------------+-----------+\r\n| Jim Bohannon At Night | 47 |\r\n| Live on Sunday Night | 37 |\r\n| Ground Zero | 32 |\r\n| Red Eye Radio | 25 |\r\n| Dave Ramsey | 24 |\r\n| Yahoo! Sports Radio | 22 |\r\n| John Batchelor | 22 |\r\n| Prairie Home Companion | 18 |\r\n| Sean Hannity | 17 |\r\n| America in the Morning | 15 |\r\n| Local Talk | 14 |\r\n| Local Morning Show | 14 |\r\n| Local News | 13 |\r\n| Church Service | 13 |\r\n| Infomercials | 13 |\r\n| Scott Ferrall (CBS) | 11 |\r\n| Real Estate Today | 11 |\r\n| Fox Sports Radio | 10 |\r\n| At Home | 9 |\r\n| MoJo on CBS | 9 |\r\n| Somewhere in Time | 9 |\r\n| Local Investing | 9 |\r\n| Classical Music | 8 |\r\n| Diane Rehm | 8 |\r\n+------------------------+-----------+\r\n\r\n<\/pre>\nif I pull the list into older than January 1, 2014:<\/p>\n
\r\n+-------------------------+-----------+\r\n| show | deadcount |\r\n+-------------------------+-----------+\r\n| Live on Sunday Night | 76 |\r\n| Jim Bohannon At Night | 67 |\r\n| Ground Zero | 57 |\r\n| Dave Ramsey | 53 |\r\n| John Batchelor | 44 |\r\n| Sean Hannity | 35 |\r\n| Somewhere in Time | 32 |\r\n| Red Eye Radio | 31 |\r\n| Yahoo! Sports Radio | 27 |\r\n| Scott Ferrall (CBS) | 24 |\r\n| Rush Limbaugh | 24 |\r\n| Prairie Home Companion | 23 |\r\n| America in the Morning | 22 |\r\n| Local Morning Show | 21 |\r\n| Coast to Coast AM | 18 |\r\n| Jerry Doyle | 16 |\r\n| Local Talk | 14 |\r\n| Hannity Weekend | 14 |\r\n| MoJo on CBS | 14 |\r\n| Real Estate Today | 14 |\r\n| Free Talk Live | 14 |\r\n| Infomercials | 13 |\r\n| At Home | 13 |\r\n| Doug Stephan's Good Day | 13 |\r\n+-------------------------+-----------+\r\n<\/pre>\nIt’s probably worth mentioning that if someone clicks on the a radio station without clicking on the specific program, the system “imputes intent” that the listener probably intended to listen to the show currently on the air. <\/p>\n","protected":false},"excerpt":{"rendered":"
A few years ago, I got fed up with the large amount of useless information in the database – schedule items that needed constant testing and maintenance that no visitor to the web site had tried to use in over … Continue reading