How to import a website table into Google Sheets

Figured I’d do a follow-up video on how to grab data
from a website table using Google Sheets.

[youtube

Link to the walkthrough video I mentioned.

Google Docs IMPORTHTML function description

Geckoboard article on how to find the index number of a table 

Link to my Data Source Google Sheet (Shareable)

How I create the Steemit Post payout articles – a video walkthrough

 

[youtube

Here’s a walk through of how I create my Steemit post payout reports.

Things you’ll need:
1) Google Drive – (for Docs and Sheets)
2) a WordPress.com account
3) The WordPress.com for Google Docs Add-in

Link to my Data Source Google Sheet

Link to my Report Template Google Sheet

 

Low Competiton, High SBD Payout Tags for 2018-02-03

DasWortgewand / Pixabay

Median Payout: $48.67
(as of 2/3/2018 20:47:40 EST)
Source: Steemit Trending Tags

If you’re looking for post ideas, it’s good to look for primary post tags that pay well,
but don’t have that many other posts that will compete with your post.

That way, your post ranks higher (and for a longer time).

Of course, you want to make sure your post is a good fit with the category tag before posting.

The tags in this list below are sorted by payout %, low to high
and meet the following criteria:

  • <50% of median total posts (<1168 total posts)
  • >125% of median average SBD/post (> $60.84 SBD/post)
Tag

Posts

Payouts

Avg. post payout

% of median

vegan

997

$61,860.18

$62.05

127.48%

kr-event

667

$44,411.92

$66.58

136.80%

muksteem

1,078

$82,032.97

$76.10

156.35%

kr-overseas

279

$21,369.52

$76.59

157.37%

smartcash

161

$12,662.49

$78.65

161.59%

price

681

$54,556.01

$80.11

164.60%

cannabis

932

$83,720.08

$89.83

184.56%

kr-travel

608

$56,573.92

$93.05

191.18%

kr-art

731

$68,569.24

$93.80

192.72%

sbd

938

$92,976.78

$99.12

203.66%

giveaway

791

$86,088.00

$108.83

223.61%

steemsilvergold

533

$75,542.00

$141.73

291.20%

openmic

829

$149,769.46

$180.66

371.19%

gardening

943

$177,261.09

$187.98

386.21%

norway

520

$124,277.32

$238.99

491.04%

meetup

485

$131,529.12

$271.19

557.19%

eos

642

$178,483.06

$278.01

571.20%

curation

982

$328,727.21

$334.75

687.78%

sbdtothemoon

10

$4,329.26

$432.93

889.49%

bitshares

570

$498,753.87

$875.01

1797.78%

Image by DasWortgewand on Pixabay.

Highest SBD Paying Steemit Tags for 2018-01-26

Median payout: $49.70 (as of 1/26/2018 0:28:52 EST)

Source: Steemit Trending Tags


Tags with >125% of median SBD payout, lowest to highest

Tag Posts Comments Payouts Avg. post payout % of median
art 41,604 36,046 $2,591,656.31 $62.29 125.35%
culture 2,751 685 $178,907.57 $65.03 130.86%
life 123,752 56,399 $8,072,365.95 $65.23 131.26%
success 1,414 537 $92,265.46 $65.25 131.30%
blog 50,200 11,999 $3,278,437.26 $65.31 131.41%
challenge 1,762 623 $117,348.24 $66.60 134.01%
africa 2,395 365 $160,984.72 $67.22 135.26%
bitcoin 33,848 27,984 $2,297,372.02 $67.87 136.58%
vegan 837 1,007 $57,067.71 $68.18 137.20%
introduceyourself 24,037 60,758 $1,642,772.89 $68.34 137.52%
fr 1,219 2,122 $83,378.44 $68.40 137.64%
creative 2,606 322 $178,586.17 $68.53 137.90%
macro 1,033 583 $73,722.28 $71.37 143.61%
bwphotocontest 581 1,340 $41,929.23 $72.17 145.22%
muksteem 998 3,185 $72,854.77 $73.00 146.90%
steemiteducation 2,432 3,373 $179,663.80 $73.87 148.65%
ru 1,801 776 $134,094.69 $74.46 149.82%
family 3,818 1,057 $285,382.08 $74.75 150.41%
technology 7,906 3,190 $590,961.35 $74.75 150.41%
adventure 3,217 932 $245,574.55 $76.34 153.61%
food 19,944 25,508 $1,528,827.49 $76.66 154.25%
cooking 1,513 433 $116,836.91 $77.22 155.39%
health 10,688 7,050 $826,881.67 $77.37 155.68%
cryptocurrency 27,878 20,255 $2,176,618.52 $78.08 157.11%
deutsch 4,647 10,014 $363,304.43 $78.18 157.32%
kr-event 459 3,023 $36,517.72 $79.56 160.09%
education 4,753 1,902 $382,612.63 $80.50 161.98%
drawing 6,217 2,245 $501,581.19 $80.68 162.35%
painting 3,027 466 $245,776.56 $81.19 163.38%
sports 3,867 3,377 $314,479.66 $81.32 163.64%
gaming 5,595 4,994 $457,554.18 $81.78 164.56%
space 1,074 459 $88,138.59 $82.07 165.14%
thealliance 1,237 1,944 $104,058.79 $84.12 169.27%
recipe 2,487 775 $209,653.64 $84.30 169.63%
minnowsupport 1,596 977 $134,611.94 $84.34 169.72%
help 1,724 635 $146,227.88 $84.82 170.68%
cannabis 932 1,533 $79,063.26 $84.83 170.70%
kr-art 695 2,791 $59,042.89 $84.95 170.95%
steemit 71,185 56,651 $6,164,531.55 $86.60 174.26%
politics 5,863 2,733 $520,790.42 $88.83 178.74%
money 16,351 6,647 $1,454,124.44 $88.93 178.95%
travel 27,526 30,108 $2,463,034.30 $89.48 180.06%
price 573 995 $51,376.29 $89.66 180.42%
sbd 942 753 $84,537.66 $89.74 180.58%
kr-travel 567 2,383 $50,990.27 $89.93 180.96%
contest 6,740 13,572 $613,352.10 $91.00 183.12%
review 2,148 583 $199,563.00 $92.91 186.95%
design 2,461 744 $234,328.60 $95.22 191.60%
giveaway 842 2,245 $80,674.50 $95.81 192.80%
writing 21,379 9,423 $2,128,610.40 $99.57 200.35%
ethereum 4,493 1,619 $452,587.34 $100.73 202.70%
trading 3,557 1,590 $360,056.56 $101.22 203.69%
adsactly 1,201 1,093 $121,777.88 $101.40 204.04%
science 8,135 4,508 $825,835.94 $101.52 204.28%
blockchain 11,791 3,061 $1,213,458.31 $102.91 207.09%
vlog 1,372 897 $142,048.50 $103.53 208.33%
investing 1,715 607 $179,636.71 $104.74 210.77%
japanese 1,168 5,976 $125,252.18 $107.24 215.79%
kr-writing 1,259 903 $135,388.39 $107.54 216.39%
business 2,926 1,291 $322,562.89 $110.24 221.83%
creativity 3,921 624 $444,746.50 $113.43 228.24%
steemsilvergold 564 6,010 $64,689.90 $114.70 230.80%
tutorial 1,865 979 $216,562.79 $116.12 233.66%
translation 1,544 96 $182,584.13 $118.25 237.96%
community 4,189 2,378 $518,119.61 $123.69 248.89%
utopian-io 5,403 17,389 $681,004.29 $126.04 253.63%
kr 14,060 97,848 $1,817,941.09 $129.30 260.18%
homesteading 1,250 3,831 $163,928.74 $131.14 263.89%
steemstem 2,126 3,235 $279,768.56 $131.59 264.80%
teamaustralia 1,093 775 $146,224.83 $133.78 269.20%
ita 1,180 3,166 $163,284.89 $138.38 278.45%
freedom 2,930 2,121 $413,187.63 $141.02 283.77%
cn 8,373 11,775 $1,204,929.38 $143.91 289.57%
howto 1,480 674 $213,716.55 $144.40 290.57%
steem 24,865 24,346 $3,768,347.55 $151.55 304.96%
philosophy 3,970 2,306 $602,561.92 $151.78 305.42%
openmic 887 5,449 $141,361.61 $159.37 320.69%
programming 1,009 517 $163,545.09 $162.09 326.16%
minnowbooster 141 1,764 $23,124.08 $164.00 330.01%
psychology 2,449 1,882 $443,214.54 $180.98 364.17%
sndbox 1,379 551 $256,573.46 $186.06 374.39%
gardening 881 1,251 $172,156.94 $195.41 393.21%
fiction 2,788 2,205 $550,272.73 $197.37 397.16%
anarchy 1,752 1,117 $373,102.54 $212.96 428.52%
minnowsunite 1,356 384 $292,934.88 $216.03 434.70%
norway 499 2,193 $115,315.08 $231.09 465.01%
eos 688 1,660 $164,018.91 $238.40 479.72%
coinkorea 1,338 3,262 $325,592.45 $243.34 489.66%
persian 158 1,880 $42,212.62 $267.17 537.61%
crypto-news 1,430 1,237 $406,998.24 $284.61 572.71%
curation 932 2,107 $306,180.23 $328.52 661.06%
steemdev 463 1,110 $208,026.46 $449.30 904.10%
charlesfuchs 42 1,660 $25,317.96 $602.81 1213.00%
bitshares 576 2,667 $482,802.68 $838.20 1686.66%
witness-category 177 1,874 $158,569.22 $895.87 1802.71%

Low Competition, High SBD Payout Steemit Tags for 2018-01-22

DasWortgewand / Pixabay

Source: Steemit Tags

(as of 1/22/2018 20:54:07 EST)
Median Payout: $50.57

If you’re looking for post ideas, it’s good to look for primary post tags that pay well,
but don’t have that many other posts that will compete with your post.

That way, your post ranks higher (and for a longer time).

Of course, you want to make sure your post is a good fit with the category tag before posting.

The tags in this list below are sorted by payout %, high to low
and meet the following criteria:

  • <75% of median total posts (<1,406 total posts)
  • >125% of median average SBD/post (> $63.22 SBD/post)

 

Tag Posts Payouts Avg. post payout % of median
bwphotocontest 616 $40,965.68 $66.50 131.50%
smartcash 130 $9,095.20 $69.96 138.34%
vegan 748 $55,608.92 $74.34 147.00%
muksteem 891 $70,692.16 $79.34 156.88%
price 608 $50,123.31 $82.44 163.01%
kr-event 414 $34,398.09 $83.09 164.29%
kr-art 658 $56,270.16 $85.52 169.09%
conspiracy 862 $80,027.75 $92.84 183.57%
giveaway 806 $79,243.68 $98.32 194.41%
cannabis 783 $77,976.51 $99.59 196.92%
kr-travel 493 $49,334.53 $100.07 197.87%
steemsilvergold 560 $60,607.04 $108.23 214.00%
openmic 824 $138,750.45 $168.39 332.95%
programming 930 $159,612.51 $171.63 339.36%
minnowbooster 124 $23,006.24 $185.53 366.86%
gardening 848 $170,612.05 $201.19 397.83%
norway 491 $112,637.77 $229.40 453.61%
eos 594 $160,213.68 $269.72 533.32%
persian 147 $41,185.16 $280.17 553.99%
meetup 360 $117,586.47 $326.63 645.85%
curation 854 $298,566.37 $349.61 691.29%
steemdev 454 $203,620.19 $448.50 886.84%
charlesfuchs 43 $24,224.28 $563.36 1113.94%
bitshares 614 $475,164.16 $773.88 1530.22%
witness-category 165 $155,764.10 $944.02 1866.64%

 

Low Competition, High SBD Payout Steemit Tags for 2018-01-06

DasWortgewand / Pixabay

Source: Steemit Tags

(as of 1/6/2018 21:08:10 EST)
Median Payout: $47.18, up $0.53 from yesterday

If you’re looking for post ideas, it’s good to look for primary post tags that pay well,
but don’t have that many other posts that will compete with your post.

That way, your post ranks higher (and for a longer time).

Of course, you want to make sure your post is a good fit with the category tag before posting.

The tags in this list below are sorted by payout %, high to low
and meet the following criteria:

  • <75% of median total posts (<1,268 total posts)
  • >125% of median average SBD/post (> $58.98 SBD/post)

 

Tag Posts Payouts Avg. post payout % of median
gold 1,061 $62,748.82 $59.14 125.35%
spirituality 1,190 $76,871.53 $64.60 136.91%
work 1,184 $79,167.48 $66.86 141.72%
bwphotocontest 516 $35,295.88 $68.40 144.98%
macro 888 $62,377.71 $70.25 148.88%
coffee 882 $63,261.98 $71.73 152.02%
thealliance 1,010 $72,859.36 $72.14 152.89%
kr-event 319 $23,165.96 $72.62 153.92%
muksteem 732 $55,873.16 $76.33 161.78%
kr-travel 475 $36,703.45 $77.27 163.77%
sbd 890 $70,753.66 $79.50 168.49%
japan 1,000 $85,953.92 $85.95 182.18%
cooking 1,158 $102,915.62 $88.87 188.36%
steemsilvergold 498 $44,471.31 $89.30 189.27%
minnowsupport 1,227 $114,755.39 $93.53 198.22%
conspiracy 727 $68,000.86 $93.54 198.25%
giveaway 721 $68,096.61 $94.45 200.18%
cannabis 696 $71,031.17 $102.06 216.30%
japanese 1,012 $109,526.15 $108.23 229.38%
kr-writing 907 $105,564.37 $116.39 246.68%
vlog 897 $104,646.54 $116.66 247.26%
homesteading 1,204 $144,324.19 $119.87 254.06%
teamaustralia 949 $117,604.61 $123.92 262.65%
familyprotection 136 $17,674.17 $129.96 275.44%
ita 797 $111,698.24 $140.15 297.04%
openmic 759 $114,217.93 $150.48 318.95%
adsactly 403 $66,604.76 $165.27 350.29%
sndbox 1,008 $172,221.17 $170.85 362.12%
marijuana 819 $151,710.38 $185.24 392.60%
gardening 840 $161,759.31 $192.57 408.14%
norway 478 $97,188.09 $203.32 430.93%
persian 131 $35,253.00 $269.11 570.36%
coinkorea 976 $281,448.59 $288.37 611.19%
eos 474 $139,170.64 $293.61 622.29%
curation 667 $265,236.03 $397.66 842.81%
beyondbitcoin 1,039 $648,578.17 $624.23 1323.03%
bitshares 601 $445,554.50 $741.36 1571.27%
charlesfuchs 25 $19,277.93 $771.12 1634.35%

 

Low Competition, High SBD Payout Steemit Tags for 2018-01-04

DasWortgewand / Pixabay

If you’re looking for post ideas, it’s good to look for primary post tags that pay well,
but don’t have that many other posts that will compete with your post.

That way, your post ranks higher (and for a longer time).

Of course, you want to make sure your post is a good fit with the category tag before posting.

Source: Steemit Tags

(as of 1/4/2018 20:52:45 EST)

The tags in this list below are sorted by payout %, high to low
and meet the following criteria:

  • <75% of median total posts (<1,200 total posts)
  • >125% of median average SBD/post (> $62.47 SBD/post)

 

Tag Posts Payouts Avg. post payout % of median
charlesfuchs 23 $18,402.85 $800.12 1601.04%
bitshares 578 $439,475.79 $760.34 1521.43%
beyondbitcoin 1005 $644,571.76 $641.36 1283.36%
curation 631 $261,136.01 $413.84 828.10%
coinkorea 896 $276,976.56 $309.13 618.56%
eos 487 $137,958.41 $283.28 566.84%
persian 129 $34,216.96 $265.25 530.76%
norway 446 $94,566.87 $212.03 424.28%
gardening 796 $160,598.30 $201.76 403.71%
marijuana 748 $150,736.05 $201.52 403.24%
sndbox 914 $162,964.48 $178.30 356.77%
openmic 655 $111,819.81 $170.72 341.60%
adsactly 376 $60,725.28 $161.50 323.17%
recipes 1,006 $157,829.65 $156.89 313.93%
cn-reader 868 $128,635.06 $148.20 296.54%
ita 706 $104,199.82 $147.59 295.33%
teamaustralia 870 $115,502.75 $132.76 265.65%
familyprotection 120 $15,751.95 $131.27 262.66%
steemit-health 229 $29,385.25 $128.32 256.77%
kr-writing 801 $102,333.97 $127.76 255.64%
homesteading 1,149 $139,519.64 $121.43 242.97%
vlog 810 $97,633.56 $120.54 241.19%
cannabis 617 $70,163.57 $113.72 227.55%
japanese 959 $107,376.27 $111.97 224.04%
giveaway 695 $66,491.46 $95.67 191.44%
minnowsupport 1,187 $112,485.46 $94.76 189.62%
conspiracy 705 $66,558.77 $94.41 188.91%
steemsilvergold 472 $42,737.52 $90.55 181.18%
muksteem 611 $53,812.42 $88.07 176.23%
kr-travel 400 $34,986.59 $87.47 175.02%
cooking 1,150 $99,986.08 $86.94 173.97%
sbd 820 $69,109.15 $84.28 168.64%
coffee 821 $62,498.29 $76.12 152.32%
thealliance 944 $68,390.66 $72.45 144.97%
work 1,097 $78,388.02 $71.46 142.98%
macro 858 $60,489.78 $70.50 141.07%
spirituality 1,079 $75,268.97 $69.76 139.58%

 

