Instagram Business Connector

Start moving your Instagram Business data with fully managed data pipelines. Get clean normalized data ready for analytics, easy to setup and analyze with AI in minutes.

View more about the Instagram Business connector in the Weld documentation

media_history

_weld_synced_at

carousel_album_engagement

int

carousel_album_impressions

5 more instagram-business tables

Explore available Instagram Business data

Browse all the data tables available for the Instagram Business connector, in our interactive ERD data viewer.

View the Instagram Business Data Schema

Transform and model Instagram Business data

Get clean data models from your Instagram Business data. Weld makes it easy to transform and model with the powerful built in SQL editor and AI Assistant.

Instagram Business

raw.instagram_business.table1

raw.instagram_business.table2

Get started with Instagram Business SQL Templates

Get inspiration on how to model your data, with our collection of foundational SQL templates we have battle-tested at Weld. All the templates work out of the gate with the Weld data integrations for Instagram Business.

Profile Overview Report

Profile overview report for Instagram Business integration. It combines data from different tables to calculate average follows count, average followers count, average profile views, and average website clicks for each user on a monthly basis. The results are then ordered by month.

User Engagement and Outreach Report

Generates a report on user engagement and outreach for an Instagram Business integration. It combines data from various tables to calculate average follower count, profile views, website clicks, like count, comments count, feed impressions, and feed reach on a monthly basis. The result is sorted by month and user ID.

Media Performance Report

Generates a media performance report for Instagram Business integration. It combines metrics from the media_history and media_insights tables to provide a comprehensive view of monthly media performance. The report includes metrics such as total media posts, likes, comments, carousel engagement, impressions, reach, reel likes, plays, feed engagement, impressions, and reach.

Media Insights Deep Dive

Retrieves various metrics for different types of media posts (carousel, reel, story, feed). It also calculates engagement rates for each type of media. The template joins the media data with the media history table to include additional information such as caption, timestamp, media type, likes count, and comments count. The final result is sorted by month and media posted date in descending order.

Growth Analysis

Calculates the growth rates of various metrics for an Instagram Business account. It retrieves monthly data on average followers, average follows, total feed engagement, total carousel engagement, and total reel likes. It then calculates the growth rate percentages for each metric compared to the previous month. The results are sorted by month in descending order.

View all Instagram Business templates