Skip to content
Content Mix Analyzer for Tweets
Share
Explore

Content Mix Analyzer for Tweets

🙏 Thank you for your interest in this document. It would not be possible without the by . Thanks to for organizing the April 2022 Build Weekend.
Why this doc?
You already know you should post a mix of content on social. Too much of one kind of content can be boring. But it can be hard to look back and see how well one has been doing in engaging with others and posting around a few core themes.
Use this document to define what your content priorities are. Then, regularly return to this document to categorize past tweets and see if you are meeting your content priorities.
If you are interested in analyzing your tweets — or looking to understand another Twitter account — be sure to copy this document and make it your own. ()
Clarification from video: The sync does not pull up to 1000 records. There are syncing limits.
Copy doc

Let’s go. 🚀

Step 1: What is the Twitter account you would like to analyze?
Be sure to leave off the @.
Twitter Account:
jack
Step 2: Identify Topics
Pick 2 - 3 main topics that you would like to talk about on social. The decide how much of the time you’d like to focus on each.
Content mix:
109%
Status check:
⚠️ - The content mix is NOT at 100%.
db Tweet Categories
2
Search
Category Name
Color
Content Mix
1
Category A
Orange 1
10%
2
Category B
Orange 2
10%
3
Category C
Yellow 1
10%
4
Category D
Yellow 2
10%
5
Category E
Blue 1
10%
6
Category F
Blue 2
10%
7
Category G
Purple 1
10%
8
Category H
Purple 2
19%
9
Replies to Others
Pink 1
10%
10
Miscellaneous
Pink 2
5%
11
Other Not Listed
Gray
5%
There are no rows in this table


