How to Analyze Your Social Media Activities With Excel

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

2 comments

 
 

6 Facebook Marketing Tips for Managing Your Facebook Page

social media how toWondering what works and what doesn’t for your Facebook page?

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.

edit-facebook-settings

You can add/remove admins directly from the Admin panel.

4 comments

 
 

How to Know if Your Social Media Activities Are Working

social media how toDo you know if your social media strategy is working?

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.

facebook-admin-insights

Facebook Insights are found in the admin panel of your page.

1 comment

 
 

Facebook Engagement: How to Get Seen in the Facebook News Feed

Do you want to understand Facebook engagement?

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

Social Media Marketing Podcast w/ Michael Stelzner

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

In this episode, I interview John Haydon, author of Facebook Marketing for Dummies and founder of Inbound Zombie, a consultancy focused on small- and medium-sized nonprofits.

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 Now

You can also subscribe via iTunes, RSS, Stitcher or Blackberry.

4 comments

 
 

How to Improve Your Facebook Engagement Using Controlled Experiments

social media how to Are you wondering what type of Facebook post works best?

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.

Why Experiments?

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.

best post types

Take a look at the best post types for your page.

3 comments

 
 






Check out the Social Media Marketing Podcast!
Check out our Blogging workshop!
Join our Social Media Marketing Networking Club
Download the free Social Media Marketing Industry Report