Use the Twitter Premium data source to pull detailed data of your Tweets, and create historical reports to see how your audience's engagement has changed over time. You can compare the data from the Twitter Premium data source with your X Ads (Twitter) data to see how engagement for campaigns and organic posts differs.
Once you’ve connected to Twitter Premium, you’re ready to create your first query in Google Sheets, Looker Studio (formerly Data Studio), or Excel.
Query types for this data source
When connecting to the Twitter Premium data source, you need to select a query type. The query type defines what sort of metrics and dimensions are available.
- Tweet engagements: Impression and engagement data for Tweets up to 90 days.
- Common account information: General information about the profile, such as description, location, and friend and follower count.
- Tweet historical: Data for Tweets older than 90 days. Note that the "Tweet historical" query type is available as a separately paid feature.
Try these queries
See the following use cases for examples of how to set up queries.
See Tweet engagement
Take a look at the engagements and engagement rate of your Tweets for the past 28 days.
Use the “Tweet engagements” query type.
The “Engagements” metric shows the number of times users have interacted with the Tweet.
The “Engagement rate” metric shows the rate at which the users engaged with the Tweet.
For best results in Looker Studio, use the table chart type.
- Set the date range to Last 28 days.
- Select the Engagements and Engagement rate metrics.
- Select the Tweet text dimension to split the query results by Tweet text.
See impressions, retweets, replies, and favorites
Explore what sort of Tweets were most discussed last week.
Use the “Tweet engagements” query type.
The “Impressions” metric shows the number of times your Tweets have been viewed.
The “Retweets” metric shows the number of times the Tweet has been retweeted.
The “Replies” metric shows the number of times the Tweet has been replied to.
The “Favourites” metric shows the number of times the Tweet has been added as a favorite.
For best results in Looker Studio, use the table chart type.
- Set the date range to Last 7 days.
- Select the Impressions, Retweets, Replies, and Favourites metrics.
- Select the Tweet text and Tweet link dimensions to split the query results by Tweet.
See basic information about Twitter profiles
Fetch basic information about Twitter profiles, such as their name, URL, profile description, how long the profile has been in use, and where they're located.
Use the “Common account information” query type.
The “Follower count” metric shows the number of followers the user has.
The “Statuses” metric shows the number of user statuses.
For best results in Looker Studio, use the table chart type.
- Select the Follower count and Statuses metrics.
- Select the Name, User URL, Description, Member since, and Location dimensions.
See historical impressions, engagements, video views, and clicks
Get insight into how much attention your Tweets have received in the past 6 months.
Use the “Tweet historical” query type. Note that the "Tweet historical" query type is available as a separately paid feature.
The “Video views” metric shows the number of times a video in the Tweet has been 50% visible for at least two seconds.
The “URL clicks” metric shows how many times a URL in the Tweet has been clicked.
For best results in Looker Studio, use the combo chart type.
- Set the date range to Last 6 months.
- Select the Engagements, Impressions, Video views, and URL clicks metrics.
- Select the Year & week dimension to split the query results by week.
Set up scheduled refreshes for your reports
You can set up scheduled refreshes for your reports created in Google Sheets and Excel. Follow the instructions on how to create and manage scheduled reports in Google Sheets and how to set up scheduled report triggers in Excel.
In Looker Studio, you can have a copy of your report emailed to you and important stakeholders at regular intervals.
More resources
See the Supermetrics blog for more information about the Twitter Premium data source.
You might also be interested in: