RE: Looking at the numbers from Steepshot // January - May 2018
Hi @jingis07, glad we could figure this out, well done! The analysis of the number of active users over a longer period of time is a very interesting metric. It shows that the number of recurring users is significantly lower than the number of active users. This approach is something to keep in mind also for other analyses. I'm curious, how did you filter out the bot comments? I think this needs a more complex query than what you've sketched with the author not in (...)
, or am I missing something?
Your contribution has been evaluated according to Utopian policies and guidelines, as well as a predefined set of questions pertaining to the category.
To view those questions and the relevant answers related to your post, click here.
Need help? Write a ticket on https://support.utopian.io/.
Chat with us on Discord.
[utopian-moderator]
It is not complex as you think.
First of all
filters post, leaving only comments
Then
author not in (......)
removes comments from the authors in the bracketREFERENCE
https://www.w3schools.com/sql/sql_in.asp
https://steemit.com/utopian-io/@paulag/analysis-of-steemit-bidbot-business-steemit-business-intelligence
Hi @jingis07, thanks for your explanation. Now I understand: your query gets all comments done via steepshot, but does not include comments done via steemit, busy, etc,. Filtering out the bot authors on those comments probably makes no difference, since the bots don't post via steepshot anyway but use other/custom
app
settings injson_metadata
. So the actual engagement level on steepshot posts is likely to be higher than the numbers you've shown.I think it could work to get all replies to a steepshot post by joining
Comments as posts
withComments as replies
onposts.permlink = replies.parent_permlink
etc... In that case your author exclude list could be used to filter out the bot replies.