Introduction

Datasources and destinations

Fields listing for Instagram Public Data

Instagram ID
Field IDaccount/id
TypeTEXT
Data Typedimension
Username
Field IDaccount/username
TypeTEXT
Data Typedimension
Name
Field IDaccount/name
TypeTEXT
Data Typedimension
Biography
Field IDaccount/biography
TypeTEXT
Data Typedimension
Profile Picture
The profile picture
Field IDaccount/profile_picture_url
TypeTEXT
Data Typedimension
Website
Field IDaccount/website
TypeTEXT
Data Typedimension
Year
Year such as 2017.
Field ID_NORMALIZED_DATE_FIELD_YEAR
TypeYEAR
Data Typedimension
Year Quarter
Year and quarter.
Field ID_NORMALIZED_DATE_FIELD_YEAR_QUARTER
TypeYEAR_QUARTER
Data Typedimension
Year month
Year and month.
Field ID_NORMALIZED_DATE_FIELD_YEAR_MONTH
TypeYEAR_MONTH
Data Typedimension
Year week
Year and week.
Field ID_NORMALIZED_DATE_FIELD_YEAR_WEEK
TypeYEAR_WEEK
Data Typedimension
Date
Year, month, and day.
Field ID_NORMALIZED_DATE_FIELD_YEAR_MONTH_DAY
TypeYEAR_MONTH_DAY
Data Typedimension
Year month day hour
Year, month, day, and hour.
Field ID_NORMALIZED_DATE_FIELD_YEAR_MONTH_DAY_HOUR
TypeYEAR_MONTH_DAY_HOUR
Data Typedimension
Quarter of the year
Quarter of the year
Field ID_NORMALIZED_DATE_FIELD_QUARTER
TypeQUARTER
Data Typedimension
Month of the year
Month of the year
Field ID_NORMALIZED_DATE_FIELD_MONTH
TypeMONTH
Data Typedimension
Week of the year
Week of the year
Field ID_NORMALIZED_DATE_FIELD_WEEK
TypeWEEK
Data Typedimension
Week of the year (start Sunday)
Week of the year
Field ID_NORMALIZED_DATE_FIELD_WEEK_START_SUNDAY
TypeWEEK
Data Typedimension
Month and day
Month and day
Field ID_NORMALIZED_DATE_FIELD_MONTH_DAY
TypeMONTH_DAY
Data Typedimension
Day of the week
Week of the year
Field ID_NORMALIZED_DATE_FIELD_DAY_OF_WEEK
TypeDAY_OF_WEEK
Data Typedimension
Day of the month
Day of the year
Field ID_NORMALIZED_DATE_FIELD_DAY
TypeDAY
Data Typedimension
Hour of the day
Hour of the day
Field ID_NORMALIZED_DATE_FIELD_HOUR
TypeHOUR
Data Typedimension
Profile Followers
Field IDfollowers_count
TypeNUMBER
Data Typemetric
Profile Follows
Field IDfollows_count
TypeNUMBER
Data Typemetric
Profile Post Count
Field IDmedia_count
TypeNUMBER
Data Typemetric
Post ID
Field IDmedia/id
TypeTEXT
Data Typedimension
Post Created
Field IDmedia/timestamp
TypeYEAR_MONTH_DAY
Data Typedimension
Post Type
Field IDmedia/media_type
TypeTEXT
Data Typedimension
Post Media URL
Field IDmedia/media_url
TypeTEXT
Data Typedimension
Link To Post
Field IDmedia/permalink
TypeTEXT
Data Typedimension
Post Caption
Field IDmedia/caption
TypeTEXT
Data Typedimension
Comments
Field IDcomments_count
TypeNUMBER
Data Typemetric
Media Likes
Field IDlike_count
TypeNUMBER
Data Typemetric
Post Hashtag Count
Field IDmedia/hashtag_count
TypeNUMBER
Data Typedimension
Post Hashtags
Field IDmedia/found_hashtags
TypeTEXT
Data Typedimension
Post Caption Length (without Hashtags)
Field IDmedia/caption_length_no_hashtags
TypeNUMBER
Data Typedimension
Post Caption Length
Field IDmedia/media_caption_length
TypeNUMBER
Data Typedimension
Extracted Date
The date where the extraction take times.
Field ID_catchr_date_extract
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Platform Name
Return the platform name
Field ID_catchr_platform_name
TypeTEXT
Data Typedimension