Docs
Instagram Public Data Fields List
30 fields · 21 metrics · 9 dimensions
BigQuery
Looker Studio
Google Sheets
Power BI| Field Name | Label | Type | Description | Group |
|---|---|---|---|---|
| Account8 fields | ||||
Biography |
biography | Metric | biography metric from Instagram Public Data. This field provides data for reporting and analysis in your marketing dashboards. | Account |
acc_id |
Account Id | Dimension | Unique identifier for the account in Instagram Public Data. | Account |
acc_name |
Account name | Dimension | The display name of the account as configured in Instagram Public Data. | Account |
followers_count |
Followers count | Metric | Total number of Instagram users following the user. | Account |
follows_count |
Follows count | Metric | Total number of Instagram users the user follows. | Account |
media_count |
Media count | Metric | Total number of IG Media published on the user. | Account |
profile_picture_url |
Account picture URL | Dimension | The total count of ac picture url recorded during the reporting period. | Account |
website |
Website | Metric | Website metric from Instagram Public Data. This field provides data for reporting and analysis in your marketing dashboards. | Account |
| Hashtag1 fields | ||||
hashtag_id |
Hashtag Id | Dimension | Unique identifier for the hashtag in Instagram Public Data. | Hashtag |
| Media20 fields | ||||
date |
Date | Dimension | Timestamp or date value for date. Used for time-series analysis and filtering. | Media |
day_of_week |
Day of week (Mon – Sun) | Metric | Day of week (Mon – Sun) metric from Instagram Public Data. This field provides data for reporting and analysis in your marketing dashboards. | Media |
hour |
Hour of day | Metric | Hour of day metric from Instagram Public Data. This field provides data for reporting and analysis in your marketing dashboards. | Media |
media_caption |
Media caption | Metric | Media caption metric from Instagram Public Data. This field provides data for reporting and analysis in your marketing dashboards. | Media |
media_comments_count |
Media count of comments | Metric | Count of comments on the media. Includes replies on comments. | Media |
media_id |
Media Id | Dimension | Unique identifier for the media in Instagram Public Data. | Media |
media_like_count |
Media count of likes | Metric | Count of likes on the media, including replies on comments. | Media |
media_permalink |
Media permalink | Metric | Media permalink metric from Instagram Public Data. This field provides data for reporting and analysis in your marketing dashboards. | Media |
media_picture |
Media picture | Metric | Media picture metric from Instagram Public Data. This field provides data for reporting and analysis in your marketing dashboards. | Media |
media_product_type |
Media product type | Dimension | Surface where the media is published. Can be AD, FEED, or STORY. | Media |
media_timestamp |
Media creation date | Metric | Timestamp or date value for media creation date. Used for time-series analysis and filtering. | Media |
media_type |
Media type | Dimension | Media type. Can be CAROUSEL_ALBUM,IMAGE, or VIDEO. | Media |
media_url |
Media URL | Dimension | Media URL metric from Instagram Public Data. This field provides data for reporting and analysis in your marketing dashboards. | Media |
month |
Month | Metric | Month metric from Instagram Public Data. This field provides data for reporting and analysis in your marketing dashboards. | Media |
quarter |
Quarter | Metric | Quarter metric from Instagram Public Data. This field provides data for reporting and analysis in your marketing dashboards. | Media |
week |
Week | Metric | Week metric from Instagram Public Data. This field provides data for reporting and analysis in your marketing dashboards. | Media |
year |
Year | Metric | Year metric from Instagram Public Data. This field provides data for reporting and analysis in your marketing dashboards. | Media |
year_month |
Month and year | Metric | Month and year metric from Instagram Public Data. This field provides data for reporting and analysis in your marketing dashboards. | Media |
year_quarter |
Quarter and year | Metric | Quarter and year metric from Instagram Public Data. This field provides data for reporting and analysis in your marketing dashboards. | Media |
year_week |
Week and year | Metric | Week and year metric from Instagram Public Data. This field provides data for reporting and analysis in your marketing dashboards. | Media |
| account1 fields | ||||
profile_picture |
Account picture | Metric | The total count of ac picture recorded during the reporting period. | account |