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