Connect Twitter Ads to Google BigQuery with Windsor.ai

twitter

+

bigquery

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.

Twitter Ads metrics and dimensions available for streaming into Google BigQuery

NameTypeDescription
Twitter Ads Account IDTEXTYour Twitter ads account ID
Twitter Ads Account nameTEXTYour Twitter ads account 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.
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
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.

Windsor.ai: 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.

insights

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.