Supercharging Content Makers with Coda Hashtag Map

Explore

Gallery

Supercharging Content Makers with Coda Hashtag Map

Farid Sabitov

⁠

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

Coda⁠

. 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

Hashtag Types

Type

Definition

Discipline based

Based on the DesignOps Skill matrix. Working on preparing similar one for ProductOps

Engagement based

Based on the content creation engagement models, like doing events, call for speakers, sharing updates or writing articles

Tool based

Tools that I’m using the most like Coda and Figma

Topic based

Main focus areas from the

DesignOps Skill Matrix

⁠

. Similar for any ops practitioners. Ex.: metrics, coordination, accelerators, knowledge management

Trend based

Short trending topics out of Google Trends

https://trends.google.com/trends/explore?date=today%203-m&geo=US&q=product%20management

⁠

There are no rows in this table

⁠

LinkedIn Hashtag Map

Next I started going through the main platforms that I'm planning to use. It's

YouTube⁠

LinkedIn⁠

and

Twitter⁠

. After doing analysis on which hashtags are followed the most on

LinkedIn⁠

I found an interesting learning:

The plural or singular form of hashtags are important. Check #techonologies and #technology hashtag followers in
LinkedIn⁠
. The difference is almost 4000%

⁠

The cool part about

Coda⁠

, 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

https://www.linkedin.com/feed/hashtag/?keywords=ProductOps⁠

⁠

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

LinkedIn⁠

(based on the number of followers).

LinkedIn Followers

LinkedIn Followers

⁠

If you don't want to set number of followers as one of the column values in Coda, you can create a

Coda Pack⁠

. I'm using

Postman⁠

for testing different endpoints that I'm getting from Chrome Developer Console as cUrl. Let me know on

Twitter⁠

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

LinkedIn⁠

, I started to explore the ways how to do the same hashtag map for

YouTube⁠

. While working on the hashtag map, I found

vidIQ⁠

. 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

example⁠

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.

Hashtags Heatmap