Connect Twitter Ads to Google BigQuery with Windsor.ai
+
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 Windsor.ai.
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 Windsor.ai.
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:
- 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 charts.windsor.ai
You should also read :
Stream any Data to Google BigQuery
Data Studio Twitter Ads Overview Report
See Windsor.ai in action
Twitter Ads metrics and dimensions available for streaming into Google BigQuery
| Name | Type | Description |
|---|---|---|
| Account ID | TEXT | Your Twitter ads account ID |
| Account Name | TEXT | Your Twitter ads account name |
| Ad Name | TEXT | The Ad 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. |
| objective | TEXT | objective description |
| Promoted Tweet ID | TEXT | Promoted Tweet ID |
| 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 |
| url_clicks | NUMERIC | Total clicks on the link or Website Card in an ad, including earned. |
| 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.