Stop Flying Blind, 2013 Social Media Planning Spreadsheet

by Lisa Peyton on Jan 03, 2013

Social media is big. It is unwieldy. And it grows thicker and more complicated with each day.

Fear not. 

With some simple planning, self-reflection and research, you can harness the ‘beast’ that has become social media. Whether you are totally new to technology and the online space or are an industry veteran, around since its inception, the following plan will help you build a solid foundation for social media success.

This methodology can be applied to managing personal social media profiles and provide a basic foundation for a solid business social media strategy.

I have created a Social Media Planning Spreadsheet that outlines MY plan and can serve as the perfect template for yours.

It’s time to OWN your social media in 2013!

Phase 1: Planning and Research

The first and most important step is asking yourself what you TRULY want to accomplish by creating and updating social media profiles.

If after some thoughtful self-reflection you realize you AREN’T looking for a new job, a better career path, more clients, more contacts, more influence, maintaining connections with friends and family AND want to live entirely ‘off the grid’, then perhaps social media is NOT your ‘thang’. IF you DO want any of these outcomes then it’s time to determine which are the most important and WHY.

Goals and Objectives

Many of us have rushed into creating a social media profile before actually asking the question ‘why?’ This may have left you fumbling to create constant updates with no real sense of purpose which is a waste of time and can lead to feelings of resentment and even anger. It’s time to go back to the drawing board and take a look at your overall objective.

Your overall objective should be fairly broad and have a DIRECT impact on something VERY important to YOU. It can be an overall business objective, an overall personal objective or both. Your objective should also be measurable and time sensitive. This will ensure you have the means to measure your social media success and hold yourself accountable for meeting your goals.

Last year, I had one very simple objective for my social media activities. I wanted to provide consistent and valuable updates to my network of social media and digital marketing professionals, thereby organically growing my business network by a certain percentage over the twelve month time span. This year, I want to take my strategy to the next level and incorporate a plan for my personal contacts as well.

Audience

When diving into your overall objective, it’s essential you explore who you are trying to reach. If your approach is strictly business, then your overall objective is likely tied to revenue or compensation. This doesn’t mean that your social media strategy should be directly tied to revenue, but it does help to determine a target for your efforts. You’ll likely want to reach and engage with potential customers, employers or folks that INFLUENCE these groups.

A more personal approach may include audience segments such as friends from the gym, distant family members, co-workers, drinking buddies, etc. Each of these segments has very specific needs and expectations regarding your involvement on social media. So ask yourself if connecting with these groups will help you meet your overall objectives.

Tools like Vizify.com allow you to get a glimpse into the demographics of your current social media followers.

Research

Before finalizing your objectives and audience segments, go out and gather some data to help drive your planning. If you are currently maintaining several social media profiles, take the time to determine WHO is already a follower, fan or ‘liker’. Tools like Vizify.com’s Tweetsheet can show you stunning stats about your Twitter followers and help you learn about the demographics of your current online community.

For more qualitative data, I recommend surveying your current followers and fans. By conducting a brief survey of your current community, you can determine if they can be segmented, what information they find valuable and if engaging with them will help meet your overall objectives. If you are just getting started and don’t have an ‘online’ community, start by surveying those you know in the real world.

Tools like SurveyMonkey.com make creating an online survey easy and cost-free. If you’re looking at conducting a more robust survey, I highly recommend reading Hubpspot’s guide to using surveys in your marketing. The insight you can gain from a survey of your colleagues, friends and family is invaluable at helping to determine your target audience segments and if you are currently meeting their needs. If you don’t have time to conduct a full-blown survey, simply start asking for direct feedback on your current social media efforts or lack thereof.

Self Discovery, Google-style

Google’s Ad Preview and Diagnosis tool allows you to get organic search results without personalizing them based upon your browsing behavior.

The ONE thing I ALWAYS do before meeting with potential clients is ‘Google’ their name, the name of their business and take a look at their online profiles. Take the time to Google variations of YOUR name and the name of your business or company.

