Instagram Business link
Instagram Business provides metadata and insights for IG User (Instagram Business Account) and IG Media (Instagram Photo, Video, Story, or Album) objects.
See Instagram's API documentation for more information.
Featureslink
Feature Name | Supported | Notes |
---|---|---|
Capture deletes | ||
Custom data | ||
Data blocking | check | Column level |
Column hashing | check | |
Re-sync | check | Connector level |
History | ||
API configurable | check | API configuration |
Priority-first sync | check | USER_INSIGHTS table |
Fivetran data models | check | Get the models: source / transform; Get the social media reporting model |
Private networking |
Setup guidelink
Follow our step-by-step Instagram Business setup guide to connect Instagram with your destination using Fivetran connectors.
Sync overviewlink
You can sync all accounts or select specific accounts to sync.
To sync metadata and insights of the IG User and IG Media objects, we need the following permissions:
instagram_basic
instagram_manage_insights
pages_show_list
pages_read_engagement
During every sync, we fetch the data for all the accounts that you are syncing and all the media objects for each account.
Sync frequencylink
The metrics fetched for all the _INSIGHTS
tables (except for the USER_INSIGHTS
table) represent values present at the time of that particular sync. We recommend that you set a sync frequency of not more than 10 minutes for more granular insights.
You can use the _fivetran_synced
column to track the metrics available at the time of each sync.
Schema informationlink
This schema applies to all Instagram Business connectors.
To zoom, open the ERD in a new window.Schema noteslink
User Lifetime Insights tablelink
For the USER_LIFETIME_INSIGHTS
table, we fetch data up to the current date and not for the current date. Since v.13.0, the Graph API doesn't return end_time
for the audience_*
metrics. For these metrics, we use default value in the date
column, which is equal to current date in the UTC timezone.
The key
type varies depending on the metric
value. For example, the online_followers
metric is an hourly breakdown, so each key
represents an hour from a day, for a total of 24 values.
Media tableslink
We don't fetch data for deleted media objects.
We can fetch the story
media data only in the 24-hour span in which the story is active. We recommend that you set a sync frequency of not more than 10 minutes for more granular data.