Data Sources

Instagram Insights

Metrics & Dimensions List


Updated: 2026-08-01

Important

Two reports are available:

  • instagram_insights__account_daily - day-by-day performance of the account
  • instagram_insights__media_lifetime - lifetime performance of each post, reel or story

The lifetime table holds the totals accumulated by a piece of media since it was published, refreshed on every sync.

Account Table

account_idText

Identifier of the Instagram account the row belongs to.

usernameText

The username of the Instagram account.

ig_idText

The ID assigned to the account by Instagram.

nameText

The name associated with the Instagram account (e.g., business or personal name).

dateDate

The date for which the metrics are being reported.

followers_count_lifetimeNumber

The total number of followers the account has accumulated over its lifetime.

media_count_lifetimeNumber

The total number of media items (posts, stories, etc.) shared by the account over its lifetime.

accounts_engaged_dayNumber

The number of unique accounts that engaged with the account's content on a given day.

views_dayNumber

The number of times your content was played or displayed. Content includes reels, posts, stories.

comments_dayNumber

The number of comments received on the account's content on a given day.

likes_dayNumber

The number of likes received on the account's content on a given day.

reach_dayNumber

The number of unique accounts that saw the account's content on a given day.

replies_dayNumber

The number of replies received on the account's comments on a given day.

saves_dayNumber

The number of times the account's content was saved on a given day.

shares_dayNumber

The number of times the account's content was shared on a given day.

total_interactions_dayNumber

The total number of interactions (likes, comments, shares, saves, etc.) with the account's content on a given day.

Media Table

account_idText

Identifier of the Instagram account the row belongs to.

usernameText

The username of the Instagram account.

media_idText

The unique ID of the media object.

shortcodeText

The short, unique code used in the URL of the media object.

captionText

The caption text associated with the media object.

timestampTimestamp

The date and time the media object was created.

permalinkText

The permanent URL of the media object.

thumbnail_urlText

URL of the media thumbnail. For media with no thumbnail, the media URL is used instead.

media_product_typeText

The type of media product (e.g., "FEED", "STORY", "REELS", "IGTV").

media_typeText

The type of media (e.g., "IMAGE", "VIDEO", "CAROUSEL_ALBUM").

media_urlText

The URL of the full-size media object.

views_lifetimeNumber

Total number of times the video IG Media has been seen.

comments_lifetimeNumber

The total number of comments on the media object.

follows_lifetimeNumber

The total number of follows gained from this media object.

ig_reels_avg_watch_time_lifetimeNumber

The average watch time of Reels related to this media.

ig_reels_video_view_total_time_lifetimeNumber

The total time spent viewing Reels related to this media.

likes_lifetimeNumber

The total number of likes on the media object.

profile_activity_lifetimeNumber

The total number of profile actions (e.g., visits, follows) generated by this media.

profile_visits_lifetimeNumber

The total number of profile visits generated by this media.

reach_lifetimeNumber

The total number of unique accounts that have viewed the media object.

saved_lifetimeNumber

The total number of times the media object has been saved.

shares_lifetimeNumber

The total number of times the media object has been shared.

total_interactions_lifetimeNumber

The total number of interactions (e.g., likes, comments, shares) with the media object.