Supermetrics brings all your marketing data into Google Sheets, Google Data Studio, Excel, BigQuery, Snowflake, Redshift, Azure
| Category | Field | Code | Description |
|---|---|---|---|
| TIME | Year | year | |
| Year of week (Sun-Sat) | yearOfWeek | ||
| Year of week (Mon-Sun) | yearOfWeekIso | ||
| Quarter | Quarter | Quarter, e.g. 1 | |
| Year & month | yearMonth | ||
| Month | month | ||
| Year & week (Sun-Sat) | yearWeek | ||
| Year & week (Mon-Sun) | yearWeekIso | ||
| Week (Sun-Sat) | week | ||
| Week (Mon-Sun) | weekIso | ||
| Day of month | dayOfMonth | ||
| Day of week (Sun-Sat) | dayOfWeekName | ||
| Day of week (Mon-Sun) | dayOfWeekNameIso | ||
| Date | date | ||
| ACCOUNT | Profile ID | account_id | Profile's ID |
| Instagram ID | ig_id | Profile's Instagram ID | |
| Username | username | Profile's username | |
| Name | name | Profile's name | |
| Biography | biography | Profile's biography | |
| Website | website | Profile's website | |
| PHOTO & VIDEO | Media ID | media_id | Graph ID of the media object |
| Media created | timestamp | Date and time media was added | |
| Media type | media_type | Type of the media object. PHOTO, VIDEO, ... | |
| Media URL | media_url | URL of the media object | |
| Media permalink | media_permalink | URL of the post on Instagram | |
| Media product type | media_product_type | Surface where the media is published. Can be AD, FEED, STORY, or REELS | |
| Media shortcode | media_shortcode | Shortcode of the post on Instagram | |
| Video thumbnail URL | media_thumbnail_url | URL of the video thumbnail | |
| Media caption | media_caption | Caption of the post | |
| Media comments enabled | media_is_comment_enabled | Whether or not the comments are enabled | |
| FOLLOWERS | Gender | audience_gender | The gender distribution of this profile's followers |
| Age | audience_age | The age distribution of this profile's followers | |
| Country | audience_country_dim | The countries of this profile's followers | |
| Area & city | audience_city_dim | The cities of this profile's followers with area information | |
| Area | audience_area_only_dim | The areas of this profile's followers | |
| City | audience_city_only_dim | The cities of this profile's followers | |
| DEPRECATED | IGTV video title | media_video_title | Title of IGTV media object. Please note that this field will be removed on 2022-07-28 |
| Locale | audience_locale_dim | The locales by country codes of this profile's followers. Please note that this field will be removed on 2023-12-11 |