Text analytics reveal thirty two percent of comments on hive are not unique and at least ten percent add no value to discussion by holoz0r

View this thread on: hive.blog | peakd.com | ecency.com

hive-133987 · @holoz0r · 2025-05-27T22:07:06+00:00

$14.66

Text analytics reveal thirty two percent of comments on hive are not unique and at least ten percent add no value to discussion

![image.png](https://files.peakd.com/file/peakd-hive/holoz0r/Eq5JF9Lw823Q2bAX4ksyMGDRdWZby4vFC8iP758zYW91xz3kQEBcYejqPM9JX5SsYur.png)


In a past, professional life, I once did a task that examined the quality and occurrence of text. No on asked for it. I was a Business Analyst who kept seeing the same comments come up, and I was concerned that poor quality notes were being left on customer accounts. 

I was trying to ascertain <em>how good</em> complaint resolution notes left by on customer cases were based on their length, uniqueness, and frequency. Now that I find myself temporarily unemployed, I thought it would be fun (if you can call data fun - I do) to create a study on HIVE comments, and to do some objective analysis on the comments left on HIVE. 

Because I am feeling lazy for this analysis, I am using power query and Excel, so I'll include the step by step methodology as I go.

Firstly, some parameters about the data used: 

- Extracted from HIVE SQL, I am looking at the Comments table. 

``` = DBHive{[Schema="dbo",Item="Comments"]}[Data] ```

- I am then looking only for a week worth of content

``` = Table.SelectRows(dbo_Comments, each [created] >= #datetime(2025, 5, 18, 0, 0, 0) and [created] <= #datetime(2025, 5, 24, 0, 0, 0)) ```

- I am interested <em>only</em> in comments, not top level posts. Therefore I am filtering OUT content that does not have a parent author. I'm also keeping everything with a "blank" title, as this appears to get me actual comments.

``` = Table.SelectRows(#"Filtered Rows", each ([parent_author] <> null and [parent_author] <> "") and ([title] = "")) ```

This leaves me with 98,655 comments to work with as a sample set, looking at a period of a week. The first thing I want to check the integrity of the data, and given that I know my own data best, let me test to see what I've been doing and who I've been talking to most on the blockchain in the last week: 


| holoz0r replies to user | this many times |
|-------------------------|-----------------|
| riverflows              | 16              |
| galenkp                 | 8               |
| cryptoandcoffee         | 4               |
| jorgebgt                | 3               |
| creativemary            | 3               |
| abh12345                | 3               |
| meno                    | 3               |
| hivewatchers            | 3               |
| azircon                 | 3               |
| fastchrisuk             | 2               |
| mattclarke              | 2               |
| acidyo                  | 2               |
| steevc                  | 2               |
| menati                  | 2               |
| beatminister            | 2               |
| raceline                | 2               |
| buggedout               | 2               |
| vatman                  | 2               |
| edicted                 | 2               |
| vimukthi                | 2               |
Looks about right, given that I know my activity. 

So my next step is to figure out which account did the most replies in the sampled period. (because, as we all should know by now, not every account is a human, and it is pretty obvious on the basis of some of the account names that appear in the list. 

The next thing I want to learn about is users who are not me, because they are typically more interesting than myself. The thing I love about data is that data hides absolutely nothing, and we can see that there is a lot of bots or tokens... 

| User making comment | count of comments |
|---------------------|-------------------|
| hivebuzz            | 3634              |
| lolzbot             | 2000              |
| actifit             | 988               |
| worldmappin         | 940               |
| luvshares           | 822               |
| beerlover           | 700               |
| splinterboost       | 621               |
| pizzabot            | 616               |
| ladytoken           | 596               |
| bpcvoter1           | 452               |
| roswelborges        | 448               |
| aquarius.academy    | 448               |
| chi4god             | 442               |
| hug.bot             | 435               |
| hivebits            | 418               |
| u89gw               | 415               |
| xcv47               | 413               |
| w7ngc               | 412               |
| jkl65               | 411               |
| w95hj               | 409               |
| sor31               | 409               |
| hk14d               | 407               |
| fgh87               | 407               |
| asd09               | 407               |
| f76wz               | 405               |
| vmn31               | 404               |
| dw38h               | 404               |
| wiv01               | 403               |
| x6oc5               | 402               |
| zxc43               | 401               |

What I am interested in next is probably a futile exercise, but I want to know what the most commonly left ... comment is and what percentage that IDENTICAL comment makes up of all the comments left during the week. 

I am pleased to report that this simple analysis reveals that: 

<h1>Over 10% of the comments left on HIVE comments are entirely meaningless</h1>

Data doesn't lie. Here are the top 100 most commonly left comments. 

![image.png](https://files.peakd.com/file/peakd-hive/holoz0r/23tHZbtPDGrBVHXUTSnpLrjhi7uXF1vy1BoC4AVuDv83KHeg9kzAS8ABrvGWeZvmdaNmb.png)

Furthermore, once I exclude non-duplicate comments, we find that 32,068 of the comments left on HIVE for the week are non-unique. Therefore, from our original sample of 98,655 comments, a whopping 32.5% of comments left on the HIVE blockchain are NOT UNIQUE!

This means, on aggregate, for every comment that you see on HIVE, about one in three will be the same. Context is important though, therefore we've got to consider common phrases that appear at the top of the list: 

When I look through the duplicate comments, I can see that we're a grateful bunch, with the string "thank" appearing in 12,861 comments, or 13% of replies. 

I plan on interrogating this data in more depth, but I think this is a good starting point to build a future "dashboard" of comment health on HIVE. 

What would you like to see in such a dashboard? 

My thoughts are as follows: 

- Is the comment unique?
- How many comments by x user? 
- Who swears the most? 
- What comments are just calling bots to give tokens?
- Is the comment longer or shorter than the average comment? 
- Who on had the most interactions with who? 
- Does the comment contain picture(s)? 

Open to suggestions. Give me stuff to do.

👍 stayoutoftherz, ezrider, meesterboom, papilloncharity, sbi2, steevc, mattclarke, jarvie, jacobtothe, preparedwombat, kenny-crane, ericvancewalton, riverflows, lynds, c0ff33a, tattoodjay, ace108, friendlymoose, gadrian, minismallholding, likedeeler, gamersclassified, pusen, smartvote, harbiter, skiptvads, jjerryhan, captainquack22, littlebee4, crrdlx, strega.azure, builderofcastles, scion02b, ahlawat, b00m, esecholito, backinblackdevil, kriszrokk, citizensmith, trezzahn, terminado, dreamtales, whiterosecoffee, teamaustralia, sbi-tokens, sazbird, bearone, splinterlandshq, miprimerconcurso, castri-ja, izzydawn, bagpuss, urun, wisbeech, life-relearnt, iumac03, mariaogliastre, geom, thedailysneak, realtreebivvy, teamuksupport, sneakyninja, irregular-n, braaiboy.spt, and 34 others

`author`	holoz0r
`permlink`	text-analytics-reveal-thirty-two-percent-of-comments-on-hive-are-not-unique-and-at-least-ten-percent-add-no-value-to-discussion
`category`	hive-133987
`json_metadata`	{"app":"peakd/2025.5.7","format":"markdown","tags":["analysis","text","hivesql","comments","quality"],"users":[],"image":["https://files.peakd.com/file/peakd-hive/holoz0r/Eq5JF9Lw823Q2bAX4ksyMGDRdWZby4vFC8iP758zYW91xz3kQEBcYejqPM9JX5SsYur.png","https://files.peakd.com/file/peakd-hive/holoz0r/23tHZbtPDGrBVHXUTSnpLrjhi7uXF1vy1BoC4AVuDv83KHeg9kzAS8ABrvGWeZvmdaNmb.png"]}
`created`	2025-05-27 22:07:06
`last_update`	2025-05-27 22:07:06
`depth`	0
`children`	54
`last_payout`	2025-06-03 22:07:06
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	7.336 HBD
`curator_payout_value`	7.325 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	6,668
`author_reputation`	532,753,731,455,214
`root_title`	"Text analytics reveal thirty two percent of comments on hive are not unique and at least ten percent add no value to discussion"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	143,003,079
`net_rshares`	46,056,521,628,455
`author_curate_reward`	""

properties (23)vote details (98)

voter	rshares	pct
kenny-crane	886,574,431,819	50%
ericvancewalton	820,609,049,945	100%
meesterboom	4,676,340,857,949	100%
ace108	525,027,116,238	10%
sazbird	18,519,670,964	100%
wisbeech	12,059,743,567	100%
steevc	2,092,578,975,686	60%
mattclarke	1,218,798,255,788	100%
jacobtothe	941,222,286,469	100%
builderofcastles	77,215,551,915	31%
c0ff33a	545,644,166,746	15%
preparedwombat	939,269,084,620	42%
gamersclassified	209,622,389,446	100%
bearone	18,418,947,707	35%
teamaustralia	20,397,152,576	45%
joeyarnoldvn	452,123,181	1.47%
papilloncharity	3,465,671,879,459	80%
captainquack22	101,613,543,184	100%
tattoodjay	539,870,746,028	15%
stayoutoftherz	12,843,732,261,267	100%
likedeeler	233,656,583,126	100%
ahlawat	54,466,078,928	100%
minismallholding	425,444,512,432	50%
crrdlx	86,404,627,215	100%
noloafing	1,109,708,158	18.68%
izzydawn	14,477,596,314	50%
thegoliath	1,689,354,616	100%
miprimerconcurso	17,583,329,518	100%
citizensmith	35,735,155,179	100%
b00m	54,023,463,745	100%
sneakyninja	6,801,758,821	9.34%
blue.panda	543,781,991	15%
soufianechakrouf	1,225,690,534	50%
leslierevales	5,723,109,567	40%
portugalcoin	5,315,183,834	10%
jarvie	1,004,778,007,227	22%
realtreebivvy	8,998,163,844	50%
vatman	5,143,047,784	100%
jasonwaterfalls	749,815,127	100%
jjerryhan	106,265,653,570	40%
life-relearnt	11,821,962,081	50%
backinblackdevil	42,726,185,398	100%
sbi2	2,470,771,634,807	48.82%
gadrian	439,365,471,072	30%
riverflows	757,378,175,165	100%
thedailysneak	9,068,840,998	9.34%
mariaogliastre	11,181,608,223	100%
smartvote	131,985,897,859	6.2%
bagpuss	14,408,591,063	100%
babysavage	3,443,270,269	18.68%
ravensavage	1,800,278,043	18.68%
monsterguru	1,312,804,947	100%
whiterosecoffee	22,851,374,590	7.5%
leighscotford	781,937,146	1.5%
davidtron	1,129,644,520	17.6%
imbartley	457,990,165	15%
the.lazy.panda	923,806,727	15%
sbi-tokens	18,573,693,916	18.68%
lynds	562,754,757,304	100%
urun	12,441,227,548	100%
fenngen	2,886,520,448	50%
terminado	28,550,662,677	65%
tommys.shop	6,252,582,011	50%
teamuksupport	8,884,618,268	7.5%
friendlymoose	521,811,014,441	50%
ezrider	8,015,294,254,961	100%
esecholito	46,553,479,486	90%
fazendadolobo	584,027,630	90%
unclefunker	1,556,929,337	100%
pusen	190,702,786,499	100%
kriszrokk	40,686,750,185	100%
cryptosneeze	2,213,049,847	3.75%
emsenn0	705,694,290	3.73%
davidbright	2,847,676,469	7.5%
trezzahn	33,619,981,290	100%
geom	10,253,155,308	100%
maxmaka	713,674,193	100%
marsupia	969,542,333	30%
splinterlandshq	18,260,682,474	100%
scion02b	70,186,451,455	100%
irregular-n	6,665,351,547	80%
ingi1976	5,766,395,032	25%
edgar28	2,846,087,404	100%
iumac03	11,601,272,814	100%
littlebee4	99,792,878,572	19%
castri-ja	17,267,718,459	100%
josephlizyness	3,088,456,434	100%
skiptvads	114,962,179,951	21%
strega.azure	77,893,117,399	100%
preciouz-01	913,821,303	25%
chisomdamian	2,768,416,029	50%
braaiboy.spt	6,529,823,767	100%
dreamtales	27,568,864,911	100%
harbiter	128,246,296,849	80%
tecnotronics	3,166,731,518	100%
soundminds	2,908,862,207	60%
michael561	968,050,217	3.73%
sreymom	1,081,762,515	49%

@crrdlx · 2025-05-28T12:14:54+00:00

$0.02

This is interesting information. One thing made me scratch my head: the WUSANG comment being the most commonly mentioned. Wasn't sure what to make of that, I run the bot and HBIT seems to get called more often, and LUV even more often. So, why WUSANG? I wondered. Then, I saw that your sample week was 5/18 to 5/24. On 5/21, dead center (of course!), the Hivebits account was attacked. Evidently WUSANG was the command of choice. I wrote about it at https://peakd.com/hivebits/@crrdlx/hbit-resource-credits (initially thinking it was just a resource credits situation).

👍 holoz0r

`author`	crrdlx
`permlink`	re-holoz0r-swz0ou
`category`	hive-133987
`json_metadata`	{"tags":["hive-133987"],"app":"peakd/2025.5.7","image":[],"users":[]}
`created`	2025-05-28 12:14:54
`last_update`	2025-05-28 12:14:54
`depth`	1
`children`	6
`last_payout`	2025-06-04 12:14:54
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.010 HBD
`curator_payout_value`	0.010 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	569
`author_reputation`	66,007,718,085,702
`root_title`	"Text analytics reveal thirty two percent of comments on hive are not unique and at least ten percent add no value to discussion"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	143,012,884
`net_rshares`	68,111,376,033
`author_curate_reward`	""

properties (23)vote details (1)

voter	weight	wgt%	rshares	pct	time
holoz0r	0 B		68,111,376,033	100%

@borniet · 2025-06-06T07:07:06+00:00

$0.03

I've seen the same a while ago, when I fixed the BBHbot. A bot account was simply spreading the !BBH tipping call in comments all over the place, without even owning BBH (and thus not having tipping powers). No idea what the use of it was, but it sucked bigtime. It was at that time that I started reworking the comments of the tipping bots I operate, and slowly went towards the daily summary system (or weekly now for large part of my other bots !INDEED), and have added a pretty strong blacklisting system to my bots.
I have the impression that it is not even always about gaining things, but just the "fun" of trying to break things...

👍 crrdlx

`author`	borniet
`permlink`	re-crrdlx-202566t975168z
`category`	hive-133987
`json_metadata`	{"tags":["hive-133987"],"app":"ecency/4.1.2-vision","format":"markdown+html"}
`created`	2025-06-06 07:07:06
`last_update`	2025-06-06 07:07:06
`depth`	2
`children`	4
`last_payout`	2025-06-13 07:07:06
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.012 HBD
`curator_payout_value`	0.013 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	639
`author_reputation`	215,343,739,075,815
`root_title`	"Text analytics reveal thirty two percent of comments on hive are not unique and at least ten percent add no value to discussion"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	143,195,871
`net_rshares`	82,353,949,993
`author_curate_reward`	""

properties (23)vote details (1)

voter	weight	wgt%	rshares	pct	time
crrdlx	0 B		82,353,949,993	100%

@crrdlx · 2025-06-06T07:10:42+00:00

Agree, it's the thrill

properties (22)

`author`	crrdlx
`permlink`	re-borniet-sxfalt
`category`	hive-133987
`json_metadata`	{"tags":["hive-133987"],"app":"peakd/2025.5.9","image":[],"users":[]}
`created`	2025-06-06 07:10:42
`last_update`	2025-06-06 07:10:42
`depth`	3
`children`	3
`last_payout`	2025-06-13 07:10:42
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.000 HBD
`curator_payout_value`	0.000 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	22
`author_reputation`	66,007,718,085,702
`root_title`	"Text analytics reveal thirty two percent of comments on hive are not unique and at least ten percent add no value to discussion"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	143,195,900
`net_rshares`	0

3 replies

@holoz0r · 2025-05-28T12:19:45+00:00

$0.03

Very important for the data to line up with our <em>temporal</em> observations! I hadn't heard about your project prior to this, and my discovery of the WUSANG command is what led me to follow your account, which may be what lead you to come to this post, I'm not sure!

I plan to exclude such calls to bots in future analysis of comment quality, because, well, they have their place for the communities that enjoy using them and speculating on the Hive Engine tokens and various side chains that they're integrated with. 

I won't lie, my query on those token call commands is sort of linked with @aggroed  [recently posting](https://peakd.com/hive-/@aggroed/hive-engine-transaction-fees-for-bots-update-wednesday-may-28-go-live-date-and-more-lead-time-for-community-businesses-services-) about changing the ability for bulk transactions to occur on the sidechains. 

As with all things, it is all interconnected. I just want to learn more about the over arching comment quality on HIVE :)

👍 crrdlx

`author`	holoz0r
`permlink`	re-crrdlx-swz0wu
`category`	hive-133987
`json_metadata`	{"tags":["hive-133987"],"app":"peakd/2025.5.7","image":[],"users":["aggroed"]}
`created`	2025-05-28 12:19:45
`last_update`	2025-05-28 12:19:45
`depth`	2
`children`	0
`last_payout`	2025-06-04 12:19:45
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.012 HBD
`curator_payout_value`	0.013 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	991
`author_reputation`	532,753,731,455,214
`root_title`	"Text analytics reveal thirty two percent of comments on hive are not unique and at least ten percent add no value to discussion"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	143,012,954
`net_rshares`	84,879,063,273
`author_curate_reward`	""

properties (23)vote details (1)

voter	weight	wgt%	rshares	pct	time
crrdlx	0 B		84,879,063,273	100%

@darkflame · 2025-05-28T16:55:57+00:00

$0.06

Good analysis! This is the kind of data that I find fascinating. A dashboard is a great idea but even updates about these figures would be helpful. Hivewatchers keeps an eye out for SPAM, but I have spent a lot of time wondering how we can examine and verify some of the content that has already been created. The first 6 days are key for upvotes, but most upvotes are usually made within the first hour of being <a href="https://peakd.com/created">created</a>. 

For some more stat suggestions;
- how many comments are posts that are !PIZZA calls? (good stats, user engagement)
- how many stories/comments have NOT been upvoted on? (separate spam/possible treasure)
- how many users have posted/commented within the last hour?

I honestly have a lot more ideas.
I see other good suggestions in the other comments as well.


![image.png](https://files.peakd.com/file/peakd-hive/darkflame/EpVFQQE8HY6omp6Xa15Tvkj26jK4yUg4qnRritTchS7Rj7HbNmmkZcjBVZyVmh84LCe.png)


https://hiveuprss.github.io/hiveisbeautiful/

👍 jacobtothe

`author`	darkflame
`permlink`	re-holoz0r-swzdp8
`category`	hive-133987
`json_metadata`	{"tags":["hive-133987"],"app":"peakd/2025.5.9","image":["https://files.peakd.com/file/peakd-hive/darkflame/EpVFQQE8HY6omp6Xa15Tvkj26jK4yUg4qnRritTchS7Rj7HbNmmkZcjBVZyVmh84LCe.png"],"users":[]}
`created`	2025-05-28 16:55:57
`last_update`	2025-05-28 16:55:57
`depth`	1
`children`	4
`last_payout`	2025-06-04 16:55:57
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.030 HBD
`curator_payout_value`	0.030 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	1,007
`author_reputation`	91,268,302,506,475
`root_title`	"Text analytics reveal thirty two percent of comments on hive are not unique and at least ten percent add no value to discussion"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	143,019,458
`net_rshares`	183,915,660,747
`author_curate_reward`	""

properties (23)vote details (1)

voter	weight	wgt%	rshares	pct	time
jacobtothe	0 B		183,915,660,747	20%

@borniet · 2025-06-06T06:28:30+00:00

$0.10

That IS an interesting link for sure! Thanks for sharing! 
What is the Podping thing btw?

👍 darkflame

`author`	borniet
`permlink`	re-darkflame-202566t82830894z
`category`	hive-133987
`json_metadata`	{"tags":["hive-133987"],"app":"ecency/4.1.2-vision","format":"markdown+html"}
`created`	2025-06-06 06:28:30
`last_update`	2025-06-06 06:28:30
`depth`	2
`children`	2
`last_payout`	2025-06-13 06:28:30
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.050 HBD
`curator_payout_value`	0.051 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	89
`author_reputation`	215,343,739,075,815
`root_title`	"Text analytics reveal thirty two percent of comments on hive are not unique and at least ten percent add no value to discussion"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	143,195,366
`net_rshares`	308,950,597,278
`author_curate_reward`	""

properties (23)vote details (1)

voter	weight	wgt%	rshares	pct	time
darkflame	0 B		308,950,597,278	89%

@darkflame · 2025-06-06T07:22:03+00:00

I believe https://3speak.tv/ uses Podping. @brianoflondon knows about this.

"Podping leverages Hive to solve the RSS polling problem."

Recent post --> https://peakd.com/podping/@brianoflondon/podping-on-hive-is-quietly-announcing-3000-podcast-episodes-per-hour

properties (22)

`author`	darkflame
`permlink`	re-borniet-sxfb4n
`category`	hive-133987
`json_metadata`	{"tags":["hive-133987"],"app":"peakd/2025.5.9"}
`created`	2025-06-06 07:22:03
`last_update`	2025-06-06 07:22:03
`depth`	3
`children`	1
`last_payout`	2025-06-13 07:22:03
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.000 HBD
`curator_payout_value`	0.000 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	262
`author_reputation`	91,268,302,506,475
`root_title`	"Text analytics reveal thirty two percent of comments on hive are not unique and at least ten percent add no value to discussion"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	143,196,034
`net_rshares`	0

1 reply

@holoz0r · 2025-05-28T23:52:03+00:00

$0.11

Thanks for sharing that link! I watched it for maybe a little bit too long, it was a pretty nice implementation of sitting back and watching the world go by. 

I have some logic written to detect any calls to bots that have an exclamation mark in front of them. I think some sort of hybrid metric that looks at comment length and complexity (of the language used) will find those that aren't just calling the bot for people to farm the hive engine tokens. 

I think the other interesting thing (if it is there in the data) - I can probably work on this as a goal - is ... what was the oldest post that got a comment that week? 

Will require me to do one big pull of data from hivesql, or maybe download and interrogate the block log for historical data, but it would definitely be very interesting!

👍 darkflame

`author`	holoz0r
`permlink`	re-darkflame-swzwyr
`category`	hive-133987
`json_metadata`	{"tags":["hive-133987"],"app":"peakd/2025.5.9","image":[],"users":[]}
`created`	2025-05-28 23:52:03
`last_update`	2025-05-28 23:52:03
`depth`	2
`children`	0
`last_payout`	2025-06-04 23:52:03
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.054 HBD
`curator_payout_value`	0.054 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	799
`author_reputation`	532,753,731,455,214
`root_title`	"Text analytics reveal thirty two percent of comments on hive are not unique and at least ten percent add no value to discussion"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	143,027,301
`net_rshares`	330,472,157,489
`author_curate_reward`	""

properties (23)vote details (1)

voter	weight	wgt%	rshares	pct	time
darkflame	0 B		330,472,157,489	100%

@harbiter · 2025-05-27T23:07:15+00:00

$0.02

I guess this is what happens when you've got plenty of time 😂

👍 holoz0r

`author`	harbiter
`permlink`	re-holoz0r-swy085
`category`	hive-133987
`json_metadata`	{"tags":["hive-133987"],"app":"peakd/2025.5.7","image":[],"users":[]}
`created`	2025-05-27 23:07:15
`last_update`	2025-05-27 23:07:15
`depth`	1
`children`	1
`last_payout`	2025-06-03 23:07:15
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.012 HBD
`curator_payout_value`	0.012 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	61
`author_reputation`	98,489,128,872,304
`root_title`	"Text analytics reveal thirty two percent of comments on hive are not unique and at least ten percent add no value to discussion"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	143,003,690
`net_rshares`	80,227,401,346
`author_curate_reward`	""

properties (23)vote details (1)

voter	weight	wgt%	rshares	pct	time
holoz0r	0 B		80,227,401,346	100%

@holoz0r · 2025-05-27T23:25:45+00:00

Only for now... this has been circulating in my thoughts for some time. Maybe I'll make a scoring algorithm and get people grades for their comment performance.

properties (22)

`author`	holoz0r
`permlink`	re-harbiter-swy12v
`category`	hive-133987
`json_metadata`	{"tags":["hive-133987"],"app":"peakd/2025.5.7"}
`created`	2025-05-27 23:25:45
`last_update`	2025-05-27 23:25:45
`depth`	2
`children`	0
`last_payout`	2025-06-03 23:25:45
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.000 HBD
`curator_payout_value`	0.000 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	160
`author_reputation`	532,753,731,455,214
`root_title`	"Text analytics reveal thirty two percent of comments on hive are not unique and at least ten percent add no value to discussion"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	143,003,947
`net_rshares`	0

@jacobtothe · 2025-05-29T20:05:42+00:00

$0.02

The bilpcoin spam farm (at least 10 accounts, although not all are active spammers) has been a source of irritation for me over the last year. The repetition combined with the length is insane.

Another account, @aquarius.academy, seems to feed from a list of dubiously-soirced "inspirational" quotations and has taken to replying to old posts long past payout. I try to keep an eye on it and down ote any upvotes while alerting those voters to the scam. Can you filter accounts rotating through such lists?

Finally, while I see less of it now, the ol' "nice post" and "follow for follow?" stuff has declined, but still seems to crop up from new users unfamiliar with our netiquette or bad actors trying the laziest possible methods.

👍 holoz0r, dustbunny

`author`	jacobtothe
`permlink`	re-holoz0r-sx1h5g
`category`	hive-133987
`json_metadata`	{"tags":["hive-133987"],"app":"peakd/2025.5.9","image":[],"users":["aquarius.academy"]}
`created`	2025-05-29 20:05:42
`last_update`	2025-05-29 20:05:42
`depth`	1
`children`	2
`last_payout`	2025-06-05 20:05:42
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.012 HBD
`curator_payout_value`	0.012 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	734
`author_reputation`	567,290,588,872,877
`root_title`	"Text analytics reveal thirty two percent of comments on hive are not unique and at least ten percent add no value to discussion"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	143,047,157
`net_rshares`	78,552,125,280
`author_curate_reward`	""

properties (23)vote details (2)

voter	weight	wgt%	rshares	pct	time
holoz0r	0 B		57,898,320,102	70%
dustbunny	0 B		20,653,805,178	6.54%

@holoz0r · 2025-05-30T03:52:48+00:00

$0.06

I have a list of accounts that I'm tagging as human or not human, and it is my intent to focus on "human" interaction, but yes, I will be publishing the list of accounts that I am tagging as non human in my next post on this topic. 

There is a filter in my data set for this, as I've set it up as a flag in the table I'm building. 

> Finally, while I see less of it now, the ol' "nice post" and "follow for follow?" stuff has declined, but still seems to crop up from new users unfamiliar with our netiquette or bad actors trying the laziest possible methods.

I am really keen to see how many posts are just "Thank You" and the number of these, and how many unique users do things like that. That will be my next group by command on my data set, I am just processing some more rows to get a bit of a longer term picture than the week I sampled here. 

A week is just a snap shop, whereas a few months will be meaningful, and enable week on week tracking for trends, word clouds, key words and overall sentiment analysis and more. 

There's so much that can be done.

👍 jacobtothe

`author`	holoz0r
`permlink`	re-jacobtothe-sx22rz
`category`	hive-133987
`json_metadata`	{"tags":["hive-133987"],"app":"peakd/2025.5.9","image":[],"users":[]}
`created`	2025-05-30 03:52:48
`last_update`	2025-05-30 03:52:48
`depth`	2
`children`	1
`last_payout`	2025-06-06 03:52:48
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.032 HBD
`curator_payout_value`	0.032 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	1,069
`author_reputation`	532,753,731,455,214
`root_title`	"Text analytics reveal thirty two percent of comments on hive are not unique and at least ten percent add no value to discussion"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	143,053,101
`net_rshares`	192,492,693,756
`author_curate_reward`	""

properties (23)vote details (1)

voter	weight	wgt%	rshares	pct	time
jacobtothe	0 B		192,492,693,756	20%

@jacobtothe · 2025-05-30T04:02:18+00:00

It's nice we have an open system for that kind of analysis. Web2 social media is full of the same kind of nonsense, but transparency is antithetical to their model.

properties (22)

`author`	jacobtothe
`permlink`	re-holoz0r-sx237s
`category`	hive-133987
`json_metadata`	{"tags":["hive-133987"],"app":"peakd/2025.5.9","image":[],"users":[]}
`created`	2025-05-30 04:02:18
`last_update`	2025-05-30 04:02:18
`depth`	3
`children`	0
`last_payout`	2025-06-06 04:02:18
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.000 HBD
`curator_payout_value`	0.000 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	164
`author_reputation`	567,290,588,872,877
`root_title`	"Text analytics reveal thirty two percent of comments on hive are not unique and at least ten percent add no value to discussion"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	143,053,216
`net_rshares`	0

@kenny-crane · 2025-05-29T21:53:24+00:00

Nice use of HiveSQL and thanks for sharing the results on top repeated comments for the recent week.  

I see the @tokenfaucet bot call of !TF on the list.  That gives HBD, HIVE, LOH or PEPE.  And it only works on tokenfaucet posts so it is more self-contained.  Also it doesn't reply anything in certain cases, rather than giving error messages.

I have read that there is plenty of room in the blocks we produce every 3 seconds but it's still good practice to limit what we put in there, I would think, especially for bot related comments.

But also, HIVE is more than people posting and commenting. So it is expected to see people come up with other use cases for this blockchain.

Thanks again for the post and data.  It is getting good interaction here in the comments too!

👍 holoz0r

`author`	kenny-crane
`permlink`	re-holoz0r-sx1m51
`category`	hive-133987
`json_metadata`	{"tags":["hive-133987"],"app":"peakd/2025.5.9","image":[],"users":["tokenfaucet"]}
`created`	2025-05-29 21:53:24
`last_update`	2025-05-29 21:53:24
`depth`	1
`children`	3
`last_payout`	2025-06-05 21:53:24
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.000 HBD
`curator_payout_value`	0.000 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	778
`author_reputation`	234,919,950,009,556
`root_title`	"Text analytics reveal thirty two percent of comments on hive are not unique and at least ten percent add no value to discussion"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	143,048,560
`net_rshares`	55,927,724,850
`author_curate_reward`	""

properties (23)vote details (1)

voter	weight	wgt%	rshares	pct	time
holoz0r	0 B		55,927,724,850	65%

@holoz0r · 2025-05-30T03:46:18+00:00

$0.05

It is definitely true that HIVE is more than people just posting and commenting. There are other uses, but they should really be custom json transactions like all the Splinterlands battles were once upon a time. :) 

While there might be plenty of room in those blocks, one day, there might not be, and it is important, for me at least, to understand what makes it up, so that one day when there might not be enough room in those blocks, we can look back at things like this as a community and decide what we want to assign the valuable space in our blocks to. 

Furthermore, I am not sure how to feel about curation projects leaving a comment on everything they vote. That information is recorded by the chain as the vote action, and I'm not sure what "value" the comment alerting to the author to that is. Particularly for some communities and hives where it seems almost each and every post gets one of those "curation" comments.

👍 kenny-crane

`author`	holoz0r
`permlink`	re-kenny-crane-sx22h3
`category`	hive-133987
`json_metadata`	{"tags":["hive-133987"],"app":"peakd/2025.5.9","image":[],"users":[]}
`created`	2025-05-30 03:46:18
`last_update`	2025-05-30 03:46:18
`depth`	2
`children`	2
`last_payout`	2025-06-06 03:46:18
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.022 HBD
`curator_payout_value`	0.023 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	933
`author_reputation`	532,753,731,455,214
`root_title`	"Text analytics reveal thirty two percent of comments on hive are not unique and at least ten percent add no value to discussion"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	143,053,053
`net_rshares`	141,292,492,080
`author_curate_reward`	""

properties (23)vote details (1)

voter	weight	wgt%	rshares	pct	time
kenny-crane	0 B		141,292,492,080	8%

@kenny-crane · 2025-05-30T04:41:57+00:00

$0.03

Thanks for the reply!

>While there might be plenty of room in those blocks, one day, there might not be

I have always thought the exact same thing. I am not convinced that all HIVE needs is 100X the number of MAUs (Monthly Active Users) and all will be well, although I have read several people who have said that on here. Having that many new people posting and commenting has its own social issues and abuse potential and token depreciation as I think most noobs are mainly sellers. I don't think the reward pool can handle a big increase in people here.  And I don't think there enough room in the blocks for 100X people, but I could be wrong.  I just think, be careful what you wish for!  I have seen niche online communities last decades and I would be fine if we stay small. I don't know how many other people I could follow on here anyway.  I'm already on here too many minutes a day!

> I am not sure how to feel about curation projects leaving a comment on everything they vote

I also agree.  They take up blockchain space and presentation space on the page, especially ones with graphics. But then again, people like the dopamine hit from these comments. I guess we're all like rats in a <a href="https://en.wikipedia.org/wiki/B._F._Skinner">Skinner</a> box who perform an action for a reward. I'm not sure what that says about modern society but that's a topic for another day.

At tokenfaucet, a reply is necessary because we randomly give one of 4 tokens with one of a few multipliers so we tell them what they've won. I'm actually thinking of moving the "game" to its own website so as not to be a part of potential over use of the blockchain.

Well thanks again for the interaction which got me thinking further, I appreciate you! :)

👍 holoz0r

`author`	kenny-crane
`permlink`	re-holoz0r-sx251z
`category`	hive-133987
`json_metadata`	{"tags":["hive-133987"],"app":"peakd/2025.5.9"}
`created`	2025-05-30 04:41:57
`last_update`	2025-05-30 04:41:57
`depth`	3
`children`	1
`last_payout`	2025-06-06 04:41:57
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.012 HBD
`curator_payout_value`	0.013 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	1,752
`author_reputation`	234,919,950,009,556
`root_title`	"Text analytics reveal thirty two percent of comments on hive are not unique and at least ten percent add no value to discussion"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	143,053,714
`net_rshares`	79,827,441,986
`author_curate_reward`	""

properties (23)vote details (1)

voter	weight	wgt%	rshares	pct	time
holoz0r	0 B		79,827,441,986	100%

1 reply

@mattrife · 2025-05-29T09:04:18+00:00

$0.06

I find this analysis very true to my experience when browsing Hive. Every time I post, I get dozens of comments like “Awesome post!”, “Thanks for sharing”, and “Great content,” – which I know 90% are bots. As a new user, I feel a bit discouraged because I don’t know if the interactions on [Wacky Flip](https://wacky-flip.org) are genuine or just “bait” to earn tokens. If Hive wants to retain real users, the quality of comments should be prioritized over quantity!

👍 jacobtothe

`author`	mattrife
`permlink`	sx0mj7
`category`	hive-133987
`json_metadata`	{"links":["https://wacky-flip.org"],"app":"hiveblog/0.1"}
`created`	2025-05-29 09:04:18
`last_update`	2025-05-29 09:04:18
`depth`	1
`children`	2
`last_payout`	2025-06-05 09:04:18
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.030 HBD
`curator_payout_value`	0.030 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	466
`author_reputation`	9,194,932,003
`root_title`	"Text analytics reveal thirty two percent of comments on hive are not unique and at least ten percent add no value to discussion"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	143,035,297
`net_rshares`	184,608,043,285
`author_curate_reward`	""

properties (23)vote details (1)

voter	weight	wgt%	rshares	pct	time
jacobtothe	0 B		184,608,043,285	20%

@holoz0r · 2025-05-29T12:17:24+00:00

Well, there will be some future analysis that I perform on those comments from different users that are the same. 

A lot of people might say "thank you", "thanks", "great photo", "good post", "Really interesting", or other stuff like that. 

I have three pages built so far following on from this post to break down some stuff, and will just present it as is, without any commentary, aside from sharing my methodology.

properties (22)

`author`	holoz0r
`permlink`	re-mattrife-sx0vgz
`category`	hive-133987
`json_metadata`	{"tags":["hive-133987"],"app":"peakd/2025.5.7","image":[],"users":[]}
`created`	2025-05-29 12:17:24
`last_update`	2025-05-29 12:17:24
`depth`	2
`children`	0
`last_payout`	2025-06-05 12:17:24
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.000 HBD
`curator_payout_value`	0.000 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	422
`author_reputation`	532,753,731,455,214
`root_title`	"Text analytics reveal thirty two percent of comments on hive are not unique and at least ten percent add no value to discussion"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	143,038,003
`net_rshares`	0

@jacobtothe · 2025-05-29T20:07:30+00:00

The best way to get genuine followers for your account is to find other content creators and offer genuine comments yourself. Otherwise, yeah, nothing but bots trying to farm votes.

properties (22)

`author`	jacobtothe
`permlink`	re-mattrife-sx1h8g
`category`	hive-133987
`json_metadata`	{"tags":["hive-133987"],"app":"peakd/2025.5.9"}
`created`	2025-05-29 20:07:30
`last_update`	2025-05-29 20:07:30
`depth`	2
`children`	0
`last_payout`	2025-06-05 20:07:30
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.000 HBD
`curator_payout_value`	0.000 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	181
`author_reputation`	567,290,588,872,877
`root_title`	"Text analytics reveal thirty two percent of comments on hive are not unique and at least ten percent add no value to discussion"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	143,047,175
`net_rshares`	0

@meesterboom · 2025-05-29T20:22:21+00:00

$1.67

*Thank* for this analysis 😃

The bots are bad, nice to know about one in three bad!

👍 galenkp, holoz0r
👎 endhivewatchers

`author`	meesterboom
`permlink`	re-holoz0r-sx1hx7
`category`	hive-133987
`json_metadata`	{"tags":["hive-133987"],"app":"peakd/2025.5.9","image":[],"users":[]}
`created`	2025-05-29 20:22:21
`last_update`	2025-05-29 20:22:21
`depth`	1
`children`	1
`last_payout`	2025-06-05 20:22:21
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.836 HBD
`curator_payout_value`	0.837 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	83
`author_reputation`	1,794,309,123,074,202
`root_title`	"Text analytics reveal thirty two percent of comments on hive are not unique and at least ten percent add no value to discussion"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	143,047,386
`net_rshares`	5,038,327,347,526
`author_curate_reward`	""

properties (23)vote details (3)

voter	rshares	pct
holoz0r	57,014,446,691	68%
galenkp	4,981,312,900,835	50%
endhivewatchers	0	-0.01%

@holoz0r · 2025-05-30T03:49:09+00:00

$0.16

I see what you did there. That won't come up in the report until I do more analysis on newer data. ;) 

I am hoping to publish some stuff in a few hours exploring some more insights that I am digging into using the data set.

👍 meesterboom

`author`	holoz0r
`permlink`	re-meesterboom-sx22lv
`category`	hive-133987
`json_metadata`	{"tags":["hive-133987"],"app":"peakd/2025.5.9","image":[],"users":[]}
`created`	2025-05-30 03:49:09
`last_update`	2025-05-30 03:49:09
`depth`	2
`children`	0
`last_payout`	2025-06-06 03:49:09
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.082 HBD
`curator_payout_value`	0.082 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	225
`author_reputation`	532,753,731,455,214
`root_title`	"Text analytics reveal thirty two percent of comments on hive are not unique and at least ten percent add no value to discussion"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	143,053,078
`net_rshares`	491,901,918,614
`author_curate_reward`	""

properties (23)vote details (1)

voter	weight	wgt%	rshares	pct	time
meesterboom	0 B		491,901,918,614	10%

@papilloncharity · 2025-05-29T20:36:54+00:00

$0.02

A question. If I like to give commentors a token for a comment, instead of a few cents. At least in my mind, a token is more valuable than some cents. So, if someone farms tokens like Lol, Pizza, Beer, or any other, would it appear that I am a partner of the farmers?

👍 holoz0r, dustbunny

`author`	papilloncharity
`permlink`	re-holoz0r-2025529t223641929z
`category`	hive-133987
`json_metadata`	{"tags":["analysis","text","hivesql","comments","quality"],"app":"ecency/4.1.2-vision","format":"markdown+html"}
`created`	2025-05-29 20:36:54
`last_update`	2025-05-29 20:36:54
`depth`	1
`children`	7
`last_payout`	2025-06-05 20:36:54
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.012 HBD
`curator_payout_value`	0.012 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	267
`author_reputation`	2,503,340,996,105,196
`root_title`	"Text analytics reveal thirty two percent of comments on hive are not unique and at least ten percent add no value to discussion"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	143,047,537
`net_rshares`	79,760,814,350
`author_curate_reward`	""

properties (23)vote details (2)

voter	weight	wgt%	rshares	pct	time
holoz0r	0 B		56,065,721,173	66%
dustbunny	0 B		23,695,093,177	7.47%

@holoz0r · 2025-05-30T03:47:54+00:00

If you're making a good, comment that references the material and tries to get some genuine discussion with the author, that is very different from just hitting them with a "token call" comment. 

I suppose if you're thanking someone for their comment and that's all, but instead of the reward being HIVE, and being the token instead via the token call, I suppose it is going to be more than just the token call, right? :)

properties (22)

`author`	holoz0r
`permlink`	re-papilloncharity-sx22js
`category`	hive-133987
`json_metadata`	{"tags":["hive-133987"],"app":"peakd/2025.5.9","image":[],"users":[]}
`created`	2025-05-30 03:47:54
`last_update`	2025-05-30 03:47:54
`depth`	2
`children`	6
`last_payout`	2025-06-06 03:47:54
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.000 HBD
`curator_payout_value`	0.000 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	423
`author_reputation`	532,753,731,455,214
`root_title`	"Text analytics reveal thirty two percent of comments on hive are not unique and at least ten percent add no value to discussion"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	143,053,061
`net_rshares`	0

@beerlover · 2025-05-30T07:48:42+00:00

<div class='pull-right'>https://files.peakd.com/file/peakd-hive/beerlover/yiuU6bdf-beerlover20gives20BEER.gif<p><sup><a href='https://hive-engine.com/?p=market&t=BEER'>View or trade </a> <code>BEER</code>.</sup></p></div><center><br> <p>Hey @holoz0r, here is a little bit of <code>BEER</code> from @papilloncharity for you. Enjoy it!</p> <p>Learn how to <a href='https://peakd.com/beer/@beerlover/what-is-proof-of-stake-with-beer'>earn <b>FREE BEER</b> each day </a> by staking your <code>BEER</code>.</p> </center><div></div>

properties (22)

`author`	beerlover
`permlink`	re-holoz0r-re-papilloncharity-sx22js-20250530t074842198z
`category`	hive-133987
`json_metadata`	{"app":"beerlover/3.0","language":"rust","developer":"wehmoen"}
`created`	2025-05-30 07:48:42
`last_update`	2025-05-30 07:48:42
`depth`	3
`children`	0
`last_payout`	2025-06-06 07:48:42
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.000 HBD
`curator_payout_value`	0.000 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	527
`author_reputation`	25,788,868,904,142
`root_title`	"Text analytics reveal thirty two percent of comments on hive are not unique and at least ten percent add no value to discussion"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	143,056,025
`net_rshares`	0

@beerlover · 2025-05-30T07:48:48+00:00

<div class='pull-right'>https://files.peakd.com/file/peakd-hive/beerlover/yiuU6bdf-beerlover20gives20BEER.gif<p><sup><a href='https://hive-engine.com/?p=market&t=BEER'>View or trade </a> <code>BEER</code>.</sup></p></div><center><br> <p>Hey @holoz0r, here is a little bit of <code>BEER</code> from @papilloncharity for you. Enjoy it!</p> <p>Did you know that <a href='https://dcity.io/city</b>you can use <b>BEER</b> at dCity game</a> to buy cards to rule the world.</p> </center><div></div>

properties (22)

`author`	beerlover
`permlink`	re-holoz0r-re-papilloncharity-sx22js-20250530t074848167z
`category`	hive-133987
`json_metadata`	{"app":"beerlover/3.0","language":"rust","developer":"wehmoen"}
`created`	2025-05-30 07:48:48
`last_update`	2025-05-30 07:48:48
`depth`	3
`children`	0
`last_payout`	2025-06-06 07:48:48
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.000 HBD
`curator_payout_value`	0.000 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	492
`author_reputation`	25,788,868,904,142
`root_title`	"Text analytics reveal thirty two percent of comments on hive are not unique and at least ten percent add no value to discussion"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	143,056,026
`net_rshares`	0

@papilloncharity · 2025-05-30T07:48:33+00:00

$0.02

Yeah, you are right, and short replies to comments seems to be in fashion nowadays.  Thankfully there are still people around who one can have a good conversation with. Replies like "very nice pictures", and such does not auger well for long engagements.
!BEER

👍 holoz0r

`author`	papilloncharity
`permlink`	re-holoz0r-2025530t94831237z
`category`	hive-133987
`json_metadata`	{"tags":["hive-133987"],"app":"ecency/4.1.2-vision","format":"markdown+html"}
`created`	2025-05-30 07:48:33
`last_update`	2025-05-30 07:48:33
`depth`	3
`children`	3
`last_payout`	2025-06-06 07:48:33
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.012 HBD
`curator_payout_value`	0.012 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	260
`author_reputation`	2,503,340,996,105,196
`root_title`	"Text analytics reveal thirty two percent of comments on hive are not unique and at least ten percent add no value to discussion"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	143,056,023
`net_rshares`	74,585,934,735
`author_curate_reward`	""

properties (23)vote details (1)

voter	weight	wgt%	rshares	pct	time
holoz0r	0 B		74,585,934,735	100%

3 replies

@pizzabot · 2025-05-28T16:56:18+00:00

<center>PIZZA!


$PIZZA slices delivered:
@darkflame<sub>(1/15)</sub> tipped @holoz0r 


<sub>Come get [MOON](https://moon.hive.pizza)ed!</sub></center>

properties (22)

`author`	pizzabot
`permlink`	re-text-analytics-reveal-thirty-two-percent-of-comments-on-hive-are-not-unique-and-at-least-ten-percent-add-no-value-to-discussion-20250528t165618z
`category`	hive-133987
`json_metadata`	"{"app": "pizzabot"}"
`created`	2025-05-28 16:56:18
`last_update`	2025-05-28 16:56:18
`depth`	1
`children`	0
`last_payout`	2025-06-04 16:56:18
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.000 HBD
`curator_payout_value`	0.000 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	152
`author_reputation`	7,566,038,174,751
`root_title`	"Text analytics reveal thirty two percent of comments on hive are not unique and at least ten percent add no value to discussion"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	143,019,463
`net_rshares`	0

@riverflows · 2025-06-01T06:48:06+00:00

Oh I really want to know who swears the most - thankyou! ;)

> Over 10% of the comments left on HIVE comments are entirely meaningless

This doesn't surprise me. I think @tarazkp told me years ago I didn't have to reply to every comment ... 🤯🤯🤯🤯 which made me feel better about the whole thing 😂 

Grateful for our meaningful - I think - conversations this week!

properties (22)

`author`	riverflows
`permlink`	re-holoz0r-sx6085
`category`	hive-133987
`json_metadata`	{"tags":["hive-133987"],"app":"peakd/2025.5.9","image":[],"users":["tarazkp"]}
`created`	2025-06-01 06:48:06
`last_update`	2025-06-01 06:48:06
`depth`	1
`children`	1
`last_payout`	2025-06-08 06:48:06
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.000 HBD
`curator_payout_value`	0.000 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	363
`author_reputation`	2,087,871,067,002,455
`root_title`	"Text analytics reveal thirty two percent of comments on hive are not unique and at least ten percent add no value to discussion"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	143,094,971
`net_rshares`	0

@holoz0r · 2025-06-01T09:40:09+00:00

They'll always be meaningful. So long as at least 50% of the participants choose to assign value to it. Or.. someone comes along and joins our conversations.

properties (22)

`author`	holoz0r
`permlink`	re-riverflows-sx686v
`category`	hive-133987
`json_metadata`	{"tags":["hive-133987"],"app":"peakd/2025.5.9","image":[],"users":[]}
`created`	2025-06-01 09:40:09
`last_update`	2025-06-01 09:40:09
`depth`	2
`children`	0
`last_payout`	2025-06-08 09:40:09
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.000 HBD
`curator_payout_value`	0.000 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	158
`author_reputation`	532,753,731,455,214
`root_title`	"Text analytics reveal thirty two percent of comments on hive are not unique and at least ten percent add no value to discussion"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	143,096,642
`net_rshares`	0

@scion02b · 2025-05-28T10:39:27+00:00

$0.02

Thanks for sharing! Data is fun!  Now this makes me want to learn how to access HiveSQL to play around with. :)

