Connect Twitter Ads to Google BigQuery with Windsor.ai

twitter ads Field Reference logo

+

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.

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:

  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 charts.windsor.ai

You should also read :

Stream any Data to Google BigQuery

google data studio twitter

See Windsor.ai in action

Start Free trial

Twitter Ads metrics and dimensions available for streaming into Google BigQuery

NameTypeDescription
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
conversion_customNUMERICNumber of web conversions of type CUSTOM.
conversion_custom_metricNUMERICBreakdown of web conversions of type CUSTOM by metric.
conversion_custom_order_quantityNUMERICBreakdown of web conversions of type CUSTOM by order_quantity.
conversion_custom_order_quantity_engagementNUMERICBreakdown of web conversions of type CUSTOM by order_quantity_engagement.
conversion_custom_order_quantity_viewNUMERICBreakdown of web conversions of type CUSTOM by order_quantity_view.
conversion_custom_post_engagementNUMERICBreakdown of web conversions of type CUSTOM by post_engagement.
conversion_custom_post_viewNUMERICBreakdown of web conversions of type CUSTOM by post_view.
conversion_custom_sale_amountNUMERICBreakdown of web conversions of type CUSTOM by sale_amount.
conversion_custom_sale_amount_engagementNUMERICBreakdown of web conversions of type CUSTOM by sale_amount_engagement.
conversion_custom_sale_amount_viewNUMERICBreakdown of web conversions of type CUSTOM by sale_amount_view.
conversion_downloadsNUMERICNumber of web conversions of type DOWNLOAD.
conversion_downloads_metricNUMERICBreakdown of web conversions of type DOWNLOAD by metric.
conversion_downloads_order_quantityNUMERICBreakdown of web conversions of type DOWNLOAD by order_quantity.
conversion_downloads_order_quantity_engagementNUMERICBreakdown of web conversions of type DOWNLOAD by order_quantity_engagement.
conversion_downloads_order_quantity_viewNUMERICBreakdown of web conversions of type DOWNLOAD by order_quantity_view.
conversion_downloads_post_engagementNUMERICBreakdown of web conversions of type DOWNLOAD by post_engagement.
conversion_downloads_post_viewNUMERICBreakdown of web conversions of type DOWNLOAD by post_view.
conversion_downloads_sale_amountNUMERICBreakdown of web conversions of type DOWNLOAD by sale_amount.
conversion_downloads_sale_amount_engagementNUMERICBreakdown of web conversions of type DOWNLOAD by sale_amount_engagement.
conversion_downloads_sale_amount_viewNUMERICBreakdown of web conversions of type DOWNLOAD by sale_amount_view.
conversion_purchasesNUMERICNumber of web conversions of type PURCHASE.
conversion_purchases_assistedNUMERICBreakdown of web conversions of type PURCHASE by assisted.
conversion_purchases_metricNUMERICBreakdown of web conversions of type PURCHASE by metric.
conversion_purchases_order_quantityNUMERICBreakdown of web conversions of type PURCHASE by order_quantity.
conversion_purchases_order_quantity_engagementNUMERICBreakdown of web conversions of type PURCHASE by order_quantity_engagement.
conversion_purchases_order_quantity_viewNUMERICBreakdown of web conversions of type PURCHASE by order_quantity_view.
conversion_purchases_post_engagementNUMERICBreakdown of web conversions of type PURCHASE by post_engagement.
conversion_purchases_post_viewNUMERICBreakdown of web conversions of type PURCHASE by post_view.
conversion_purchases_sale_amountNUMERICBreakdown of web conversions of type PURCHASE by sale_amount.
conversion_purchases_sale_amount_engagementNUMERICBreakdown of web conversions of type PURCHASE by sale_amount_engagement.
conversion_purchases_sale_amount_viewNUMERICBreakdown of web conversions of type PURCHASE by sale_amount_view.
conversion_sign_upsNUMERICNumber of web conversions of type SIGN_UP.
conversion_sign_ups_metricNUMERICBreakdown of web conversions of type SIGN_UP by metric.
conversion_sign_ups_order_quantityNUMERICBreakdown of web conversions of type SIGN_UP by order_quantity.
conversion_sign_ups_order_quantity_engagementNUMERICBreakdown of web conversions of type SIGN_UP by order_quantity_engagement.
conversion_sign_ups_order_quantity_viewNUMERICBreakdown of web conversions of type SIGN_UP by order_quantity_view.
conversion_sign_ups_post_engagementNUMERICBreakdown of web conversions of type SIGN_UP by post_engagement.
conversion_sign_ups_post_viewNUMERICBreakdown of web conversions of type SIGN_UP by post_view.
conversion_sign_ups_sale_amountNUMERICBreakdown of web conversions of type SIGN_UP by sale_amount.
conversion_sign_ups_sale_amount_engagementNUMERICBreakdown of web conversions of type SIGN_UP by sale_amount_engagement.
conversion_sign_ups_sale_amount_viewNUMERICBreakdown of web conversions of type SIGN_UP by sale_amount_view.
conversion_site_visitsNUMERICNumber of web conversions of type SITE_VISIT.
conversion_site_visits_metricNUMERICBreakdown of web conversions of type SITE_VISIT by metric.
conversion_site_visits_order_quantityNUMERICBreakdown of web conversions of type SITE_VISIT by order_quantity.
conversion_site_visits_order_quantity_engagementNUMERICBreakdown of web conversions of type SITE_VISIT by order_quantity_engagement.
conversion_site_visits_order_quantity_viewNUMERICBreakdown of web conversions of type SITE_VISIT by order_quantity_view.
conversion_site_visits_post_engagementNUMERICBreakdown of web conversions of type SITE_VISIT by post_engagement.
conversion_site_visits_post_viewNUMERICBreakdown of web conversions of type SITE_VISIT by post_view.
conversion_site_visits_sale_amountNUMERICBreakdown of web conversions of type SITE_VISIT by sale_amount.
conversion_site_visits_sale_amount_engagementNUMERICBreakdown of web conversions of type SITE_VISIT by sale_amount_engagement.
conversion_site_visits_sale_amount_viewNUMERICBreakdown of web conversions of type SITE_VISIT by sale_amount_view.
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.
mobile_conversion_achievements_unlocked_assistedNUMERICBreakdown of mobile conversions of type ACHIEVEMENT_UNLOCKED by assisted.
mobile_conversion_achievements_unlocked_order_quantityNUMERICBreakdown of mobile conversions of type ACHIEVEMENT_UNLOCKED by order_quantity.
mobile_conversion_achievements_unlocked_post_engagementNUMERICBreakdown of mobile conversions of type ACHIEVEMENT_UNLOCKED by post_engagement.
mobile_conversion_achievements_unlocked_post_viewNUMERICBreakdown of mobile conversions of type ACHIEVEMENT_UNLOCKED by post_view.
mobile_conversion_achievements_unlocked_sale_amountNUMERICBreakdown of mobile conversions of type ACHIEVEMENT_UNLOCKED by sale_amount.
mobile_conversion_add_to_carts_assistedNUMERICBreakdown of mobile conversions of type ADD_TO_CART by assisted.
mobile_conversion_add_to_carts_order_quantityNUMERICBreakdown of mobile conversions of type ADD_TO_CART by order_quantity.
mobile_conversion_add_to_carts_post_engagementNUMERICBreakdown of mobile conversions of type ADD_TO_CART by post_engagement.
mobile_conversion_add_to_carts_post_viewNUMERICBreakdown of mobile conversions of type ADD_TO_CART by post_view.
mobile_conversion_add_to_carts_sale_amountNUMERICBreakdown of mobile conversions of type ADD_TO_CART by sale_amount.
mobile_conversion_add_to_wishlists_assistedNUMERICBreakdown of mobile conversions of type ADD_TO_WISHLIST by assisted.
mobile_conversion_add_to_wishlists_order_quantityNUMERICBreakdown of mobile conversions of type ADD_TO_WISHLIST by order_quantity.
mobile_conversion_add_to_wishlists_post_engagementNUMERICBreakdown of mobile conversions of type ADD_TO_WISHLIST by post_engagement.
mobile_conversion_add_to_wishlists_post_viewNUMERICBreakdown of mobile conversions of type ADD_TO_WISHLIST by post_view.
mobile_conversion_add_to_wishlists_sale_amountNUMERICBreakdown of mobile conversions of type ADD_TO_WISHLIST by sale_amount.
mobile_conversion_checkouts_initiated_assistedNUMERICBreakdown of mobile conversions of type CHECKOUT_INITIATED by assisted.
mobile_conversion_checkouts_initiated_order_quantityNUMERICBreakdown of mobile conversions of type CHECKOUT_INITIATED by order_quantity.
mobile_conversion_checkouts_initiated_post_engagementNUMERICBreakdown of mobile conversions of type CHECKOUT_INITIATED by post_engagement.
mobile_conversion_checkouts_initiated_post_viewNUMERICBreakdown of mobile conversions of type CHECKOUT_INITIATED by post_view.
mobile_conversion_checkouts_initiated_sale_amountNUMERICBreakdown of mobile conversions of type CHECKOUT_INITIATED by sale_amount.
mobile_conversion_content_views_assistedNUMERICBreakdown of mobile conversions of type CONTENT_VIEW by assisted.
mobile_conversion_content_views_order_quantityNUMERICBreakdown of mobile conversions of type CONTENT_VIEW by order_quantity.
mobile_conversion_content_views_post_engagementNUMERICBreakdown of mobile conversions of type CONTENT_VIEW by post_engagement.
mobile_conversion_content_views_post_viewNUMERICBreakdown of mobile conversions of type CONTENT_VIEW by post_view.
mobile_conversion_content_views_sale_amountNUMERICBreakdown of mobile conversions of type CONTENT_VIEW by sale_amount.
mobile_conversion_downloads_order_quantityNUMERICBreakdown of mobile conversions of type DOWNLOAD by order_quantity.
mobile_conversion_downloads_post_engagementNUMERICBreakdown of mobile conversions of type DOWNLOAD by post_engagement.
mobile_conversion_downloads_post_viewNUMERICBreakdown of mobile conversions of type DOWNLOAD by post_view.
mobile_conversion_downloads_sale_amountNUMERICBreakdown of mobile conversions of type DOWNLOAD by sale_amount.
mobile_conversion_installs_assistedNUMERICBreakdown of mobile conversions of type INSTALL by assisted.
mobile_conversion_installs_order_quantityNUMERICBreakdown of mobile conversions of type INSTALL by order_quantity.
mobile_conversion_installs_post_engagementNUMERICBreakdown of mobile conversions of type INSTALL by post_engagement.
mobile_conversion_installs_post_viewNUMERICBreakdown of mobile conversions of type INSTALL by post_view.
mobile_conversion_installs_sale_amountNUMERICBreakdown of mobile conversions of type INSTALL by sale_amount.
mobile_conversion_installs_skan_post_engagementNUMERICBreakdown of mobile conversions of type INSTALL (skan) by post_engagement.
mobile_conversion_installs_skan_post_viewNUMERICBreakdown of mobile conversions of type INSTALL (skan) by post_view.
mobile_conversion_invites_assistedNUMERICBreakdown of mobile conversions of type INVITE by assisted.
mobile_conversion_invites_order_quantityNUMERICBreakdown of mobile conversions of type INVITE by order_quantity.
mobile_conversion_invites_post_engagementNUMERICBreakdown of mobile conversions of type INVITE by post_engagement.
mobile_conversion_invites_post_viewNUMERICBreakdown of mobile conversions of type INVITE by post_view.
mobile_conversion_invites_sale_amountNUMERICBreakdown of mobile conversions of type INVITE by sale_amount.
mobile_conversion_key_page_views_post_engagementNUMERICBreakdown of mobile conversions of type KEY_PAGE_VIEW by post_engagement.
mobile_conversion_key_page_views_post_viewNUMERICBreakdown of mobile conversions of type KEY_PAGE_VIEW by post_view.
mobile_conversion_levels_achieved_assistedNUMERICBreakdown of mobile conversions of type LEVEL_ACHIEVED by assisted.
mobile_conversion_levels_achieved_order_quantityNUMERICBreakdown of mobile conversions of type LEVEL_ACHIEVED by order_quantity.
mobile_conversion_levels_achieved_post_engagementNUMERICBreakdown of mobile conversions of type LEVEL_ACHIEVED by post_engagement.
mobile_conversion_levels_achieved_post_viewNUMERICBreakdown of mobile conversions of type LEVEL_ACHIEVED by post_view.
mobile_conversion_levels_achieved_sale_amountNUMERICBreakdown of mobile conversions of type LEVEL_ACHIEVED by sale_amount.
mobile_conversion_logins_assistedNUMERICBreakdown of mobile conversions of type LOGIN by assisted.
mobile_conversion_logins_order_quantityNUMERICBreakdown of mobile conversions of type LOGIN by order_quantity.
mobile_conversion_logins_post_engagementNUMERICBreakdown of mobile conversions of type LOGIN by post_engagement.
mobile_conversion_logins_post_viewNUMERICBreakdown of mobile conversions of type LOGIN by post_view.
mobile_conversion_logins_sale_amountNUMERICBreakdown of mobile conversions of type LOGIN by sale_amount.
mobile_conversion_payment_info_additions_assistedNUMERICBreakdown of mobile conversions of type PAYMENT_INFO_ADDITION by assisted.
mobile_conversion_payment_info_additions_order_quantityNUMERICBreakdown of mobile conversions of type PAYMENT_INFO_ADDITION by order_quantity.
mobile_conversion_payment_info_additions_post_engagementNUMERICBreakdown of mobile conversions of type PAYMENT_INFO_ADDITION by post_engagement.
mobile_conversion_payment_info_additions_post_viewNUMERICBreakdown of mobile conversions of type PAYMENT_INFO_ADDITION by post_view.
mobile_conversion_payment_info_additions_sale_amountNUMERICBreakdown of mobile conversions of type PAYMENT_INFO_ADDITION by sale_amount.
mobile_conversion_purchases_assistedNUMERICBreakdown of mobile conversions of type PURCHASE by assisted.
mobile_conversion_purchases_order_quantityNUMERICBreakdown of mobile conversions of type PURCHASE by order_quantity.
mobile_conversion_purchases_post_engagementNUMERICBreakdown of mobile conversions of type PURCHASE by post_engagement.
mobile_conversion_purchases_post_viewNUMERICBreakdown of mobile conversions of type PURCHASE by post_view.
mobile_conversion_purchases_sale_amountNUMERICBreakdown of mobile conversions of type PURCHASE by sale_amount.
mobile_conversion_purchases_skan_post_engagementNUMERICBreakdown of mobile conversions of type PURCHASE by post_engagement.
mobile_conversion_purchases_skan_post_viewNUMERICBreakdown of mobile conversions of type PURCHASE by post_view.
mobile_conversion_rates_assistedNUMERICBreakdown of mobile conversions of type RATE by assisted.
mobile_conversion_rates_order_quantityNUMERICBreakdown of mobile conversions of type RATE by order_quantity.
mobile_conversion_rates_post_engagementNUMERICBreakdown of mobile conversions of type RATE by post_engagement.
mobile_conversion_rates_post_viewNUMERICBreakdown of mobile conversions of type RATE by post_view.
mobile_conversion_rates_sale_amountNUMERICBreakdown of mobile conversions of type RATE by sale_amount.
mobile_conversion_re_engages_assistedNUMERICBreakdown of mobile conversions of type RE_ENGAGE by assisted.
mobile_conversion_re_engages_order_quantityNUMERICBreakdown of mobile conversions of type RE_ENGAGE by order_quantity.
mobile_conversion_re_engages_post_engagementNUMERICBreakdown of mobile conversions of type RE_ENGAGE by post_engagement.
mobile_conversion_re_engages_post_viewNUMERICBreakdown of mobile conversions of type RE_ENGAGE by post_view.
mobile_conversion_re_engages_sale_amountNUMERICBreakdown of mobile conversions of type RE_ENGAGE by sale_amount.
mobile_conversion_reservations_assistedNUMERICBreakdown of mobile conversions of type RESERVATION by assisted.
mobile_conversion_reservations_order_quantityNUMERICBreakdown of mobile conversions of type RESERVATION by order_quantity.
mobile_conversion_reservations_post_engagementNUMERICBreakdown of mobile conversions of type RESERVATION by post_engagement.
mobile_conversion_reservations_post_viewNUMERICBreakdown of mobile conversions of type RESERVATION by post_view.
mobile_conversion_reservations_sale_amountNUMERICBreakdown of mobile conversions of type RESERVATION by sale_amount.
mobile_conversion_searches_assistedNUMERICBreakdown of mobile conversions of type SEARCH by assisted.
mobile_conversion_searches_order_quantityNUMERICBreakdown of mobile conversions of type SEARCH by order_quantity.
mobile_conversion_searches_post_engagementNUMERICBreakdown of mobile conversions of type SEARCH by post_engagement.
mobile_conversion_searches_post_viewNUMERICBreakdown of mobile conversions of type SEARCH by post_view.
mobile_conversion_searches_sale_amountNUMERICBreakdown of mobile conversions of type SEARCH by sale_amount.
mobile_conversion_shares_assistedNUMERICBreakdown of mobile conversions of type SHARE by assisted.
mobile_conversion_shares_order_quantityNUMERICBreakdown of mobile conversions of type SHARE by order_quantity.
mobile_conversion_shares_post_engagementNUMERICBreakdown of mobile conversions of type SHARE by post_engagement.
mobile_conversion_shares_post_viewNUMERICBreakdown of mobile conversions of type SHARE by post_view.
mobile_conversion_shares_sale_amountNUMERICBreakdown of mobile conversions of type SHARE by sale_amount.
mobile_conversion_sign_ups_assistedNUMERICBreakdown of mobile conversions of type SIGN_UP by assisted.
mobile_conversion_sign_ups_order_quantityNUMERICBreakdown of mobile conversions of type SIGN_UP by order_quantity.
mobile_conversion_sign_ups_post_engagementNUMERICBreakdown of mobile conversions of type SIGN_UP by post_engagement.
mobile_conversion_sign_ups_post_viewNUMERICBreakdown of mobile conversions of type SIGN_UP by post_view.
mobile_conversion_sign_ups_sale_amountNUMERICBreakdown of mobile conversions of type SIGN_UP by sale_amount.
mobile_conversion_site_visits_order_quantityNUMERICBreakdown of mobile conversions of type SITE_VISIT by order_quantity.
mobile_conversion_site_visits_post_engagementNUMERICBreakdown of mobile conversions of type SITE_VISIT by post_engagement.
mobile_conversion_site_visits_post_viewNUMERICBreakdown of mobile conversions of type SITE_VISIT by post_view.
mobile_conversion_site_visits_sale_amountNUMERICBreakdown of mobile conversions of type SITE_VISIT by sale_amount.
mobile_conversion_spent_credits_assistedNUMERICBreakdown of mobile conversions of type SPENT_CREDIT by assisted.
mobile_conversion_spent_credits_order_quantityNUMERICBreakdown of mobile conversions of type SPENT_CREDIT by order_quantity.
mobile_conversion_spent_credits_post_engagementNUMERICBreakdown of mobile conversions of type SPENT_CREDIT by post_engagement.
mobile_conversion_spent_credits_post_viewNUMERICBreakdown of mobile conversions of type SPENT_CREDIT by post_view.
mobile_conversion_spent_credits_sale_amountNUMERICBreakdown of mobile conversions of type SPENT_CREDIT by sale_amount.
mobile_conversion_tutorials_completed_assistedNUMERICBreakdown of mobile conversions of type TUTORIAL_COMPLETED by assisted.
mobile_conversion_tutorials_completed_order_quantityNUMERICBreakdown of mobile conversions of type TUTORIAL_COMPLETED by order_quantity.
mobile_conversion_tutorials_completed_post_engagementNUMERICBreakdown of mobile conversions of type TUTORIAL_COMPLETED by post_engagement.
mobile_conversion_tutorials_completed_post_viewNUMERICBreakdown of mobile conversions of type TUTORIAL_COMPLETED by post_view.
mobile_conversion_tutorials_completed_sale_amountNUMERICBreakdown of mobile conversions of type TUTORIAL_COMPLETED by sale_amount.
mobile_conversion_updates_assistedNUMERICBreakdown of mobile conversions of type UPDATE by assisted.
mobile_conversion_updates_order_quantityNUMERICBreakdown of mobile conversions of type UPDATE by order_quantity.
mobile_conversion_updates_post_engagementNUMERICBreakdown of mobile conversions of type UPDATE by post_engagement.
mobile_conversion_updates_post_viewNUMERICBreakdown of mobile conversions of type UPDATE by post_view.
mobile_conversion_updates_sale_amountNUMERICBreakdown of mobile conversions of type UPDATE by sale_amount.
objectiveTEXTobjective description
TEXTPromoted 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.

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.