Windsor brings all your Instagram Public Data data into Power BI, Looker Studio, Google Sheets, Excel, BigQuery, Snowflake, Tableau, Azure, PostgreSQL, MySQL, Python, Amazon S3, Azure, Azure MS SQL
Instagram Public Data Field Reference
Fields
| ID | Type | Name | Description | Report |
|---|---|---|---|---|
| account_id | TEXT | Account ID | The app user's app-scoped ID (version 11.0+) or raw user ID (version 10.0 and lower). | me |
| account_name | TEXT | Account Name | The User's username. | me |
| account_type | TEXT | Account Type | The User's account type. Can be BUSINESS, MEDIA_CREATOR, or PERSONAL. | me |
| caption | TEXT | Caption | The Media's caption text. Not returnable for Media in albums. Note: When using emojis in captions, the encoding format should be UTF-8 and character length may be affected depending on the emoji used. | media |
| datasource | TEXT | Data Source | The name of the Windsor connector returning the row | |
| date | DATE | Date | The Date | media |
| day_of_month | TEXT | Day of month | Day of the month | |
| is_shared_to_feed | TEXT | Is Shared to Feed | For Reels only. When true, indicates that the reel can appear in both the Feed and Reels tabs. When false, indicates the reel can only appear in the Reels tab. Neither value determines whether the reel actually appears in the Reels tab because the reel may not meet eligibilty requirements or may not be selected by our algorithm. See reel specifications for eligibility critera. | media |
| media_count | NUMERIC | Media Count | Total number of media for this profile. Provides the count for today. | me |
| media_id | TEXT | Media ID | The Media's ID. | media |
| media_type | TEXT | Media Type | The Media's type. Can be IMAGE, VIDEO, or CAROUSEL_ALBUM. | media |
| media_url | IMAGE_URL | Media URL | The Media's URL. | media |
| media_username | TEXT | Media Username | The Media owner's username. | media |
| month | TEXT | Month | Number of the month | |
| permalink | TEXT | Permalink | The Media's permanent URL. Will be omitted if the Media contains copyrighted material, or has been flagged for a copyright violation. | media |
| source | TEXT | Source | The name of the Windsor connector returning the row | |
| thumbnail_url | IMAGE_URL | Thumbnail URL | The Media's thumbnail image URL. Only available on VIDEO Media. | media |
| timestamp | TIMESTAMP | Timestamp | The Media's publish date in ISO 8601 format. | media |
| today | DATE | Today | Today's date | |
| username | TEXT | Username | The User's username. | me |
| week | TEXT | Week | Week (Sun-Sat). | |
| week_day | TEXT | Day of week and day number | Weekday number and name combined (Sun-Sat).Numbered from 0 Sunday to 6 Saturday. | |
| week_day_iso | TEXT | Day of week and day number, ISO | Weekday number and name combined, ISO format (Mon-Sun).Numbered from 1 Monday to 7 | |
| week_iso | TEXT | Week ISO | Week, ISO format (Mon-Sun). | |
| year | TEXT | Year | Year | |
| year_month | TEXT | Yearmonth | Year and month, e.g. 2024|3 | |
| year_of_week | TEXT | Year of week | The year that contains first day of the week (Sun-Sat). | |
| year_of_week_iso | TEXT | Year of week, ISO | The year that contains first day of the ISO week (Mon-Sun). | |
| year_week | TEXT | Year week | Year and week for US weeks (Sun-Sat), e.g. 2024|15 | |
| year_week_iso | TEXT | Year week ISO | Year and week for ISO weeks (Mon-Sun), e.g. 2024|20 |