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, e.g. 2017 |
| Year of week (Sun-Sat) | yearOfWeek | Year of week for US-style Sunday-Saturday weeks, e.g. 2017 | |
| Year of week (Mon-Sun) | yearOfWeekIso | Year of week for ISO standard Monday-Sunday weeks, e.g. 2017 | |
| Quarter | Quarter | Quarter, e.g. 1 | |
| Year & month | yearMonth | Year and month, e.g. 2017|06 | |
| Month | month | Month, e.g. 09 | |
| Year & week (Sun-Sat) | yearWeek | ||
| Year & week (Mon-Sun) | yearWeekIso | Year and week for ISO standard Monday-Sunday weeks, e.g. 2017|08 | |
| Week (Sun-Sat) | week | US week number, e.g. 51 | |
| Week (Mon-Sun) | weekIso | ISO week number, e.g. 51 | |
| Day of month | dayOfMonth | Day of month, e.g. 2 | |
| Day of week (Sun-Sat) | dayOfWeekName | Day of week number & name for US-style Sunday-Saturday weeks, e.g. 0 Sunday | |
| Day of week (Mon-Sun) | dayOfWeekNameIso | Day of week number & name for ISO standard Monday to Sunday weeks, e.g. 1 Sunday | |
| 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 | |
| COMMENTS | Media comment date | media_comment_date | Date the comment was posted |
| Media comment time | media_comment_time | Time the comment was posted | |
| Media comment text | media_comment_text | Text of the comment | |
| 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 | |
| Follow type | follow_type | Breaks down results by FOLLOWER, NON_FOLLOWER, and UNKNOWN | |
| ACCOUNT INSIGHTS | Contact button type | contact_button_type | Breaks down profile links taps by the tapped contact button: CALL, EMAIL, TEXT, DIRECTION, BOOK_NOW, INSTANT_EXPERIENCE |
| 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 | |
| Query | Start date | system_metadata.query_date_range_start | The start date of the requested query |
| End date | system_metadata.query_date_range_end | The end date of the requested query | |
| Timezone | system_metadata.query_timezone | The timezone that is supplied to the query | |
| Filters | system_metadata.query_filters | All filters used in the query | |
| Start | system_metadata.query_date_start | When the query was started | |
| End | system_metadata.query_date_end | When the query completed | |
| Duration | system_metadata.query_duration | The duration in seconds of the query | |
| Accounts | system_metadata.query_accounts | A list of accounts of which the data was pulled from | |
| Excluded invalid accounts | system_metadata.query_excluded_accounts | A list of unavailable accounts excluded from the query due to the "Exclude invalid accounts" setting | |
| Datasource | Data source logins | system_metadata.data_source_logins | The data source login accounts that were used to authenticate against the data source |
| Data source login owners | system_metadata.data_source_login_owners | The Supermetrics users that created the data source login connections |