👍 holoz0r

`author`	scion02b
`permlink`	re-holoz0r-swyw9n
`category`	hive-133987
`json_metadata`	{"tags":["hive-133987"],"app":"peakd/2025.5.7","image":[],"users":[]}
`created`	2025-05-28 10:39:27
`last_update`	2025-05-28 10:39:27
`depth`	1
`children`	1
`last_payout`	2025-06-04 10:39:27
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.010 HBD
`curator_payout_value`	0.011 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	111
`author_reputation`	7,312,002,205,386
`root_title`	"Text analytics reveal thirty two percent of comments on hive are not unique and at least ten percent add no value to discussion"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	143,011,575
`net_rshares`	70,168,331,758
`author_curate_reward`	""

properties (23)vote details (1)

voter	weight	wgt%	rshares	pct	time
holoz0r	0 B		70,168,331,758	100%

@holoz0r · 2025-05-28T10:41:33+00:00

$0.02

It is easy. There's a tutorial on [WWW.HIVESQL.IO](https://docs.hivesql.io/tutorials/hivesql-for-microsoft-excel)

You need to pay a 1HBD Fee. You can then connect using PowerQuery, SQL, Python, or whatever other programming language you'd like to use that supports SQL statements. 

I'm doing some more in depth analysis on this data set at the moment, and I expect to have a few other posts around this data in the coming days. :)