High SBD Payout Steemit Categories for 2017-12-28

Here’s today’s list of all the high SBD paying Steemit categories –
categories whose average SBD payout is greater than 125% of the median for the top 250 Steemit categories

Median Average SBD payout:
$51.06 (as of 2017-12-27 23:32 EST)

I’ll be breaking these down into tiers, so you can choose what level you’d like:

  • Tier 0 has < 500 posts
  • Tier 1 has 500 – 999 posts
  • Tier 2 has 1,000 – 4,999 posts
  • Tier 3 has 5,000 – 9,999 posts
  • Tier 4 has 10,000+ posts

Tier 0 (<500 posts)

 

Tag Posts Comments Payouts Avg. post payout %of median
witness-category 111 937 138,183.96 $1,244.90 2438.34%
bitshares 483 2,051 428,098.92 $886.33 1736.03%
steemfest 352 685 194,079.83 $551.36 1079.94%
eos 418 995 132,832.10 $317.78 622.42%
openmic 445 3474 105,215.55 $236.44 463.11%
norway 394 2417 88,090.53 $223.58 437.92%
persian 147 2057 31,538.99 $214.55 420.23%
steemadvent 39 1,129 7,253.15 $185.98 364.27%
steemit-health 205 1,051 29,198.28 $142.43 278.97%
muksteem 442 1336 49,772.40 $112.61 220.56%
bwphotocontest 311 847 33,335.32 $107.19 209.94%
steemsilvergold 361 2962 37,636.09 $104.26 204.20%
dance 488 762 33,466.40 $68.58 134.32%

 


Tier 1 (500 – 999 posts)

 

Tag Posts Comments Payouts Avg. post payout %of median
beyondbitcoin 910 419 635,354.77 $698.19 1367.52%
curation 602 1149 252,225.01 $418.98 820.64%
coinkorea 819 2380 263,680.00 $321.95 630.60%
marijuana 653 424 149,166.44 $228.43 447.42%
gardening 715 822 158,085.95 $221.10 433.06%
sndbox 754 321 137,185.32 $181.94 356.37%
cn-reader 806 283 122,079.56 $151.46 296.67%
ita 595 1,275 89,360.72 $150.19 294.16%
teamaustralia 762 493 109,185.28 $143.29 280.65%
vlog 671 546 89,232.07 $132.98 260.47%
cannabis 533 765 68,596.49 $128.70 252.08%
japanese 881 3,946 102,637.23 $116.50 228.19%
giveaway 648 1,172 62,643.33 $96.67 189.35%
conspiracy 666 526 63,240.41 $94.96 185.99%
sbd 656 422 61,388.06 $93.58 183.29%
japan 886 203 81,298.72 $91.76 179.73%
coffee 742 447 61,428.88 $82.79 162.15%
girls 916 131 74,375.56 $81.20 159.04%
space 893 285 71,447.87 $80.01 156.71%
work 968 200 76,002.49 $78.51 153.78%
thealliance 772 565 59,415.62 $76.96 150.75%
spirituality 964 560 71,684.33 $74.36 145.65%
memechallenge 565 930 40,052.08 $70.89 138.85%
gold 871 233 58,912.86 $67.64 132.48%

 


Tier 2 (1,000 – 4,999 posts)

 

Tag Posts Comments Payouts Avg. post payout %of median
crypto-news 1,241 791 375,347.30 $302.46 592.41%
anarchy 1,442 859 326,890.66 $226.69 444.01%
minnowsunite 1,243 302 281,394.33 $226.38 443.41%
psychology 1,791 1,040 404,214.65 $225.69 442.06%
fiction 2,350 1,851 487,880.03 $207.61 406.64%
freedom 2,161 597 356,184.91 $164.82 322.84%
philosophy 3,388 2,085 545,115.10 $160.90 315.14%
steemstem 1,134 1,538 178,969.96 $157.82 309.12%
howto 1,275 435 191,671.35 $150.33 294.45%
recipes 1,029 194 153,919.22 $149.58 292.98%
community 2,746 1483 393,973.23 $143.47 281.01%
business 2,157 574 289,870.46 $134.39 263.22%
creativity 3,030 259 388,666.85 $128.27 251.24%
homesteading 1,034 3,887 132,130.26 $127.79 250.29%
help 1,151 339 134,492.31 $116.85 228.87%
ethereum 3,557 898 384,496.66 $108.10 211.72%
deutsch 2684 5548 288,024.74 $107.31 210.19%
gaming 3,330 3463 353,581.90 $106.18 207.97%
review 1,470 523 154,861.30 $105.35 206.34%
investing 1,317 302 136,996.61 $104.02 203.74%
tutorial 1,434 422 146,911.79 $102.45 200.66%
contest 4395 8920 449,215.65 $102.21 200.20%
adventure 2,116 644 210,547.65 $99.50 194.89%
education 3,059 916 295,319.40 $96.54 189.09%
kr-newbie 3,136 2,120 298,272.69 $95.11 186.29%
introduction 1,416 1,119 131,963.03 $93.19 182.54%
sports 2,832 2889 263,536.74 $93.06 182.27%
drawing 4,618 1,987 423,047.73 $91.61 179.43%
minnowsupport 1,159 1045 105,837.12 $91.32 178.86%
painting 2,336 355 210,694.06 $90.19 176.66%
trading 3,244 1,406 279,808.61 $86.25 168.94%
design 2051 437 176,319.11 $85.97 168.38%
steemiteducation 1305 1,463 111,017.74 $85.07 166.63%
finance 1,117 175 93,575.45 $83.77 164.09%
culture 1,832 478 147,725.97 $80.64 157.94%
family 2,792 1,169 224,485.86 $80.40 157.48%
recipe 2,214 441 167,585.19 $75.69 148.26%
africa 1,727 266 128,476.97 $74.39 145.71%
ru 1,632 826 115,645.65 $70.86 138.79%
utopian-io 4,022 14630 283,823.07 $70.57 138.22%
creative 2,093 287 147,618.57 $70.53 138.14%
challenge 1,192 296 82,710.19 $69.39 135.91%
inspiration 1,939 551 132,216.85 $68.19 133.56%
steemitphotochallenge 1,374 942 93,683.66 $68.18 133.55%
flowers 1,581 440 105,515.00 $66.74 130.72%
success 1,015 202 66,061.47 $65.09 127.48%

 


