This guide covers the basic functionality of the Supermetrics Twitter Public Data connector for Sheets and Data Studio, and gives examples of how to set up a query in two popular products.
Quick links to sections below:
- Query Types
- Example Query Setup with Google Sheets
- Example Query Setup with Data Studio
- Common Issues
The Twitter Public Data connector allows you to collect publicly available data about users and tweets, though the data and fields available are much more limited in this public API version than the full Twitter Analytics. It uses a query selection system for the type of data you would like to collect, which limits which metrics can be used, but prevents user errors from combining invalid field combinations.
The Twitter Public Data connector supports 3 type of queries:
- Twitter tweets by keyword - allows you to pull the latest X tweets that contain certain keywords
- Twitter user data - gathers data about specific user names, such as Followers count, Tweet count, location of user, etc.
- Twitter user tweets - gathers data about specific tweets the user made, as well as retweet and reply data.
Query type selection in Google Sheets:
Query type selection in Data Studio:
Example Query Setup in Google Sheets
Here is a walk-through for setting up a 'Twitter user tweets' query using the Google Sheets Add-on. (The example for Data Studio is below this section.)
- With an empty cell selected, launch the sidebar in Google Sheets.
- In the Data Source section, scroll down to the Simple Connectors part of the list and then select the connector "Twitter Public Data (beta)"
- It will direct you to log into a Twitter account. Note that any valid account will work, it's not pulling data from any specific account. Click Sign In to continue.
- When the login process is complete, it will redirect you back to the sidebar. Click on Report configuration to continue the setup.
- In the Select query type drop-down, select "Twitter user tweets".
- In the Twitter usernames: box, add the username you wish to search for. You can add expand the box and add more than one name, one each on a new line.
- The Translate to: option lets you get translations of the tweets. This is optional and defaults to "No Translation".
- In the # of rows per item: drop-down, select "10". This will pull the most recent 10 tweets for each user name you added. For better performance, avoid higher row values.
- In the Include retweets: and Include replies: drop-downs, select "no" to omit data for these.
- Open the Select metrics section and click on the box to see what metrics as available. Based on the query type selected, different metrics may be shown. Note that as this is a simple connector, it's field options are more limited.
- Open the Split by section and click on the box in the Split by rows to see what dimensions as available.
- You can also apply filters to some fields under Filter, or set "no headers" in the advanced settings under the Options. These are optional though, and not required to make the query work.
- At the top of the sidebar, click Get Data to Table to run the query and see the results. In this example, this is the most recent 10 tweets made by Supermetrics and their lifetime like count.
If further adjustments need to be made, click Modify. Note that due to the nature of the "Query type" system, you cannot combine Tweet data with the user data in a single query. If you get errors, see the Common Issues section in this article at the bottom.
Example Query Setup in Data Studio
Here is a walk-through for setting up a 'Twitter user tweets' query using the Data Studio connector.
- In Data Studio, add a new data source and search for "Twitter Public Data" in the Partner Connectors section. Click SELECT to add it.
- Click AUTHORIZE to start the authorization process for Data Studio. In the resulting pop-up, click your Google account you are using for Data Studio access. Click Allow to continue (else the connector won't function).
- Click AUTHORIZE for Twitter Public Data and follow the prompts to log into a Twitter account. Note that any valid Twitter account will work, this is not pulling data from a specific account.
- Once the login is complete, the configuration page will show the rest of the settings for the data source.
- In the Query type drop-down, select "Twitter user tweets".
- Go down to the ***************** SETTINGS FOR QUERY TYPE: Twitter user tweets ***************** section.
- In the Twitter usernames box, add one or more user names, comma separated.
- In the Include retweets drop-down, select "no". This will only pull tweets made by the user directly.
- In the Include replies drop-down, select "no". This will not pull replies data into the query.
- The Translate to drop-down can be set to another language to translate the tweet text. This is optional and defaults to "No translation".
- If you want to be allowed to change the above settings in Data Studio's UI directly, you can check one or more of the "Allow X to be modified in reports" boxes next to the setting. This is optional.
- You do not need to fill out any other query section as it will not be used. Note that you can only set one query type at a time with this connector. If you need other query types, repeat this process to create a new data source with the different query type selected.
- Give the Data Source a meaningful name.
- Click CONNECT in the upper right-hand corner to create the data source.
- It will take you to a page with all the connector's fields that are available for the "Twitter user tweets" query type. Click ADD TO REPORT to continue.
- Create a report element on the report page, selecting your new source as the Data Source. Add the metrics and dimensions available to create your query. In this example, a table is used to show the last ~2000 posts made to the Supermetrics page.
- If you need to modify the query, you can do so from the Data bar in the Data Studio UI and it will update automatically to reflect your changes.
"No account objects selected" Errors
More often affects Data Studio. Check that you filled out the proper query section and that there's a valid username name given.
Query Runs Very Slowly
The API being used is not that efficient, so the more accounts you try pull or the more rows, the slower it gets. Try reducing the number of accounts you are trying to get data for to increase performance. If using Sheets, try reducing the # of Rows per item value to under 200.
No Data over Time is Available/I Can't Report Over Time?
Sadly, this version of the API only shows lifetime totals for most metrics and you won't be able to report changes over time unless you use the "Combine new with old" feature in Sheets and run this every day to collect your own historical data (this feature is not available at all in Data Studio).
No Data for User
Make sure you are using the Twitter user name given in the URL to their Twitter page. This will ensure you are getting data from the correct account.
The Metrics I Wanted Are Not Listed/How Do I Get Twitter Analytics Engagement Data?
Unfortunately the Basic API does not offer these. We are working with Twitter to try to get access to the Enterprise API that has this data, but discussions are ongoing and we cannot provide a timeline for when this better connector will be available.