How to Get X (Twitter) Ads Data in Looker Studio

Twitter ads are primarily used to engage a broad audience with real-time conversations and trending topics. By leveraging Twitter’s dynamic platform, businesses can reach users actively by discussing news, events, and various interests. Posting ads on Twitter can drive significant user engagement, especially for campaigns focused on brand awareness, product launches, and timely promotions. With its extensive reach and active user base, Twitter offers a powerful tool for businesses to capture the attention of potential customers and followers.

Looker Studio is a great tool for generating reports on raw data for better insights. With Two Minute Reports (TMR) for Looker Studio, you can get your ad insights in just minutes–without any coding. Simply select the metrics data you want to view and the raw data will appear without delay.

Select X (Twitter) Ads in the TMR Portal

The first thing to do is to go through our portal and select the data source you want to add.

  • Choose Two Minute Reports for Looker Studio (the blue one).
  • Select your team. If you only have one team, you can skip this and TMR will automatically redirect you to the connectors page.

You will now see the connectors page.

  • In the connectors page, find and select X (Twitter) Ads.

Authorize Your X (Twitter) Account

The next series of steps is to configure your X (Twitter) account with TMR.

Info: The example below is for X (Twitter) Ads. Two Minute Reports also allows you to connect with other data sources.

Login to Your X (Twitter) Account

In this section, you need to log in to your X (Twitter) account for authentication making sure it connects with TMR and Looker Studio.

  • Under Data Sources, click + Add New button.
  • Name your data source
  • Click the Sign in with X (Twitter).
  • Go through the entire authentication in X (Twitter). If successful, Two Minute Reports gives a prompt “Signed in! You may close this tab now.

Configuring Your X (Twitter) Account with TMR

Info: Query configuration is a setting in Two Minute Reports. It’s where you will choose which account to get data from and other configurations from that data source.

  • In the Query Configs section, click the + Add New button. Choose the data source you added earlier. Click Next.

The next step is where you configure your X (Twitter) settings to TMR so that you can create reports in Looker Studio. You may configure the following parameters depending on your preference as TMR has imported them.

  • Name your query config.
  • Select your X (Twitter) Ad Account.
  • The Data Options section is provided if you want to include missing time values or replace blank metrics with zeros. This means empty metrics are still being reported as zero values.
  • Click Save.

Once everything is finished, click the green Create Report button on the right. The next section is creating reports in Looker Studio.

Was this helpful?