4 ms·
Here's a quick chart of the monthly number of submissions to Reddit over time (until April 2017): https://docs.google.com/spreadsheets/d/1d3kqAebZiUqmI-GbmvNY6C
by minimaxir 9y ago
Here's a quick chart of the monthly number of submissions to Reddit over time (until April 2017): https://docs.google.com/spreadsheets/d/1d3kqAebZiUqmI-GbmvNY6Cz22QJrdwiX20ZuchQs_g0/edit?usp=sharing https://docs.google.com/spreadsheets/d/1d3kqAebZiUqmI-GbmvNY...
At about the start of 2017, Reddit saw a noticeable increase in the activity growth rate, which investors love (although the biggest chunk occurred around October/November 2016, due to the U.S. Election)
And here's the BigQuery to reproduce the aggregation:
#standardSQL
SELECT DATE_TRUNC(DATE(TIMESTAMP_SECONDS(created_utc)), MONTH) as mon, COUNT(*) as num_submissions
FROM `fh-bigquery.reddit_posts.*`
WHERE (_TABLE_SUFFIX BETWEEN "2015_12" AND "2017_04" OR _TABLE_SUFFIX = "full_corpus_201512")
GROUP BY mon
ORDER BY mon
- ben_jones 9y agoAre there any studies being done in the increase of bot accounts used for social media manipulation and other such marketing purposes?
- shostack 9y agoIf not bots then shills. There was a massive increase in obvious shills/bots in the various political subs leading up to the election and through today (although less so than before the election). Let's get some engagement stats on those user counts.
- greenleafjacob 9y agoYes, http://comprop.oii.ox.ac.uk/ http://comprop.oii.ox.ac.uk/
- swyx 9y agonewbie here... where can i run this thing? from your post it seems like someone is hosting "fh-bigquery.reddit_posts" somewhere?
- r721 9y agoI wish there was a way to exclude rss-like subreddits with loads of automated submissions and almost no comments/votes, like /r/willis7737_news/, /r/AutoNewspaper/, /r/Raytheon/, /r/TheColorIsBlue/ (they come and go each year, these are the ones I see around recently).