Build Your Author Platform With This Free Marketing Spreadsheet

Build Your Author Platform With This Free Marketing Spreadsheet

You know by now that whether you write fiction or nonfiction, growing your author platform is key.

Connecting with readers before, during and after you write your novel showcases your commitment to agents and publishers—and creates an audience for your work.

But with the myriad ways to find readers, it can be overwhelming to get started and stay consistent. Should you blog? Focus on your email list? Be more active on Twitter or Instagram? Or try something else entirely?

Defeat marketing anxiety

After I started my writing podcast, I wanted to find new ways to reach out to potential listeners.

I decided to boost my Twitter presence, get on Instagram and restart my newsletter. But with limited time (I want to write, too!), I kept putting off posting and hitting “send.” I felt like I couldn’t get a handle on my platform.

I’m a big fan of spreadsheets–I already use one to track my submissions to lit journals and magazines. But it took me a while to realize that I could use a spreadsheet to fight the overwhelm I felt when I went on Twitter or checked the traffic to my website.

The day that I did, I started posting.

Maximize your marketing with this handy spreadsheet

A spreadsheet–you can download your very own customizable copy of mine here (it even comes with instructions)–can help you in several ways.

First, it allows you see the entire picture.

Your platform might have several pieces: social media, blogging, guest posting or other venues where readers find your work. Noting where you are sharing what can keep you from saying the exact same thing over and over again. It can also help you remember to share your content in different places; you can turn a guest post (like this one) into a tweet and a link for your newsletter.

A spreadsheet can also help you see which avenues are most effective for your goals.

By keeping tabs on traffic to your website, you can narrow your focus to the most useful tactics for you. I’ve had a lot of fun connecting with fellow writers and podcast listeners on Instagram, but you might get more traffic via Twitter or YouTube.

Focus on what works

Tracking your efforts can also keep you from getting discouraged.

Rather than feeling lost and unsure of what to try next, you can look at what has worked and what hasn’t and adjust your course. You’ll have a record of what you’ve done that you can check against blog traffic, newsletter sign-ups or content downloads.

For example, I kept track of podcast downloads after sharing each episode on social media; instead of feeling bummed whenever downloads stayed flat, I used this data to help me decide where to spend my time.

Time is what it all boils down to: writers, perhaps working at another job or taking care of family, have very limited time, and marketing can easily eat up most of it, leaving little for you to actually write. My spreadsheet doesn’t track every single tweet you send-;what it does is give you space to brainstorm and plan what you want to say in each place that you share your work, so that you can spend an hour or two planning, and then just a few minutes checking in each day or each week.

Make it work for you

Whatever system you use to plan your marketing, make it work for you.

I used my spreadsheet for a few weeks, then tweaked it to reflect what I actually needed: a sheet for each place I shared my work, with columns for dates, ideas and whether or not content had be scheduled or posted.

This system maintains my sanity, maximizes my writing time, and keeps me from reinventing the wheel every time you log on to Twitter. You can add more detail (what time to post) or less (I include space for links and images) so that it does the same for you.

Download your copy here–and please share tweaks that make it better for you!

How do you get a handle on your platform?

Filed Under: Marketing


  • Kim says:

    Well…I clicked on the download link…but there doesn’t appear to be a way to download or save it…

  • Hi Alicia,

    You are right. There’s no gain in trying to do everything at the same time. The best option remains focusing on only the things that work. Find and do them over and over again as long as you are seeing positive result. If it’s an ad campaign, keep running it. In fact, increase it. This is is how success is achieved.

    Thanks for sharing.


  • SS says:

    Thanks for the spreadsheet

  • Mush says:

    I too LOVE spreadsheets and get overwhelmed with all my paper lists of good ideas and how to market them.

    I liked your newsletter tab, but am going to change mine to a subject list for articles I want to write. I get great ideas, but then have to chase all the pieces of paper or electronic notes I created in the moment. I can use this to compile them and actually write compelling content my readers are looking for. I might also add a tab to track questions my audience is asking for prompts to new articles.

    I also want to add an article tab for articles that are already written. Then I will track where I have shared them (Facebook, other blogs, print, etc.). This will work better for me than separating each platform because I frequently post links to content in several places.

    Thank you for an excellent idea!

    • Mush, thank you for the awesome ideas! I think tracking articles already written and where shared is a brilliant idea. It might also help you to re-share later, since some folks probably missed it the first time around. Hope the spreadsheet works well for you! –Alicia

  • Paulo Cesar says:

    Hi Alicia Reyes: ‘Lost and unsure’ we share that in common though not for haven’t gotta time to write down. Mostly i would like to invite you to take a read to my post in word press or at Inkitt.Com straight to take a look to my book ‘Dark Corcel’ you’ll realize more than anything I’d like to have the right place or meet the promoter which will consider unbiased my work, help me to elaborate the feedback process and publish it.
    thanks for your time; Going on with your ideas.

Speak Your Mind

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.