Step 3: Assign Each Tweet a Category
Make sure to sync the table and then start assigning categories. In the Twitter Search Pack settings, you can adjust how frequently the document auto-updates or if it updates manually only.
Total Tweets:
81
Tweets without an assigned category:
75
db Account Tweets
2
Search
Text
Category
Date
Like Count
Quote Count
Retweet Count
1
@uselessthinking @iHadrami_ @trengriffin @garrytan no
Replies to Others
4/17/2022
2275
58
170
2
@iHadrami_ @trengriffin @garrytan it’s consistently been the dysfunction of the company
Replies to Others
4/17/2022
1914
105
242
3
@trengriffin @garrytan big facts
Replies to Others
4/16/2022
1313
16
89
4
https://t.co/lWDGPNk8cs
Replies to Others
4/16/2022
3971
98
316
5
@rosecity_jo @talkhoops if it were up to me I’d take away likes too
Replies to Others
4/16/2022
325
12
33
6
@decryptmedia @vladtenev @RobinhoodApp what a joke indeed
Replies to Others
4/16/2022
578
6
39
7
🌕
4/16/2022
23112
515
1943
8
@buyindip @elonmusk @ChrisJBakke When I was fired in 2008 and made chair, the board took most of my shares away from me. I also gave 1% of the company back to the employee pool in 2015. So, ended up with very little of company. https://t.co/ARyAn542k6
4/16/2022
778
15
104
9
@WakaFlocka it’s been on 99% for a decade now
4/16/2022
976
6
43
10
@SBF_FTX @TomBrady @BillClinton @opmthebahamas ?
4/16/2022
3295
17
105
11
@Beautyon_ Eh? Bitcoin makes it possible, as you point out in your replies below
4/16/2022
87
2
5
12
@Beautyon_ Yes. Exactly
4/16/2022
99
1
6
13
@Beautyon_ You’re arguing my point here.
4/16/2022
69
1
1
14
@JackPosobiec @MarkDice @bluesky No company ever could
4/16/2022
227
5
25
15
@VonPlumps True. And I really hope it stays that way. I do believe we have regressed recently tho.
4/16/2022
336
3
14
16
@Rand0mGuest2 @stephanlivera CEOs don’t matter in this space. Or maybe at all.
4/16/2022
851
9
43
17
@nrunje @lsanger @theAkshEffect @nbashaw @Twitter It is actually good for catching up on things when you are away from app for a while.
But the important thing is we gave people choice. No other platform of scale has.
4/16/2022
148
1
6
18
@bwinterrose @chrismessina @lsanger @theAkshEffect @nbashaw @Twitter And this
4/16/2022
36
1
3
19
@chrismessina @lsanger @theAkshEffect @nbashaw @Twitter It’s being worked on. Or was.
4/16/2022
90
2
5
20
@lsanger @theAkshEffect @nbashaw @Twitter It’s not easy. Keep in mind we are the only service that allows you to turn the algorithm off.
4/16/2022
113
2
9
21
@Bob_Boyle_1662 @TunechiBtc @k3tan0 @VitalikButerin Exactly ✨
4/16/2022
242
1
6
22
@D_Twitt3r @k3tan0 @VitalikButerin @bluesky Yes. Twitter doesn’t own it. So a new owner of Twitter wouldn’t matter for some time. Funding would need to be reassessed.
It has been slow, but this is an entirely new protocol in the open. They are slow but hopefully deliberate towards resilience
4/16/2022
152
2
10
23
@MikeMcDonald89 @VitalikButerin The idea? 11
4/15/2022
455
8
21
24
@Blackamazon I did. And I don’t see all your questions.
4/15/2022
39
1
4
25
@k3tan0 @VitalikButerin I’m don’t believe any individual or institutions should own social media, or more generally media companies. It should be an open and verifiable protocol. Everything is a step toward that.
4/15/2022
1168
37
177
26
@Blackamazon no. nothing to do with it
4/15/2022
25
2
1
27
@MarkDice as I said in a thread on the event, I believe all permanent bans are a failure of the company. But likely right decision for the the company. Wrong for technology underlying the service. Hence @bluesky
4/15/2022
636
78
73
28
@SusanLiTV @BillyM2k @hannity already announced full resignation from company, including board, back in Nov.
4/15/2022
849
30
73
29
@VitalikButerin same
4/15/2022
4087
18
169
30
@vladtenev nah i’m good i don’t use robinhood
4/15/2022
8562
205
744
31
@theAkshEffect @nbashaw @Twitter yep
4/15/2022
253
5
11
32
@Beautyon_ I disagree. I believe it does need a protocol with bitcoin-like properties to create resilience against governments and corporations globally.
4/15/2022
408
11
34
33
@Beautyon_ right. bitcoin has a protocol that is resilient to corporate interests. social media does not. without that, it is a problem.
4/15/2022
556
7
58
34
@SGBarbour as a public company, twitter has always been "for sale." that's the real issue.
4/15/2022
5228
168
657
35
@heyalexfriedman @elonmusk no
4/15/2022
2853
9
86
36
@pavtalk @seyitaylor agree.
and I wasn't pushed out. I left.
4/15/2022
264
6
18
37
@vladtenev u thirsty?
4/15/2022
4956
78
303
38
@joshu 💯
4/15/2022
29
2
4
39
@juli882 @NeilJacobs amen my son
4/13/2022
142
4
6
40
@travelyInvestor @NeilJacobs no
4/13/2022
44
2
4
41
@Erikcason @NeilJacobs not worth refuting the fact that it's a spiritual cult of psychopaths that don't care about anyone
4/13/2022
1387
27
98
42
@NeilJacobs agree. i'm skeptical of any and all "leadership," especially my own.
and those ads need clicks and conversion...
4/13/2022
1547
19
81
43
@greg16676935420 you dropped this: st
4/12/2022
5379
5
75
44
@RobinhoodApp ?
4/12/2022
4544
27
255
45
@kayvz never
4/12/2022
206
1
10
46
wow https://t.co/LPByH8HWU5
4/12/2022
7166
90
807
47
@finkd 🫂
4/12/2022
158
17
27
48
@pmarca 🫂
4/12/2022
558
16
21
49
RT @adriyoung: “all of these jack tweets got me thinking about where my hug is at… now we don’t hug at all i just wonder where that energy…
4/12/2022
0
0
113
50
everybody stop and hug
4/12/2022
6853
240
810
51
🫂
4/12/2022
11318
202
941
52
@brockm 🫂
4/12/2022
137
3
13
53
@brockm it is
4/12/2022
2999
14
148
54
@ayosogunro no kicking, I want to help fix it
4/12/2022
603
4
44
55
@ahlswedecollect @espiers No it wasn’t.
4/12/2022
69
2
6
56
@waltisfrozen I do. But the output of what we are discussing is not the result of an elected system. The Fed is not elected.
4/12/2022
221
4
20
57
@JoyAnnReid Ok. You can continue with the binary thing, or we can discuss systemic change which calls out both parties.
4/12/2022
730
12
40
58
@espiers You’re new here. Hi.
4/12/2022
249
3
8
59
@davidmweissman I’m sure your perception is true. Doesn’t discount that the broader system is damaged.
4/12/2022
524
6
12
60
@HuayoCanto @donmoyn Verídico
4/12/2022
51
1
6
61
@JoyAnnReid I’m with you on corporate driving most of this. The party doesn’t matter. It’s the same system. Both parties have the same incentive. It’s not for the people.
4/12/2022
322
9
24
62
@OyeYknow @ck_SNARKs @francispouliot_ Same team
4/12/2022
87
5
3
63
@ck_SNARKs @ltngstore and @CashApp
4/12/2022
239
2
10
64
@waltisfrozen Do you disagree? Neither party from what I’ve seen. The current system lacks any transparency and accountability. Inching towards either would be entirely refreshing.
4/12/2022
332
5
18
65
@donmoyn This was caused well before the war.
4/11/2022
3918
23
290
66
@brguest20 I’m sorry to disappoint my guest
4/11/2022
367
4
8
67
@surferjimw Slow and steady! Come through.
4/11/2022
404
3
10
68
@corndalorian @disclosetv blame me
4/11/2022
966
8
35
69
@ReuvenSoraya @CarterMansbach And heat your home
4/11/2022
122
6
6
70
@tomcoates @ryanpic54 @JoyAnnReid You don’t understand the power of the dollar and our single export. Ask someone in Nigeria how the dollar affects them.
4/11/2022
2775
1421
1420
71
@tomcoates All of which happened before the war. All the way back to Trump and prior.
4/11/2022
77
2
4
72
@ProofofBrain_ @CarterMansbach He’s ride or die twitter
4/11/2022
41
2
3
73
@cmclymer Yes I do. Much more transparent than most.
4/11/2022
255
9
8
74
@JoyAnnReid Neither of those “caused it”. They may have compounded, but did not spark it. This isn’t “both sides”, it’s looking critically at the system we created and live in.
4/11/2022
1165
9
37
75
@CarterMansbach “Sleep” is not trading it
4/11/2022
425
3
20
76
@TVietor08 I have zero interest in making money. I have every interest in fixing it. I also have zero interest in cryptocurrencies.
4/11/2022
6963
295
769
77
@CarterMansbach Why is that a negative?
4/11/2022
1714
6
35
78
Every administration, republican or democrat, has an opportunity to build trust with the public.
Instead, every single time, they choose deception and zero accountability. It’s not the party, it’s the system. https://t.co/sxLJTkPkSn
4/11/2022
56950
1547
8867
79
clean https://t.co/SlOTPwsBDs
4/11/2022
4027
36
353
80
@jackmallers same team always!
4/10/2022
1403
5
39
81
we love Miles https://t.co/K1fsZZ4Z1e
4/10/2022
2166
20
253
There are no rows in this table


db Common Words
2
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.