X Organic (Twitter) report building guide

Prev Next

Use the X Organic (Twitter) data source connector to see how your follower base evolves and which Tweets perform best. Compare X Organic data with your X Ads (Twitter) data to see how engagement differs between campaigns and organic posts.

Before you begin

Before you build reports, you need to connect the data source to Supermetrics.

Query types

With this data source, you need to select a query type to get the right type of data:

  • Profile info: Returns the current follower count and total Tweet count for your profile.

  • Tweet engagements: Returns basic engagement metrics for Tweets created in the past 90 days. Note that metric values are lifetime totals per Tweet, not values for the selected date range.

Note

If you need to use multiple query types in your Looker Studio report, you will need to create separate connectors for each query type. Learn more about query types in Looker Studio.

Popular queries

These query configurations help you track key performance indicators and analyze trends. You can use these settings in any Supermetrics destination, such as Data Explorer, Dashboards, Google Sheets, Looker Studio, or data warehouse destinations.

Review impressions and engagement for recent Tweets

See the impressions and engagement totals for your most recent Tweets, alongside Tweet text, creation date, and URL — useful for identifying which content is performing best and informing your organic content strategy.

To fetch this data, use the following settings in your reporting or visualization tool:

Setting

Value

Query type

Tweet engagements

Metrics

Impressions, Engagements

Dimensions

Created date, Tweet URL, Tweet text

Suggested visualization

Table

Understanding the data

  • Impressions: The total number of times the Tweet was seen.

  • Engagements: The total number of engagements on the Tweet.

  • Created date: The date the Tweet was published.

  • Tweet URL: A direct link to the Tweet on X.

  • Tweet text: The text content of the Tweet.

Note

Tweet engagement metrics are lifetime totals per Tweet, not values for the selected date range.

Analyze detailed audience engagement per Tweet

Get a full breakdown of how your audience has interacted with your Tweets over the last 28 days — including engagements, clicks, impressions, likes, replies, and retweets — so you can identify which Tweets generated the most interaction.

To fetch this data, use the following settings in your reporting or visualization tool:

Setting

Value

Query type

Tweet engagements

Date range

Last 28 days

Metrics

Engagements, Clicks, Impressions, Likes, Replies, Retweets

Dimensions

Created date, Tweet text, Tweet URL

Suggested visualization

Table

Understanding the data

  • Engagements: The total number of engagements on the Tweet.

  • Clicks: The total number of clicks on the Tweet, including favorites and other engagement types.

  • Impressions: The total number of times the Tweet was seen.

  • Likes: The total number of likes on the Tweet.

  • Replies: The total number of replies to the Tweet.

  • Retweets: The number of times the Tweet was retweeted.

  • Created date: The date the Tweet was published.

  • Tweet text: The text content of the Tweet.

  • Tweet URL: A direct link to the Tweet on X.

Note

Tweet engagement metrics are lifetime totals per Tweet, not values for the selected date range.

Display current profile follower count

Show your current follower count as a scorecard — a simple way to surface your audience size and track it over time using scheduled refreshes.

To fetch this data, use the following settings in your reporting or visualization tool:

Setting

Value

Query type

Profile info

Metrics

Followers

Dimensions

Date

Suggested visualization

Scorecard

Understanding the data

  • Followers: The total number of accounts currently following your profile.

  • Date: Used to anchor the data to a specific point in time.

View profile lifetime details

See a snapshot of your profile's lifetime totals — including followers, following, total Tweets published, favourites, and list memberships — useful for adding profile context to your organic reporting dashboard.

To fetch this data, use the following settings in your reporting or visualization tool:

Setting

Value

Query type

Profile info

Metrics

Favourites, Followers, Following, Lists, Tweets

Dimensions

Account name, Account ID

Suggested visualization

Table

Understanding the data

  • Favourites: The total lifetime number of posts the account has liked.

  • Followers: The total number of accounts currently following the profile.

  • Following: The total number of accounts the profile is following.

  • Lists: The number of public lists the account is a member of.

  • Tweets: The total lifetime number of Tweets the account has published.

  • Account name: The display name of the X account.

  • Account ID: The unique identifier of the X account.

More resources

You might also be interested in: