Recently the 'Moderation results' were published across all Stack Exchange sites.

On my main site, Drupal Answers, I noticed a drastic fall in moderation actions, flagging etc. from the results that were published last year.

I then wanted to discover further on SEDE to get the difference of the overall activity of the site from 2018-2019.

By the overall activity, I mean the amount of answers, questions, comments etc.

Since I don’t have experience writing SEDE queries I ask here for guidance how to write such a query. One day I will look into writing SEDE queries and getting to know the database.

I want to have a query that returns the difference of the following data from 2018-2019 (it should be possible to make start and end year dynamic).

  • Amount of questions
  • Amount of answers
  • Amount of comments
  • Amount of new contributors

Don’t know if there’s more that makes sense to include in the query, feel free to comment if you think there’s something that should be added to the query.

  • 2
    If you get 10K you have access to graphs of number of questions and answers. – Journeyman Geek Jan 6 at 1:13
  • I've just been doing it manually. – Rubiksmoose Jan 6 at 1:35
  • Not a query but this site comparing the dumps on a couple of things might help somewhat: sese.evbpc.com – curious Jan 6 at 2:00
  • @JourneymanGeek I don't doubt that what you say is correct, but perhaps I could trouble you for a URL for the graphs you speak of on Worldbuilding. – Tantalus' touch. Jan 6 at 3:52
  • @JourneymanGeek I think you're talking about the Site Analytics privilege, but that's 25K. – Glorfindel Jan 6 at 7:17
  • .... Clearly my memory is a little faulty. – Journeyman Geek Jan 6 at 7:28

The decrease of moderation activities might actually be a good thing in your case. According to this metasmoke report, Drupal Answers saw much less spam in 2019 than in 2018:

enter image description here

I've written a SEDE query comparing the number of questions and answers networkwide, to answer How can we find the fastest growing sites within the last year?. It's a bit of overkill if you just want to use it for a single site, but the number of questions has dropped by about 13% and the number of answers by 35%:

enter image description here

But I think you're better off using the queries Rubiksmoose used here:

| improve this answer | |

You must log in to answer this question.