Music blog content tracker

Explore

From planning future blog posts and storing data about previous content, to organising my gig calendar and tracking playlists, this Airtable base has been structured around (and is dramatically increasing the organisation of) my independent music blog 'Cool Music and Things'.

​

While the base has been created with a music blog in mind, it's tables and features, which I'll explain in detail below, are transferrable across all kinds of blogs and I hope that you can make use of them!

​

The base focuses around a central 'Blog posts' table, featuring important data about previous posts, including the date, featured artists and URLs to the post itself and to related social media posts from myself and others.

​

The 'Post planning' table allows me to store ideas for future posts as and when they happen, tracking the progress of these ideas whether they eventually become published or lost in the blog abyss.

​

'Artists' uses some exciting Airtable features, connecting to multiple tables within the base to provide data about the artists, using the Count field type to sort artists in the order of those who have been featured most within the blog, added to most playlists and who I have seen perform most (read: the artists I'm giving the most love to.)

​

The 'Gigs calendar' allows me to keep a record of previous gigs attended whilst also storing data about upcoming shows that I'd like to attend, all in one place. The calendar view is particularly useful here in giving a visual display of upcoming events!

​

More efficient than a paper to-do list, the 'Tasks' table is a useful way of tracking things that I'd like to do for the site beyond blog posts, and encourages me to always look for ways to improve the blog.

​

As mentioned above, the 'Playlists' table connects to 'Artists' and provides interesting data there, whilst also keeping a useful record of some pretty cool playlists, if I do say so myself…

​

'PR contacts' is a pretty self-explanatory list of people in music PR whose submissions I've enjoyed and written about in the past - connecting to specific posts through the 'Blog posts' table enables me to order these by those who I have interacted with the most.

​

As an extension of the 'Gigs calendar', the 'Venues' table enables me to store data about the location of various music venues, and to see which venues I've visited the most.

​

Finally, the 'Stats' table is in its early days, but I hope to use it to keep a weekly record of social media followers (Facebook, Twitter and Instagram) and views on the blog itself. Tracking progress in this way should help me to encourage myself to push for more followers or to give myself a pat on the back when it's performing particularly well.

​

http://www.coolmusicandthings.co.uk/

https://www.facebook.com/coolmusicandthings

https://twitter.com/coolmusicthings

https://www.instagram.com/coolmusicandthings/

Explore
Updated January 18, 2018 at 9:30 PM
Copied 402 times

Megan Seekings

English Literature and Media graduate, blogger, bookseller
Explore the base
Main view
Shares of social posts
By stage
Main view - in order of total features
Gallery (to share)
Alphabetical view
By order of blog posts
By order of gigs on line-up
Main view - all gigs
Upcoming gigs only
Gigs attended
Calendar view
By stage
Main view
Main view
Main view
Main view