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.

If you enjoyed this, please share it with your network!

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

subscribe to my newsletter here

Marketing Blue Belt
Get your copy of Marketing Blue Belt!

Order your 2018 Marketing Planning Framework
Download your 2018 Marketing Planning Framework!

Subscribe To MyNewsletter

Subscribe To MyNewsletter

Enjoyed the content here? Make sure you never miss anything important. Subscribe to my free weekly newsletter, Almost Timely!

You have Successfully Subscribed!

Pin It on Pinterest

Share This