Coming soon - Get a detailed view of why an account is flagged as spam!
view details

This post has been de-listed

It is no longer included in search results and normal feeds (front page, hot posts, subreddit posts, etc). It remains visible only via the author's post history.

3
[New Features] Ability to aggregate subreddits and authors by average and sum of comment scores
Author Summary
Stuck_In_the_Matrix is in New Features
Post Body

Moving forward with more features for score data, the API will now allow aggregations by author and subreddit with regards to score to show the top scoring subreddits and authors.

Keep in mind that this aggregation is expensive (especially for authors) and may timeout if it exceeds 20 seconds -- so you should also use the metadata=true parameter to check if it did time out.

There are a few parameters to use here including min_doc_count which will restrict results to show only subreddits or authors who made at least X comments is a specific period. I always find examples to be the best way to learn, so here are some examples.

To see the top subreddits by average comment score over a 24 hour period (this shows between 2 and 3 days ago) where the subreddit had at least 1,000 comments made in that period, you would do this:

https://api.pushshift.io/reddit/comment/search/?aggs=subreddit:score:avg&after=96h&before=72h&min_doc_count=1000&size=100

This will show the top 100 subreddits that had the highest average comment scores.

The four new aggregations are:

subreddit:score:avg

subreddit:score:sum

author:score:avg

author:score:sum

If you wanted to see how much total karma was generated from a specific author, you could do this:

https://api.pushshift.io/reddit/comment/search/?aggs=author:score:sum&after=96h&before=72h&min_doc_count=1&author=[deleted]&size=0&metadata=true

This shows that there was a total of 279,942 karma generated from comments by [deleted] authors.

Who were the top 10 average contributors by highest average comment score to /r/science in that period?

https://api.pushshift.io/reddit/comment/search/?aggs=author:score:avg&after=96h&before=72h&min_doc_count=1&subreddit=science&agg_size=10&size=0&metadata=true

Most of the results are from people who had one comment that generated a lot of karma. You could increase the min_doc_count to something higher.

In this example, in order to be included in the rankings, an author would have had to make at least 2 comments:

https://api.pushshift.io/reddit/comment/search/?aggs=author:score:avg&after=96h&before=72h&min_doc_count=2&subreddit=science&agg_size=10&size=0&metadata=true

Aggregations by authors are much more expensive because it basically has to find every comment made by every author and group them first before doing the aggregations. There are far fewer subreddits in play than authors for a specific time period, so those results will be faster. It's normal for an author aggregation to take 10-15 seconds to complete -- but this can eventually be optimized.

With the new API, it will be possible to see the average reply delay by authors and rank them by smallest to largest -- this pulls out basically all bots on Reddit.

Author
Account Strength
100%
Account Age
11 years
Verified Email
No
Verified Flair
No
Total Karma
143,730
Link Karma
34,810
Comment Karma
108,242
Profile updated: 2 days ago
Posts updated: 6 months ago

Subreddit

Post Details

Location
We try to extract some basic information from the post title. This is not always successful or accurate, please use your best judgement and compare these values to the post title and body for confirmation.
Posted
5 years ago