Introduction

Datasources and destinations

Fields listing for X / Twitter Public Data

EXPLORE YOUR DATA

Metrics & dimensions

Find the fields you need for your next report.

10 metrics42 dimensions

52 fields

All fields
FieldDetails
Account Country Codes
Provides a list of countries where this user is not available.
Field IDaccount/withheld.country_codes
DimensionTEXT
Account Created At
Field IDaccount/created_at
DimensionYEAR_MONTH_DAY
Account Description
The text of this user's profile description (also known as bio), if the user provided one.
Field IDaccount/description
DimensionTEXT
Account Id
Unique identifier of this user. This is returned as a string in order to avoid complications with languages and tools that cannot handle large integers.
Field IDaccount/id
DimensionTEXT
Account Location
The location specified in the user's profile, if the user provided one. As this is a freeform value, it may not indicate a valid location, but it may be fuzzily evaluated when performing searches with location queries.
Field IDaccount/location
DimensionTEXT
Account Most Recent Tweet Id
The ID of the User's most recent Tweet
Field IDaccount/most_recent_tweet_id
DimensionTEXT
Account Name
The friendly name of this user, as shown on their profile.
Field IDaccount/name
DimensionTEXT
Account Pinned Tweet Id
Unique identifier of this user's pinned Tweet.
Field IDaccount/pinned_tweet_id
DimensionTEXT
Account Profile Image Url
The URL to the profile image for this user, as shown on the user's profile.
Field IDaccount/profile_image_url
DimensionTEXT
Account Protected
Indicates if this user has chosen to protect their Tweets (in other words, if this user's Tweets are private).
Field IDaccount/protected
DimensionBOOLEAN
Account Scope
Indicates whether the content being withheld is a Tweet or a user (this API will return user).
Field IDaccount/withheld.scope
DimensionTEXT
Account URL
The URL specified in the user's profile, if present.
Field IDaccount/url
DimensionTEXT
Account Username
The Twitter handle (screen name) of this user.
Field IDaccount/username
DimensionTEXT
Account Verified
Indicate if this user is a verified Twitter user.
Field IDaccount/verified
DimensionBOOLEAN
Account Verified Type
Indicates the type of verification for the Twitter account.
Field IDaccount/verified_type
DimensionTEXT
Bookmark Count
Field IDpublic_metrics.bookmark_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
Followers Count
Number of users who follow this user.
Field IDpublic_metrics.followers_count
MetricNUMBER
Following Count
Number of users this user is following.
Field IDpublic_metrics.following_count
MetricNUMBER
Hour of the day
Hour of the day
Field ID_NORMALIZED_DATE_FIELD_HOUR
DimensionHOUR
Impression Count
Field IDpublic_metrics.impression_count
MetricNUMBER
Like Count
Number of likes.
Field IDpublic_metrics.like_count
MetricNUMBER
Listed Count
Number of lists that include this user.
Field IDpublic_metrics.listed_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
Quarter of the year
Quarter of the year
Field ID_NORMALIZED_DATE_FIELD_QUARTER
DimensionQUARTER
Quote Count
Field IDpublic_metrics.quote_count
MetricNUMBER
Reply Count
Field IDpublic_metrics.reply_count
MetricNUMBER
Retweet Count
Field IDpublic_metrics.retweet_count
MetricNUMBER
Tweet Author Id
Field IDtweet/author_id
DimensionTEXT
Tweet Conversation Id
Field IDtweet/conversation_id
DimensionTEXT
Tweet Copyright
Field IDtweet/withheld.copyright
DimensionTEXT
Tweet Count
Number of Tweets (including Retweets) posted by this user.
Field IDpublic_metrics.tweet_count
MetricNUMBER
Tweet Country Codes
Field IDtweet/withheld.country_codes
DimensionTEXT
Tweet Created At
Field IDtweet/created_at
DimensionYEAR_MONTH_DAY
Tweet Id
Field IDtweet/id
DimensionTEXT
Tweet Language
Field IDtweet/lang
DimensionTEXT
Tweet Possibly Sensitive
Field IDtweet/possibly_sensitive
DimensionBOOLEAN
Tweet Reply Settings
Field IDtweet/reply_settings
DimensionTEXT
Tweet Reply To User Id
Field IDtweet/in_reply_to_user_id
DimensionTEXT
Tweet Scope
Field IDtweet/withheld.scope
DimensionTEXT
Tweet Source
Field IDtweet/source
DimensionTEXT
Tweet Text
Field IDtweet/text
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.