Lucen

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

IDNameTypeDescription
client_idClient idSTRINGOrganization slug that owns the observation.
account_idAccount idSTRINGInstagram professional account ID.
dateDateDATECompleted America/Los_Angeles calendar date of the account insight.
connection_aliasConnection aliasSTRINGPortal connection alias that collected the observation.
metricMetricSTRINGNative account metric, views or reach. Parent totals are collected independently.
breakdown_typeBreakdown typeSTRINGNative dimension: follow_type or media_product_type. Never sum across dimension types.
breakdown_valueBreakdown valueSTRINGNative category within breakdown_type, such as FOLLOWER or NON_FOLLOWER for follow_type, or REEL, STORY or AD for media_product_type. Categories are preserved as returned. Dimensions are separate reports, not a combined cross-tab.
valueValueFLOAT64Daily value in this category. Reach is non-additive and category rows need not sum to parent reach.
row_keyRow keySTRINGDeterministic key for the model row grain.
data_updated_atData updated atTIMESTAMPUTC fetch time of the completed breakdown slice that supplied this row.

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;

Integration page