Supercharging Content Makers with Coda Hashtag Map

Explore

Supercharging Content Makers with Coda Hashtag Map

Hashtags

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

Hashtags Heatmap

Type

Tags

View on LinkedIn

LinkedIn Followers

View on Youtube

Youtube Videos

Youtube Channels

View on VidIQ

Search Volume

Competition

Overall Score

Trend based

Layoffs

Open in LinkedIn

15,359

Open in Youtube

1,200

694

Open in VidIQ

15,831.5

12.96

Discipline based

ProductOps

Open in LinkedIn

189

Open in Youtube

Open in VidIQ

1,352.3

2.22

ProductManagement

Open in LinkedIn

3,603,014

Open in Youtube

8,200

1,100

Open in VidIQ

166,547.1

38.14

DesignOps

Open in LinkedIn

1,135

Open in Youtube

100

Open in VidIQ

1,872

1.86

Design

Open in LinkedIn

5,867,449

Open in Youtube

1,100,000

225,000

Open in VidIQ

456,826.8

84.78

Ops

Open in LinkedIn

621

Open in Youtube

89,000

9,000

Open in VidIQ

137,271.8

96.2

Management

Open in LinkedIn

35,830,217

Open in Youtube

100,000

27,000

Open in VidIQ

81,930.5

83.33

DesignManagement

Open in LinkedIn

839

Open in Youtube

100

Open in VidIQ

1,109.1

6.58

ProductDesign

Open in LinkedIn

89,599

Open in Youtube

13,000

3,400

Open in VidIQ

107,087.1

33.28

UserResearch

Open in LinkedIn

12,810

Open in Youtube

554

185

Open in VidIQ

9,532.4

15.8

DesignSystems

Open in LinkedIn

6,431

Open in Youtube

468

Open in VidIQ

10,143.8

27.66

DesignSystem

Open in LinkedIn

5,033

Open in Youtube

557

190

Open in VidIQ

54,155.1

29.43

ContentStrategy

Open in LinkedIn

1,120,199

Open in Youtube

5,000

1,700

Open in VidIQ

38,485.7

24.42

Marketing

Open in LinkedIn

20,292,798

Open in Youtube

595,000

135,000

Open in VidIQ

772,395.7

72.82

Operations

Open in LinkedIn

22,453

Open in Youtube

9,900

2,800

Open in VidIQ

6,326.7

86.66

Engagement based

Community

Open in LinkedIn

128,641

Open in Youtube

242,000

63,000

Open in VidIQ

464,507.5

Event

Open in LinkedIn

38,628

Open in Youtube

483,000

127,000

Open in VidIQ

59,556.3

91.05

Topic based

InsightsManagement

Open in LinkedIn

Open in Youtube

Open in VidIQ

2,277.7

15.37

SystemsThinking

Open in LinkedIn

5,194

Open in Youtube

881

235

Open in VidIQ

11,387.9

28.16

ChangeManagement

Open in LinkedIn

54,864

Open in Youtube

4,000

1,400

Open in VidIQ

26,457.7

28.75

Coordination

Open in LinkedIn

919

Open in Youtube

8,700

3,300

Open in VidIQ

4,660.8

60.97

Process

Open in LinkedIn

9,133

Open in Youtube

44,000

17,000

Open in VidIQ

28,616.6

92.49

Governance

Open in LinkedIn

14,011

Open in Youtube

8,400

2,400

Open in VidIQ

5,158.1

29.79

KnowledgeManagement

Open in LinkedIn

6,149

Open in Youtube

565

290

Open in VidIQ

20,562.1

13.22

Technologies

Open in LinkedIn

7,195

Open in Youtube

50,000

6,000

Open in VidIQ

3,975

77.16

Technology

Open in LinkedIn

26,317,101

Open in Youtube

1,300,000

243,000

Open in VidIQ

525,556.9

79.6

Leadership

Open in LinkedIn

3,272,700

Open in Youtube

239,000

49,000

Open in VidIQ

194,732.4

77.28

CenterOfExcellence

Open in LinkedIn

306

Open in Youtube

545

149

Open in VidIQ

11.05

PeopleManagement

Open in LinkedIn

10,969

Open in Youtube

662

328

Open in VidIQ

4,666.2

53.21

DEI

Open in LinkedIn

4,750

Open in Youtube

5,300

2,000

Open in VidIQ

21,370.8

80.36

Goals

Open in LinkedIn

23,200

Open in Youtube

559,000

150,000

Open in VidIQ

85,091.8

91.68

OKR

Open in LinkedIn

3,107

Open in Youtube

2,400

596

Open in VidIQ

71,430.5

31.55

KPIs

Open in LinkedIn

6,128

Open in Youtube

1,200

471

Open in VidIQ

13,841

22.35

Partnerships

Open in LinkedIn

260,526

Open in Youtube

3,800

1,500

Open in VidIQ

1,066.9

38.88

Culture

Open in LinkedIn

4,715,075

Open in Youtube

344,000

100,000

Open in VidIQ

70,552

96.94