👍 scion02b

properties (23)vote details (1)

@stayoutoftherz · 2025-05-27T22:32:54+00:00

$0.02

Very interesting! Maybe to find out how comments are rewarded, or if posts from authors with higher stake get on average more comments. I have the strong feeling that there are many comment farmers out there who don´t contribute much but at least try to be not entirely repetitive (unlike the "well done sir" from past times). And if those comment farmers get more upvotes on their comments than users with less, but more meaningful comments.
Or a separate analysis of long comments (e.g. >50 words). Are they more rewarded than shorter comments? Which communities have longer comments? Are there communities with significantly more comments than others? There is a lot to do...

👍 holoz0r

properties (23)vote details (1)

@holoz0r · 2025-05-27T23:24:09+00:00

$0.04

Comment length by community is a very interesting idea, and I am already wondering if high stakeholders get more engagement on account of lower vested accounts thinking they will get noticed and get some crumbs.

Comment depth is also a factor. If there’s a free flowing discourse, that’s awesome, if length is consistent. 

You’ve given me a lot to think about and I appreciate that.

👍 stayoutoftherz

properties (23)vote details (1)

@steevc · 2025-05-29T19:40:39+00:00

$0.02

There's plenty of junk on Hive. I wondered what all the accounts were with random looking 5 letter names. Looks like they are part of Waivo and may just be used to store data for their system. Anyone can use Hive as a database and they don't even have to worry about downvotes really. I wonder if this will expand. I was actually thinking about some data I could store on the blockchain, but I know there are ways to do it without creating posts or comments.

