My 2017 Instagram Best 9 Photos Data Visualization

Lots of folks are publishing a nice little montage of their best 9 Instagram photos using one of the many #Best9 apps available. I have two problems with these apps.

First, it’s not clear what constitutes best 9 from a measurement perspective. Likes? Comments? A blend? Sum? Average? Median? There’s really no way to know and no flexibility.

Second, it’s not clear how rigorous the various privacy policies of these apps are. When we connect an app to a social media account, it can request all kinds of permissions we may not want to give.

What’s a marketing data scientist to do? Create our own, of course. Using data from social media monitoring tools such as Crowdtangle, I built an interactive visualization of my Instagram Best 9. To use it, hover over any of the blue bars to see the associated photo.

Simply hover over the bars to see which photos made the cut based on the sum of engagements.

Want this for yourself? As long as you’ve got Tableau and a data source, you can make a copy of the workbook.

If you enjoy these photos, feel free to connect with me on Instagram at @cspenn.


You might also enjoy:


Want to read more like this from ? Get updates here:

subscribe to my newsletter here


AI for Marketers Book
Get your copy of AI For Marketers (2019 Edition)

Analytics for Marketers Discussion Group
Join my Analytics for Marketers Slack Group!


Pin It on Pinterest

Shares
Share This