• 0 Posts
  • 5 Comments
Joined 1 year ago
cake
Cake day: July 20th, 2023

help-circle

  • Honestly I think we need more voting options. Some that I would think would expand on up/down votes:

    I like this
    I don’t like this but the content is good (think news articles delivering good journalism on bad news)
    I don’t like this and don’t want to see more (irrelevant content to you)
    I disagree with this post
    Content is irrelevant to the community
    Content is spam/harmful/etc

    That’s obviously not what they would be called, but those are the feelings the votes should convey. And those can be expressed in a simple upvote downvote front to end users as well.

    I like this and I don’t like this but the content is good both deliver upvotes

    I don’t like this and don’t want to see more doesn’t do either, but tells the algorithm that you don’t want to see that stuff (I don’t even know if any fediverse stuff ranks with an algorithm.

    I disagree and content is not relevant both downvote, and content is harmful both downvotes and reports in one action


  • I can answer yes to all of these questions but still use a spreadsheet. I understand your point, but I feel even with these the line is still gray.

    I just checked and my largest spreadsheet currently has 14,300 lines across 12 tabs. Each tab contains the same information just pulled from a separate form. So each tab is linked to a form to update automatically when someone submits a new response. We then process these responses periodically throughout the day. Finished responses are color coded so a ton of formatting. Also 7+ people interacting with it daily.

    Then we have a data team that aggregates the information weekly through a script that sends them a .csv with the aggregate data.

    The spreadsheet (and subsequent forms) are updated twice a year. It was updated in June and will be updated again in December. It’s at 14k now and will continue to grow. We’ve been doing this through a few iterations and do not run into performance issues.