Scan the top several pages of results and determine IF you are visible and if so, do the results speak to how your want to be represented to your target audience. Due to Google’s ability to personalize your search results, I would recommend using a tool like the Google Ad Preview tool.

This tool will display organic search results without personalizing them based upon your prior browsing behavior.

Whether you like it or not, there are likely social media profiles floating around the web that house information about YOU!

Klout.com scrapes sites such as Twitter and will assign a ‘Klout score’ to users that haven’t even signed up for an account. How about that LinkedIn account you created years ago and haven’t looked at since, it’s only 15% complete. Or that Twitter account you created and abandoned in 2010?

The point is that Google can and will FIND any assets that house your name and display them for all searchers to see.

Before embracing your new social media plan, it’s essential you audit the current state of your online visibility and build fixing any hiccups into your planning.

Phase II – Building your roadmap

After completing your research and determining your objectives, it’s time to choose your channels.

Now that you have taken the time to determine your objectives, target audience and current state of your online profiles, it’s time for the fun stuff!

Channel Selection

There are thousands of social media networks and platforms and it’s impossible to participate in them all. Even building communities around a handful of networks can be a full-time job. Before selecting which social media channels you want to participate in, determine how much time you can commit to your social media activities and then prioritize based upon your objectives and P.I.T’s or Passions, Interests and Talents.

If your objectives are more business focused, then considering platforms that are used by business professionals would be the way to go. LinkedIn has become the largest and most active network of business professionals online and should be part of ANY strategy to grow a professional network. LinkedIn users now have the ability to create updates and post via a newsfeed, just like Facebook. Creating consistent LinkedIn updates that meet the needs of your target audience can help you reach your overall business objectives.

For more personal objectives and reaching out to friends and family, Facebook will likely be your channel of choice. It is also, of course, the largest GLOBAL social network and almost EVERYONE has a profile, so it can be a key channel for everyone from brand marketers to small business owners.

Apart from these obvious choices, there are several other platforms that are among the most popular and can provide access to your target segments. They include sites such as:

  • Twitter
  • YouTube
  • Google+
  • Instagram
  • Foursquare
  • Pinterest

When determining your platform of choice, consider these key factors:

  • Who
    Examine WHO is using the platform. Studies, reports and infographics are floating around the web that outlines social media user statistics. Make sure your chosen platform speaks to your target audience.
  • What
    Be sure to align the type of media on each platform with your passions, interests and talents or PITs. If you LOVE digital photography then choosing a community that promotes and supports that medium might prove to be a good choice.Instagram is one of the fastest growing communities that centers around digital photography. Even if you efforts are business focused, there may be a creative way to incorporate photography and rich media into your strategy. For inspiration, look no further than this recent Social Fresh article, ‘Top Brands Succeeding at Instagram and What You Can Learn From Them’.
  • Why
    Does engaging on your selected network help to meet your overall objective? This might be a tough one to determine up front but read on to learn how to incorporate metrics and measure your success.

Content Strategy

Determining specific channels is only half of the social media battle. You will also need to create a plan around the type of content you will be posting and sharing with your community. Be sure that each overall objective is supported by thoughtful content that speaks to your target audience segments.

After conducting my initial research, I discovered that my 2012 plan to only post business themed updates WASN’T serving a large portion of my community. A close friend shared with me that she didn’t understand my Facebook updates and she was left feeling confused. Social Media Plan = FAIL. This feedback helped to drive my decision to strategize BOTH my personal and professional posts and to explore segmenting my business posts from those that are more personal.

Phase III – Commitment and Accountability

Once you have determined your active social media channels, it’s time to commit to regular updates. Try to come up with a schedule that is realistic and consistent. If you have time to update your profiles daily AND you have enough valuable content for daily posts – then GO FOR IT! I would argue that for some this may not be a realistic expectation and updating weekly may be more achievable.

