Every month, we analyze our Reddit/Subreddit Dataset on the Snowflake Marketplace to discover which Subreddits have the highest surge in new subscribers. The dataset not only helps us identify Subreddits with significant growth but also includes AI-generated fields with parsed subreddit names, related categories, and top search terms tied to the content of a subreddit.

To track and analyze the metrics, we categorize the Subreddits into three groups based on their subscriber count:

  • Large: Subreddits with 100,000 subscribers or less.
  • Medium: Subreddits with 50,000 to 100,000 subscribers.
  • Small: Subreddits with 20,000 to 50,000 subscribers.
Image generated by ChatGPT Create an image featuring Reddit’s Snoo character. Snoo should be wearing a mix of medieval fantasy attire inspired by Dungeon Meshi, such as a wizard hat and a tunic. Around Snoo, include various social media icons (Facebook, Twitter, Instagram) floating as if they are magical symbols. In Snoo’s hand, have a glowing firefly (representing Firefly Mains 🔥🪰). Also, include a small companion resembling a beloved character from Honkai Star Rail, standing beside Snoo, to
ChatGPT Prompt: Create an image featuring Reddit's Snoo character. Snoo should be wearing a mix of medieval fantasy attire inspired by Dungeon Meshi, such as a wizard hat and a tunic. Around Snoo, include various social media icons (Facebook, Twitter, Instagram) floating as if they are magical symbols. In Snoo's hand, have a glowing firefly (representing Firefly Mains 🔥🪰). Also, include a small companion resembling a beloved character from Honkai Star Rail, standing beside Snoo, to give a sense of adventure and camaraderie.

Large Subreddits

In June 2024, the large subreddit with the most growth since the previous month:

🏆 /r/socialmedia/ 🏆

Description

A sub for professional discussion about social media, news, and best practices.

Top 5 Subreddits related to the winner:

1. /r/memes/ — 32,335,330 total subscribers 2. /r/AdviceAnimals/ — 9,940,200 total subscribers 3. /r/cats/ — 6,274,984 total subscribers 4. /r/woahdude/ — 4,146,156 total subscribers 5. /r/tiktokp*rn/ — 2,274,953 total subscribers

The entire top 10 list:

1. /r/socialmedia/13.65% growth ( 1,074,905 total subscribers) 2. /r/Superstonk/12.65% growth ( 1,095,274 total subscribers) 3. /r/TheBoys/11.63% growth ( 1,136,723 total subscribers) 4. /r/Nbamemes/11.32% growth ( 1,103,797 total subscribers) 5. /r/AITAH/10.85% growth ( 1,884,026 total subscribers) 6. /r/fragrance/10.11% growth ( 1,254,375 total subscribers) 7. /r/HouseOfTheDragon/9.62% growth ( 1,384,338 total subscribers) 8. /r/PhotoshopRequest/9.36% growth ( 1,123,323 total subscribers) 9. /r/AskEngineers/9.30% growth ( 1,631,882 total subscribers) 10. /r/introvert/8.90% growth ( 1,712,592 total subscribers)

Medium Subreddits

In June 2024, the medium subreddit with the most growth since the previous month:

🏆 /r/DungeonMeshi/ 🏆

Description

Devoted to Ryōko Kui's award winning hunger-inducing manga / anime, Dungeon Meshi! Monsters never looked so tasty!

Top 5 Subreddits related to the winner:

1. /r/Art/ — ( 22,443,378 total subscribers) 2. /r/gifs/ — ( 21,653,582 total subscribers) 3. /r/oddlysatisfying/ — ( 10,927,046 total subscribers) 4. /r/HistoryMemes/ — ( 10,603,681 total subscribers) 5. /r/anime/ — ( 10,402,262 total subscribers)

The entire top 10 list:

