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.
Connect Twitter Ads to Google BigQuery with Windsor.ai
+
Stream all your media and ads data from from Twitter Ads to Google BigQuery
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
| Name | Type | Description |
|---|---|---|
| Twitter Ads Account ID | TEXT | Your Twitter ads account ID |
| Twitter Ads Account name | TEXT | Your Twitter ads account name |
| Ad Group | TEXT | The Ad Group Name |
| App Clicks | NUMERIC | Total number of app install or app open attempts |
| Campaign | TEXT | The Campaign Name |
| Card Engagements | NUMERIC | Total number of card engagements |
| Clicks | NUMERIC | Total number of clicks, including favorites and other engagements |
| Date | DATE | The Date |
| Engagements | NUMERIC | Total number of engagements |
| Follows | NUMERIC | Total number of follows |
| Impressions | NUMERIC | Total number of impressions |
| Likes | NUMERIC | Total number of likes |
| Media Engagements | NUMERIC | Total number of clicks of media across Videos, Vines, GIFs, and Images. |
| Media Views | NUMERIC | Total number of views (autoplay and click) of media across Videos, Vines, GIFs, and Images. |
| Qualified Impressions | NUMERIC | Total number of qualified impressions |
| Replies | NUMERIC | Total number of replies |
| Retweets | NUMERIC | Total number of retweets |
| Spend | NUMERIC | The total media spend (Duplicate) |
| Spend | NUMERIC | The total media spend |
| Twitter Handle | TEXT | Your Twitter handle linked to your Ad account |
| Video 15s views | NUMERIC | Total number of views where at least 15 seconds of the video or for 95% of the total duration was viewed |
| Video 3s100pct views | NUMERIC | Total number of views where at least 3 seconds were played while 100% in view (legacy video_total_views) |
| Video 6s views | NUMERIC | Total number of views where at least 6 seconds of the video was viewed |
| Video content starts | NUMERIC | Total number of video playback starts |
| Video cta clicks | NUMERIC | Total clicks on the call to action |
| Video total views | NUMERIC | Total number of video views |
| Video views 100 | NUMERIC | Total number of views where at least 100% of the video was viewed. |
| Video views 25 | NUMERIC | Total number of views where at least 25% of the video was viewed. |
| Video views 50 | NUMERIC | Total number of views where at least 50% of the video was viewed. |
| Video views 75 | NUMERIC | Total 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
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.