Approval, rejection and decision time statistics for Adopt a subreddit program by Reddit.
This repository includes:
- Scraper script that uses pullpush API for getting data from r/redditrequest
- Analys script that counts comments from u/request_bot
- That script counts the following:
- Instant moderation request grants by bot
- Moderation rejections by bot for the following reasons:
- Requester is banned in the requesting community
- Invalid link in post
- Community is already in the queue
- Request was already posted by the same requester less than 15 days ago
- Requester didn't reply to bot
- Requester has not met criteria
- Community violated Reddit's policies
- Community was recently banned
- Community has active mods
- Community is not eligible for moderation requests
- Requester has not verified email
- Manual request rejections by admins (for whatever reason they have in mind)
- Along with a formatted spreadsheet with data from 01.06.2024 to 06.01.2025. File. Uploaded to Google Spreadsheets. I recommend opening it with Google Spreadsheets, not Microsoft Excel.
- Scraper was tested on comments from 01.06.2024 and to 06.01.2025, may require adjustments in text matching for other ranges



Granted | 298 |
Community was recently banned | 33 |
User has not verified email | 23 |
Admin decision | 173 |
Not eligible community | 25 |
Community has active mods | 142 |
Community violated Reddit policies | 7 |
User has not met criteria | 118 |
User didn't reply to bot | 37 |
Repeated request | 114 |
Community already in queue | 11 |
Invalid link in post | 16 |
User is banned in the requested sub | 3 |
Top mod requests during period | 56 |
Top mod removal granted | 10 |
User is already top mod | 22 |
Time between request and admin decision | 404 058 |
Time between request and granted median without instagrants | 390 794 |
Time between request and granted average without instagrants | 399 406 |
Time between request and admin reject | 337 762 |
Instantly granted | 167 |
Not instantly granted | 131 |



Requests made during period | 3 429 |
Granted | 778 |
Community was recently banned | 109 |
User has not verified email | 86 |
Admin decision | 697 |
Not eligible community | 13 |
Community has active mods | 376 |
Community violated Reddit policies | 33 |
User has not met criteria | 380 |
User didn't reply to bot | 101 |
Repeated request | 387 |
Community already in queue | 78 |
Invalid link in post | 53 |
User is banned in the requested sub | 9 |
Top mod requests during period | 222 |
Top mod removal granted | 28 |
User is already top mod | 81 |
Time between request and admin decision | 448 508 |
Time between request and granted median without instagrants | 440 843 |
Time between request and granted average without instagrants | 456 569 |
Time between request and admin reject | 384 977 |
Instantly granted | 519 |
Not instantly granted | 259 |



Requests made during period | 3 096 |
Granted | 556 |
Community was recently banned | 85 |
User has not verified email | 61 |
Admin decision | 568 |
Not eligible community | 19 |
Community has active mods | 391 |
Community violated Reddit policies | 14 |
User has not met criteria | 367 |
User didn't reply to bot | 91 |
Repeated request | 356 |
Community already in queue | 5 |
Invalid link in post | 51 |
User is banned in the requested sub | 10 |
Top mod requests during period | 233 |
Top mod removal granted | 18 |
User is already top mod | 83 |
Time between request and admin decision | 471 832 |
Time between request and granted median without instagrants | 479 542 |
Time between request and granted average without instagrants | 496 114 |
Time between request and admin reject | 370 649 |
Instantly granted | 474 |
Not instantly granted | 82 |



Requests made during period | 2 644 |
Granted | 416 |
Community was recently banned | 67 |
User has not verified email | 77 |
Admin decision | 449 |
Not eligible community | 22 |
Community has active mods | 336 |
Community violated Reddit policies | 21 |
User has not met criteria | 319 |
User didn't reply to bot | 72 |
Repeated request | 335 |
Community already in queue | 23 |
Invalid link in post | 34 |
User is banned in the requested sub | 3 |
Top mod requests during period | 175 |
Top mod removal granted | 40 |
User is already top mod | 68 |
Time between request and admin decision | 443 412 |
Time between request and admin reject | 330 483 |
Instantly granted | 415 |
Not instantly granted | 1 |



