Connect Twitter Ads to Google BigQuery with




Stream all your media and ads data from from Twitter Ads to Google BigQuery

About Twitter Ads

Twitter is a microblogging and social media platform. Users connect and reach out with short messages, which Twitter calls Tweets. Business users use Twitter to capture and analyse data. Twitter Ads allows advertisers to advertise their products to targeted audiences on the Twitter platform.

About Google BigQuery

Google BigQuery is a cloud based data warehouse. It allows flexible scaling and is a commonly used Platform as a Service solution.

It is very simple to connect Pinterest Ads to Google Big Query, it can be done in a fast and easy manner with
In this article, we’ll explain how to get both platforms connected. The whole process should not take more than 5 minutes.

First step:

You need to select Twitter ads as a Data Source and Grant twitter Access to

Second Step:

you will need to go to Select  Destination to choose where do you want to send your data.

Third Step:

In this case Select Google BigQuery As A Data Destination

Fifth Step:

  1. As a connector URL, you can use any URL providing a JSON. Either from the connectors or for example a URL with cached and transformed data from

You should also read :

Stream any Data to Google BigQuery

Data Studio Twitter Ads Overview Report

See in action

Start Free trial

Twitter Ads metrics and dimensions available for streaming into Google BigQuery

Account IDTEXTYour Twitter ads account ID
Account NameTEXTYour Twitter ads account name
Ad NameTEXTThe Ad Name
Ad GroupTEXTThe Ad Group Name
App ClicksNUMERICTotal number of app install or app open attempts
CampaignTEXTThe Campaign Name
Card EngagementsNUMERICTotal number of card engagements
ClicksNUMERICTotal number of clicks, including favorites and other engagements
DateDATEThe Date
EngagementsNUMERICTotal number of engagements
FollowsNUMERICTotal number of follows
ImpressionsNUMERICTotal number of impressions
LikesNUMERICTotal number of likes
Media EngagementsNUMERICTotal number of clicks of media across Videos, Vines, GIFs, and Images.
Media ViewsNUMERICTotal number of views (autoplay and click) of media across Videos, Vines, GIFs, and Images.
objectiveTEXTobjective description
Promoted Tweet IDTEXTPromoted Tweet ID
Qualified ImpressionsNUMERICTotal number of qualified impressions
RepliesNUMERICTotal number of replies
RetweetsNUMERICTotal number of retweets
SpendNUMERICThe total media spend (Duplicate)
SpendNUMERICThe total media spend
Twitter HandleTEXTYour Twitter handle linked to your Ad account
url_clicksNUMERICTotal clicks on the link or Website Card in an ad, including earned.
Video 15s viewsNUMERICTotal number of views where at least 15 seconds of the video or for 95% of the total duration was viewed
Video 3s100pct viewsNUMERICTotal number of views where at least 3 seconds were played while 100% in view (legacy video_total_views)
Video 6s viewsNUMERICTotal number of views where at least 6 seconds of the video was viewed
Video content startsNUMERICTotal number of video playback starts
Video cta clicksNUMERICTotal clicks on the call to action
Video total viewsNUMERICTotal number of video views
Video views 100NUMERICTotal number of views where at least 100% of the video was viewed.
Video views 25NUMERICTotal number of views where at least 25% of the video was viewed.
Video views 50NUMERICTotal number of views where at least 50% of the video was viewed.
Video views 75NUMERICTotal number of views where at least 75% of the video was viewed. Easily connect Twitter Ads to Google BigQuery

See the value and return on every marketing touchpoint

data warehouse

Providing 50+ marketing data streams, we make sure that all the data we integrate is fresh and accessible by marketeers, whenever they want.


Spend less time on manual data loading and spreadsheets. Focus on delighting your customers.

Start a free trial today.

Integrate all your data and measure what matters.