Supermetrics brings all your marketing data into Google Sheets, Google Data Studio, Excel, BigQuery, Snowflake, Redshift, Azure
| Category | Field | Code | Type | Description |
|---|---|---|---|---|
| TIME | Year | year | dim | |
| Year of week (Sun-Sat) | yearOfWeek | dim | ||
| Year of week (Mon-Sun) | yearOfWeekIso | 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 week (Sun-Sat) | dayOfWeekName | dim | ||
| Day of week (Mon-Sun) | dayOfWeekNameIso | dim | ||
| Date | date | dim | ||
| Day of month | dayOfMonth | dim | ||
| Time | time | dim | ||
| Hour | hour | dim | ||
| POST | ID | id | dim | |
| From ID | from_id | dim | ||
| Post text | text | dim | ||
| Post text (translated) | text_translated | dim | ||
| Post type | post_type | dim | ||
| Source type | source_type | dim | ||
| Source platform | source_platform | dim | ||
| MISCELLANEOUS | Marked as ads | marked_as_ads | dim | |
| Groups can post | groups_can_post | dim | ||
| Comments can post | can_post | dim | ||
| Can like | can_like | dim | ||
| Can publish | can_publish | dim | ||
| OWNER | Owner ID | owner_id | dim | |
| Owner type | owner_type | dim | ||
| Owner screen name | owner_screen_name | dim | ||
| Gender | owner_gender | dim | ||
| Profile first name | profile_first_name | dim | ||
| Profile last name | profile_last_name | dim | ||
| Group name | group_name | dim | ||
| Owner photo (50) | owner_photo_50 | dim | ||
| Owner photo (100) | owner_photo_100 | dim | ||
| Owner photo (200) | owner_photo_200 | dim | ||
| Is admin | is_admin | dim | ||
| Is closed | is_closed | dim | ||
| Is member | is_member | dim | ||
| POST METRICS | Comments | comments_count | met | |
| Likes | likes_count | met | ||
| User likes | user_likes | met | ||
| Reposts | reposts_count | met | ||
| User reposted | user_reposted | met | ||
| Views | views_count | met | ||
| ACCOUNT | User ID | user_id | dim | |
| First name | first_name | dim | ||
| Last name | last_name | dim | ||
| Gender | gender | dim | ||
| Nickname | nickname | dim | ||
| Screen name | screen_name | dim | ||
| Birth date | bdate | dim | ||
| Status | status | dim | ||
| Status (translated) | status_translated | dim | ||
| About | about | dim | ||
| About (translated) | about_translated | dim | ||
| Home town | home_town | dim | ||
| City | city | dim | ||
| Country | country | dim | ||
| Deactivated | deactivated | dim | ||
| OPTIONAL | Activities | activities | dim | |
| Interests | interests | dim | ||
| Musics | music | dim | ||
| TV | tv | dim | ||
| Books | books | dim | ||
| Movies | movies | dim | ||
| Games | games | dim | ||
| Quotes | quotes | dim | ||
| MISCELLANEOUS | Verified | verified | dim | |
| University | university | dim | ||
| Faculty | faculty | dim | ||
| Graduation year | graduation_year | dim | ||
| Site | site | dim | ||
| Mobile phone | mobile_phone | dim | ||
| Home phone | home_phone | dim | ||
| Occupation type | occupation_type | dim | ||
| Occupation | occupation | dim | ||
| PHOTO | User photo URL (50) | photo_50 | dim | |
| User photo URL (100) | photo_100 | dim | ||
| User photo URL (200) | photo_200 | dim | ||
| User photo URL (400 original) | photo_400_orig | dim | ||
| User photo URL (max original) | photo_max_orig | dim | ||
| ACCOUNT COUNTERS | Albums | counters_albums | met | |
| Audios | counters_audios | met | ||
| Videos | counters_videos | met | ||
| Notes | counters_notes | met | ||
| Gifts | counters_gifts | met | ||
| Friends | counters_friends | met | ||
| Groups | counters_groups | met | ||
| Photos | counters_photos | met | ||
| User photos | counters_user_photos | met | ||
| Followers | counters_followers | met | ||
| Subscriptions | counters_subscriptions | met | ||
| Pages | counters_pages | met |