pull down to refresh

I've been pulling some stats off SN this last few hours.
Analysing the top stackers but in a new way. Seeing who is top of the pops for 'sats per write' and who is the best 'conversation keeper' with their posts. Not sure how best to present all the tables & keep it in a readable format. Perhaps a vertical PDF. Will try and wrap it up for early next week.
This will be so cool to see! Based on your work, I know I don't need to say this, but I am nothing if not redundant, and so: please post methodology when you 'release' the big one!
reply
210 sats \ 5 replies \ @davidw 13 Jan
Fun Fact Not-Friday... @Natalia has more comments on her posts on average than even @sn (58.2 vs 57.1)
reply
I've been pulling some stats off SN this last few hours
wow, impressive - how did you get those data πŸ‘€ is it the SQL that @ekzyis trying to pill me in?
reply
484 sats \ 3 replies \ @davidw 13 Jan
The stats don't take into consideration every post on the site.
I made a python script that pulls any post above 1k sats in rewards and dumps the details into a local spreadsheet for now.
reply
this's one of those skills I lack, would be so nice if get to see it in action. πŸ€”
reply
You're seeing very similar skills in action right now, lol :)
But I know what you mean. More posts!
I'll try to use my automation skills to get faster with my ZtZ posts so I still have time for other things lol
I'm still doing a lot manual.
Cool! Any sneak-peak takeaways yet?
reply

Posting on particular Day of Week

Posting at Time of Day (Eastern time)

This is taking data from posts over 5k with over sats total (that were not "Satsraisers"). Goes to show posting early for the European market & when people wake-up State-side pays off. Waiting a few more hours leads to more discussion/comments. Time shown is in U.S. Eastern time. Wednesdays, Thursdays (and surprisingly Sundays) have been popular too.
cc. @Natalia if posting just once a week, something to bear in mind πŸ˜€
reply
🀠 One more follow-up....
People who are NOT currently cowboys/cowgirls have bigger peaks & troughs. (Current) cowboys continue to stack consistently throughout the week...
Whereas the opposite is true for comments from cowboys. Way more discussion on their posts, perhaps suggesting we could do more to get "dippers' to engage after posting something of value on SN. They seem extremely active on Sundays, which is a nice opportunity for us to skew the rewards that day perhaps.
(Note: data still from posts with over 5k sats).
reply
456 sats \ 1 reply \ @kurszusz 13 Jan
How I can become a cowboy? :)
reply
451 sats \ 0 replies \ @davidw 13 Jan
Be both curious and generous with your time. Proof of work will see to it that you are rewarded.
reply
interesting, but there are quiet some undergrounds πŸ€“ did you count them in?
perhaps suggesting we could do more to get "dippers' to engage after posting something of value on SN
what dat mean πŸ€” the easiest and best way is do a shoutout in saloon once post something:)
reply
My bad, with poor English. Dipping into something, I use it like it’s temporary. In and out quickly.
When non-cowboys post something (at least this is my interpretation) there’s naturally a little less discussion from everyone. I suspect a big portion of comments from cowboy posts, are from cowboys themselves.
The chart is telling me that others have less time/willingness to be able to do it during the week, which makes sense.
reply
and @Undisciplined is signaling that he is watching us. πŸ˜‚
When non-cowboys post something (at least this is my interpretation) there’s naturally a little less discussion from everyone. I suspect a big portion of comments from cowboy posts, are from cowboys themselves.
hmmmm, especially when @nemo in town, more fun - dancing in everyone's post, taking all the street!
reply
Just a gentle nudge for you to keep this interesting conversation going. Pretend like I'm not even here.
reply
230 sats \ 3 replies \ @davidw 13 Jan
@nemo must be enjoying the reef right now. The only way I can keep this going is by posting more charts...

Sats per post - current cowboys vs not

reply
when would you post this fun piece?
also, here are some tiny things that could be improved in the charts
  • format of dates - I guess you mean Mons, Tues, Weds, etc, get rid of 1-7 then.
  • the colors - yellow and orange is hard to tell apart, same for pinkish and dark red.
  • it would be even nicer to include the numbers like how many cowboys and noncowboys in this data collection, how many posts in total etc.
I also like posting either in Wed or Thur, works great for my schedule too, and nothing need to stressed about when it's in the middle of the week!
this "Sats Per Post - Posted at Time of Day" is quite interesting.
reply
Definitely is. Something I had witnessed/felt when posting ~6am Eastern but hadn't proven until now. Now I wonder how many sats I have left on the table posting later in the day, once I finally finish editing (versus waiting the extra day).
reply
for me, I noticed the best is 6-10am Eastern time.
Now I wonder how many sats I have left on the table posting later in the day, once I finally finish editing (versus waiting the extra day).
yea, you always post in my late nights πŸ˜†
also one more bonus of posting "early" is that you could easily rank into the top post with more zap ranks.
this is the real SSL here @ekzyis
reply
I had noticed the same with early posts.
I wonder if it's driven by the reward schedule: early posts have more time to climb the ranks and earn more rewards.
Maybe an upcoming rewards experiment can vary the timing of the rewards calculation. cc: @k00b and @ekzyis
reply
Great point. Kind of bizarre how the comments by time of day are the complete opposite to zaps.
People mindlessly zapping with their feet in the mornings, versus commenting whilst munching down a sandwich nearer lunchtime.
reply