Back to plugin list
googleads
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.1

Type

Source

Platforms
Date Published

Feb 20, 2024

Price per 1M rows

$100

free quota

1M rows

  • googleads_ad_groups
    • googleads_ad_group_criteria
      • googleads_ad_group_criterion_labels
    • googleads_ad_group_ads
      • googleads_ad_group_ad_labels
    • googleads_ad_group_labels
  • googleads_campaigns
    • googleads_campaign_criteria
    • googleads_campaign_labels
  • googleads_customers
    • googleads_customer_labels

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
NameType
accessible_bidding_strategyutf8
ad_serving_optimization_statusutf8
advertising_channel_sub_typeutf8
advertising_channel_typeutf8
app_campaign_settingjson
audience_settingjson
base_campaignutf8
bidding_strategy_system_statusutf8
bidding_strategy_typeutf8
campaign_budgetutf8
campaign_grouputf8
_cq_iduuid
_cq_parent_iduuid
customer_idint64
dynamic_search_ads_settingjson
end_dateutf8
excluded_parent_asset_field_typeslist<item: int64, nullable>
excluded_parent_asset_set_typeslist<item: int64, nullable>
experiment_typeutf8
final_url_suffixutf8
frequency_capsjson
geo_target_type_settingjson
hotel_property_asset_setutf8
hotel_settingjson
idint64
labelslist<item: utf8, nullable>
local_campaign_settingjson
local_services_campaign_settingsjson
nameutf8
network_settingsjson
optimization_goal_settingjson
optimization_scorefloat64
payment_modeutf8
performance_max_upgradejson
primary_statusutf8
primary_status_reasonslist<item: int64, nullable>
real_time_bidding_settingjson
resource_nameutf8
selective_optimizationjson
serving_statusutf8
shopping_settingjson
start_dateutf8
statusutf8
tracking_settingjson
tracking_url_templateutf8
travel_campaign_settingsjson
url_custom_parametersjson
url_expansion_opt_outbool
vanity_pharmajson
video_brand_safety_suitabilityutf8
Relations

The following tables depend on "Google Ads Campaigns":

Subscribe to product updates

Be the first to know about new features.