There's a certain idiot who leaves loads of spammy comments on my posts, but we can't stop that. At least they are mostly hidden. You don't need that much HP to allow a bot to post all day.

Cheers for the interesting data.

👍 holoz0r, dustbunny

properties (23)vote details (2)

@bpcvoter1 · 2025-05-31T11:56:24+00:00

@steevc, you seem to enjoy spreading lies, don’t you? We only share the truth—call it spam if you wish.  

**TURN OFF THE BUILDAWHALE SCAM FARM**  
- **STOP THE BAD DOWNVOTES**  
- **STOP PLAYING WITH PEOPLE’S LIVELIHOODS**  

---

### Key Issues That Demand Immediate Attention:  
The problems are glaring, undeniable, and corrosive to the Hive ecosystem. They must be addressed without delay:  
- **Downvote abuse**  
- **Farming schemes**  
- **Speaking disrespectfully to others**  
- **Encouraging people to avoid certain users out of personal dislike**  
- **Self-voting with alt accounts**  
- **Self-funding projects through self-votes**  
- **Promoting games that don’t even exist** (LOL)  

These practices harm not just individual users—they undermine the very foundation of Hive, eroding trust and poisoning the community. Such actions are unethical and outright destructive.  

---

### @buildawhale Wallet:  
- **HIVE (Primary Token):** 0.012  
- **Staked HIVE (HP):** 66,400.611  
- **Total HP:** 2,421,539.226  
- **Delegated HIVE:** +2,355,138.615 HP  
  - Received: **2,355,080 HP from @blocktrades** (Aug 16, 2020)  