Requests made during period | 4 406 |
Granted | 854 |
Community was recently banned | 107 |
User has not verified email | 114 |
Admin decision | 564 |
Not eligible community | 39 |
Community has active mods | 579 |
Community violated Reddit policies | 34 |
User has not met criteria | 627 |
User didn't reply to bot | 103 |
Repeated request | 532 |
Community already in queue | 27 |
Invalid link in post | 81 |
User is banned in the requested sub | 5 |
Top mod requests during period | 515 |
Top mod removal granted | 20 |
User is already top mod | 349 |
Time between request and admin decision | 468 396 |
Time between request and granted median without instagrants | 582 734 |
Time between request and granted average without instagrants | 589 440 |
Time between request and admin reject | 359 313 |
Instantly granted | 845 |
Not instantly granted | 9 |



Requests made during period | 4 841 |
Granted | 849 |
Community was recently banned | 112 |
User has not verified email | 140 |
Admin decision | 588 |
Not eligible community | 72 |
Community has active mods | 610 |
Community violated Reddit policies | 22 |
User has not met criteria | 774 |
User didn't reply to bot | 123 |
Repeated request | 622 |
Community already in queue | 32 |
Invalid link in post | 69 |
User is banned in the requested sub | 12 |
Top mod requests during period | 610 |
Top mod removal granted | 26 |
User is already top mod | 409 |
Time between request and admin decision | 471 086 |
Time between request and granted median without instagrants | 420 589 |
Time between request and granted average without instagrants | 436 530 |
Time between request and admin reject | 388 362 |
Instantly granted | 826 |
Not instantly granted | 23 |



Requests made during period | 3 415 |
Granted | 676 |
Community was recently banned | 72 |
User has not verified email | 105 |
Admin decision | 437 |
Not eligible community | 18 |
Community has active mods | 473 |
Community violated Reddit policies | 30 |
User has not met criteria | 510 |
User didn't reply to bot | 102 |
Repeated request | 400 |
Community already in queue | 3 |
Invalid link in post | 51 |
User is banned in the requested sub | 4 |
Top mod requests during period | 462 |
Top mod removal granted | 30 |
User is already top mod | 283 |
Time between request and admin decision | 445 201 |
Time between request and granted median without instagrants | 340 524 |
Time between request and granted average without instagrants | 340 524 |
Time between request and admin reject | 368 996 |
Instantly granted | 673 |
Not instantly granted | 3 |



Requests made during period | 3 752 |
Granted | 629 |
Community was recently banned | 108 |
User has not verified email | 129 |
Admin decision | 339 |
Not eligible community | 52 |
Community has active mods | 515 |
Community violated Reddit policies | 32 |
User has not met criteria | 615 |
User didn't reply to bot | 94 |
Repeated request | 444 |
Community already in queue | 4 |
Invalid link in post | 68 |
User is banned in the requested sub | 9 |
Top mod requests during period | 558 |
Top mod removal granted | 31 |
User is already top mod | 326 |
Time between request and admin decision | 462 080 |
Time between request and granted median without instagrants | 575 075 |
Time between request and granted average without instagrants | 453 430 |
Time between request and admin reject | 316 511 |
Instantly granted | 626 |
Not instantly granted | 3 |
- Clone repository
- Adjust values in scrape.ts file: on line 116 adjust dates: after and before. Script will parse starting from before and sorted in descending order to older posts, so you need to change second argument (before) each time you restart script.
- Run scrape.ts with Bun:
bun scrape.ts
- After that, comments.json will be generated, use
bun analys.ts
and you will get list of values needed to be inserted into spreadsheets starting from the very first row. Just copy and paste them into B1 cell and they will populate needed rows. Do not change order of output in analys.ts or it will mess up data in spreadsheets. You might get errors likeNo autoreply for
. You can ignore them, as there will be data cutoffs where you scraped result of request, but not initial posting of it.