How To Get The Most Out Of Facebook Insights

By Rachel Hadley

People in the social media industry are generally very creative– and sometimes creative people are not particularly analytical. In order to calculate social media ROI, you need to be comfortable with numbers.  Likeable provides its clients with a monthly analysis of Facebook data. It ultimately helps us determine the best time, day and format to reach and engage fans in the future. Even if numbers aren’t your thing, here are a few tips that can help you make the most of Facebook Insights.

Facebook provides an astounding amount of data in Insights, which you can export into an Excel file. The most important thing you can do to easily translate what all that data means is to create a pivot table. If you don’t know how to create a pivot table, you can learn very quickly.

First you’ll need to export your page-level and post-level data. The key metrics tab on each sheet contains a lot of useful information. Just a few calculations can give you a nice snapshot. Instead of creating tons of formulas within your key metrics tab, create a few pivot tables that will do all of the work for you.

Below are a few examples. After creating the table, you can highlight and bold key numbers that stick out. For example, in the chart below, engagement rate (engaged users/reach) was extremely high at the end of 2012. While the engagement rate has dropped in 2013, the average reach, engaged users, people talking about this and new page likes has increased.

Page level data by DATE:

Page Data by DATE

Post-level data by TYPE of post:

Post Data by TYPE

After you export post-level data, you can add a few fields to better analyze the results.

Insights Added Column

By creating a column for weekday using the formula “=WEEKDAY(cell)” and time, which you can round to the nearest hour using the formula “=(TIME(HOUR(cell),MROUND(MINUTE(cell),60),0))”; you will be able to see how your posts perform on certain days and during different times of the day.

Post Data by DAY

In Excel, 1=Sunday, 2=Monday, etc. The above chart shows us that engagement rate is highest on Sundays, Fridays and Wednesdays and reach is highest on Tuesdays, Wednesdays and Mondays.

Post Data by TIME

While the majority of posting on the page example above happens between 8 a.m. and 4 p.m., fans are highly engaged with posts made outside of those hours as well. From an engagement standpoint, the best time to post is 11 a.m. and 4 p.m. Early morning posts had the highest reach.

Numbers and charts can be overwhelming, but once you understand the easiest way to calculate those numbers and the best way to translate what they mean, you’ll be able to understand your fans better and serve them content that they value at the best time to reach the most fans at once.

What interesting data have you pulled from Facebook Insights to fine tune your Facebook strategy? Share in the comments below.

[...] [...]
[...] Internet loves cats. And yes, you could spend your days trawling through a Matrix-like stream of Facebook insights, looking for the viral edge your brand desperately needs to take engagement rates to the next [...]
treb072410 October 23, 2013
Great tip! Thanks for sharing the insight!..
Deon Fialkov October 23, 2013
Never knew facebook pages gave you information about who unliked the page ... is that a new option ? Also how many fake profiles should one allow in their page or should one not care seeing that only the admins of the page can see them ?
[...] Click here to view original web page at Share this:FacebookRedditDiggStumbleUponGoogle +1Pinterest [...]
Mari Smith October 22, 2013
Great post. Horrible title. Very unlikeable. I might've shared this with my peeps, but not with that title. :(
Rachel Hadley October 23, 2013
Hi @MariSmith:disqus, I heard a lot of both positive and negative feedback on the title yesterday. Thankfully, I heard only positive feedback on the content. I appreciate your comments and have changed the title to something more likeable. This has been a great lesson learned for me!
carrie kerpen October 22, 2013
Hey @MariSmith:disqus -- thanks so much for your feedback. I heard this from a few ppl, I've emailed the author for her consideration. Glad you found the content useful, though. xoxo. - Carrie

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>