Which trending topic pays the most per post? (Week 33)

in #creative7 years ago

While the Trending Topics lists the total number of posts and the total money received per category it does not show which category receives the most 'average payout per post'.

So I did what I do best and wrote some bash awk voodoo and calculated the "Average Payout per Post per Category" by dividing the number of posts by the total payout per each category which gave the following results in a nice clickable table:

PositionTag# Posts$Payout$Payout/#Posts
1creative77$95791$1244
2market62$73759$1190
3beyondbitcoin649$540627$833
4economics158$127920$810
5painting165$130005$788
6government83$65327$787
7finance82$64131$782
8anarchism233$170488$732
9recipes179$126809$708
10minnowsunite379$264137$697
11stats212$130828$617
12community393$239498$609
13blockchain1141$686713$602
14review127$75814$597
15beach51$30003$588
16family269$154958$576
17marketing296$168165$568
18success78$43866$562
19security345$190730$553
20girls125$66649$533
21beauty253$130789$517
22creativity527$266828$506
23freedom511$247117$484
24lifestyle150$65201$435
25cooking150$64751$432
26adventure369$156814$425
27investment91$37456$412
28japan126$51400$408
29crypto-news819$328571$401
30work149$58664$394
31programming228$87825$385
32anarchy710$271677$383
33steem7338$2790414$380
34recipe281$105284$375
35books179$67007$374
36business635$237099$373
37psychology891$332191$373
38story3083$1135176$368
39blog3828$1406003$367
40challenge132$47930$363
41help297$107537$362
42economy175$60995$349
43investing248$85847$346
44live69$23535$341
45fun405$132919$328
46lol19$6216$327
47fashion151$47087$312
48howto479$148865$311
49usa59$17940$304
50writing4157$1247101$300
51picture32$9541$298
52marijuana471$137587$292
53culture268$77975$291
54drawing852$247678$291
55humor256$73766$288
56russia44$12472$283
57india160$44918$281
58spirituality184$51448$280
59ethereum1051$285190$271
60poloniex368$98874$269
61coinkorea680$182136$268
62china120$31244$260
63games239$61758$258
64youtube272$69908$257
65flowers262$67063$256
66fiction1285$325933$254
67ksi41$10408$254
68tutorial273$68575$251
69comic120$29947$250
70curation629$155554$247
71design409$98289$240
72people73$17237$236
73bitshares1476$338718$229
74garden224$51406$229
75newbie137$31386$229
76space216$49296$228
77entertainment217$49136$226
78inspiration374$84187$225
79sex148$32315$218
80history833$179971$216
81coffee242$51524$213
82philosophy1996$425805$213
83money4095$863445$211
84film289$60452$209
85trading848$177240$209
86cryptocurrencies112$23305$208
87comedy152$31458$207
88world80$16568$207
89crypto1021$204338$200
90game299$59861$200
91movie238$46480$195
92teamaustralia258$49146$190
93education826$156186$189
94science2469$465145$188
95war217$40855$188
96nature3365$611666$182
97kr-newbie1267$229819$181
98life25620$4501381$176
99happy75$12940$173
100esteem420$72030$172
101mining357$60321$169
102ico286$45948$161
103news4435$713773$161
104politics2067$330575$160
105technology1828$292461$160
106diy195$31039$159
107witness-category660$103259$156
108meetup514$79435$155
109love1186$181567$153
110trending69$10416$151
111venezuela176$26053$148
112conspiracy192$27741$144
113newslink78$11223$144
114tech70$10050$144
115tr412$59284$144
116vlog292$40723$139
117steem-help748$101495$136
118macro243$32870$135
119memes88$11821$134
120video2187$292195$134
121kr-writing248$33089$133
122new379$50367$133
123photos244$32321$132
124poem341$44930$132
125ru722$94711$131
126sport291$38167$131
127health3818$497054$130
128introduce368$46844$127
129eos835$102091$122
130gaming1675$204454$122
131trump245$29783$122
132aceh547$65810$120
133altcoin179$21358$119
134joke61$7206$118
135africa346$40289$116
136cervantes321$36767$115
137movies395$44455$113
138funny4884$548949$112
139steemit38081$4278397$112
140animals1172$130078$111
141comics207$23001$111
142dog94$10355$110
143introduction1083$117975$109
144animal229$24822$108
145motivation909$97414$107
146cryptocurrency8953$907978$101
147cannabis568$56543$100
148steepshot194$19147$99
149beautiful85$8355$98
150gold424$40257$95
151minnowsupportproject553$52631$95
152cat151$14116$93
153music4424$412268$93
154sports1440$133289$93
155travel14945$1371281$92
156anime157$14109$90
157sunset180$16194$90
158english81$7117$88
159photo750$65825$88
160meme870$75198$86
161art17588$1494846$85
162btc178$14954$84
163philippines222$17773$80
164nsfw676$53449$79
165flower218$16915$78
166litecoin323$24973$77
167whalepower835$63291$76
168bitcoin16762$1223135$73
169dogs248$18152$73
170free274$19412$71
171deutsch2675$186937$70
172natural142$9946$70
173poetry3513$245498$70
174fitness602$40847$68
175photography32721$2212989$68
176cars410$27611$67
177charity416$27910$67
178cn7184$475430$66
179gardening1649$108039$66
180hot126$8354$66
181beer532$34341$65
182food12806$815088$64
183introduceyourself21880$1396523$64
184religion999$63330$63
185google236$14461$61
186cats334$19168$57
187jokes52$2940$57
188vegan427$24250$57
189football336$18902$56
190chainbb-general626$34460$55
191tv170$9020$53
192contest3357$174270$52
193truth397$20459$52
194minnowsupport989$50922$51
195silver412$20460$50
196gridcoin568$27355$48
197christianity447$20718$46
198pictures171$7700$45
199giveaway913$39457$43
200introducemyself2415$101719$42
201norway1066$45243$42
202trevonjb631$24904$39
203kr-market537$19298$36
204steemitphotochallenge2160$78057$36
205kr-join531$18659$35
206upvote264$8396$32
207memechallenge848$24346$29
208kr32141$895034$28
209openmic1922$54134$28
210amazing127$3241$26
211car242$6313$26
212teamphilippines290$7529$26
213nigeria712$17472$25
214spanish11836$280357$24
215indonesia3389$75541$22
216ua143$3189$22
217japanese2259$48540$21
218steem-pocalypse856$17891$21
219quote204$3892$19
220christian-trail930$16823$18
221kr-event400$7358$18
222kr-travel735$12942$18
223homesteading1741$30081$17
224polish1023$17189$17
225treetuesday453$7565$17
226muksteem1266$20873$16
227beachwednesday475$6972$15
228spam622$9621$15
229kr-daily929$12158$13
230fr1001$11890$12
231test493$5770$12
232bwphotocontest1364$15672$11
233comment538$5812$11
234charlesfuchs614$4665$8
235colorchallenge8729$69122$8
236steemit-health2705$20503$8
237bitconnect332$2388$7
238days16$64$4
239myanmar1264$3975$3
240neo522$831$2
241steemiteducation873$1991$2
242steemsilvergold2624$4352$2
243monomad838$1051$1
244dtube2119$4$0
245helenamaywinbot1093$26$0
246juanitathebot728$22$0
247lemona90$0$0
248minnowsfaucet634$53$0
249miso123$56$0

steem dollars

Sort:  

Well done. Now i also understand why you put creative in your tag!

Haha you got me there! ;) Indeed when I saw 'creative' as number one category, by posting in that category I also wanted to indirectly let them (you) know that this category indeed payed out the most.

amazinge

Great post