• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
  • Skip to footer

Social Media Examiner

Your Guide to the Social Media Jungle

  • 🔥 Free Newsletter
  • ⭐ FREE Web3 Course
  • 🗓️ Our Events
    • Social Media Marketing World (Mar 13-15)
    • Other Industry Events
  • 💡 Society
  • ⚙️ Tools
  • 🎙️ Podcasts
    • Social Media Marketing Podcast
    • Social Media Marketing Talk Show
    • Web3 Business Podcast
    • Our YouTube Channel
  • 🎯 Partner With Us
    • Podcast Sponsorship
    • Email Sponsorship
      • Email Newsletter
      • Dedicated Email Blast
    • Event Sponsorship
      • Social Media Marketing World
    • Tools Sponsorship
  • 👋 About Us
    • Our Story
    • Articles
      • Web3
      • Instagram Marketing
      • Facebook Marketing
      • YouTube Marketing
      • LinkedIn Marketing
      • TikTok Marketing
      • Expert Interviews
  • Search
  • Social Media Marketing World10th annual. Biggest industry event. Get the recordings!IMPROVE YOUR MARKETING

    How to Analyze Your Social Media Activities With Excel

    by Merlin U Ward / January 30, 2014

    social media how toAre 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
    categories-columns
    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: like, comment 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.

    Categories

    3 Days of World-Class Training—Zero Travel!

    Social Media Marketing World

    Travel to Social Media Marketing World off the table? Get all of the great content at a fraction of the price with an On-Demand ticket.

    That’s full access to recordings of every keynote, workshop, and session—the ones people travel thousands of miles to see. Don't wait. Get your On-Demand ticket and enjoy actionable content that you can watch anytime, anywhere.

    GET YOUR ON-DEMAND TICKET NOW

    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.

    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).

    create-subcategories-istock-image
    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.

    Target

    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:

    Tools Resource Guide

    Looking for something to make your life easier?

    Discover the tools we recommend to drive engagement, save you time, and boost sales across your entire marketing funnel or business.

    Whether you need help planning content, organizing social posts, or developing your strategy, you’ll find something for every situation.

    FIND YOUR NEXT FAVORITE TOOL
    • Subscribe
    • Visit website
    • Buy now
    • Share
    calls-to-action-column
    Enter your calls to action to help you monitor your success.

    Meta-tags

    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.

    #4: Collect Your Data

    Time to fill in your spreadsheet! There are a number of ways to do this, depending on the networks you use.

    Below is an example of a spreadsheet for a retail company using the above-defined categories, subcategories, targets and meta-tags.

    example-spreadsheet
    Populate your spreadsheet with post details.

    There's a lot of information to gather, but it's all easy to find.

    Twitter Analytics has an Export feature for your last 500 tweets, and Facebook Insights can be exported in 180-day chunks. Export regularly to make sure your data is current.

    Use a tool like bit.ly to keep track of your link clicks. If you tend to post the same link multiple times, make sure you're attributing your click to the right content by using tools like HootSuite‘s Click Report or BufferApp to track which specific posts generate the clicks. Each of these tools has free versions that allow you to measure posts on multiple networks.

    #5: Sort Your Data

    To identify your best-performing content across all of your networks, sort the Total Engagement column in descending order.

    engagement-sorted-spreadsheet
    Sort by Total Engagement.

    The best-performing posts in terms of engagement show at the top of the column.

    post-sorted-spreadsheet
    After sorting by Total Engagement, your most successful posts show at the top of the spreadsheet.

    To find the best-performing posts for specific social networks like Twitter or Instagram, filter first by Network, then by Total Engagement.

    twitter-sorted-spreadsheet
    Filter your spreadsheet to find the posts with the highest engagement on each network.

    #6: Analyze Categories

    The next step is to manually filter for the categories and subcategories you're interested in reviewing.

    filtered-spreadsheet
    This spreadsheet is filtered to show only Product category posts.

    Excel is very literal, so if you include more than one category or subcategory assigned to content, you'll need to use the “contains” input in the Excel Filter feature, rather than selecting the check boxes. Use this setting to see the rows in the column that have multiple subcategories assigned, and those with just one.

    multiple-filtered-spreadsheet
    Use the “contains” filter to show Product category posts that cross into multiple subcategories.

    Once you identify the top posts in your categories, it's time to analyze them for post copy, sentence structure and images (if applicable). What trends can help you optimize content for each network?

    Here are examples of three posts that promoted the same link.

    sweater-posts-comparison
    A comparison of three posts promoting the same link shows that engagement was highest with men.

    In this case, analysis shows that the shorter post lengths received more engagement. Among these similar posts about sweaters, the post using two different images generated a higher click-through rate with males than with females.

    Conclusion

    You don't have to rely on intuition to find out which posts perform best for you. Use Excel to reveal important insights about post engagement in nearly real time and make more informed decisions about your content strategy.

    What do you think? How are you currently measuring the impact of your content? Do you have other strategies or tools that you use? Please leave your questions and comments in the box below.

    Images from iStockPhoto.

    Get Your FREE Course: Web3 for Beginners

    Web 3 for Beginners

    Curious about Web3, but don't know where to start or who to trust?

    Introducing Web3 for Beginners, a course taught by Michael Stelzner, the founder of Social Media Examiner.

    Learn the basics of Web3 and apply it to your business with this FREE comprehensive course.


    CLICK HERE TO GET FREE ACCESS

    About the authorMerlin U Ward

    Merlin is an author, marketer, strategist, and beer geek! His book “You Get What You Give” explores five distinct social media marketing strategies that strengthen the customer and brand relationship.
    Other posts by Merlin U Ward »

    Get Social Media Examiner’s Future Articles in Your Inbox!

    Get our latest articles delivered to your email inbox and get the FREE Social Media Marketing Industry Report (39 pages, 50+ charts)!

    Industry Report Cover

    Worth Exploring:

    Facebook

    Marketing Help Explore More →

    Instagram

    Marketing Help Explore More →

    YouTube

    Marketing Help Explore More →

    Linkedin

    Marketing Help Explore More →

    Web3

    Marketing Help Explore More →

    Social Media Marketing Industry Report

    Get Free Report →

    Social Marketing Trends

    The data you've been missing!

    Need a new plan? Discover how marketers plan to change their social activities in the 14th annual Social Media Marketing Industry Report. It reveals what marketers have planned for their social activities, content marketing, and more! Get this free report now and never miss another great article from us. Join more than 400,000 marketers!

    Enter your email to get
    our free report:


    Footer

    Your Guide to the Social Media Jungle
    Copyright © 2023 Social Media Examiner®
    All Rights Reserved. Terms of Use | Privacy Policy.

    Helpful Links

    • About us
    • Our content via email
    • Our podcasts
    • Our YouTube channel
    • Our live show
    • Our industry report
    • Sponsorship opportunities
    • RSS
    • Accessibility