Social
Instagram Insights schema
SightShark syncs Instagram Insights into a data warehouse you own. It creates 6 tables holding 78 fields, refreshed daily. Account and media data for a professional account, with per-media insights, comments, daily account insights and lifetime audience demographics.
6 tables / 78 fields / Tables from the production sync
Tables and fields
Every table this connector creates, and every field in it, named as you will query it.
snapshots_media_insights
17 fields
- id
- media_type
- comments
- follows
- ig_reels_avg_watch_time
- ig_reels_video_view_total_time
- likes
- navigation
- profile_activity
- profile_visits
- reach
- replies
- saved
- shares
- total_interactions
- views
- snapshot_time
snapshots_media
14 fields
- id
- ig_id
- caption
- is_comment_enabled
- media_product_type
- media_type
- media_url
- owner_id
- permalink
- shortcode
- thumbnail_url
- timestamp
- username
- snapshot_time
reports_user_insights
15 fields
- id
- date
- accounts_engaged
- comments
- follows_and_unfollows
- likes
- online_followers
- profile_links_taps
- reach
- replies
- reposts
- saves
- shares
- total_interactions
- views
snapshots_user_lifetime_insights
10 fields
- ig_user_id
- metric
- timeframe
- breakdown
- key
- value
- snapshot_time
- engaged_audience_demographics
- follower_demographics
- reached_audience_demographics
snapshots_user
12 fields
- id
- ig_id
- followers_count
- follows_count
- has_profile_pic
- is_published
- media_count
- name
- profile_picture_url
- username
- website
- snapshot_time
snapshots_media_comment
10 fields
- id
- media_id
- hidden
- like_count
- owner_id
- owner_username
- parent_id
- text
- timestamp
- snapshot_time
Where it lands
Into a warehouse you already own, in a region you pick. The modelling runs inside that project, so nothing leaves your cloud to be transformed and we keep no copy of your history.
- Google BigQuery
- Snowflake
- Databricks
- AWS Redshift
- Azure Synapse
Organic numbers live behind a different login from paid, so the two halves of the same channel are usually reported separately and never add up.
Questions people ask
What tables does SightShark create from Instagram Insights?
6 tables, including snapshots_media_insights, snapshots_media, reports_user_insights. snapshots_media_insights is one row per media item, per sync. Every one is listed on this page, with its fields.
Which Instagram Insights fields can I get?
All 78 listed fields are on this page, table by table, named as they appear in your warehouse.
How often does Instagram Insights data refresh?
Daily. A sync adds to the tables rather than replacing them, so when a platform restates a figure for a day that has already closed, both the original number and the correction stay on record.
Can I join Instagram Insights data to my other platforms?
Yes. Every metric is modelled to one name, one type, one grain and one currency, so a query across Instagram Insights and another source needs no reconciling of field names first.
Related connectors
Reporting on this data
- 7 min read
What happens when a platform changes its API.
A pipeline that stops gets fixed today. A pipeline that keeps returning rows can be wrong for a month.
Read it - 6 min read
How to write metric definitions that hold across clients.
Most arguments about a number are arguments about what the number means. Write it down once.
Read it - 7 min read
How far back a new client's marketing data goes.
Further than you expect in places, and gone for good in others. Worth knowing before the day you need it.
Read it
Get started
Want Instagram Insights in your own warehouse?
A call with someone who can answer the schema questions.