Back to plugin list
Official
Premium
Google Ads
The CloudQuery Google Ads plugin for CloudQuery pulls configuration from Google Ads API and loads it into any supported CloudQuery destination
Publisher
cloudquery
Latest version
v3.2.10
Type
Source
Platforms
Date Published
Price per 1M rows
Starting from $15
monthly free quota
1M rows
Google Ads Campaigns
The googleads_campaigns table shows data for Google Ads Campaigns.
https://developers.google.com/google-ads/api/reference/rpc/v13/Campaign
The composite primary key for this table is customer_id, id, resource_name.
Columns
| Name | Type |
|---|---|
| accessible_bidding_strategy | utf8 |
| ad_serving_optimization_status | utf8 |
| advertising_channel_sub_type | utf8 |
| advertising_channel_type | utf8 |
| app_campaign_setting | json |
| audience_setting | json |
| base_campaign | utf8 |
| bidding_strategy_system_status | utf8 |
| bidding_strategy_type | utf8 |
| campaign_budget | utf8 |
| campaign_group | utf8 |
| _cq_id | uuid |
| _cq_parent_id | uuid |
| customer_id | int64 |
| dynamic_search_ads_setting | json |
| end_date | utf8 |
| excluded_parent_asset_field_types | list<item: int64, nullable> |
| excluded_parent_asset_set_types | list<item: int64, nullable> |
| experiment_type | utf8 |
| final_url_suffix | utf8 |
| frequency_caps | json |
| geo_target_type_setting | json |
| hotel_property_asset_set | utf8 |
| hotel_setting | json |
| id | int64 |
| labels | list<item: utf8, nullable> |
| local_campaign_setting | json |
| local_services_campaign_settings | json |
| name | utf8 |
| network_settings | json |
| optimization_goal_setting | json |
| optimization_score | float64 |
| payment_mode | utf8 |
| performance_max_upgrade | json |
| primary_status | utf8 |
| primary_status_reasons | list<item: int64, nullable> |
| real_time_bidding_setting | json |
| resource_name | utf8 |
| selective_optimization | json |
| serving_status | utf8 |
| shopping_setting | json |
| start_date | utf8 |
| status | utf8 |
| tracking_setting | json |
| tracking_url_template | utf8 |
| travel_campaign_settings | json |
| url_custom_parameters | json |
| url_expansion_opt_out | bool |
| vanity_pharma | json |
| video_brand_safety_suitability | utf8 |
Relations
The following tables depend on "Google Ads Campaigns":