Welcome, podcasters. This is where I show you how to use Airtable to better plan your episodes and better track your data.

YOUR BROADCASTING CONTENT

We’re starting – as always – in a Grid View, but you actually won’t live here very much. I still want to show you a little housekeeping around your set-up for this.

The first table will be titled Season One, and this is where we plan your broadcasting content. Once you have broadcasted everything in this table, you can simply duplicate it for Season Two. The trick is to not duplicate the records – which it will prompt you to select – when you duplicate the table.

Your broadcasting content fields

The first field for your records will be your Episode Names. I suggest you start by numbering them before filling in the episode titles. The logic behind this that when you want to sort through them, they’ll always be in order.

The next field will be your Stages of Production. You will create these by using the Single Select field type. What you use will depend on how you operate but in this video, I’ve created ::

  • BROADCASTED :: For episode that have already been put out into the world;
  • RECORDED :: When a recording is in post-production but hasn’t been broadcasted yet;
  • SCHEDULED/INVITED :: To identify episodes that are being prepared, but haven’t been recorded yet;
  • IDEAS :: To brain dump those genius thoughts you want to act on later.

The next few fields include ::

  • Your Broadcast Date;
  • The Length/Duration of your podcast episode;
  • Your Show Notes;
  • Your Episode URL;
  • The number of times your episode was Downloaded;
  • Your Sponsors – which is actually linked from another table (more on this in a moment)’
  • Your Social Links – also linked from another table., and to be explored in another table.

Your broadcasting content views

KANBAN VIEW

The next View I have set up is the Kanban View :: this View stacks those different episodes based on your Stages of Production. The benefit with this View is that you can move each of your Stages from one stage to another.

GALLERY VIEW

I’ve created a Gallery View specifically for the episodes that are Works-In-Progress. It is appropriately named WIP Gallery and I’ve applied two filters to the Stages field :: Broadcasted and Ideas. This way, the only episodes you see listed in this View are the ones you are currently working on or preparing for.

Another Gallery View for your Post-Production Gallery. In this View, you’re filtering only the episodes that have been broadcasted. When you need to grab a quick episode URL or if you want to analyze overall trends in your download numbers, for instance, this can be a handy View.

GRID VIEW

But back to that original Grid View because you may want to also track your topics. You could add a selection field to create a dropdown for each subject matter you cover. This field could be a valuable addition to your Post-Production Gallery to assess what topics get the most downloads and build your broadcasting strategy around what the people want.

YOUR SOCIAL CONTENT

Your social content fields

The first field is labeled TO DO or DONE. I’ve also added a filter that removes the record when it has been marked as DONE. This way, you’re only seeing the social content that still needs to be created.

The second field is linked to the last table and you can import each of your episodes here. Once you add an episode, go back to the first table and see how that appears. You see how you can now easily identify what social content is to be done and what has been done at a glance.

But what exactly has to be done? Looking back in the Social Table, I’ve created some suggested fields that you can take or leave as it applies to you. Some of my suggestions include ::

  • Templates;
  • Promotional material for your guests to use;
  • Tracking whether you’ve sent this to your guests;
  • Facebook images or content;
  • Instagram images or content;
  • Pinterest images or content;
  • YouTube images or content.

And once all of these fields are indicated as complete? You can change you first field to DONE.

TRACKING YOUR SPONSORS

The way I’ve set up your Sponsors table is fun because it automates the value – in dollars! – of the content you’re broadcasting. Let’s get the technicalities out of the way first.

Your sponsored fields

Your first field will be your Sponsor Name.  The next few fields are your sponsor identifiers, including ::

  • The type of ad you’re sponsored by;
  • The URL where the mp4 of your ad is stored;
  • Your contract – because you have a contract, right?;
  • The ad cost per episode.

The next field is linked to your first table. Each episode for which you are promoting that specific ad or sponsor should be populated into this field. Everything else snowballs from there.

Auto-calculate the value of your sponsorships

This table is available for download in the BONUS section of {AIRTABLE Like A Boss} but you can create your own table with the following settings ::

The following field automatically calculates how many times you promoted this sponsorship. This is accomplished using the COUNT field type to count how many episodes you’ve linked.

Our next field uses a FORMULA to calculate the overall revenue this ad has generated. The formula used here is :: {Cost Per Episode} * {# of promos}

Following this, I have the ROLLUP field type that is calculating the overall downloads for this add. The settings are such that you select the first table with all your episodes and you’re looking at the Downloads field. To roll up all of the Downloads from each of the episodes this ad has been used on, the formula SUM(values) will then sum up all the appropriate data.

Finally, I use another FORMULA field to calculate the value per single episode download. The formula used here is {Total revenue}/{Downloads}and voila! You’re tracking your own value and analytics.

I want to create on-brand content that always gets me paid or build my list