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 | |
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 | |
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 |