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

Type

Source

Platforms
Date Published

Mar 26, 2024

Price per 1M rows

Starting from $15

monthly 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 Group Criteria

The googleads_ad_group_criteria table shows data for Google Ads Ad Group Criteria.

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

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

Columns
NameType
ad_grouputf8
approval_statusutf8
bid_modifierfloat64
cpc_bid_microsint64
cpm_bid_microsint64
cpv_bid_microsint64
_cq_iduuid
_cq_parent_iduuid
criterion_idint64
customer_idint64
disapproval_reasonslist<item: utf8, nullable>
display_nameutf8
effective_cpc_bid_microsint64
effective_cpc_bid_sourceutf8
effective_cpm_bid_microsint64
effective_cpm_bid_sourceutf8
effective_cpv_bid_microsint64
effective_cpv_bid_sourceutf8
effective_percent_cpc_bid_microsint64
effective_percent_cpc_bid_sourceutf8
final_mobile_urlslist<item: utf8, nullable>
final_urlslist<item: utf8, nullable>
final_url_suffixutf8
idint64
labelslist<item: utf8, nullable>
negativebool
percent_cpc_bid_microsint64
position_estimatesjson
quality_infojson
resource_nameutf8
statusutf8
system_serving_statusutf8
tracking_url_templateutf8
typeutf8
url_custom_parametersjson
Relations

This table depends on:

Google Ads Ad Groups

The following tables depend on "Google Ads Ad Group Criteria":

Subscribe to product updates

Be the first to know about new features.