Reddit/Subreddit Dataset

# Reddit/Subreddit Dataset

Reddit is the world's leading forum community for every interest. The dataset tracks attributes of 2.1+ million subreddits and subscriber counts daily since January 2023. Additionally, we leverage AI to append subreddit attributes that allow you to categorize and find subreddits by subject. The dataset is ideal for Interest-Based Segmentation, trend analysis, and audience insights.

<p><br/></p>

## ✨ Features

- Tracking 2M current and historical subreddit communities
- 60M+ records
- AI appended attributes tracking subreddit categories, related search terms, and related subjects allowing for finding related subreddit communities
- Subscriber counts dating back to January 2023

<p><br/></p>

## 🎟️ Free Trial

The free trial is for a period of 7 days and includes subreddits with more than 100,000 followers.

<p><br/></p>

## 🗄️ Tables Included in the Dataset

- **Subreddit Dimension** - A record per subreddit with many attributes that describe the subreddit
- **Fact Subreddit Day** - A record per day subreddit tracking the number of subscribers
- **Date Dimension** - Date dimension table (per day)

<p><br/></p>

## 💎 High-Value Attributes in the Dataset:

- **subreddit_url** - full URL to the subreddit
- **description** - Subreddit description
- **parsed words** - Words parsed from the subreddit name
- **derived categories** - An appended array of high-level categories related to the subreddit
- **derived search terms** - An appended array of search terms related to the subreddit
- **derived related subjects** - An appended array of subjects related to the subreddit
- **subreddit type** - Type of subreddit. Public or Private
- **language** - ISO Language Date
- **subreddit created date** - Timestamp of when the subreddit was created
- **subscriber count** - Total number of subscribers. Tracked per day.
- **allows images** - Boolean. True = Allows Images
- **allows discovery** - Boolean. True = Allows Discovery
- **over18** - Boolean. True = Over 18 subreddit
- **whitelist status** - filled with some_ads, no_ads, all_ads
- **advertiser category** - filled with Automotive, Business/FinanceCollege/University, • Entertainment, Family&Youth Games, Health, Lifestyles, Local, Retail, Sports, Technology, Travel
- **derived categories** 🤖 - AI appended array with categories related to the the subreddi community.
- **derived related subjects** 🤖 - AI appended array with subjects related to the subreddit community.
- **derived search terms** 🤖 - AI appended search terms related to the subreddit community.

# Reddit/Subreddit 数据集（Reddit/Subreddit Dataset）

Reddit 是全球领先的全领域兴趣论坛社区。本数据集自2023年1月起，每日追踪超过210万个子论坛（subreddit）的各项属性与订阅者数量。此外，我们借助人工智能（AI）为子论坛追加属性，支持按主题对其进行分类与检索。本数据集非常适用于基于兴趣的用户细分、趋势分析与受众洞察。

<p><br/></p>

## ✨ 核心特性
- 追踪200万个当前及历史子论坛社区
- 累计超过6000万条记录
- 追加AI生成属性，涵盖子论坛分类、相关搜索词与关联主题，支持快速检索相关子论坛社区
- 包含可追溯至2023年1月的订阅者数量历史数据

<p><br/></p>

## 🎟️ 免费试用
免费试用期限为7天，覆盖粉丝量超过10万的子论坛社区。

<p><br/></p>

## 🗄️ 数据集包含的数据表
- **子论坛维度表（Subreddit Dimension）**：每条记录对应一个子论坛，包含描述该论坛的多项核心属性
- **子论坛每日事实表（Fact Subreddit Day）**：按日记录子论坛的订阅者数量变化
- **日期维度表（Date Dimension）**：按天构建的日期维度数据表

<p><br/></p>

## 💎 数据集高价值属性
- **subreddit_url**：子论坛完整访问URL
- **description**：子论坛官方描述文本
- **parsed words**：从子论坛名称中解析提取的词汇
- **derived categories**：追加的子论坛所属高级分类数组
- **derived search terms**：追加的与子论坛相关的搜索词数组
- **derived related subjects**：追加的与子论坛相关的关联主题数组
- **subreddit type**：子论坛类型，分为公开（Public）与私有（Private）
- **language**：ISO语言标识
- **subreddit created date**：子论坛创建时间戳
- **subscriber count**：订阅者总数量，按日追踪更新
- **allows images**：布尔类型字段，`True`代表允许上传图片
- **allows discovery**：布尔类型字段，`True`代表允许被平台搜索发现
- **over18**：布尔类型字段，`True`代表为18+年龄限制子论坛
- **whitelist status**：白名单状态，取值包含`some_ads`、`no_ads`、`all_ads`
- **advertiser category**：广告分类，取值包括Automotive（汽车）、Business/Finance（商业/金融）、College/University（高校/大学）、Entertainment（娱乐）、Family&Youth Games（家庭与青少年游戏）、Health（健康）、Lifestyles（生活方式）、Local（本地）、Retail（零售）、Sports（体育）、Technology（科技）、Travel（旅游）
- **derived categories** 🤖：AI追加的与子论坛社区相关的分类数组
- **derived related subjects** 🤖：AI追加的与子论坛社区相关的主题数组
- **derived search terms** 🤖：AI追加的与子论坛社区相关的搜索词列表

搜集汇总

背景与挑战

背景概述

该数据集涵盖210多万个Reddit子社区的属性和每日订阅数据，时间跨度自2023年1月起，包含6000多万条记录。通过AI技术添加了分类、关联主题和搜索词等属性，支持兴趣细分、趋势分析和受众洞察研究。