1. /r/DungeonMeshi/38.35% growth ( 74,091 total subscribers) 2. /r/tollywood/30.84% growth ( 83,958 total subscribers) 3. /r/CreditCardsIndia/24.36% growth ( 67,112 total subscribers) 4. /r/foodsafety/20.02% growth ( 55,443 total subscribers) 5. /r/UtterlyUniquePhotos/19.34% growth ( 83,690 total subscribers) 6. /r/CATpreparation/18.41% growth ( 96,147 total subscribers) 7. /r/dropout/16.73% growth ( 77,519 total subscribers) 8. /r/IndiaTax/15.32% growth ( 57,185 total subscribers) 9. /r/hazbin/14.88% growth ( 61,323 total subscribers) 10. /r/Chainsawfolk/13.75% growth ( 94,618 total subscribers)

Small Subreddits

In June 2024, the small subreddit with the most growth since the previous month:

🏆 /r/FireflyMains/ 🏆

Description

✦Firefly Mains 🔥🪰 A beloved character from the game Honkai Star Rail, also known under the alias 'Stellaron Hunter Sam,' a remnant of Glamoth's Iron Cavalry.✦ ⏤⏤⏤⏤⏤⏤⏤⏤✦🔥✦⏤⏤⏤⏤⏤⏤⏤ ✦Join us here at Firefly Mains to learn more and theorize about Firefly, experience precious fan arts of her (or sick mecha art), build discussions, leaks, community talks, and just a lot of general Firefly love. ⏤⏤⏤⏤⏤⏤⏤⏤✦🔥✦⏤⏤⏤⏤⏤⏤⏤ ✦Join us on Discord~! ✦discord.gg/fireflymains✦

The entire top 10 list:

1. /r/FireflyMains/35.54% growth ( 38,721 total subscribers) 2. /r/housekeeping/27.04% growth ( 21,324 total subscribers) 3. /r/binichderalman/26.08% growth ( 30,776 total subscribers) 4. /r/Law_and_Politics/25.45% growth ( 23,204 total subscribers) 5. /r/HENRYUK/21.66% growth ( 29,849 total subscribers) 6. /r/PowerScaling/21.53% growth ( 35,037 total subscribers) 7. /r/TropPeurDeDemander/21.35% growth ( 28,348 total subscribers) 8. /r/AITA_WIBTA_PUBLIC/18.48% growth ( 49,069 total subscribers) 9. /r/DecodingTheGurus/17.45% growth ( 42,194 total subscribers) 10. /r/Btechtards/16.10% growth ( 46,141 total subscribers)

About the Reddit/Subreddit Dataset

Dataplex Consulting & Data Product's Reddit/Subreddit Dataset on the Snowflake Marketplace is available to any Snowflake user. Enjoy a limited version of the dataset for 7 days using the free trial.

Documentation and an Entity Relationship Diagram that includes the tables in the dataset are available on Dataplex-Consulting.com.

You can use the Reddit/Subreddit Dataset to search for trending subreddits, subreddits related to specific categories, and categories of trending subreddits, among other things. Below are the SQL queries for retrieving the top subreddits and their related counterparts.

About Dataplex Consulting & Data Products

Consulting

We specialize in providing data consulting services to businesses of all sizes. With over 20 years of experience working with a diverse range of companies, including small businesses and Fortune 500 corporations, our team has gained a wealth of practical expertise in the field. We take pride in our proven track record in data architecture, building data integrations, designing data warehouses, developing pipelines, and all things data. Contact us to learn how Dataplex Consulting & Data Products can help your business succeed with data-driven results.

Datasets

Dataplex Consulting & Data Products offers curated high quality datasets available on the Snowflake Marketplace to make data more accessible to any business. Check out our Datasets ranging from healthcare data to social media metrics. Our data pipelines include automatic data quality checks and are actively monitored to ensure on-time, clean, and quality data.

If you have a particular dataset that can empower your business, please contact us to explore how we can assist you.

Find our full catalog of datasets on the Snowflake Marketplace!