Showing posts with label Databases. Show all posts
Showing posts with label Databases. Show all posts

Saturday, 13 November 2010

The Pilot Project

In 2010, we took a first step to curating a national archive of new independent music. There's a long way to ago...

On Thursday 18th November 2010, at 7pm, I was a happy man, if slightly apprehensive. That’s when the Pilot Project website went live. Before then it was an idea and a holding screen. Now, it’s something else altogether. Over a thirty month spell of planning, cajoling and nagging, The Pilot Project has gone from a rough concept to a really solid website, packed with good stuff.  It’s done so with considerable help from some truly great people, and a very welcome grant from Digital Content Development at the Arts Council. And it’s given me craft satisfaction, the likes of which I haven’t felt for ten years. Then it was a huge classical database, built from scratch for lovely RTE lyric fm. That was great fun and very worthwhile. 

This is too, and it could turn out to be even better.

Wednesday, 7 April 2010

Case Histories and conclusions

The Track Record page here and on my website has turned out to be of the most consistently visited pages. To build on this, I’ve just gussied my website with some of the more interesting Selector case histories. If you’re at all interested in music scheduling in radio, there may be stuff to glean; feel free to help yourself. 

The case histories are, in chronological order:

BRMB-FM / Xtra-AM: the highs and lows of introducing computer scheduling. Very early 90s.
BBC Radio 2: putting in a multi-genre library, along with the BBC's very first digital playout rig.
Swedish Radio P4: developing client skills in hugely varied markets.
RTÉ lyric fm: working collaboratively with passionately involved production staff to build not so much a database as a knowledge base. The polar opposite of most implementations.
UTV Radio: upskilling staff and debugging inherited nightmare scheduling conflicts.
Coast 106: swimming successfully against the UK radio stream with a larger than normal library.

In this diverse range of situations, there are some common threads...
First : dialogue, up and down the chain of command,  is good. In fact, in my view it’s not so much good as essential. While many radio stations implement a rigid schedule from above, normally for ease and simplicity of management, some of the best ideas and approaches evolve from engaging with the staff who work with the system. Nobody is right all the time. If there is a conflict, either with content or with programming, it’s often very useful to examine that conflict in minute detail, so see if there is a better way to do things. Best to leave your ego at the door, though. I won’t name the middle manager who loved the idea of challenging his boss on music issues, but hated the idea of talking to his own staff about those same issues.

Second: We’re in the era of tiny databases. In the US, they’re now talking about cutting down from 150 to 50 songs. However, almost all the above case histories show ratings success allied to larger libraries. 

Third: A note to managers: large databases can be a pain to keep tidy. And talking to your staff about programming issues can be a hassle you could do without. Things can get emotive. It can eat into your time, and not everybody has that luxury. But I suggest that if you actually care about what you do, you’ll benefit from putting in that time. Radio is still full of passionate people. You’ll get the best out of those people if you meet them halfway, here and everywhere else where ideas can be shared and debated.

Thursday, 4 February 2010

How do I know my Selector Mood Codes are right? Selector Tip 1

New feature. I’ve been a Selector wrangler for over half my career; it’s partly how I make my living.

I’m going to post a regular series of tips. Most of these cover editorial approach, which I think is an area that gets left behind. Some tips will apply to other scheduling systems. If you like what you see, or if you know someone who might, pass them on. If you really like what you see, get in touch by replying directly to this post (bottom of the post, below) or through the website link in the Work-Related pane at left.

Tip 1 is about finding your Centre Of Gravity - the midpoint of your Mood or Energy values.


The overall balance of station sound depends hugely on how you classify songs. Typically stations code their songs for Mood or Energy (occasionally both), on a scale of 1 to 5. 1 is catatonic, 5 is extremely in your face.

This is, naturally, a very subjective area. So it really helps to get a very clear idea of what the mid-ground Mood value is for your station. That’s what I mean by Centre of Gravity.

Here’s a recipe:
- Open up a list of all your active songs.
- If you have coded songs for Mood or Energy, sort them by this field.
- Now look in the middle area to find, say, three songs that are absolutely bang in the middle of the Mood range for your station. That's your benchmark.
- Work out from there. Work back up the list, and measure every song against your new standard.
- Then go down the list the other way. I guarantee you’ll find some surprises.
- If you have a big library, break it down into Categories first. This can be heavy going.
- If you haven’t set values at all - shame on you - the process is still the same. Find three benchmark songs, and work out from there.

- By the way, this is hard work. Fatigue can set in. You probably won't get it done in one session. Take your time to get it right.

After you've done that initial re-evaluation, do some analysis work to see if you’ve set the Mood or Energy rules up right for what you’ve actually got. That’s a tip for another day.