Content Management Master List for Authors with image of spreadsheet

Content Management Master List for Authors

Can you easily find information on any of your published works? What about the Amazon link for your first book? The publication date of a certain blog post? What about the link to the podcast episode you were a guest on last year?

If you said no to any of these, you need to create a master list to help manage your content. With this one list, you have access to all of your content. This enables you to create a marketing strategy while also helping you manage your intellectual property.

What Is A Master List?

A master list is a listing of all the content you have created or been involved with. 

I find a spreadsheet easier to work with but a database or text document may work for you.

What Goes On A Content Management Master List?

The content that you create or are a part of creating. This is not just the books you write. It also includes blog posts, podcast episodes, YouTube videos, guest posts, short stories published by others, and so on.

The information you need to keep track of may vary depending on the media, so consider different sheets or sections for different media. Since I use a spreadsheet, I prefer a different sheet for each. Here are some examples:

Blog posts – title, URL, original date of publication, date of updates/revisions, date published elsewhere (Medium, LinkedIn), URL if published elsewhere, shortened link (if using a link shortener).

If you do an audio or video version of your blog/articles, you need to keep track of that information as well. Link to where it is hosted, date published, etc. You may want to add this with your post information or keep a separate list for audio and video. Play around with it to see what works for you.

Podcast/YouTube episodes – same basic information as blog posts, but also include a link to the corresponding blog post/transcript if there is one.

Guest posts, articles, short stories published by others – again, same information as your posts, plus name of publication, editor/owner name, and when/if rights revert back to you. Consider adding the social media handles of the blogger/publisher so you can tag them when you share the link.

Podcast interviews – episode title, number, podcast name, host, link and the host’s social media handles so you can easily tag them when you share the episode.

Books – of course! However, this one is going to be complex if you publish wide and in multiple formats. In fact, consider keeping a separate sheet for each book. What you may need:

  • Title
  • Date of publication
  • if additional editions/revisions, add date of each
  • link to each online retailer
  • if use Book Funnel, include the link to that page as well
  • link to each format
  • video trailer
  • cover – artwork
  • box sets it is part of

Do I Really Need This?

Yes!! First, this is your content. Having the information in one place lets you easily create and implement a plan to market your work. Even if it isn’t content you have rights to, such as a podcast interview, you want to share it with your list and on social media. The master list gives you a place to keep track of all of it.

Second, this is your intellectual property. You need to record so you know what you have. If you have sold any rights, you can add that to your master list to keep track of what is yours, what you have sold, and if/when rights revert back to you.

The topic of intellectual property is huge, well beyond the scope of this article. To begin to get a grasp on it, please read the series of posts Kristine Kathryn Rusch is writing. She sees a change in the writing business with a focus on intellectual property and licensing. Here’s the first oneYou can follow the series by clicking on the Business Musings category at the top of the post.

Just Begin

This can all seem overwhelming, especially if you have a lot of content. So start small. Pick one thing, blog posts or podcast episodes, work through them, then move on to the next. The main thing is, just start. 

As you begin adding to your master list, you may realize that you need to change things around. Maybe it makes more sense for you to put all the information about a blog post together. Maybe you prefer to keep audio information together and separate from the written version information. Find a system that works for you and use it.

For You To Do

I’ve got a blank spreadsheet template set up you can use. It is free to download when you join my list for writers. You can edit it to suit your needs: move columns around, switch sheets, delete columns that don’t apply, and add ones that do. Customize it to suit your needs and career.

Do you have a master list to manage your content? Is it up to date? If you don’t have one, will you get started today? Leave a comment and let me know.


Looking for other tools to manage your writing? My Submissions Spreadsheet can help you keep track of where you send your work, whether to publishers or for guest posting. The post gives you instructions on using and a link to click to download. No sign-up required!

1 thought on “Content Management Master List for Authors”

  1. This is such a good idea. It’s the kind of thing I do for my clients but never for myself – you know that expression the cobbler’s child goes without shoes? That’s me! It’s really good for repurposing content, too.


Leave a Comment