Metrics

Open in LinkedIn

1,606

Open in Youtube

1,300

635

Open in VidIQ

2,286.6

76.25

Communication

Open in LinkedIn

184,960

Open in Youtube

111,000

30,000

Open in VidIQ

116,725.6

75.83

Community

Open in LinkedIn

128,641

Open in Youtube

242,000

63,000

Open in VidIQ

464,507.5

CorporateGuidelines

Open in LinkedIn

950

Open in Youtube

Open in VidIQ

1,058.1

33.76

Engagement

Open in LinkedIn

248,698

Open in Youtube

124,000

49,000

Open in VidIQ

24,982.2

70.06

CompetencyMatrix

Open in LinkedIn

Open in Youtube

Open in VidIQ

1,066.8

6.41

Team

Open in LinkedIn

184,949

Open in Youtube

469,000

174,000

Open in VidIQ

214,402.2

96.75

Intake

Open in LinkedIn

Open in Youtube

4,500

1,400

Open in VidIQ

7,662

65.3

Planning

Open in LinkedIn

38,636

Open in Youtube

41,000

13,000

Open in VidIQ

40,522.3

98.33

Quality

Open in LinkedIn

56,193

Open in Youtube

120,000

38,000

Open in VidIQ

48,484.8

98.54

Workflow

Open in LinkedIn

1,520

Open in Youtube

9,000

3,500

Open in VidIQ

21,186.3

Activities

Open in LinkedIn

559

Open in Youtube

43,000

13,000

Open in VidIQ

14,088

95.38

Ceremonies

Open in LinkedIn

Open in Youtube

933

419

Open in VidIQ

3,419

83.23

Deliverables

Open in LinkedIn

Open in Youtube

100

Open in VidIQ

3,159.3

9.87

Tools

Open in LinkedIn

4,760

Open in Youtube

177,000

34,000

Open in VidIQ

90,929.3

92.93

BudgetManagement

Open in LinkedIn

173

Open in Youtube

100

Open in VidIQ

2,088.9

42.93

Accelerator

Open in LinkedIn

3,749

Open in Youtube

3,800

1,500

Open in VidIQ

78,472.9

73.8

Vendors

Open in LinkedIn

21,082

Open in Youtube

4,300

1,800

Open in VidIQ

2,346.8

46.38

Promotion

Open in LinkedIn

9,250

Open in Youtube

118,000

35,000

Open in VidIQ

23,753.5

75.8

Assessment

Open in LinkedIn

3,582

Open in Youtube

9,800

3,100

Open in VidIQ

3,279

67.62

Feedback

Open in LinkedIn

9,145

Open in Youtube

50,000

15,000

Open in VidIQ

83,310.1

65.02

Education

Open in LinkedIn

9,606,159

Open in Youtube

2,100,000

311,000

Open in VidIQ

562,574

97.64

Recruiting

Open in LinkedIn

1,045,391

Open in Youtube

24,000

5,200

Open in VidIQ

8,054.9

32.77

Staffing

Open in LinkedIn

62,668

Open in Youtube

6,000

1,700

Open in VidIQ

9,954.1

20.47

Onboarding

Open in LinkedIn

11,615

Open in Youtube

3,500

1,300

Open in VidIQ

7,427

18.2

Playbook

Open in LinkedIn

381

Open in Youtube

3,100

549

Open in VidIQ

14,907.5

52.74

Toolkits

Open in LinkedIn

347

Open in Youtube

240

112

Open in VidIQ

4,511.3

41.52

Recognition

Open in LinkedIn

6,082

Open in Youtube

6,800

3,200

Open in VidIQ

3,744.5

67.06

Nocode

Open in LinkedIn

4,691

Open in Youtube

10,000

1,900

Open in VidIQ

86,092.9

24.96

Lowcode

Open in LinkedIn

5,475

Open in Youtube

5,700

763

Open in VidIQ

22,832.4

18.15

Tool based

Coda

Open in LinkedIn

137

Open in Youtube

5,100

2,500

Open in VidIQ

243,073.1

69.35

Figma

Open in LinkedIn

3,248

Open in Youtube

17,000

4,100

Open in VidIQ

1,917,872.5

47.53

Dovetail

Open in LinkedIn

Open in Youtube

992

357

Open in VidIQ

5,038

69.03

FigJam

Open in LinkedIn

Open in Youtube

542

269

Open in VidIQ

35,165.4

18.2

Miro

Open in LinkedIn

663

Open in Youtube

7,100

2,000

Open in VidIQ

322,597.2

93.81

⁠

Useful resources

⁠

Youtube Hashtags⁠

policies;

⁠

Youtube hashtags recommendations⁠

by SproutSocial;

⁠

vidIQ⁠

for Youtube hashtags;

⁠

Semrush⁠

for more global hashtags overview;

⁠

Youtube API⁠

for future automations if you would like to create your own Coda Pack;

Want to print your doc?
This is not the way.

Try clicking the ⋯ next to your doc name or using a keyboard shortcut (

CtrlP

) instead.