Facebook (Page) Insights Dashboard with Tableau

Here is an attempt at creating a Facebook Insights dashboard using Tableau. The objective of creating this dashboard was to help the content creator with scheduling the content.  To accomplish this, I simply used the ‘Page level’ data exported from one of my experimental Facebook pages’ insights. (You can access the insights dashboard for your pages here.)

The dashboard gives an insight into which day of the week works best for the page. You can click on different weekdays to monitor the performance of your content strategy on those days. As an extension to this dashboard, I now want to try to blend the ‘Post Level’ data and get better insight into ‘what type of posts work best for the brand’ on top of ‘what days of the week work better’. Also, if you have access to the demographic data (what I call ‘People level’ data), you can dig deeper into metrics like ‘engagement’ and ‘reach’ for each post based on more meaningful segments like country, age and gender.

Dashboard 1

Related Articles:

DIY: Analytics Driven Social Media (Facebook) [Parth Acharya – Blog]

Brand New Excel Add-in: Data Explorer (And How to: Social Media Analytics) [Parth Acharya – Blog]


Microsoft Excel Add-in: GeoFlow… and Data Visualization

In October 2012, I wrote a blog post on how to use Google Fusion table for Data Visualization. The data used in the example is from my Facebook Page Librans when the page fan count had reached number 100. The visualization (in mentioned blog) portrays how those 100 Librans are placed on World map with the help of Google Fusion Table.

A few weeks back, the page reached number 200 and I was thinking how else can I place those fans on global map, if I don’t use Google Fusion Table. That was essentially the time when Microsoft launched an Excel Add-in, GeoFlow (with other new features like one more Excel add-in Data Explorer) in PASS Business Analytics Conference 2013.

Here is what I was able to do with GeoFlow

(Fundamentally, GeoFlow let me create a virtual journey through all the countries ‘Librans’ on my Facebook page are from. Later, I recorded a video of it to make the journey presentable on social platforms.)

On visualization front, you can try different themes to change the way globe looks; you can change the way your data points look; you can also change the speed at which the globe rotates.

GeoFlow can prove to be useful when you have data that can be sliced based on location.

I would be glad to discuss other use cases or domains GeoFlow can be used in. Please feel free to share your thoughts.

Download GeoFlow here.

%d bloggers like this: