BigQuery Connector

Sync Instagram Data to BigQuery

Detrics loads Instagram into Google BigQuery on the schedule you set. The tables arrive clean, the history keeps growing, and you can query everything from SQL, Looker Studio, or Claude. We run the pipeline so you don't have to.

Book a Demo

*Free 30-minute consultation

SELECT
  username,
  SUM(account_reach) AS account_reach
FROM `your_project.marketing_data.instagram_insights_account_daily_reach_daily`
WHERE date >= DATE_SUB(CURRENT_DATE(), INTERVAL 30 DAY)
GROUP BY username
ORDER BY account_reach DESC
LIMIT 10

Why send Instagram data to BigQuery?

Audience evolution

Store daily snapshots of followers and engagement to measure real long-term growth.

History without limits

Platform APIs cap how far back you can query. In BigQuery every Instagram sync is stored across its 11 tables, so you accumulate years of your own history.

One warehouse for everything

Join Instagram with the rest of your platforms in one place, no copy-pasting between sheets.

Ask Claude about it

With your data in BigQuery, Claude can answer business questions about Instagram in plain language.

Only connector with high resolution post images

Image URLs from Meta, TikTok and Instagram expire within 24 hours. Detrics stores every creative in a Google Cloud Storage bucket inside your own project and writes a permanent URL to BigQuery, so your dashboards never show a broken image again. How image persistence works.

Ads table in BigQuery showing each creative's image next to its metrics

Instagram tables in BigQuery

This is what Detrics creates for Instagram: 11 preset tables with scheduled syncs, plus any custom one you define.

Account Analytics

account_reach_advanced

Reach analysis by follower type and media type

usernameaccount follow typeaccount media product typeaccount reach+1

account_kpis

Key account totals — snapshot table: each sync appends current values; trend by DATE(_detrics_synced_at), daily deltas via LAG()

usernamewebsiteaccount IDaccount reachaccount likesaccount shares+6

account_kpis_by_media_type

Account totals by content type — snapshot table: each sync appends current values; trend by DATE(_detrics_synced_at)

usernamewebsiteaccount media product typeaccount reachaccount likesaccount shares+5

+4 more tables in this group

Content Performance

media_performance

Content performance metrics and engagement

media product typepermalinkmedia URLviewsreachsaved+7

media_performance_historical

Long-term media performance tracking

usernameshortcodemedia product typeviewsreachsaved+13

post_comments

All comment text on your posts (one row per comment)

permalinkcaptiontimestampcomment like count+5

Daily Reach

account_daily_reach_daily

Per-day account reach, keyed on account + date — the incremental-dedup-safe Instagram table

usernameaccount IDaccount reach

HOW IT WORKS

From Instagram to your warehouse

Connect your account once. Detrics handles schemas, syncs, and backfills.

First step

Connect your first datasource

Link any of 37+ marketing and ecommerce platforms in a couple of clicks.

Connect a source

Second step

Set up your destination

Point Detrics at your BigQuery project and dataset. We write the SQL and handle the setup for you.

Set up destination

Third step

Create your transfer

Choose what to sync and how often. Detrics builds and runs the pipeline for you.

Create a transfer

And that's it

Real-time data, forever

Your data lands in the warehouse and stays fresh automatically. We handle the syncing, the maintenance, and every API update for you.

Book a demo

In the demo we set everything up for you and save you hours.

Then ask Claude about it

With Instagram in BigQuery, the Detrics MCP server lets you manage your warehouse and run queries in plain language. MCP access is included with every BigQuery plan.

Which Instagram posts got the most engagement?

Compare my Instagram account reach week over week

Summarize my organic Instagram performance for the last month

Explore the Instagram MCP server

Every Instagram field, on demand

Preset tables curated by our team
Custom tables with any field combination
Incremental syncs that only load new data
Automatic backfill of up to 12 months of history

32 metrics

28 dimensions

View Instagram Fields

Get Instagram into your warehouse this week