My posting schedule for 2012, daily business updates Monday through Friday, was something I was striving for AND for the most part was able to achieve. I considered my audience, WHEN they were online and tried to produce updates during those times. There are a bevy of time-saving tools that can be used to help streamline your updates, but that’s a whole different blog post!

It’s also ESSENTIAL you schedule time to ‘listen’ and respond on each active channel. Social media isn’t a one-way conversation and simply spewing out updates isn’t a good strategy for anyone. Taking the time to thoughtfully respond to other posts, photos, questions and conversations will help you learn more about your community and ultimately make you a better communicator.

Measurement

The Social Media Planning Spreadsheet outlines my plan for 2013 and can be a GREAT template for yours. It includes a tab for measurement, where you can track your metrics monthly. Simply add your own content under each tab, following the key points outlined in this article.

Once you have established your plan, it’s important to come up with a few metrics to help hold yourself accountable and to determine if you’re getting closer to your ultimate objective. The ‘Measurement’ tab on the Social Media Planning Spreadsheet allows you to track your metrics monthly.

Looking back at my objective for 2012, organically growing my business network by a certain percentage over the 12 month time span, I can come up with a few simple metrics to measure this outcome.

Tracking these metrics weekly or monthly can then help to determine if I’m on the road to reaching my goal by year’s end. I strongly recommend setting up a simple spreadsheet and committing to updating your metrics regularly. Try to incorporate metrics that not only speak to the size of your community but also the engagement level.

My metrics for 2012 may have looked something like this:

  • # of LinkedIn connections
  • # of Twitter followers
  • # of RT’s, Replies and mentions on Twitter (via Tweetreach.com)
  • # of Google+ circlers
  • Klout score

Is it worth it?

All of this planning may seem like TONS of work and it will take time.

However, the time you will save from useless updates on platforms where nobody is listening will more than make up for this initial investment.

Not only will you maximize your effectiveness and meet your objectives, you will also begin to see the fruits of your labor. Seeing monthly improvements in your social media metrics will help fuel your efforts and keep you inspired to continue your regular updates. Thereby creating a SNOWBALL EFFECT of social media success!

How do you plan on managing your social media profiles in 2013?

Got any time-saving tools that help you stay on track? Please share your insights with the community by adding your comments.

 

Social Fresh EAST 2014 is July 16-18 in Orlando. Featured speakers: Spotify, Yahoo, Logitech, Dunkin Donuts, PGA Tour, JetBlue >> Reserve your ticket now.

Post Author

Lisa is a leader in the field of digital marketing. Based in Portland, OR, she serves as executive editor at TMMPDX.COM and teaches digital strategy at Portland State University. Her services include social media coaching, content strategy and digital...

  • Ali

    Dear Social Media Goddess,

    What a great thing to provide to people, perhaps there are not many left, like me who really haven’t got a clue – what a kindness to lay something like this out so clearly – even if I can’t make myself make the time to follow up on these suggestions, reading what you have here has helped me understand what the rest of the world is doing.

  • http://twitter.com/DarlasRock Darla Schoenrock

    Very smart social media strategy, Thank you for the Social Media Planning Guide download and links to some of the tools you mentioned in the article.

  • http://twitter.com/RankWatch RankWatch

    Loved the way you have detailed out every particular topic and especially in the right order. Optimizing and planning your site according to the Organic search results holds an important place in the recent marketing trend.

  • http://twitter.com/Lafi87 Mohammad Lafi

    Beautifully written, however, sadly the download link isn’t working, alternative link?

  • http://twitter.com/JHDenverSEO Jennifer Holzman

    This is great, Lisa. My social media management is all about Google Drive Spreadsheets- it makes this so much easier

  • Kate McLaughlin

    Awesome after searching for an hour, I found the content I was looking for, Thanks!

  • Cecily Quintana

    Happy New Year Lisa! This is a fantastic, but most importantly, useful article. I am leading pro bono marketing workshops to Native American and First Nation artists for the Native Arts and Culture Foundation. With your permission, and credit given, I would love to share this content with the participants. Let me know – Cecily Quintana