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

38 comments

 
 

Facebook Hashtags: This Week in Social Media

social media researchWelcome to our weekly edition of what’s hot in social media news. To help you stay up to date with social media, here are some of the news items that caught our attention.

What’s New This Week?

Facebook Launches Clickable Hashtags: Clickable hashtags are rolling out on Facebook. “When you click on a hashtag in Facebook, you’ll see a feed of what other people and Pages are saying about that event or topic.”

facebook hashtags

"Similar to other services like Instagram, Twitter, Tumblr or Pinterest, hashtags on Facebook allow you to add context to a post or indicate that it is part of a larger discussion."

32 comments

 
 

6 Twitter Analytics Tools to Improve Your Marketing

social media toolsDo you know if your Twitter marketing is working?

Monitoring and analyzing your Twitter projects can be challenging.

With the right metrics, you can improve and tailor your Twitter campaigns for better results.

Luckily, third-party Twitter tools provide these metrics, but there are MANY tools to choose from out there.

So here I’ll share some of the best Twitter analytics tools to help you improve your Twitter marketing.

#1: SocialBro: Explore Your Community

I consider SocialBro one of the top three most effective marketing tools for businesses.

SocialBro comes with excellent analytics that give great insights not only about your marketing campaign, but also about your Twitter account and followers.

Here are the analytics tools available with SocialBro.

Real-time Analytics

Real-time Analytics gives you details of the people who are active users and have tweeted in the last 10 minutes in real time. This helps you determine the specific hour of the day when people are active.

It’s a quick way to know when you should be tweeting. This is more relevant than depending on studies done by others, because it’s tailored specifically for you and your Twitter community.

79 comments

 
 

3 Ways Twitter Analysis Can Enhance Your Marketing

social media how toTwitter is a powerful marketing tool.  But have you considered using the power of Twitter to enhance marketing efforts—social media or not?  This article will show you how.

Most people talk about Twitter in terms of getting to know people, building lists and using followers.  But for marketers and business owners, that’s just the start.

The Laser Focus of Twitter

One of the reasons I prefer Twitter to Facebook is that it’s much more focused, and in that regard, is much more business-oriented. As opposed to Facebook, where business and social are separated by pages and profiles, Twitter combines it all together in an easy-to-follow format.

39 comments

 
 

Building Your Business One Tweet at a Time: Twitter Marketing 101

social media book reviews“You want me to use Twitter to market my business?” I hear you asking. “How do I generate leads and promote my business by telling my friends what I had for lunch?

Yes, many people just use Twitter to share their day with their friends. Friends who may live 2,000 miles away.

And some people use it to broadcast a breaking news story as it happens. Like the time a plane crash-landed in the Hudson River. A man in a nearby boat with an iPhone got the “scoop” on that story before the news media reported it.

43 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
Check out our sister publication: My Kids' Adventures