I’m sometimes asked about my podcasting workflow, how SQPN goes about recording, editing, distributing, and promoting our shows. This is the second in a series of posts that explain the multiple steps that take me from the beginning to the end of the process for each show we produce. The first post described my hardware setup.
Before I record a podcast, there’s a certain amount of work that needs to be done. I keep track of all our shows and the individual episodes and where they are in the process using the relational database tool AirTable. The database is broken down into a series of views either by show title or specific filters like “In the edit queue” or “in the release queue”.1
Each record has the episode title, episode number, the date and time that the recording is scheduled (if any), the release date of the show, current status (i.e. idea, scheduling guests, recording scheduled, edit queue, posting scheduled, posted), series title, assigned editor, host, guests/co-hosts, episode description, editorial notes, link to the episode on the SQPN site, and then specialized fields related to particular shows (e.g. which Doctor is it, the Doctor Who season, Doctor Who or Star Trek original air date; the Mysterious World category; the Star Trek series and season, etc.) There’s also a database of the podcast panelists and guests and their contact information as well as databases for tracking the picks of the week for The Secrets of Technology and Let’s Talk.2