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.3

Type

Source

Platforms
Date Published

Mar 12, 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 Ad Groups

The googleads_ad_groups table shows data for Google Ads Ad Groups.

https://developers.google.com/google-ads/api/reference/rpc/v13/AdGroup

The composite primary key for this table is customer_id, id, resource_name.

Columns
NameType
ad_rotation_modeutf8
audience_settingjson
base_ad_grouputf8
campaignutf8
cpc_bid_microsint64
cpm_bid_microsint64
cpv_bid_microsint64
_cq_iduuid
_cq_parent_iduuid
customer_idint64
display_custom_bid_dimensionutf8
effective_cpc_bid_microsint64
effective_target_cpa_microsint64
effective_target_cpa_sourceutf8
effective_target_roasfloat64
effective_target_roas_sourceutf8
excluded_parent_asset_field_typeslist<item: int64, nullable>
excluded_parent_asset_set_typeslist<item: int64, nullable>
final_url_suffixutf8
idint64
labelslist<item: utf8, nullable>
nameutf8
optimized_targeting_enabledbool
percent_cpc_bid_microsint64
resource_nameutf8
statusutf8
target_cpa_microsint64
target_cpm_microsint64
target_roasfloat64
tracking_url_templateutf8
typeutf8
url_custom_parametersjson
Relations

The following tables depend on "Google Ads Ad Groups":

Subscribe to product updates

Be the first to know about new features.