Although I check my Instagram feed multiple times daily and enjoy looking at pictures from my favorite pizza spots more often than I would like to admit, I don’t post on my own feed very much. So, when I was thinking about what I would like to explore with my Instagram data, I decided to keep it pretty simple.
What posts get the most likes on my Instagram account?
The short answer:
Pictures of me and pictures of me with my friends…in the month of April.
The long(er) answer:
I first joined Instagram in 2013, 3 years after its initial launch. At that point, it wasn’t nearly as popular or used as it is today. Not all of my friends had accounts yet, so when I first started posting I didn’t get many likes per post. To this day I only allow people I actually know to follow my private account, so as more people I knew joined Instagram my likes count per post continued to grow as well (pretty intuitive).
I have received the most likes per post within the last 3 years and 3 of my most liked 5 posts were all in the month of April. The content that does the best for me are pictures of myself, but not selfies, or me doing things outdoors with my friends. This isn’t too surprising to me since I only interact on Instagram with people I have met face-to-face. Following the logic of my own behavior/interactions with people I know on Instagram, it is fun to see where people are in their lives or see how they’ve changed, which garners more attention = more likes.
I used a very simple SQL code to query my Instagram data and visualized it in Metabase. You can take a look at my likes over time since joining Instagram in the graph here.
This is the SQL code that powered this query: