Data Sources

Instagram Insights

Metrics & Dimensions List

Important

For the Media table

  • We retrieve the latest 500 media items from an Instagram account daily, provided they were published within the last 2 years.

Account Table

account_id
Text

Account ID - The unique ID of the Instagram account.

username
Text

Username - The username of the Instagram account

ig_id
Text

Instagram ID - The unique ID of the Instagram account.

name
Text

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

date
Date

Date - The date for which the metrics are being reported.

followers_count_lifetime
Number

Followers Count (Lifetime) - The total number of followers the account has accumulated over its lifetime.

media_count_lifetime
Number

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

accounts_engaged_day
Number

Accounts Engaged (Day) - The number of unique accounts that engaged with the account's content on a given day.

comments_day
Number

Comments (Day) - The number of comments received on the account's content on a given day.

views_day
Number

Views (Day) - The number of times your content was played or displayed. Content includes reels, posts, stories.

likes_day
Number

Likes (Day) - The number of likes received on the account's content on a given day.

reach_day
Number

Reach (Day) - The number of unique accounts that saw the account's content on a given day.

replies_day
Number

Replies (Day) - The number of replies received on the account's comments on a given day.

saves_day
Number

Saves (Day) - The number of times the account's content was saved on a given day.

shares_day
Number

Shares (Day) - The number of times the account's content was shared on a given day.

total_interactions_day
Number

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

Media Table

account_id
Text

Account ID - The unique ID of the Instagram account.

username
Text

Username - The username of the Instagram account

media_id
Text

Media ID - The unique ID of the media object.

shortcode
Text

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

caption
Text

Caption - The caption text associated with the media object.

timestamp
Date

Datetime - The date and time the media object was created.

permalink
Text

Permalink - The permanent URL of the media object.

thumbnail_url
Text

Thumbnail URL - The URL of the thumbnail image for the media object.

media_product_type
Text

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

media_type
Text

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

media_url
Text

Media URL - The URL of the full-size media object.

views_lifetime
Number

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

comments_lifetime
Number

Comments Lifetime - The total number of comments on the media object.

follows_lifetime
Number

Follows Lifetime - The total number of follows gained from this media object.

ig_reels_avg_watch_time_lifetime
Number

IG Reels Average Watch Time Lifetime - The average watch time of Reels related to this media.

ig_reels_video_view_total_time_lifetime
Number

IG Reels Video View Total Time Lifetime - The total time spent viewing Reels related to this media.

likes_lifetime
Number

Likes Lifetime - The total number of likes on the media object.

profile_activity_lifetime
Number

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

profile_visits_lifetime
Number

Profile Visits Lifetime - The total number of profile visits generated by this media.

reach_lifetime
Number

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

saved_lifetime
Number

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

shares_lifetime
Number

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

total_interactions_lifetime
Number

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