You are viewing a single comment's thread from:
RE: Steemit Content Analysis
Okay, I got the accounts per day for the last 6 years. This was easy. I send you a csv file if I have all data.
But how are the others defined?
active voter is a user, who voted at least once a day/month?
active commenter is a user, who created at least a comment on a day/month?
active author is a user, who created at least a post (and comment?) on a day/month?
I think the number of posts created on a day/month is also interesting (I got it too :-) ).
You are a wizard! I am very glad, I think it will be interesting information. 🥳
Fantasy! You are a wizard of at least 14th level!
I think you indicated everything correctly. If a person voted at least once today, he can be considered an active voter. The same with comments and posts.
I send you the csv-files for each request after sending this comment.
So that you can categorise the data, I would like to explain the conditions that were used in the SQL query:
Accounts per day: Number of accounts created per day (file: daily_account_creation.csv)
Posts per day: Number of posts (without comments) created per day; also deleted/muted posts (file: daily_post_creation.csv)
Commentator per day: Number of authors per day who have written at least one comment; also deleted/muted comments; unique authors (file: daily_commentator_count.csv)
Author per day: Number of authors per day who have written at least one post; also deleted/muted posts; unique authors (file: daily_author_count.csv)
Unfortunately, there is no way (without big effort) to determine the number of voters per day. The votes are not stored separately in a table, but only together with other data.
I hope you can prepare the data accordingly and give us an analysis :-)
Here's what we got: https://steemit.com/steem/@o1eh/steem-statistics-for-6-years