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