Instagram data reference
Social
4 tables
68 columns
Lucen syncs your Instagram data (Social) to your warehouse and models it into the tables below. You connect Instagram with one OAuth sign-in. By default your data refreshes every day at 07:00 Buenos Aires time (UTC-3). Your plan sets how many times a day it can sync, and you can choose the times, see pricing.
Your plan sets how much history the first sync loads, see pricing.
Send Instagram data to
Tables
gold_instagram_account_day
- Grain
- account_id / date
- Use for
- Daily views, reach, profile views, account engagement, and the follower stock
gold_instagram_account_day_breakdown
- Grain
- account_id / date / metric / breakdown_type / breakdown_value
- Use for
- Views and reach by native audience or content categories; never reconstruct parent reach by summing categories
gold_instagram_media
- Grain
- account_id / media_id
- Use for
- Current feed and reels plus lifetime counters as of the latest snapshot
gold_instagram_story
- Grain
- account_id / story_id
- Use for
- Latest retained Story metadata, views, reach, replies and navigation, including expired Stories
Columns
Column names match your warehouse exactly. Descriptions come from dbt.
gold_instagram_account_day columns
19
gold_instagram_account_day_breakdown columns
gold_instagram_media columns
20
gold_instagram_story columns
19
Typical questions
Prompt to try
How many views and profile views did the account get last week?
gold_instagram_account_daysum views and profile_views; do not sum reach or followers
Prompt to try
How many followers does the account have?
gold_instagram_account_daylatest followers, not a sum; check followers_snapshot_date
Prompt to try
What did we publish, and how many lifetime views and saves does each post have?
gold_instagram_medialatest snapshot; NULL counters mean no insights row
Starter queries
sql
SELECT date, account_id, views, reach, profile_views
FROM `your-project.your_org_gold.gold_instagram_account_day`
WHERE date >= DATE_SUB(CURRENT_DATE(), INTERVAL 30 DAY)
ORDER BY date DESC
LIMIT 100;sql
SELECT date, account_id, metric, breakdown_type, breakdown_value
FROM `your-project.your_org_gold.gold_instagram_account_day_breakdown`
WHERE date >= DATE_SUB(CURRENT_DATE(), INTERVAL 30 DAY)
ORDER BY date DESC
LIMIT 100;sql
SELECT snapshot_date, account_id, story_id, published_at, media_type
FROM `your-project.your_org_gold.gold_instagram_story`
WHERE snapshot_date >= DATE_SUB(CURRENT_DATE(), INTERVAL 30 DAY)
ORDER BY snapshot_date DESC
LIMIT 100;sql
SELECT published_date, account_id, media_id, content_type, text
FROM `your-project.your_org_gold.gold_instagram_media`
WHERE published_date >= DATE_SUB(CURRENT_DATE(), INTERVAL 30 DAY)
ORDER BY published_date DESC
LIMIT 100;