Rachel Melia

How To Create a Facebook Reporting Template

My most popular post of all time was on social media reporting templates, so I wanted to share updated information.  Here are some tips about what to include in a Facebook reporting template as well as an example.  You can add other social media properties to compare high level performance.

First as some background..  There is ALOT of data available.  Facebook Insights has great data.  And if you are using a social media management tool like HootSuite or Sprout Social, those have great information also.  Google Analytics also provides valuable data.  And there are other free and paid tools like PageLever, etc.

All this data is great, and can be very useful for understanding and improving your efforts. But it can also be overwhelming.  At the end of the day, it’s important to track several key high level metrics.  Many set up a simple reporting dashboard to do this.

You’ll want to include Facebook metrics like total Likes, new Likes and unlikes, as well as reach, and engagement rate.  You’ll also want to include metrics that track performance against business objectives including traffic to your blog or website, mentions, improved brand sentiment, leads or email opt-ins, reduction in customer service calls, sales, and revenue.  Here is a simple reporting dashboard that can be tweaked for your business’ unique objectives and reporting capabilities.

facebook reporting template

How To Measure Your Social Media Efforts

You have likely dipped your feet in the social media waters.  And maybe you have been at it for a while and are experiencing some success.  The next step is to implement ongoing reporting.  After all, what gets measured gets improved upon. 

In this post I am going to focus on no-cost and low-cost reporting solutions that make sense for consultants and small businesses. 

The first step is to decide what to measure.  Here are some important metrics:

  1. Audience size – Facebook Likes, Twitter Followers, LinkedIn group Members, blog subscribers etc. This allows you to see the rate at which your properties grow organically and the rate at which they grow with various efforts.
  2. Interaction – Facebook Likes (Likes of articles), Comments and wall posts, Twitter Retweets and @Mentions, LinkedIn Likes and Comments, blog comments etc.  This allows you to see how interaction is affected by the different types of content you post.
  3. Your activity – Facebook posts, Tweets, LinkedIn Discussions, blog articles, etc.  This allows you to correlate your level of activity with growth and interaction.
  4. Clicks – Use a free url shortener like bit.ly to track clicks from articles, blog posts, events, etc. that you post to social media properties.  The number of clicks gives you an indication of the types of content that is appealing to your audience as well as number of people you are driving to registration forms, website content, email opt-ins, etc.
  5. Actions – You can track various actions like registrations, e-mail opt-ins, and revenue by using a pull-down menu in your form, or setting up tracking urls for each property. Use Google Analytics to track how many people come to your site from your social media properties.
  6. Unique visitors, visits, and page views – Track these metrics on your blog using Google Analytics.

The second step is to develop a template.  Here is a sample template:

Social Media Reporting Template

If you are a consultant and this looks like more than you want to do, then scale it down to the most important metrics of growth, interaction, and actions.  If you have more resources to devote to measurement, you can dive deeper into other metrics available on Facebook Insights and Google Analytics.  And, if you have a small budget and want to cut back on the manual labor you can use tools like Hootesuite’s Pro version that is only $6/mo and provides stats like link click-throughs, as well as integrates with Facebook Insights and Google Analytics.

The last step is to decide how often to measure.  In my ad agency days, we pulled client reporting weekly.  For consultants and most small businesses, I think monthly (or even less if time is an issue) is just fine.

Now you are ready to measure and improve upon your social media efforts.

If you have other metrics you measure or helpful social media measurement tools please share as a comment!

Add to FacebookAdd to DiggAdd to Del.icio.usAdd to StumbleuponAdd to RedditAdd to BlinklistAdd to TwitterAdd to TechnoratiAdd to Yahoo BuzzAdd to Newsvine


Get every new post delivered to your Inbox.

Join 50 other followers