You are viewing a single comment's thread from:
RE: Steemit Content Analysis
I would be interested to know how activity in Steem changes over time. How to measure it? I think you are absolutely right about this:
post_count from all authors grouped by day
post_count from unique authors grouped by day
or unique_author_count which wrote a post grouped by day
I don't know what the possibilities of getting the data might be, how long it will take. Maybe it's worth grouping the data by months instead of days to reduce the number of queries?
It would be nice to know the number of new accounts registered per day or per month.
It would be interesting to receive the following information:
But, of course, it all depends on the possibilities. Even data on one of the mentioned queries would be extremely interesting.
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