### @usainvote Wallet:  
- **HIVE (Primary Token):** 0.066  
- **Staked HIVE (HP):** 138,123.296  
- **Total HP:** 715,745.407  
- **Delegated HIVE:** +577,622.111 HP  
  - Received: **577,622 HP from @blocktrades** (Aug 16, 2020)  

[@buildawhale/wallet](https://peakd.com/@buildawhale/wallet) | [@usainvote/wallet](https://peakd.com/@usainvote/wallet)  

---

### @ipromote Wallet:  
- **Author Rewards:** 2,181.16  
- **Curation Rewards:** 4,015.61  
- **Staked HIVE (HP):** 0.00  
- **Rewards/Stake Co-efficient (KE):** NaN  

- **HIVE:** 25,203.749  
- **Staked HIVE (HP):** 0.000  
- **Delegated HIVE:** 0.000  
- **Estimated Account Value:** $6,946.68  

**Recent Activity:**  
- Sent to alpha-5,196.000 HIVE (21 hours ago)  
- Sent to hiveswap-1,000.000 HIVE (2 days ago)  
- Withdraw vesting from @proposalalert to @ipromote 0.447 HIVE (3 days ago)  
- Received from proposalalert 4.003 HIVE (5 days ago)  
- Received from themarkymark 1,775.684 HIVE (9 days ago)  
- Sent to alpha-4,245.000 HIVE (9 days ago)  
- Received from themarkymark 4,280.527 HIVE (17 days ago)  

---

### @leovoter Wallet:  
- **Author Rewards:** 194.75  
- **Curation Rewards:** 193.88  
- **Staked HIVE (HP):** 0.00  
- **Rewards/Stake Co-efficient (KE):** **388,632.00** *(Suspiciously High)*  

- **HIVE:** 0.000  
- **Staked HIVE (HP):** 0.001  
- **Total:** 16.551  
- **Delegated HIVE:** +16.550  

**Recent Activity:**  
- Withdraw vesting from @leovoter to @ipromote 0.053 HIVE (Sep 29, 2024)  
- Withdraw vesting from @leovoter to @ipromote 0.053 HIVE (Sep 22, 2024)  
- Withdraw vesting from @leovoter to @ipromote 0.053 HIVE (Sep 15, 2024)  
- Withdraw vesting from @leovoter to @ipromote 0.053 HIVE (Sep 8, 2024)  
- Withdraw vesting from @leovoter to @ipromote 0.053 HIVE (Sep 1, 2024)  

---

### @abide Wallet:  
**Recent Activity:**  
- Sent to ipromote -2,459.000 HIVE (22 days ago)  
- Sent to ipromote -2,486.200 HIVE (Apr 1, 2025)  
- Received from yabapmatt 20,000.000 HIVE (Apr 1, 2025)  
- Sent to ipromote -2,130.400 HIVE (Mar 8, 2025)  
- Sent to ipromote -2,248.000 HIVE (Feb 2, 2025)  
- Sent to yabapmatt -5,000.000 HIVE (Jan 25, 2025)  

---

### @proposalalert Wallet:  
- **Author Rewards:** 639.99  
- **Curation Rewards:** 0.00  
- **Staked HIVE (HP):** 6.03  
- **Rewards/Stake Co-efficient (KE):** 106.12  

**Recent Activity:**  
- Withdraw vesting from @proposalalert to @ipromote 0.447 HIVE (3 days ago)  
- Sent to ipromote -4.003 HIVE (5 days ago)  
- Sent to themarkymark -0.012 HBD (5 days ago)  
- Withdraw vesting from @proposalalert to @ipromote 0.447 HIVE (10 days ago)  
- Withdraw vesting from @proposalalert to @ipromote 0.446 HIVE (17 days ago)  

---

### @stemgeeks Wallet:  
- **Author Rewards:** 4,391.77  
- **Curation Rewards:** 304.26  
- **Staked HIVE (HP):** 0.00  
- **Rewards/Stake Co-efficient (KE):** **4,696,032.00** *(Extremely Suspicious)*  

**Recent Activity:**  
- Sent to themarkymark -1.556 HBD (Jun 14, 2024)  
- Claim rewards: 1.556 HBD, 5.912 HP (Jun 14, 2024)  
- Withdraw vesting from @stemgeeks to @ipromote 6.160 HIVE (Jun 8, 2024)  
- Sent to themarkymark -1.601 HBD (Jun 7, 2024)  
- Withdraw vesting from @stemgeeks to @ipromote 6.157 HIVE (Jun 1, 2024)  
- Sent to ipromote -1.618 HBD (May 31, 2024)  

---

### @theycallmemarky Wallet:  
- **Author Rewards:** 458.89  
- **Curation Rewards:** 0.00  
- **Staked HIVE (HP):** 0.00  
- **Rewards/Stake Co-efficient (KE):** **458,886.00** *(Highly Suspicious)*  

**Recent Activity:**  
- Withdraw vesting from @theycallmemarky to @ipromote 0.728 HIVE (Jan 12, 2025)  
- Withdraw vesting from @theycallmemarky to @ipromote 0.727 HIVE (Jan 5, 2025)  
- Withdraw vesting from @theycallmemarky to @ipromote 0.727 HIVE (Dec 29, 2024)  
- Withdraw vesting from @theycallmemarky to @ipromote 0.727 HIVE (Dec 22, 2024)  
- Withdraw vesting from @theycallmemarky to @ipromote 0.726 HIVE (Dec 15, 2024)  
- Withdraw vesting from @theycallmemarky to @ipromote 0.726 HIVE (Dec 8, 2024)  
- Withdraw vesting from @theycallmemarky to @ipromote 0.725 HIVE (Dec 1, 2024)  
- Sent to ipromote -9.202 HIVE (Oct 17, 2024)  

---

### @apeminingclub Wallet:  
- **Author Rewards:** 432.57  
- **Curation Rewards:** 2,829.11  
- **Staked HIVE (HP):** 30.51  
- **Rewards/Stake Co-efficient (KE):** 106.90  

**Recent Activity:**  
- Scheduled unstake (power down): ~2.351 HIVE (in 4 days, remaining 7 weeks)  
- Total Staked HIVE: 1,292.019  
- Delegated HIVE: +1,261.508  
  - Received delegations:  
    - @xykorlz: 624 HP (Jan 26, 2024)  
    - @bashadow: 111 HP (Sep 20, 2021)  
    - @dechuck: 104 HP (Mar 10, 2024)  
    - @hironakamura: 76 HP (Aug 23, 2022)  

- Withdraw vesting from @apeminingclub to @blockheadgames 2.348 HIVE (10 days ago)  
- Claim rewards: 0.290 HP (10 days ago)  

---

### @blockheadgames Wallet:  
- **Author Rewards:** 619.76  
- **Curation Rewards:** 99.30  
- **Staked HIVE (HP):** 0.00  
- **Rewards/Stake Co-efficient (KE):** **719,063.00** *(Highly Suspicious)*  

**Recent Activity:**  
- Withdraw vesting from @apeminingclub to @blockheadgames 2.350 HIVE (3 days ago)  
- Withdraw vesting from @apeminingclub to @blockheadgames 2.348 HIVE (10 days ago)  
- Withdraw vesting from @apeminingclub to @blockheadgames 2.347 HIVE (17 days ago)  

---

### @empoderat Wallet:  
- **HIVE (Primary Token):** 300.000  
- **Staked HIVE (HP):** 5,000.602  
- **Total:** 10.001  
- **Delegated HIVE:** -4,990.601  
  - Delegated Out: **4,991 HP to @empo.voter** (19 days ago)  

**Recent Activity:**  
- Received from acidyo 300.000 HIVE (5 hours ago)  
- Sent to bdhivesteem -10,000.808 HIVE (a day ago)  
- Received from black-mountain 387.048 HIVE (a day ago)  
- Received from hiveswap 3,384.700 HIVE (a day ago)  
- Powered up 500 HP (a day ago)  
- Stopped power down 0 HP (a day ago)  
- Received from acidyo 5,200.000 HIVE (a day ago)  
- Withdrew from vesting 798.346 HIVE (3 days ago)  
- Claimed rewards: 2.914 HBD, 17.291 HP (6 days ago)  

---

### @gogreenbuddy Wallet:  
- **HIVE (Primary Token):** 472.407  
- **Staked HIVE (HP):** 273,472.276  
- **Total:** 246,351.982  
- **Delegated HIVE:** -27,120.294  
  - Delegated Out:  
    - @curamax: 17,132 HP (Jan 11, 2025)  
    - @livepayout: 2,515 HP (Mar 5, 2025)  
    - @yablonsky: 1,011 HP (Jan 17, 2025)  
    - @thebighigg: 1,005 HP (Mar 26, 2025)  

**Recent Activity:**  
- Received from @punkteam -0.172 HBD (Jan 20, 2024)  
- Received from @punkteam -327.485 HIVE (Jan 20, 2024)  
- Received from @punkteam -248.912 HIVE (Jan 9, 2024)  
- Received from @punkteam -248.772 HIVE (Dec 28, 2023)  
- Received from @punkteam -3.155 HBD (Dec 26, 2023)  
- Received from @punkteam -497.127 HIVE (Dec 26, 2023)  
- Received from @punkteam -248.356 HIVE (Dec 9, 2023)  

---

### @rollingbones Wallet:  
- **Author Rewards:** 212.88  
- **Curation Rewards:** 29.09  
- **Staked HIVE (HP):** 0.08  
- **Rewards/Stake Co-efficient (KE):** 2,880.63  

**Recent Activity:**  
- Sent to ipromote -0.014 HIVE (Aug 19, 2021)  
- Sent to ipromote -0.449 HIVE (Jul 27, 2021)  
- Sent to ipromote -0.265 HIVE (Jul 10, 2021)  
- Sent to ipromote -1.202 HIVE (Jul 3, 2021)  
- Sent to ipromote -0.479 HIVE (Jun 8, 2021)  
- Sent to ipromote -2.945 HIVE (Jun 1, 2021)  
- Sent to ipromote -4.290 HIVE (Apr 20, 2021)  
- Sent to honey-swap -1.107 HIVE (Feb 10, 2021)  
- Sent to ipromote -0.895 HIVE (Jan 11, 2021)  
- Sent to ipromote -12.025 HIVE (Mar 7, 2020)  

---

The blockchain data tells the story plainly and clearly. We are not fabricating these claims; we are merely presenting what is already visible for all to see. As we’ve repeatedly urged @themarkymark & Co—the solution is simple: **STOP**.  

**SO PLEASE STOP.** It’s time to do what’s right for Hive and its community. Why cling to practices that harm others? Power down, step away, and let Hive thrive as it was meant to. You bring nothing positive to this ecosystem.  

**THOSE WHO ARE WATCHING—THIS COULD HAPPEN TO YOU.**  

**PLEASE STOP.**

properties (22)

@holoz0r · 2025-05-30T03:56:45+00:00

$0.06

There will be some more data to come! 

The definition of spam varies from user to user. There is also a list of accounts that I'm curating to flag as "non human" in my data set. 

Longer term, we might need to see "competition" for inclusion in blocks, perhaps based on resource credits. 

There is a <em>lot</em> of spam, but the resource credits you get for HP are an absolute bargain compared to the amount of crap you can inject into the chain.

👍 steevc

properties (23)vote details (1)

@thegoliath · 2025-05-27T22:19:51+00:00

$0.62

Surprise surprise, more like negative surprise surprise at how many bot accounts and auto-generated comments from token call commands there are!

Some great statistics there for a starting point of what you are looking into.
A dashboard would be great to share a bulk of those dot points you mentioned.. start off including some of the most useful points:

* Is the comment unique?
* How many comments by x user?
* What comments are just calling bots to give tokens?
* Who on had the most interactions with who?

This will provide some solid data and insights into comments and can later be built upon further.
I agree with data being fun, seeing the numbers and statistics showing how you want, from what you worked on is a good feeling!

![image.png](https://files.peakd.com/file/peakd-hive/thegoliath/23xL5Jo3oUgm29ZDkppFGPadtR4tFxZyRHR4wu8An9r1EUTAvcjy3m9oR1mNFRc69XKad.png)
[Image google search sourced and original source is from Reddit](https://www.reddit.com/r/HIMYM/comments/6wqusx/marshalls_pie_chart/)

👍 frogcake, mattclarke, holoz0r, kiokizz, shaidon

properties (23)vote details (5)

@holoz0r · 2025-05-27T22:25:33+00:00

Thanks mate, I don't want to overload hivesql too much with my queries, so I'm going to try and do as much <em>local</em> processing as possible. 

I have used PowerBI professionally, and could build such a thing and perhaps distribute the PBIX file for people to run it on their local systems, as I don't intend on paying for a pro licence. I might use PowerBI to prototype, then...

Do the data processing on my machine(s), then figure out a way to display JSON / CSV data in a web interface and host it as a github page or some such...

👍 thegoliath, endhivewatchers

properties (23)vote details (2)

@thegoliath · 2025-05-27T22:32:36+00:00

$0.56

Good idea, as it will be a lot for it to process along with everything already being processed, through the mass transactions the chain is going through daily.

PowerBI is so useful, I haven't dealt with it much and mostly used Excel but PowerBI is on my list for learning.

Distributing it would be good for people to see the stats, same as hosting on Github and displaying on a web interface. Keen to see more posts on this, as you feel the need to share progress for anyone else that is interested.

👍 frogcake, mattclarke, holoz0r, kiokizz

properties (23)vote details (4)

1 reply

@vatman · 2025-05-28T10:50:54+00:00

"Data doesn't lie" — very true. There are a lot of comment bots out there, and if they drop generic comments on every post, they’re bound to get small votes here and there. That adds up over time, so it’s clearly profitable for minimal (or zero) effort.

What’s wild is that these low-effort spam comments don’t seem to get flagged by the same people who claim to uphold the “quality post” standard. Makes you wonder how consistent those standards really are.

What do you think is stopping those accounts from being penalized more often? Is it because they fly under the radar, could one of those "big boss" accounts be the one running it, or is it just not worth the effort to deal with them?

properties (22)

@holoz0r · 2025-05-28T11:08:12+00:00

Probably because I haven't seen this analysis done publicly before. :P Comments are also much more difficult to systematically punish, probably because they don't get the same visibility as top-level posts do. I'm not so much interested in the reward, for a good comment, because to me, the endorphins and serotonin I get from having a genuine interaction with someone is the "Drug" I am chasing. 

I don't want to <em>punish</em> people who make shitty comments, that would discourage them from improving. Instead, I think we should <em>reward</em> people who make good comments, and try to raise everyone's ability to create, good, engaging comments. 

They don't even have to be in English. I'm seeing lots of other languages in the plaintext I've extracted, and I see a lot of "gracias", which I know means Thanks, or something :P It is just that English is the only language I know fluently, other than the various sounds I make when I bend over as I continue to age and lift heavy things at the gym. :D

👍 vatman

properties (23)vote details (1)

@vatman · 2025-05-28T11:16:15+00:00

$0.02

I found it really interesting how you were able to collect all this data using the magic you call “HiveSQL” — lol.

On the language side, I’m fluent in both Spanish and English (i live in Argentina), so I’m actually thinking of running similar analytics on the Spanish-speaking community to see if the same patterns show up there. Could be cool to compare and see if the issue of low-value comments translates across languages just as clearly. What do you think ?

👍 holoz0r

properties (23)vote details (1)

3 replies

`author`	bpcvoter1
`permlink`	sx4jzh
`category`	hive-133987
`json_metadata`	{"users":["steevc","buildawhale","blocktrades","usainvote","ipromote","proposalalert","leovoter","abide","stemgeeks","theycallmemarky","apeminingclub","xykorlz","bashadow","dechuck","hironakamura","blockheadgames","empoderat","empo.voter","gogreenbuddy","curamax","livepayout","yablonsky","thebighigg","punkteam","rollingbones","themarkymark"],"links":["https://peakd.com/@buildawhale/wallet"],"app":"hiveblog/0.1"}
`created`	2025-05-31 11:56:24
`last_update`	2025-05-31 11:56:24
`depth`	2
`children`	0
`last_payout`	2025-06-07 11:56:24
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.000 HBD
`curator_payout_value`	0.000 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	9,128
`author_reputation`	-19,521,573,901,955
`root_title`	"Text analytics reveal thirty two percent of comments on hive are not unique and at least ten percent add no value to discussion"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	143,078,863
`net_rshares`	0

voter	rshares	pct
mattclarke	623,059,148,761	50%
holoz0r	82,666,176,232	100%
kiokizz	53,404,668,577	100%
shaidon	40,051,123,335	100%
frogcake	1,161,662,173,198	100%

voter	rshares	pct
mattclarke	593,249,725,417	50%
holoz0r	78,697,254,234	100%
kiokizz	48,005,894,528	100%
frogcake	1,050,213,437,025	100%