Instagram social predefined reports

The Instagram Social data source in Data Integration includes predefined reports. Each report includes a short description of the data, a list of customizable fields (if any), and the schema mapping.

Since these reports follow a standardized format, a few fields are locked, and you can only access them through the Custom reports feature.

Accounts

The Accounts report represents all Instagram Business or Creator Accounts.

Field	Data Type	Dimension/Metric
id	String	Dimension
biography	String	Dimension
fb_page_location	Record	Dimension
fb_page_locations	Record	Dimension
fb_page_name	String	Dimension
fb_page_name_with_location_descriptor	String	Dimension
followers_count	Integer	Metric
follows_count	Integer	Metric
fb_page_id	String	Dimension
ig_id	Integer	Dimension
media_count	Integer	Metric
name	String	Dimension
profile_picture_url	String	Dimension
username	String	Dimension
website	String	Dimension

Insights Account Daily

The Insights Account Daily report represents social interaction metrics for Instagram users by day. You can only customize the incremental load type associated with this report.

Field	Data Type	Dimension/Metric
id	String	Dimension
date	String	Dimension
impressions_day	Integer	Metric
follower_count_day	Integer	Metric
followers_count	Integer	Metric
follows_count	Integer	Metric
get_directions_clicks_day	Integer	Metric
end_time	String	Dimension
ig_id	Integer	Dimension
email_contacts_day	Integer	Metric
media_count	Integer	Metric
name	String	Dimension
phone_call_clicks_day	Integer	Metric
profile_views_day	Integer	Metric
reach_day	Integer	Metric
text_message_clicks_day	Integer	Metric
username	String	Dimension
website_clicks_day	Integer	Metric

Insights account lifetime

The Insights Account Lifetime report represents social interaction metrics for Instagram users' entire lifetime. You can only customize the incremental load type associated with this report.

Field	Data Type	Dimension/Metric
date	String	Dimension
id	String	Dimension
end_time	String	Dimension
followers_count	Integer	Metric
follows_count	Integer	Metric
ig_id	Integer	Dimension
media_count	Integer	Metric
name	String	Dimension
username	String	Dimension

Insights media all medias

The Insights Media All Medias report represents social interaction metrics for all media—Instagram Photos, Videos, Stories, Albums (Carousel), or IGTV. You can only customize the incremental load type associated with this report.

Field	Data Type	Dimension/Metric
ig_id	String	Dimension
acc_id	String	Dimension
comments_count	Integer	Metric
comments_lifetime	Integer	Metric
date	String	Dimension
end_time	String	Dimension
caption	String	Dimension
ig_reels_aggregated_all_plays_count_lifetime	Integer	Metric
ig_reels_avg_watch_time_lifetime	Integer	Metric
impressions_lifetime	Integer	Metric
is_story	Boolean	Dimension
like_count	Integer	Metric
media_id	String	Dimension
media_type	String	Dimension
owner	Record	Dimension
permalink	String	Dimension
reach_lifetime	Integer	Metric
replies_lifetime	Integer	Metric
saved_lifetime	Integer	Metric
timestamp	String	Dimension
total_interactions_lifetime	Integer	Metric
username	String	Dimension
video_views_lifetime	Integer	Metric
carousel_album_engagement_lifetime	Integer	Metric
carousel_album_impressions_lifetime	Integer	Metric
carousel_album_reach_lifetime	Integer	Metric

note

• When you select Media Type as All, you must select relevant metrics for all media types: Post metrics, Story metrics, and Album metrics. If metrics are not selected for All media types, the Data Flow fails due to missing metric configurations.

• A Album metrics field is available to select Carousel Album–specific metrics such as Saved, Reach, Total Interactions, and Views.

Insights media all medias with new metrics

The Insights Media All Medias report represents social interaction metrics for all media—Instagram Photos, Videos, Stories, Albums, or IGTV. You can only customize the incremental load type associated with this report.

Field	Data Type	Dimension/Metric
ig_id	String	Dimension
acc_id	String	Dimension
comments_count	Integer	Metric
comments_lifetime	Integer	Metric
date	String	Dimension
end_time	String	Dimension
caption	String	Dimension
is_story	Boolean	Dimension
like_count	Integer	Metric
likes_lifetime	Integer	Metric
media_id	String	Dimension
media_type	String	Dimension
navigation_lifetime	Integer	Metric
owner	Record	Dimension
permalink	String	Dimension
profile_visits_lifetime	Integer	Metric
shares_lifetime	Integer	Metric
timestamp	String	Dimension
total_interactions_lifetime	Integer	Metric
username	String	Dimension
carousel_album_engagement_lifetime	Integer	Metric
carousel_album_impressions_lifetime	Integer	Metric
carousel_album_reach_lifetime	Integer	Metric

important

When you select Media Type to All, choose at least one metric from each media type: Post, Story, and Carousel Album. If metrics are not selected for all media types, the Data Flow fails due to missing metric configurations.

Insights media carousel

The Insights Media Carousel report represents social interaction metrics for all Instagram albums. You can customize only the incremental load type associated with this report.

Field	Data Type	Dimension/Metric
date	String	Dimension
ig_id	String	Dimension
acc_id	String	Dimension
comments_count	Integer	Metric
end_time	String	Dimension
caption	String	Dimension
like_count	Integer	Metric
media_id	String	Dimension
media_type	String	Dimension
owner	Record	Dimension
permalink	String	Dimension
saved_lifetime	Integer	Metric
timestamp	String	Dimension
total_interactions_lifetime	Integer	Metric
username	String	Dimension
video_views_lifetime	Integer	Metric

Insights media image

The Insights Media Image report represents social interaction metrics for Instagram Photos. You can customize only the incremental load type associated with this report.

Field	Data Type	Dimension/Metric
date	String	Dimension
ig_id	String	Dimension
acc_id	String	Dimension
comments_count	Integer	Metric
end_time	String	Dimension
caption	String	Dimension
impressions_lifetime	Integer	Metric
like_count	Integer	Metric
media_id	String	Dimension
media_type	String	Dimension
owner	Record	Dimension
permalink	String	Dimension
reach_lifetime	Integer	Metric
saved_lifetime	Integer	Metric
timestamp	String	Dimension
username	String	Dimension

Insights media image with new metrics

The Insights Media Image report represents social interaction metrics for Instagram photos. You can customize only the incremental load type associated with this report.

Field	Data Type	Dimension/Metric
acc_id	String	Dimension
caption	String	Dimension
comments_count	Integer	Metric
comments_lifetime	Integer	Metric
date	String	Dimension
end_time	String	Dimension
follows_lifetime	Integer	Metric
like_count	Integer	Metric
likes_lifetime	Integer	Metric
media_id	String	Dimension
media_type	String	Dimension
owner	Record	Dimension
permalink	String	Dimension
profile_activity_lifetime	Integer	Metric
profile_visits_lifetime	Integer	Metric
shares_lifetime	Integer	Metric
timestamp	String	Dimension
total_interactions_lifetime	Integer	Metric
username	String	Dimension

Insights media story

The Insights Media Story report represents social interaction metrics for all Instagram stories. You can customize only the incremental load type associated with this report.

Field	Data Type	Dimension/Metric
date	String	Dimension
ig_id	String	Dimension
acc_id	String	Dimension
end_time	String	Dimension
caption	String	Dimension
impressions_lifetime	Integer	Metric
is_story	Boolean	Dimension
media_id	String	Dimension
media_type	String	Dimension
owner	Record	Dimension
permalink	String	Dimension
reach_lifetime	Integer	Metric
replies_lifetime	Integer	Metric
timestamp	String	Dimension
username	String	Dimension

Insights media story with new metrics

The Insights Media Story report represents social interaction metrics for all Instagram Stories. You can only customize the incremental load type associated with this report.

Field	Data Type	Dimension/Metric
date	String	Dimension
ig_id	String	Dimension
acc_id	String	Dimension
end_time	String	Dimension
follows_lifetime	Integer	Metric
caption	String	Dimension
is_story	Boolean	Dimension
media_id	String	Dimension
media_type	String	Dimension
navigation_lifetime	Integer	Metric
owner	Record	Dimension
permalink	String	Dimension
profile_activity_lifetime	Integer	Metric
profile_visits_lifetime	Integer	Metric
shares_lifetime	Integer	Metric
timestamp	String	Dimension
total_interactions_lifetime	Integer	Metric
username	String	Dimension

Insights media video

Field	Data Type	Dimension/Metric
date	String	Dimension
ig_id	String	Dimension
acc_id	String	Dimension
comments_lifetime	Integer	Metric
comments_count	Integer	Metric
end_time	String	Dimension
engagement_lifetime	Integer	Metric
caption	String	Dimension
ig_reels_aggregated_all_plays_count_lifetime	Integer	Metric
ig_reels_avg_watch_time_lifetime	Integer	Metric
impressions_lifetime	Integer	Metric
like_count	Integer	Metric
media_id	String	Dimension
media_type	String	Dimension
owner	Record	Dimension
permalink	String	Dimension
reach_lifetime	Integer	Metric
saved_lifetime	Integer	Metric
timestamp	String	Dimension
username	String	Dimension
video_views_lifetime	Integer	Metric

Insights media video with new metrics

Field	Data Type	Dimension/Metric
ig_id	String	Dimension
acc_id	String	Dimension
comments_count	Integer	Metric
comments_lifetime	Integer	Metric
date	String	Dimension
end_time	String	Dimension
caption	String	Dimension
like_count	Integer	Metric
likes_lifetime	Integer	Metric
media_id	String	Dimension
media_type	String	Dimension
owner	Record	Dimension
permalink	String	Dimension
shares_lifetime	Integer	Metric
timestamp	String	Dimension
total_interactions_lifetime	Integer	Metric
username	String	Dimension