Supermetrics brings all your marketing data into Google Sheets, Google Data Studio, Excel, BigQuery, Snowflake, Redshift, Azure
| Category | Field | Code | Type | Description |
|---|---|---|---|---|
| ACCOUNT | Instagram ID | ig_id | dim | Profile's Instagram ID |
| Username | username | dim | Profile's username | |
| Name | name | dim | Profile's name | |
| Biography | biography | dim | Profile's biography | |
| Profile picture URL | profile_picture_url | dim | URL to profile picture | |
| Website | website | dim | Profile's website | |
| Profile followers | followers | met | Total number of unique accounts following this profile | |
| Profile follows | follows | met | Total number of accounts this profile is following | |
| Profile post count | total_post_count | met | Total number of posts for this profile | |
| Query | Start date | system_metadata.query_date_range_start | dim | The start date of the requested query |
| End date | system_metadata.query_date_range_end | dim | The end date of the requested query | |
| Timezone | system_metadata.query_timezone | dim | The timezone that is supplied to the query | |
| Filters | system_metadata.query_filters | dim | All filters used in the query | |
| Start | system_metadata.query_date_start | dim | When the query was started | |
| End | system_metadata.query_date_end | dim | When the query completed | |
| Duration | system_metadata.query_duration | dim | The duration in seconds of the query | |
| Accounts | system_metadata.query_accounts | dim | A list of accounts of which the data was pulled from | |
| Datasource | Data source logins | system_metadata.data_source_logins | dim | The data source login accounts that were used to authenticate against the data source |
| Data source login owners | system_metadata.data_source_login_owners | dim | The Supermetrics users that created the data source login connections | |
| 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 month | dayOfMonth | dim | ||
| Day of week (Sun-Sat) | dayOfWeekName | dim | ||
| Day of week (Mon-Sun) | dayOfWeekNameIso | dim | ||
| Date | date | dim | ||
| ACCOUNT | Instagram ID | ig_id | dim | Profile's Instagram ID |
| Username | username | dim | Profile's username | |
| Name | name | dim | Profile's name | |
| Biography | biography | dim | Profile's biography | |
| Profile picture URL | profile_picture_url | dim | URL to profile picture | |
| Website | website | dim | Profile's website | |
| MEDIA | Post ID | post_id | dim | Graph ID of the post |
| Post created | post_timestamp | dim | Date and time post was added | |
| Post type | post_type | dim | Type of post. PHOTO, VIDEO, etc | |
| Post media URL | post_media_url | dim | URL to the post's media object | |
| Link to post | post_permalink | dim | URL of the post on Instagram | |
| Post caption | post_caption | dim | Caption of the post | |
| Comments | post_comments | met | Total number of comments on the post, including replies | |
| Likes | post_likes | met | Total number of likes on the post, including replies | |
| POST METRICS | Likes per post | likes_per_post | met | Count of likes per post |
| Comments per post | comments_per_post | met | Count of comments per post | |
| Posts | posts | met | Posts | |
| Query | Start date | system_metadata.query_date_range_start | dim | The start date of the requested query |
| End date | system_metadata.query_date_range_end | dim | The end date of the requested query | |
| Timezone | system_metadata.query_timezone | dim | The timezone that is supplied to the query | |
| Filters | system_metadata.query_filters | dim | All filters used in the query | |
| Start | system_metadata.query_date_start | dim | When the query was started | |
| End | system_metadata.query_date_end | dim | When the query completed | |
| Duration | system_metadata.query_duration | dim | The duration in seconds of the query | |
| Accounts | system_metadata.query_accounts | dim | A list of accounts of which the data was pulled from | |
| Datasource | Data source logins | system_metadata.data_source_logins | dim | The data source login accounts that were used to authenticate against the data source |
| Data source login owners | system_metadata.data_source_login_owners | dim | The Supermetrics users that created the data source login connections | |
| MEDIA | Post ID | post_id | dim | Graph ID of the post |
| Post created | post_timestamp | dim | Date and time post was added | |
| Post type | post_type | dim | Type of post. PHOTO, VIDEO, etc | |
| Post media URL | post_media_url | dim | URL to the post's media object | |
| Link to post | post_permalink | dim | URL of the post on Instagram | |
| Post caption | post_caption | dim | Caption of the post | |
| Matching hashtags | hashtag_name | dim | Hashtags from the post caption that match the hashtags supplied for the search | |
| Hashtags | found_hashtags | dim | Hashtags included the post caption | |
| Number of hashtags | hashtag_count | dim | The total number of hashtags found in the post caption | |
| Caption length | caption_length | dim | The length of the post caption | |
| Caption length (not incl. hashtags) | caption_length_no_hashtags | dim | The length of the post caption without the hashtags | |
| Comments | post_comments | met | Total number of comments on the post, including replies | |
| Likes | post_likes | met | Total number of likes on the post, including replies | |
| Query | Start date | system_metadata.query_date_range_start | dim | The start date of the requested query |
| End date | system_metadata.query_date_range_end | dim | The end date of the requested query | |
| Timezone | system_metadata.query_timezone | dim | The timezone that is supplied to the query | |
| Filters | system_metadata.query_filters | dim | All filters used in the query | |
| Start | system_metadata.query_date_start | dim | When the query was started | |
| End | system_metadata.query_date_end | dim | When the query completed | |
| Duration | system_metadata.query_duration | dim | The duration in seconds of the query | |
| Accounts | system_metadata.query_accounts | dim | A list of accounts of which the data was pulled from | |
| Datasource | Data source logins | system_metadata.data_source_logins | dim | The data source login accounts that were used to authenticate against the data source |
| Data source login owners | system_metadata.data_source_login_owners | dim | The Supermetrics users that created the data source login connections |