Tuesday, 4 February 2014

How to Analyze Your Social Media Activities With Excel ~ Part 1

Are you looking for a way to analyze the impact of your content?
Do you need a simple system that works?
If you don’t have the budget for expensive software, spreadsheets and a little of your time can produce some useful data.
In this article I’ll show you how to analyze the engagement and impact of your social media posts using Excel.

Why Analyze?

No matter the size of your business, when it comes to social media you want to build two things: engagement and community.
To ensure that you deliver great content that resonates with your fans and followers, you need to track, test and measure the posts you put on your social networks.
It’s really that simple.
Here’s how:

#1: Build Your Spreadsheet

To begin, open Excel and create 14 columns that will contain the following categories to incorporate all of the information you need on your social media updates and posts:
  • Date
  • Network
  • Categories
  • Subcategories
  • Target
  • Calls to action
  • Meta-tags
  • Posts
  • Impressions
  • Comments (replies)
  • Likes (favorites)
  • Shares (retweets)
  • Clicks
  • Total engagement
An example spreadsheet (target, meta-tags, posts and impressions hidden).
The last four columns are where you store the engagement numbers for your content. Every network has three basic engagement actions: likecomment and share. Even on Instagram, which does not have a repost function built into it, there’s user behavior of reposting and tagging the original author.
Use this spreadsheet to store data and analyze your content.

#2: Identify Categories and Subcategories

You’ll need to decide on the information below and make a note of it before moving on to step #4 below where you fill in the spreadsheet.
Base your categories on the major topics of your posts and use them to identify major trends in content performance across each network. Examples of categories are:
  • Product: Posts about major product categories.
  • Holiday/seasonal: Posts with seasonal themes, which are especially helpful for e-commerce businesses.
  • Third-party content: Posts with content from other websites such as news, articles and blog posts.
Create as many categories as you like, but keep them manageable and general. Save the specifics for subcategories.
Break down categories into smaller subcategories. This enables you to identify microtrends, as well as which pieces of content work the best and the worst. Based on the categories above, examples could include:
  • Specific product names or features.
  • Specific names of holidays or campaigns you’re running for a particular season.
  • Specific website names from which you pull content or categories of topics for articles such as “humor,” “lifestyle” or “beauty.”
Subcategories can be as specific as you like, but keep them thematic. Each subcategory should have at least three posts; otherwise it may be too specific and better suited as a meta-tag (more on that later).
Keep your categories broad and use subcategories to drill down. Image Source: iStockPhoto.

#3: Outline Your Targets and Calls to Action

These two columns require the most forethought and a good understanding of your target market and business goals. You’ll need this information to fill out these columns on your spreadsheet.
The target is whom you’re speaking to with your content. Your business may have multiple targets based on the people and decision-makers who engage with your content and purchase your products. For the sake of simplicity, we will use “male” and “female” as target examples.
However, I encourage you to spend time considering the different types of people in your audience and build context around those individuals to inform your content strategy.
Calls to Action
CTAs take many forms, depending on the individual goals of the post in each category. Just keep in mind that not all posts need CTAs and not all CTAs must be related to products.
Examples of CTAs include:
  • Subscribe
  • Visit website
  • Buy now
  • Share
Enter your calls to action to help you monitor your success.
For a much deeper analysis on your types of content, you should use additional meta-tags to describe the individual elements of the content itself.
Keywords, image descriptions (such as person, object, colors, size or orientation) and even tone descriptors for the copy (such as humorous or excited) can be used as meta-tags.
These tags help isolate trends in creative content so you can select more engaging images and write more dynamic copy for your posts.


Post a Comment