Agent context
Instagram Business models
6 SQL models that turn the raw Instagram Business tables into the reports people ask about. Deploy them in Weld and your agent queries the definitions behind every number.
How the set is built
- 5Raw tables
- 6Core
- 6Analytics
Staging cleans each raw table once, core holds the logic, and analytics is the table dashboards and agents read.
- Profile Overview ReportProfile overview report for Instagram Business integration. For each account and month it returns the average follows and followers count, the followers gained, the average daily reach and the number of taps on the links in the profile. The results are ordered by account and month.grain: account x month · 3 raw tables
- User Engagement and Outreach ReportGenerates a report on user engagement and outreach for an Instagram Business integration. For each account and month it returns the average follower count and its change from the previous month, the followers gained, the average daily reach, the profile link taps, and the average likes, comments, feed views and feed reach per post. The result is sorted by month and user ID.grain: account x month · 5 raw tables
- Media Performance ReportGenerates 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, views and reach, reel likes, views and reach, and feed engagement, views and reach.grain: account x month the media was posted · 2 raw tables
- Media Insights Deep DiveRetrieves 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.grain: one row per media post, dated by the month it was posted · 2 raw tables
- Growth AnalysisCalculates 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.grain: account x month · 3 raw tables
- Engagment Metric AnalysisCalculates various engagement metrics for Instagram Business accounts on a monthly basis. It retrieves data such as the total number of media posts, likes, comments, feed engagement, carousel engagement, reel likes, reel comments, story replies, and story exits. Additionally, it calculates average engagement per post metrics, including average likes, comments, feed engagement, carousel engagement, reel likes, and reel comments per post. The results are ordered by month in descending order.grain: month the media was posted · 2 raw tables
- Weld or dbt
- The same SQL in both dialects. Sync the folder with GitHub Sync, or copy the dbt models into your project.
- Check before you rely on it
- Reconcile a month against Instagram Business's own reports first. Each model's notes say what the synced data can and can't support.
Connect Instagram Business.
Your agents start with context.
Sync Instagram Business to your warehouse, deploy these models, and query them from Claude, Cursor or ChatGPT over MCP. Free for 14 days, no credit card.