Open navigation

Twitter Ads, Premium, and Public Data: Query setup guide

Once you’ve authenticated Twitter Ads Twitter Premium, or Twitter Public Data, you’re ready to create your first query. This guide will walk you through how to set up your first query in any of these data sources in Google Sheets, Data Studio, and Excel, as well as data warehouse destinations like Google Cloud Storage, BigQuery, and the Supermetrics API.

Before you begin

Twitter Ads

To connect Supermetrics to Twitter Ads, you need:

Twitter Premium

To connect Supermetrics to Twitter Premium, you need:

  • A valid account.
  • Twitter Premium is available only with an Enterprise-level license. Contact our sales team if you'd like to talk about connecting it.

Note that Twitter Premium doesn't support multi-account logins or agency access. The API doesn't allow you to fetch data from multiple user accounts with one login — you'll need to add each user account separately.

Tweet historical

Twitter Premium has some rate-limited features. One of these is a cap on pulling data for Tweets that are more than 90 days old.

You can remove this cap with Supermetrics' Tweet historical feature, which offers media view, media engagement, URL clicks and more report types on Tweets older than 90 days. Start a conversation with our sales team if you'd like to add this feature to your license.

Available fields

Visit our documentation site for a full list of the metrics and dimensions Supermetrics can pull from the data source. You can find the full list of data sources on the left side of the page. 

  • Field label is the name that appears in the sidebar. 
  • Metrics can be found under type - “met”.
  • Dimensions can be found under type - “dim” .


Google Sheets Data Studio Excel Data Integrations
  1. Authenticate the data source in Google Sheets. 
  2. Select Dates. Choose one date range (today, yesterday, last week, etc.). To select a custom date, you can insert the date manually in the Start and End fields in the calendar bar.
  3. Select Metrics
  4. Select Split by Dimensions. You can choose to split your data into rows and/or columns, reflect the number of rows or columns to be fetched, and define how the data is sorted.
  5. Click Get Data to Table to create your query and pull your data.

Advanced options for Google Sheets

  1. You can filter your data by selecting the field, operator, and value to filter by. Learn more about filters.
  2. Under Options, you can add additional features to your query.
  • Replace blank metric values with zeros.
  • Combine new results with old.
  • Format results for Data Studio (to import data from Google Sheets to Data Studio).
  • No header row.
  • Highlight values with colours (green, red, etc.).
  • Advanced settings.


Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.