Tier 3 (5,000 – 9,999 posts)

 

Tag Posts Comments Payouts Avg. post payout %of median
cn 5769 9517 1,004,421.13 $174.11 341.02%
kr 8,896 51,796 1,420,017.12 $159.62 312.65%
blockchain 8,121 2,067 965,456.75 $118.88 232.85%
science 6,271 3777 696,118.93 $111.01 217.42%
health 7,070 4,723 705,280.53 $99.76 195.39%
technology 5,893 2,958 467,749.93 $79.37 155.47%
politics 5,616 1,964 443,641.92 $79.00 154.73%
music 7909 5,304 610,586.73 $77.20 151.21%

 


Tier 4 (10,000+ posts)

 

Tag Posts Comments Payouts Avg. post payout %of median
steem 17,273 20,644 3,325,287.68 $192.51 377.07%
steemit 44329 41,719 5,388,665.24 $121.56 238.10%
writing 16,159 5,551 1,797,570.96 $111.24 217.89%
travel 19,358 19,265 2,020,078.96 $104.35 204.39%
introduceyourself 15,402 32,266 1,532,654.16 $99.51 194.91%
food 13,016 16105 1,219,765.71 $93.71 183.55%
money 13,401 5,790 1,199,803.48 $89.53 175.36%
cryptocurrency 19,492 15474 1,562,389.55 $80.16 157.00%
story 21,683 5,682 1,607,803.94 $74.15 145.24%
blog 34790 8,909 2,495,938.27 $71.74 140.52%
art 31,223 24,076 2,174,036.41 $69.63 136.38%
life 94,946 42,208 6,584,937.82 $69.35 135.84%
bitcoin 27,572 31,085 1,798,875.98 $65.24 127.79%

 

High Payout Steemit Categories by Total Posts for 2017-12-27

DasWortgewand / Pixabay

 

This post’s going to be a little different than the last few posts.

I usually only list high paying Steemit categories amongst the top 250 who have less than 500 posts.

This time I’m going to list all the higher paying Steemit categories
(categories whose average payout is greater than 125% of the median for the top 250)

I’ll be breaking these down into tiers, so you can choose what level you’d like:

  • Tier 0 has < 500 posts
  • Tier 1 has 500 – 999 posts
  • Tier 2 has 1,000 – 4,999 posts
  • Tier 3 has 5,000 – 9,999 posts
  • Tier 4 has 10,000+ posts

Tier 0 (<500 posts)

Tag Posts Comments Payouts Avg. post payout median payout %of median
bitshares 474 1,917 426,969.68 $900.78 $51.71 1742.07%
steemfest 353 687 193,990.43 $549.55 $51.71 1062.80%
eos 409 980 132,352.48 $323.60 $51.71 625.83%
blocktrades 167 861 48,170.70 $288.45 $51.71 557.84%
openmic 434 3,472 104,687.37 $241.22 $51.71 466.50%
norway 401 2,372 87,213.57 $217.49 $51.71 420.62%
persian 143 2,070 31,069.83 $217.27 $51.71 420.19%
steemadvent 39 1,268 7,014.00 $179.85 $51.71 347.81%
steemit-health 197 1,042 29,193.68 $148.19 $51.71 286.60%
muksteem 441 1,379 49,375.58 $111.96 $51.71 216.53%
steemsilvergold 350 2,799 37,357.65 $106.74 $51.71 206.42%
bwphotocontest 349 1,002 32,928.64 $94.35 $51.71 182.47%
dance 473 766 33,355.95 $70.52 $51.71 136.38%

 


Tier 1 (500 – 999 posts)

Tag Posts Comments Payouts Avg. post payout median payout %of median
beyondbitcoin 910 464 634,812.23 $697.60 $51.71 1349.12%
curation 597 1,135 251,163.16 $420.71 $51.71 813.63%
coinkorea 817 2,279 262,049.67 $320.75 $51.71 620.31%
marijuana 657 447 148,945.74 $226.71 $51.71 438.44%
gardening 724 858 157,523.85 $217.57 $51.71 420.78%
sndbox 751 354 133,874.22 $178.26 $51.71 344.75%
recipes 990 197 153,618.29 $155.17 $51.71 300.09%
cn-reader 783 266 121,266.07 $154.87 $51.71 299.52%
ita 589 1,219 87,644.95 $148.80 $51.71 287.78%
teamaustralia 769 491 108,234.33 $140.75 $51.71 272.20%
vlog 674 557 88,298.10 $131.01 $51.71 253.36%
cannabis 544 832 68,283.28 $125.52 $51.71 242.75%
japanese 897 3,931 102,071.39 $113.79 $51.71 220.07%
giveaway 649 1,167 62,451.91 $96.23 $51.71 186.10%
conspiracy 665 513 62,817.65 $94.46 $51.71 182.69%
sbd 647 394 60,484.37 $93.48 $51.71 180.79%
macro 626 392 56,418.28 $90.13 $51.71 174.30%
japan 904 211 80,943.97 $89.54 $51.71 173.17%
coffee 754 427 61,074.37 $81.00 $51.71 156.65%
space 910 289 70,941.67 $77.96 $51.71 150.77%
work 974 210 75,690.22 $77.71 $51.71 150.29%
thealliance 766 527 58,570.80 $76.46 $51.71 147.88%
spirituality 977 574 71,358.13 $73.04 $51.71 141.25%
memechallenge 561 902 39,899.81 $71.12 $51.71 137.55%
gold 882 227 58,736.53 $66.59 $51.71 128.79%

 


Tier 2 (1,000 – 4,999 posts)

Tag Posts Comments Payouts Avg. post payout median payout %of median
crypto-news 1,269 908 373,554.11 $294.37 $51.71 569.30%
minnowsunite 1,238 318 281,187.21 $227.13 $51.71 439.26%
psychology 1,786 1,081 403,041.15 $225.67 $51.71 436.43%
anarchy 1,449 888 325,587.30 $224.70 $51.71 434.56%
fiction 2,348 1,791 486,517.12 $207.20 $51.71 400.73%
freedom 2,168 618 354,380.92 $163.46 $51.71 316.12%
philosophy 3,375 2,156 544,043.51 $161.20 $51.71 311.75%
steemstem 1,171 1,551 176,531.69 $150.75 $51.71 291.55%
howto 1,277 456 191,116.79 $149.66 $51.71 289.44%
community 2,774 916 391,907.23 $141.28 $51.71 273.23%
business 2,166 537 289,289.99 $133.56 $51.71 258.30%
creativity 3,038 271 387,073.52 $127.41 $51.71 246.41%
homesteading 1,039 3,925 131,186.16 $126.26 $51.71 244.19%
help 1,158 407 133,955.60 $115.68 $51.71 223.72%
deutsch 2,673 5,488 286,563.74 $107.21 $51.71 207.33%
ethereum 3,597 944 382,275.61 $106.28 $51.71 205.53%
review 1,456 491 153,492.94 $105.42 $51.71 203.88%
investing 1,294 327 135,802.15 $104.95 $51.71 202.96%
gaming 3,393 3,472 351,223.66 $103.51 $51.71 200.19%
contest 4,305 8,711 445,602.12 $103.51 $51.71 200.18%
adventure 2,074 620 209,462.68 $100.99 $51.71 195.32%
tutorial 1,444 383 144,649.93 $100.17 $51.71 193.73%
kr-newbie 3,066 1,961 295,818.78 $96.48 $51.71 186.60%
education 3,084 852 291,868.71 $94.64 $51.71 183.03%
introduction 1,422 1,104 131,791.45 $92.68 $51.71 179.24%
minnowsupport 1,138 1,039 105,257.04 $92.49 $51.71 178.88%
drawing 4,646 1,976 421,211.29 $90.66 $51.71 175.33%
sports 2,903 2,871 262,434.12 $90.40 $51.71 174.83%
painting 2,327 331 209,991.98 $90.24 $51.71 174.52%
design 2,006 461 174,910.79 $87.19 $51.71 168.63%
trading 3,198 1,319 276,399.73 $86.43 $51.71 167.15%
steemiteducation 1,315 1,405 109,285.40 $83.11 $51.71 160.72%
family 2,734 1,143 222,690.77 $81.45 $51.71 157.53%
finance 1,161 176 93,288.48 $80.35 $51.71 155.40%
culture 1,843 517 146,871.58 $79.69 $51.71 154.12%
recipe 2,211 452 166,822.01 $75.45 $51.71 145.92%
africa 1,753 313 127,646.09 $72.82 $51.71 140.82%
utopian-io 3,843 14,579 271,904.34 $70.75 $51.71 136.83%
ru 1,630 824 115,257.15 $70.71 $51.71 136.75%
creative 2,098 284 146,868.68 $70.00 $51.71 135.38%
challenge 1,181 290 82,204.29 $69.61 $51.71 134.61%
inspiration 1,934 567 131,264.07 $67.87 $51.71 131.26%
steemitphotochallenge 1,384 936 93,460.63 $67.53 $51.71 130.60%
flowers 1,578 452 104,828.59 $66.43 $51.71 128.48%

 


Tier 3 (5,000 – 9,999 posts)

Tag Posts Comments Payouts Avg. post payout median payout %of median
cn 5,733 9,232 1,000,213.57 $174.47 $51.71 337.41%
kr 8,791 50,364 1,410,919.31 $160.50 $51.71 310.39%
blockchain 8,215 2,104 959,894.71 $116.85 $51.71 225.98%
science 6,255 3,737 693,193.67 $110.82 $51.71 214.33%
health 7,028 4,555 702,441.03 $99.95 $51.71 193.30%
technology 5,984 2,891 464,599.00 $77.64 $51.71 150.15%
politics 5,684 2,014 441,064.99 $77.60 $51.71 150.07%
music 7,896 5,326 607,088.25 $76.89 $51.71 148.69%

 


Tier 4 (10,000+ posts)

Tag Posts Comments Payouts Avg. post payout median payout %of median
steem 17,339 21,132 3,312,313.98 $191.03 $51.71 369.45%
steemit 43,994 41,386 5,370,848.55 $122.08 $51.71 236.10%
writing 16,135 5,887 1,789,468.24 $110.91 $51.71 214.49%
travel 19,308 18,542 2,010,054.94 $104.10 $51.71 201.33%
introduceyourself 15,270 32,784 1,530,157.09 $100.21 $51.71 193.80%
food 12,933 15,757 1,214,144.43 $93.88 $51.71 181.56%
money 13,587 6,474 1,191,315.74 $87.68 $51.71 169.57%
cryptocurrency 19,799 15,152 1,544,376.80 $78.00 $51.71 150.85%
story 21,529 5,750 1,600,318.49 $74.33 $51.71 143.76%
blog 34,611 8,919 2,477,521.94 $71.58 $51.71 138.44%
art 30,820 24,004 2,163,531.00 $70.20 $51.71 135.76%
life 94,396 41,981 6,547,802.09 $69.37 $51.71 134.15%

Low Competition, High Payout Steemit Categories for 2017-12-19

 

DasWortgewand / Pixabay

 

If you’re looking for post ideas, it’s good to look for primary post tags that pay well,
but don’t have that many other posts that will compete with your post.

That way, your post ranks higher (and for a longer time).

Of course, you want to make sure your post is a good fit with the category tag before posting.

I’ve split these tags into two sets, each sorted by

  • Total posts in the category (under 500, 500-999)
  • Average SBD/Post as % of the overall median
  • Minimum 125% of median SBD/post (61.65 SBD/post)

< 500 posts

Tag Posts Payouts Avg. SBD/post % of Median
witness-category 133 $136,243.97 1,024.39 1661.66%
bitshares 451 $419,098.01 929.26 1507.35%
charlesfuchs 23 $14,783.49 642.76 1042.62%
steemfest 327 $193,004.15 590.23 957.40%
persian 98 $27,831.17 283.99 460.66%
openmic 358 $99,792.90 278.75 452.16%
eos 464 $127,119.15 273.96 444.40%
norway 342 $82,891.75 242.37 393.15%
steemit-health 198 $28,911.21 146.02 236.85%
muksteem 386 $45,751.35 118.53 192.26%
bwphotocontest 295 $32,047.11 108.63 176.22%
steemsilvergold 359 $33,865.44 94.33 153.02%
steemadvent 45 $3,636.92 80.82 131.10%

 


500 – 999 posts

Tag Posts Payouts Avg. SBD/post % of Median
beyondbitcoin 919 $628,050.24 683.41 1108.55%
curation 660 $241,073.87 365.26 592.49%
security 593 $209,119.13 352.65 572.03%
coinkorea 738 $249,295.34 337.80 547.94%
gardening 657 $154,673.96 235.42 381.88%
marijuana 653 $147,482.28 225.85 366.36%
sndbox 664 $112,738.92 169.79 275.41%
recipes 913 $151,022.24 165.41 268.32%
homesteading 796 $122,773.66 154.24 250.19%
teamaustralia 721 $101,378.63 140.61 228.08%
ita 564 $75,608.56 134.06 217.45%
vlog 609 $80,245.72 131.77 213.74%
cannabis 517 $66,652.25 128.92 209.12%
japanese 898 $97,319.79 108.37 175.79%
economy 766 $76,166.75 99.43 161.29%
coffee 614 $59,987.29 97.70 158.48%
giveaway 616 $58,911.89 95.64 155.13%
japan 822 $77,938.43 94.82 153.80%
work 866 $74,015.31 85.47 138.64%
conspiracy 686 $58,488.04 85.26 138.30%
macro 612 $52,088.75 85.11 138.06%

Low Competition, High Average Payout Steemit Tags for 2017-12-12

DasWortgewand / Pixabay

If you’re looking for post ideas, it’s good to look for primary post tags that pay well,
but don’t have that many other posts that will compete with your post.

That way, your post ranks higher (and for a longer time).

Of course, you want to make sure your post is a good fit with the category tag before posting .

I’ve split these tags into two sets, each sorted by

  • Total posts in the category (under 500, 500-999)
  • Average SBD/Post as % of the overall median
  • Minimum 125% of median SBD/post (61.65 SBD/post)

Under 500 posts

Tag Posts Payouts Avg. SBD/post % of Median
witness-category 120 132,077.31 1,100.64 1785.35%
bitshares 410 404,959.02 987.70 1602.15%
eos 254 120,901.34 475.99 772.10%
curation 472 222,220.10 470.81 763.69%
coinkorea 497 231,766.10 466.33 756.43%
steemfest 446 188,657.58 423.00 686.14%
openmic 283 91,504.75 323.34 524.49%
norway 288 76,089.81 264.20 428.56%
muksteem 207 41,979.52 202.80 328.96%
persian 118 22,719.73 192.54 312.32%
vlog 389 74,292.44 190.98 309.79%
cannabis 363 65,000.98 179.07 290.46%
minnowbooster 127 19,109.62 150.47 244.08%
steemit-health 190 28,390.31 149.42 242.38%
ita 401 59,272.31 147.81 239.76%
giveaway 442 53,693.81 121.48 197.05%
steemsilvergold 280 26,019.28 92.93 150.73%
bwphotocontest 325 29,616.92 91.13 147.82%
myanmar 286 23,623.63 82.60 133.99%
polish 404 31,414.99 77.76 126.13%

 


500-999 posts

