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.
LinkedIn Hashtag Map
Next I started going through the main platforms that I'm planning to use. It's , and . After doing analysis on which hashtags are followed the most on I found an interesting learning: The plural or singular form of hashtags are important. Check #techonologies and #technology hashtag followers in . The difference is almost 4000%
The cool part about , 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 Concatenate("https://www.linkedin.com/feed/hashtag/?keywords=",thisRow.Tags)
So you can open any hashtag information by just following a specific URL like 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 (based on the number of followers).
If you don't want to set number of followers as one of the column values in Coda, you can create a . I'm using for testing different endpoints that I'm getting from Chrome Developer Console as cUrl. Let me know on if you would like to learn more about Coda Packs. 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.
Youtube Hashtag Map
After finishing with , I started to explore the ways how to do the same hashtag map for . While working on the hashtag map, I found . 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%.
The way how I created open on Youtube button is:
Concatenate("https://www.youtube.com/hashtag/",thisRow.Tags)
Here is an of the Youtube Hashtag info page. To accelerate the process, I created a button for VidIQ: Concatenate("https://app.vidiq.com/channels/ff98d062-14e7-4bff-bdd8-cb0defb2f65f/keywords/overview/?term=",thisRow.Tags.EncodeForUrl().Lower())
Conclusion
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.
Useful resources
for more global hashtags overview; for future automations if you would like to create your own Coda Pack;