Introduction

Datasources and destinations

Fields listing for Instagram Public Data

EXPLORE YOUR DATA

Metrics & dimensions

Find the fields you need for your next report.

5 metrics30 dimensions

35 fields

All fields
FieldDetails
Biography
Field IDaccount/biography
DimensionTEXT
Comments
Field IDcomments_count
MetricNUMBER
Date
Year, month, and day.
Field ID_NORMALIZED_DATE_FIELD_YEAR_MONTH_DAY
DimensionYEAR_MONTH_DAY
Day of the month
Day of the year
Field ID_NORMALIZED_DATE_FIELD_DAY
DimensionDAY
Day of the week
Week of the year
Field ID_NORMALIZED_DATE_FIELD_DAY_OF_WEEK
DimensionDAY_OF_WEEK
Hour of the day
Hour of the day
Field ID_NORMALIZED_DATE_FIELD_HOUR
DimensionHOUR
Instagram ID
Field IDaccount/id
DimensionTEXT
Link To Post
Field IDmedia/permalink
DimensionTEXT
Media Likes
Field IDlike_count
MetricNUMBER
Month and day
Month and day
Field ID_NORMALIZED_DATE_FIELD_MONTH_DAY
DimensionMONTH_DAY
Month of the year
Month of the year
Field ID_NORMALIZED_DATE_FIELD_MONTH
DimensionMONTH
Name
Field IDaccount/name
DimensionTEXT
Post Caption
Field IDmedia/caption
DimensionTEXT
Post Caption Length
Field IDmedia/media_caption_length
DimensionNUMBER
Post Caption Length (without Hashtags)
Field IDmedia/caption_length_no_hashtags
DimensionNUMBER
Post Created
Field IDmedia/timestamp
DimensionYEAR_MONTH_DAY_SECOND
Post Hashtag Count
Field IDmedia/hashtag_count
DimensionNUMBER
Post Hashtags
Field IDmedia/found_hashtags
DimensionTEXT
Post ID
Field IDmedia/id
DimensionTEXT
Post Media Thumbnail URL
Field IDmedia/media_url
DimensionTEXT
Post Type
Field IDmedia/media_type
DimensionTEXT
Profile Followers
Field IDfollowers_count
MetricNUMBER
Profile Follows
Field IDfollows_count
MetricNUMBER
Profile Picture
The profile picture
Field IDaccount/profile_picture_url
DimensionTEXT
Profile Post Count
Field IDmedia_count
MetricNUMBER
Quarter of the year
Quarter of the year
Field ID_NORMALIZED_DATE_FIELD_QUARTER
DimensionQUARTER
Username
Field IDaccount/username
DimensionTEXT
Website
Field IDaccount/website
DimensionTEXT
Week of the year
Week of the year
Field ID_NORMALIZED_DATE_FIELD_WEEK
DimensionWEEK
Week of the year (start Sunday)
Week of the year
Field ID_NORMALIZED_DATE_FIELD_WEEK_START_SUNDAY
DimensionWEEK
Year
Year such as 2017.
Field ID_NORMALIZED_DATE_FIELD_YEAR
DimensionYEAR
Year month
Year and month.
Field ID_NORMALIZED_DATE_FIELD_YEAR_MONTH
DimensionYEAR_MONTH
Year month day hour
Year, month, day, and hour.
Field ID_NORMALIZED_DATE_FIELD_YEAR_MONTH_DAY_HOUR
DimensionYEAR_MONTH_DAY_HOUR
Year Quarter
Year and quarter.
Field ID_NORMALIZED_DATE_FIELD_YEAR_QUARTER
DimensionYEAR_QUARTER
Year week
Year and week.
Field ID_NORMALIZED_DATE_FIELD_YEAR_WEEK
DimensionYEAR_WEEK

Explore destinations for your data

AI

Claude

Ask Claude about your Marketing data.
AI

ChatGPT

Ask ChatGPT about your Marketing data.
Spreadsheet

Excel

Easily track, report, and analyze your marketing KPIs in Excel.‍
Data lake

Azure Blob Storage

Quickly export your marketing data to Azure Blob Storage for secure storage and analysis, streamlining workflows and enhancing insights.
Data lake

Google Cloud Storage

Effortlessly export marketing data to Google Cloud Storage for secure, scalable storage and streamlined insights.
Data lake

Amazon S3

Unlock effortless data storage and management for your marketing team with seamless transfers to Amazon S3, simplifying workflows and accelerating insights.
Data warehousing

Snowflake

Effortlessly integrates your data in Snowflake, providing a seamless solution for storage, analysis, and real-time insights.
Data warehousing

Amazon Redshift

Access advanced analytics and insights by effortlessly connecting your marketing data to Amazon Redshift.
Data warehousing

Azure SQL

Effortlessly connect your marketing data to Azure SQL for immediate access to valuable insights.
Data warehousing

PostgreSQL

Effortlessly send data from multiple Marketing platforms to your PostgreSQL database with Catchr for seamless integration, storage, and management.
Data warehousing

MySQL

Seamlessly integrate your marketing data with MySQL to access valuable analytics and insights.
Visualization

Tableau

Empower your marketing teams with seamless data transfer to Tableau.
Visualization

Power BI

Whether it's social media analytics, email marketing results, or PPC campaign data, Catchr bridges the gap. Export your data to Power BI.
Data warehousing

Big Query

Unlock advanced analytics and insights by easily connecting your marketing data to BigQuery.
Visualization

Data Studio (formerly Looker Studio)

Catchr makes it super easy to visualize your marketing data into Data Studio (formerly Looker Studio).
Spreadsheet

Google Sheets

Effortlessly report, monitor, and analyze your marketing KPIs in Google Sheets.