Tag Posts Payouts Avg. SBD/post % of Median
beyondbitcoin 897 617,317.51 688.20 1116.33%
anarchism 610 174,625.35 286.27 464.36%
marijuana 527 145,642.34 276.36 448.28%
gardening 564 150,254.30 266.41 432.14%
stats 702 166,440.78 237.10 384.59%
homesteading 565 113,079.05 200.14 324.65%
recipes 774 147,878.21 191.06 309.91%
steemstem 688 127,943.60 185.96 301.65%
teamaustralia 574 90,867.36 158.31 256.79%
help 959 128,029.68 133.50 216.56%
tutorial 818 105,643.86 129.15 209.49%
minnowsupport 788 92,393.44 117.25 190.19%
japanese 770 88,535.80 114.98 186.51%
economy 641 72,950.57 113.81 184.61%
japan 657 73,965.01 112.58 182.62%
challenge 648 67,272.99 103.82 168.40%
market 887 89,189.07 100.55 163.10%
cooking 836 83,054.50 99.35 161.15%
film 904 83,266.33 92.11 149.41%
finance 919 82,553.61 89.83 145.71%
work 802 71,111.02 88.67 143.83%
space 720 63,111.63 87.66 142.18%
macro 546 47,713.85 87.39 141.75%
steemiteducation 902 77,071.70 85.45 138.60%
spirituality 761 64,790.04 85.14 138.10%
conspiracy 602 51,171.52 85.00 137.88%
future 739 57,862.69 78.30 127.01%

Hope this helps!

Low Competition, High Average SBD Payout Steemit Tags for 2017-11-28

DasWortgewand / Pixabay

When you’re looking for post ideas, it’s always good to look for primary post tags that pay well,
yet don’t have that many other posts that will compete with your post.

That way, your post is bound to rank higher (and longer) on the new post category.

Of course, you want to check the categories before posting, just to make sure your post is a good fit with the tag.

I’ve split these tags into two sets, each sorted by

  • Total posts in the category
  • Average SBD/Post as % of the overall median (minimum 125% of median)

 


Group 1
(500 total posts, >125% of median SBD/post)

Tag Posts Comments Payouts (SBD) Avg. SBD/post median % of Median
witness-category 120 812 132,077.31 1,100.64 61.65 1785.35%
bitshares 410 1825 404,959.02 987.70 61.65 1602.15%
eos 254 571 120,901.34 475.99 61.65 772.10%
curation 472 974 222,220.10 470.81 61.65 763.69%
coinkorea 497 1180 231,766.10 466.33 61.65 756.43%
steemfest 446 1374 188,657.58 423.00 61.65 686.14%
openmic 283 2896 91,504.75 323.34 61.65 524.49%
norway 288 1308 76,089.81 264.20 61.65 428.56%
muksteem 207 630 41,979.52 202.80 61.65 328.96%
persian 118 771 22,719.73 192.54 61.65 312.32%
vlog 389 380 74,292.44 190.98 61.65 309.79%
cannabis 363 525 65,000.98 179.07 61.65 290.46%
minnowbooster 127 1003 19,109.62 150.47 61.65 244.08%
steemit-health 190 1019 28,390.31 149.42 61.65 242.38%
ita 401 1020 59,272.31 147.81 61.65 239.76%
giveaway 442 650 53,693.81 121.48 61.65 197.05%
steemsilvergold 280 2197 26,019.28 92.93 61.65 150.73%
bwphotocontest 325 1183 29,616.92 91.13 61.65 147.82%
myanmar 286 1625 23,623.63 82.60 61.65 133.99%
polish 404 1114 31,414.99 77.76 61.65 126.13%

 


Group 2
500-999 total posts, >125% of median SBD/post

Tag Posts Comments Payouts (SBD) Avg. SBD/post median % of Median
beyondbitcoin 897 308 617,317.51 688.20 61.65 1116.33%
anarchism 610 226 174,625.35 286.27 61.65 464.36%
marijuana 527 459 145,642.34 276.36 61.65 448.28%
gardening 564 704 150,254.30 266.41 61.65 432.14%
stats 702 130 166,440.78 237.10 61.65 384.59%
homesteading 565 1979 113,079.05 200.14 61.65 324.65%
recipes 774 153 147,878.21 191.06 61.65 309.91%
steemstem 688 856 127,943.60 185.96 61.65 301.65%
teamaustralia 574 439 90,867.36 158.31 61.65 256.79%
help 959 359 128,029.68 133.50 61.65 216.56%
tutorial 818 200 105,643.86 129.15 61.65 209.49%
minnowsupport 788 669 92,393.44 117.25 61.65 190.19%
japanese 770 3387 88,535.80 114.98 61.65 186.51%
economy 641 127 72,950.57 113.81 61.65 184.61%
japan 657 178 73,965.01 112.58 61.65 182.62%
challenge 648 125 67,272.99 103.82 61.65 168.40%
market 887 85 89,189.07 100.55 61.65 163.10%
cooking 836 168 83,054.50 99.35 61.65 161.15%
film 904 247 83,266.33 92.11 61.65 149.41%
finance 919 79 82,553.61 89.83 61.65 145.71%
work 802 108 71,111.02 88.67 61.65 143.83%
space 720 244 63,111.63 87.66 61.65 142.18%
macro 546 308 47,713.85 87.39 61.65 141.75%
steemiteducation 902 1245 77,071.70 85.45 61.65 138.60%
spirituality 761 339 64,790.04 85.14 61.65 138.10%
conspiracy 602 270 51,171.52 85.00 61.65 137.88%
future 739 68 57,862.69 78.30 61.65 127.01%

 

Hope this helps you to tag your posts to make the most SBD!

StishApp

FREE
VIEW