Using the Post Level Data, focus on the following columns: Post ID, Message, Posted, and Lifetime Post Total Reach. You will also need to be able to remember this formula: (Lifetime Post Total Reach/Page Likes)=Reach Percent
With this formula, you will be able to determine a multitude of discoveries about your page including:
The Best Day to Post on Facebook
The Posted Column contains the date and time. Divide the list into days of the week. Using the formula, calculate the average reach percent for each day to determine the best/worst days to post.
The Best Time to Post on Facebook
Set a range of time slots that can create a large enough sample size (e.g. 6:00-8:00 AM). Divide The Posted Column into each respective time slot and calculate the average reach percentage for each time slot.
How Many Posts Each Day
Divvy Posted column into the respective day. Find the average reach percent for each day. Categorize this data into two segments: days when you post once or twice and days when you post more than 3 times. Find the average of the two segments to determine how often one should post on a daily basis.
How Many Posts Each Week
Divvy Posted Column into respective weeks. Find the average reach percent of each week. Categorize this data into two segments: weeks when you post 1-4 times per week and weeks when you post 5+ times each week. Find the average of the data for the two segments to determine how often one should post on a weekly basis.
Best Type of Post
Separate Posted into the following categories: links, photos, videos, polls, and status update only. Then find the average reach percentage in each category and compare.
Best Length of a Post
Using a character counter, determine your post lengths. Then, divide Posted into posts with 1-80 characters and posts with 81+ characters (you’re welcome to divide it even further if you like). Then, calculate the average and compare.
Best Post Structure
Categorize your posts with “Fill in the Blank” and non-“Fill in the blank” and then determine the average reach percentages of both.
While this may come across as tedious, learning to master analyzing your page’s Facebook Insights can help you post the status updates that will generate the strongest impressions and avoid posting the ones that garner tepid responses.