My week's goal is to improve my process of content creation. I will share some of the cool stuff I came up with during this journey with some supercharged workflows using
. In this article, I would like to speak about hashtags.
First, I started with an understanding of which groups of hashtags I would like to use in my posts around ProductOps and DesignOps. So, as a result, I had discipline, engagement, tool, topic, and trend-based hashtag groups in Coda.
Hashtag Types
0
Search
Type
Definition
1
Discipline based
Based on the DesignOps Skill matrix. Working on preparing similar one for ProductOps
2
Engagement based
Based on the content creation engagement models, like doing events, call for speakers, sharing updates or writing articles
, is that it's Excel on steroids. To simplify my process, I just added a new column as a button and added a formula. The button formula opens a hyperlink with hashtag text at the end
This small improvement helped me to quickly go over all hashtags and provide values in the table.
When I finished adding all the values, I created a pie chart view out of my table to see things at scale. It is an interesting observation which #ops related hashtags are the most popular on
As you can see above, there is a way to pull the amount of followers for a specific hashtag right out of the main request and just splitting the response based on the "followerCount" text.
. The product looks impressive and can help content makers like me to accelerate their growth. I don't know how exactly they are getting the search volume and calculating competition but for my goal I just needed to go through the main hashtags and save all the values in Coda. An interesting observation from the hashtag map:
Product Management is more popular on LinkedIn than Design by 400%. But Design is more popular on Youtube than Product Management by 160%.
I love working with data and discover patterns in it. Now I'm feeling more confident on which hashtags to use and most importantly, I'm not spending time on finding which hashtags performed well for me and how specific hashtags are performing on different platforms.