Supermetrics brings all your marketing data into Google Sheets, Google Data Studio, Excel, BigQuery, Snowflake, Redshift, Azure
| Category | Field | Code | Type | Description |
|---|---|---|---|---|
| TIME | Signup date | created_utc | dim | |
| Date | created | dim | ||
| Year | year | dim | ||
| Year & month | yearMonth | dim | ||
| Month | month | dim | ||
| Year & week (Sun-Sat) | yearWeek | dim | ||
| Year & week (Mon-Sun) | yearWeekIso | dim | ||
| Week (Sun-Sat) | week | dim | ||
| Week (Mon-Sun) | weekIso | dim | ||
| Day of month | dayOfMonth | dim | ||
| Day of week (Sun-Sat) | dayOfWeekName | dim | ||
| Day of week (Mon-Sun) | dayOfWeekNameIso | dim | ||
| KEYWORD | Keyword | profile | dim | |
| ACCOUNT | Username | name | dim | |
| Icon image URL | icon_img | dim | ||
| ID | id | dim | ||
| Is set over 18 | over_18_posts | dim | ||
| SUBREDDIT | Title | title | dim | Title of the subreddit or of the post |
| Title (translated) | title_translated | dim | ||
| Subreddit type | subreddit_type | dim | ||
| Relative URL | url | dim | ||
| POST | Subreddit | subreddit | dim | |
| Author | author | dim | ||
| Author ID | author_fullname | dim | ||
| Post text | selftext | dim | ||
| Post text (translated) | selftext_translated | dim | ||
| Post text (html) | selftext_html | dim | ||
| Link to comments | permalink | dim | ||
| Thumbnail width | thumbnail_width | dim | ||
| Thumbnail height | thumbnail_height | dim | ||
| Contest mode | contest_mode | dim | ||
| Prefixed subreddit name | subreddit_name_prefixed | dim | ||
| Banned by | banned_by | dim | ||
| Clicked | clicked | dim | ||
| Approved by | approved_by | dim | ||
| Approved at | approved_at_utc | dim | ||
| Domain | domain | dim | ||
| Thumbnail URL | thumbnail | dim | ||
| Edited | edited | dim | ||
| Subreddit id | subreddit_id | dim | ||
| Brand safe | brand_safe | dim | ||
| Archived | archived | dim | ||
| Visited | visited | dim | ||
| Is video | is_video | dim | ||
| MISCELLANEOUS | Suggested sort | suggested_sort | dim | |
| Secure media | secure_media | dim | ||
| Link flair type | link_flair_type | dim | ||
| Link flair text | link_flair_text | dim | ||
| Link flair text color | link_flair_text_color | dim | ||
| Link flair background color | link_flair_background_color | dim | ||
| Link flair css class | link_flair_css_class | dim | ||
| Link flair template ID | link_flair_template_id | dim | ||
| Author flair type | author_flair_type | dim | ||
| Author flair text | author_flair_text | dim | ||
| Author flair text color | author_flair_text_color | dim | ||
| Author flair background color | author_flair_background_color | dim | ||
| Author flair css class | author_flair_css_class | dim | ||
| Author flair template ID | author_flair_template_id | dim | ||
| Author patreon flair | author_patreon_flair | dim | ||
| Whitelist status | whitelist_status | dim | ||
| Parent whitelist status | parent_whitelist_status | dim | ||
| Post hint | post_hint | dim | ||
| Can gild | can_gild | dim | ||
| Hide score | hide_score | dim | ||
| Spoiler | spoiler | dim | ||
| Locked | locked | dim | ||
| Saved | saved | dim | ||
| Hidden | hidden | dim | ||
| Media only | media_only | dim | ||
| Pinned | pinned | dim | ||
| Is crosspostable | is_crosspostable | dim | ||
| Is original content | is_original_content | dim | ||
| Is reddit media domain | is_reddit_media_domain | dim | ||
| Is robot indexable | is_robot_indexable | dim | ||
| Is meta | is_meta | dim | ||
| No follow | no_follow | dim | ||
| Stickied | stickied | dim | ||
| Quarantine | quarantine | dim | ||
| Distinguished | distinguished | dim | ||
| Media | media | dim | ||
| Is self | is_self | dim | ||
| Pwls | pwls | dim | ||
| Wls | wls | dim | ||
| SUBREDDIT METRICS | Subreddit subscribers | subreddit_subscribers | met | |
| POST METRICS | Posts | posts | met | |
| Upvotes | ups | met | ||
| Upvotes per post | upsPerPost | met | ||
| Comments | num_comments | met | ||
| Comments per post | commentsPerPost | met | ||
| Gilded | gilded | met | ||
| Gilded per post | gildedPerPost | met | ||
| Crossposts | num_crossposts | met | ||
| Reports | num_reports | met | ||
| Score | score | met | ||
| Views | view_count | met | ||
| Downvotes | downs | met | ||
| TIME | Signup date | created_utc | dim | |
| Date | created | dim | ||
| Year | year | dim | ||
| Year & month | yearMonth | dim | ||
| Month | month | dim | ||
| Year & week (Sun-Sat) | yearWeek | dim | ||
| Year & week (Mon-Sun) | yearWeekIso | dim | ||
| Week (Sun-Sat) | week | dim | ||
| Week (Mon-Sun) | weekIso | dim | ||
| Day of month | dayOfMonth | dim | ||
| Day of week (Sun-Sat) | dayOfWeekName | dim | ||
| Day of week (Mon-Sun) | dayOfWeekNameIso | dim | ||
| ACCOUNT | Username | name | dim | |
| Icon image URL | icon_img | dim | ||
| ID | id | dim | ||
| SUBREDDIT | Title | title | dim | Title of the subreddit or of the post |
| Title (translated) | title_translated | dim | ||
| Name | display_name | dim | ||
| Description | description | dim | ||
| Description (translated) | description_translated | dim | ||
| Public description | public_description | dim | ||
| Public description (translated) | public_description_translated | dim | ||
| Description (escaped HTML format) | description_html | dim | ||
| Public description (escaped HTML format) | public_description_html | dim | ||
| Icon size | icon_size | dim | ||
| Banner image URL | banner_img | dim | ||
| Banner background image | banner_background_image | dim | ||
| Banner size | banner_size | dim | ||
| Banner background color | banner_background_color | dim | ||
| Header image URL | header_img | dim | ||
| Header title | header_title | dim | ||
| Header image width & height | header_size | dim | ||
| Submit text | submit_text | dim | ||
| Submit text HTML | submit_text_html | dim | ||
| Submission type | submission_type | dim | ||
| Notification level | notification_level | dim | ||
| Over 18 | over18 | dim | ||
| Is page publicly-accessible | public_traffic | dim | ||
| Advertiser category | advertiser_category | dim | ||
| Subreddit type | subreddit_type | dim | ||
| User flair position | user_flair_position | dim | ||
| User flair type | user_flair_type | dim | ||
| User flair text | user_flair_text | dim | ||
| User flair text color | user_flair_text_color | dim | ||
| User flair css class | user_flair_css_class | dim | ||
| User flair background color | user_flair_background_color | dim | ||
| User flair template id | user_flair_template_id | dim | ||
| User sr theme enabled | user_sr_theme_enabled | dim | ||
| User sr flair enabled | user_sr_flair_enabled | dim | ||
| User flair enabled in sr | user_flair_enabled_in_sr | dim | ||
| User is banned | user_is_banned | dim | ||
| User is muted | user_is_muted | dim | ||
| User is contributor | user_is_contributor | dim | ||
| User is moderator | user_is_moderator | dim | ||
| User is subscriber | user_is_subscriber | dim | ||
| User is favorited | user_has_favorited | dim | ||
| User can flair in sr | user_can_flair_in_sr | dim | ||
| Can assign user flair | can_assign_user_flair | dim | ||
| Can assign link flair | can_assign_link_flair | dim | ||
| Link flair enabled | link_flair_enabled | dim | ||
| Link flair position | link_flair_position | dim | ||
| Key color | key_color | dim | ||
| Relative URL | url | dim | ||
| Language | lang | dim | ||
| Primary color | primary_color | dim | ||
| MISCELLANEOUS | Community icon | community_icon | dim | |
| Custom label for the submit link button | submit_link_label | dim | ||
| Custom label for the submit text button | submit_text_label | dim | ||
| Show media | show_media | dim | ||
| Show media preview | show_media_preview | dim | ||
| Allow images | allow_images | dim | ||
| Allow videos | allow_videos | dim | ||
| Allow videogifs | allow_videogifs | dim | ||
| Allow discovery | allow_discovery | dim | ||
| Emojis enabled | emojis_enabled | dim | ||
| Hide ads | hide_ads | dim | ||
| Free form reports | free_form_reports | dim | ||
| Wiki enabled | wiki_enabled | dim | ||
| Spoilers enabled | spoilers_enabled | dim | ||
| Original content tag enabled | original_content_tag_enabled | dim | ||
| All original content | all_original_content | dim | ||
| Has menu widget | has_menu_widget | dim | ||
| Accounts active is fuzzed | accounts_active_is_fuzzed | dim | ||
| Collapse deleted comments | collapse_deleted_comments | dim | ||
| Whitelist status | whitelist_status | dim | ||
| Quarantine | quarantine | dim | ||
| Wls | wls | dim | ||
| SUBREDDIT METRICS | Subscribers | subscribers | met | |
| Active users | active_user_count | met | ||
| Comment karma | accounts_active | met | ||
| Hides comment scores (min) | comment_score_hide_mins | met | ||
| Videostream links count | videostream_links_count | met | ||
| TIME | Signup date | created_utc | dim | |
| ACCOUNT | Username | name | dim | |
| Icon image URL | icon_img | dim | ||
| ID | id | dim | ||
| Is moderator | is_mod | dim | ||
| Is friend | is_friend | dim | ||
| Pref show snoovatar | pref_show_snoovatar | dim | ||
| Is employee | is_employee | dim | ||
| Gold status | is_gold | dim | ||
| Has verified email | has_verified_email | dim | ||
| Has subscribed | has_subscribed | dim | ||
| Hide from robots | hide_from_robots | dim | ||
| Verified | verified | dim | ||
| USER | Link karma | link_karma | met | |
| Comment karma | comment_karma | met | ||
| Total karma | total_karma | met |