Happy early 4th: free tool to help time your Facebook posts

Recently, Daniel Ho, Director of Marketing at Optimal, Inc., posted on the importance of timing Facebook posts for maximum engagement. I thought it was a compelling post and decided it would be nice to create a simple Excel tool to help you do just that. To use it, simply: 1) click on the icon below; and 2) download an Excel copy.

facebook posts time of day calculator

This sucker’s going to revolutionize your posting schedule.

download file in Excel

The tool, which I’ve generically named ‘Time of Day Calculator’, has four sheets, one of them hidden. The three sheets that you can see include one called Graphs, which is where your data will be mapped, PageData, and PostData.

The latter two are where you need to pitch in a helping hand – download your Facebook Insights data in a <strong>CSV</strong> format, one sheet for your Page level insights and one sheet for your Post level insights, and then copy + paste all the data from those sheets into their respective sheets within the Time of Day Calculator. The data will then be visualized for you on the Graphs sheet.

The only step you need to take to ensure full functionality is to drag the last figure for ‘Lifetime The total number of people who have liked your Page. (Unique Users)’ (it should be Column H on your Page Level Insights CSV, although they do tend to change it around).

You need to do this because the values for those cells for the most recent few days are always blank. This is because Facebook doesn’t tally those final numbers until a few days later, which causes some trouble with the functions in the back end. If you really want accuracy, you can get the missing Total Page Likes for those days manually from your Insights dashboard and do a little arithmetic.

On the Graphs sheet, the data is visualized into scatter charts with trend lines on a day-by-day basis.

time of day graph

The first chart shows you the overall best times for your content. Be aware that this tool can only show you what you give it; if you don’t post at 6:00 PM on a Saturday, it will be unable to reflect how valuable that timeframe might be for your content.

It’s an Excel tool, and there are quite a few moving parts; I’m positive some of you will break it, so, when you do, please let me know what went wrong in the comments so I can try and fix it for future users.

About Dan Wilkerson

Dan Wilkerson is Marketing Manager at LunaMetrics, a Google Analytics certified partner that also specializes in social media, search engine optimization, and PPC. You can follow him @notdanwilkerson or @LunaMetrics.
This entry was posted in Advertising. Bookmark the permalink.

4 Responses to Happy early 4th: free tool to help time your Facebook posts

  1. Dan says:

    Very cool! Just downloaded it…look forward to playing around with the sheet.

    • Dan Wilkerson says:

      Hey Dan,

      Glad to hear it! Let me know what you think.

      (Other) Dan

      • Dan says:

        Had a bit of a challenge aligning the data (Fb might have changed some of the columns / added new ones with their insights updates), but the info you can pick up is very cool!

        Thanks again!

  2. Anonymus says:

    Would be nice, but cannot use, the coluns had no name, the orders are different… and there are more than on the keymetrics sheet.

Leave a Reply

Your email address will not be published.

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>