I am looking for some statistics about 30-50 least exposed sites (those having least amount of hot questions) for recent 3-4 months.

Data I am primarily interested in is: average amount of hot questions per site per week, average amount of clicks per hot question and average number of views per these questions (I expect the latter to help estimate questions popularity besides HNQ sidebar).

For comparison purposes, I would also like to get the same stats for group of 80-100 sites having higher exposure and finally, for group of 20-40 most exposed sites.

I would also want to have these stats separately for IPS, in order to ensure that unique configuration of this site didn't skew the aggregate stats too much.

Note that proposed grouping (like 50-100-20) is not a strict requirement and if there is a different, more meaningful clustering, I will be OK with that.

Additionally, I would like to get stats about percentage of hot questions that were removed from the list by moderators, percentage of closed and / or deleted hot questions and percentage of protected hot questions (for sites grouped as described above). I doubt that these stats will be needed for the purposes of this analysis but want to make sure that we won't miss some useful correlation if there is any.

  • 2
    When I return from my holiday, I can have a look at the data my scraper has gathered. Any particular reason to look only at the last 3-4 months and not from the moment the HNQ saw major changes (which IIRC was in March this year)? – Glorfindel Nov 12 '19 at 13:07
  • @Glorfindel thanks a lot! as for my selection of the timeframe, I added a solid delay from the recent changes to make sure that data is observed in "stabilized" environment, when site communities get used to the new way of working with recent features, that's why I preferred to exclude few first months – gnat Nov 12 '19 at 13:11
  • 2
    Is IPS really the only site to limit the number of HNQ questions at a time in such a way? I know IPS is kind of special, but I would have expected other site to say "we don't want more that 3 HNQ question at a time". – BelovedFool Nov 12 '19 at 13:22
  • @BelovedFool per my observations so far IPS is indeed the only site with custom limit (it's possible though that I could miss some) – gnat Nov 12 '19 at 13:24
  • 1
    I don't think Community Building has had any hot network question in the past 4 years. – gerrit Nov 19 '19 at 9:06
  • 1
    those having least amount of hot questions - what's the main criteria for you? Just the number of questions or should the duration in the HNQ matter as well? Math.SE is the site with the most # of questions in the last 4 months (904) but ranks only #19 on the 'number of spots, polled every 3 minutes' list. Worldbuilding.SE and RPG.SE dominate the latter one. – Glorfindel Dec 4 '19 at 14:55
  • @Glorfindel just the number of questions ("least amount of hot questions"), because per my knowledge SE team folks abstain of estimating duration. Though now that you mentioned it, I recalled that your magical scripts can do estimates like that, so if you provide duration as additional details, that would be definitely great, it will provide additional dimension to learn about these things – gnat Dec 4 '19 at 15:26
  • My script records both entry and exit (well, the absence of a question in the list). Here is the # of hot questions from August 1st up to November 30th, and here the # of spots taken. Just let me know so that I'm comparing the correct site groups. – Glorfindel Dec 4 '19 at 15:38
  • @Glorfindel Number of HNQs csv in your first link is what I am primarily after. If you could augment it with additional column containing spot percentage taken from second csv, that would be cool – gnat Dec 4 '19 at 15:49
  • 1
    Sure, will do. Expect an answer in 6-8 somethings :) – Glorfindel Dec 4 '19 at 15:53
  • @Glorfindel after closer checking I noticed that tables have 150 entries - it looks like sites absent in there did not have HNQ at all, correct? FWIW my rough "personal clustering" in table based on number of questions is about like this (by rank, from top to bottom): rank 1 to 30, then 31 to 80, 81 to 108, 109 to 143, then the rest that didn't appear in HNQ at all (not much to learn about the latter, except for maybe their total amount) – gnat Dec 5 '19 at 13:03
  • 1
    Yes, that's correct. Including sites with no HNQs will make my queries a lot harder to write and decipher. – Glorfindel Dec 5 '19 at 13:06

You must log in to answer this question.

Browse other questions tagged .