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.
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.
#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:
- Calls to action
- Comments (replies)
- Likes (favorites)
- Shares (retweets)
- Total engagement
Or are you overwhelmed with all of the Facebook tactics you read about?
No matter how long you’ve had a Facebook page, it’s good to review some of the basics for creating a page for your business.
This article includes six simple tips that will make you a more effective admin and make your page more professional starting today.
#1: Check Your Wall-posting Preferences
Does your page get a lot of, ahem, critical commentary on its timeline? Or maybe just more than you have time to deal with easily? If so, it might be time to set your page’s Posting Ability tab so that only your page admins can post.
Here’s how: Choose Edit Page from your Admin panel. Then choose Edit Settings.
Are you looking for an easier way to track your social activities?
In this article I’ll show you how to find the most valuable social data and actionable insights.
The result, improve your social media strategy on Facebook, Twitter and Pinterest.
Finding the Needles in the Haystack
As marketers, we’re on a mission to track and measure our efforts and their success.
We collect information on almost everything you can think of, from purchase history and demographics to psychographic data and everything in between.
The abundance of data has opened up a complicated web of options.
It’s important to know how to find the useful data that helps us make strategic decisions.
The following three tips will help you focus on what matters.
#1: Review the Posts Tab on Facebook Insights
Facebook has given marketers access to a ton of useful information with their Page Insights. Most people use this data to measure their success. We’re going to look at how to use it to refine your strategy.
Timing Your Posts
Start by going to your Facebook page and clicking on See Insights in the navigation bar at the top of the admin panel.
Are you looking for Facebook engagement tactics that lead to news feed visibility?
To learn how to better use Facebook, I interview John Haydon for this episode of the Social Media Marketing podcast.
More About This Show
The Social Media Marketing podcast is a show from Social Media Examiner.
It’s designed to help busy marketers and business owners discover what works with social media marketing.
The show format is on-demand talk radio (also known as podcasting).
John shares why Facebook engagement is so important.
You’ll learn how to better engage Facebook fans.
Share your feedback, read the show notes and get the links mentioned in this episode below!
Listen NowYou can also subscribe via iTunes, RSS, Stitcher or Blackberry.
Are you struggling with getting engagement or reach on your Facebook posts?
You may have heard that you need to post more photos or more questions or more photos with questions…
But what really works best for your audience?
In this article, you’ll learn how to find out which types of Facebook posts work best for your page.
Running controlled experiments from time to time will help you discover what works on your page so you won’t have to take someone elses word for it.
It’s also a great way to help you come up with a posting structure that may help you streamline your content creation in the future.
#1: View Insights for Ideas
In your Insights section, you do have some data on your best post types (under Posts), but that can be a function of what types of content you have been posting lately. So you may not get the whole picture if you haven’t been posting many links recently. But it’s a good place to start your investigation.