Organic Instagram Business account data — account-level reach and interactions, follower growth, media performance, story metrics, and lifetime audience demographics.
social_ig_account_insights — live account-level reach, impressions, and interactions for any date rangesocial_ig_post_insights — engagement metrics for individual posts (likes, comments, saves, reach)social_ig_recent_posts — pull the most recent posts with caption, media type, timestamp, and engagement countsGrouped by report type. Filter to find a field fast. formula fields are computed — use their component fields in SQL.
| Field name | Label | Type |
|---|---|---|
reach_day | Reach | NUMBER |
actions | Actionsformula | NUMBER |
profile_views_day | DEPRECATED profile views | NUMBER |
email_contacts_day | DEPRECATED email contacts | NUMBER |
get_directions_clicks_day | DEPRECATED get directions clicks | NUMBER |
phone_call_clicks_day | DEPRECATED phone call clicks | NUMBER |
text_message_clicks_day | DEPRECATED text message clicks | NUMBER |
website_clicks_day | DEPRECATED website clicks | NUMBER |
| Field name | Label | Type |
|---|---|---|
configName | Entity name | STRING |
page_id | Page ID | STRING |
date | Date and time | STRING |
year | Yearformula | STRING |
month | Year monthformula | STRING |
week | Weekformula | STRING |
year_week | Year weekformula | STRING |
quarter | Quarterformula | STRING |
year_quarter | Year quarterformula | STRING |
dataFreshness | Data freshness | STRING |
| Field name | Label | Type |
|---|---|---|
reach_period | Reach period | NUMBER |
total_interactions_period | Total interactions period | NUMBER |
views | Views | NUMBER |
| Field name | Label | Type |
|---|---|---|
configName | Entity name | STRING |
page_id | Page ID | STRING |
date | Date and time | STRING |
month | Year monthformula | STRING |
week | Weekformula | STRING |
year | Yearformula | STRING |
dataFreshness | Data freshness | STRING |
| Field name | Label | Type |
|---|---|---|
follower_count_day | Daily new followers | NUMBER |
| Field name | Label | Type |
|---|---|---|
configName | Entity name | STRING |
page_id | Page ID | STRING |
date | Date and time | STRING |
month | Year monthformula | STRING |
year | Yearformula | STRING |
dataFreshness | Data freshness | STRING |
| Field name | Label | Type |
|---|---|---|
followers_count | Followers | NUMBER |
follows_count | Follows | NUMBER |
media_count | Media count | NUMBER |
audience_city_lifetime_value | Followers by city — value [collection] | NUMBER |
audience_country_lifetime_value | Followers by country — value [collection] | NUMBER |
audience_gender_age_lifetime_value | Followers by gender age — value [collection] | NUMBER |
audience_locale_lifetime_value | Followers by locale — value [collection] | NUMBER |
| Field name | Label | Type |
|---|---|---|
configName | Entity name | STRING |
name | Name | STRING |
page_id | Page ID | STRING |
date | Date and time | STRING |
profile_picture_url | Profile picture URL | STRING |
website | Website | STRING |
audience_city_lifetime_key | Followers by city — key [collection] | STRING |
audience_country_lifetime_key | Followers by country — key [collection] | STRING |
audience_gender_age_lifetime_key | Followers by gender age — key [collection] | STRING |
audience_locale_lifetime_key | Followers by locale — key [collection] | STRING |
audience_gender_lifetime_key_formula | Followers by gender — key [collection]formula | STRING |
audience_age_lifetime_key_formula | Followers by age — key [collection]formula | STRING |
dataFreshness | Data freshness | STRING |
| Field name | Label | Type |
|---|---|---|
like_count | Like count | NUMBER |
comments_count | Comments count | NUMBER |
is_comment_enabled | Is comment enabled | NUMBER |
num_of_posts | New postsformula | NUMBER |
| Field name | Label | Type |
|---|---|---|
media_id | Media ID | STRING |
media_type | Media type | STRING |
media_product_type | Media product type | STRING |
caption | Caption | STRING |
permalink | Permalink | STRING |
shortcode | Shortcode | STRING |
media_url | Media URL | STRING |
thumbnail_url | Thumbnail URL | STRING |
timestamp | Timestamp | STRING |
username | Username | STRING |
owner_id | Owner ID | STRING |
page_id | Page ID | STRING |
date | Date and time | STRING |
| Field name | Label | Type |
|---|---|---|
likes_lifetime | Likes lifetime | NUMBER |
comments_lifetime | Comments lifetime | NUMBER |
saved_lifetime | Saved | NUMBER |
shares_lifetime | Shares lifetime | NUMBER |
reach_lifetime | Lifetime reach | NUMBER |
views_lifetime | Views lifetime | NUMBER |
video_views_lifetime | Video views | NUMBER |
total_interactions_lifetime | Total interactions lifetime | NUMBER |
| Field name | Label | Type |
|---|---|---|
media_id | Media ID | STRING |
media_type | Media type | STRING |
media_product_type | Media product type | STRING |
page_id | Page ID | STRING |
timestamp | Timestamp | STRING |
date | Date and time | STRING |
year | Yearformula | STRING |
quarter | Quarterformula | STRING |
month | Year monthformula | STRING |
dataFreshness | Data freshness | STRING |
| Field name | Label | Type |
|---|---|---|
reach_lifetime | Lifetime reach | NUMBER |
exits_lifetime | Exits | NUMBER |
replies_lifetime | Story replies | NUMBER |
taps_back_lifetime | Story taps back | NUMBER |
taps_forward_lifetime | Story taps forward | NUMBER |
num_of_stories | New storiesformula | NUMBER |
| Field name | Label | Type |
|---|---|---|
media_id | Media ID | STRING |
story_id | Story ID | STRING |
media_type | Media type | STRING |
caption | Caption | STRING |
permalink | Permalink | STRING |
shortcode | Shortcode | STRING |
media_url | Media URL | STRING |
thumbnail_url | Thumbnail URL | STRING |
timestamp | Timestamp | STRING |
username | Username | STRING |
owner_id | Owner ID | STRING |
page_id | Page ID | STRING |
date | Date and time | STRING |
dataFreshness | Data freshness | STRING |
The hedgehog-social-insights MCP provides live, on-demand access to Instagram data. Use it for current-period reporting and recent post retrieval without needing to query PMA's warehouse.
| Tool | Data points / capability |
|---|---|
social_ig_account_insights | Account-level reach, impressions, profile views, and interactions for any requested date range. Use social_list_clients to resolve the client name first. |
social_ig_post_insights | Per-post engagement — likes, comments, saves, reach, and impressions for a specific post ID. |
social_ig_recent_posts | Retrieve the most recent posts for an account — caption, media type, timestamp, permalink, and engagement counts. Useful for content audits and weekly snapshots. |