Google ads
Prerequisites
Setting up the Google ads connector
Basic Setup
Create a new data source
Select Google Ads
Fill in the Name and Short name
Click on “Sign in with google” from the credentials dropdown and Authenticate your account.
In another window, navigate to Google ads manager https://ads.google.com/ and sign in with your account.
Select the ad account (no) you want to use as source.
In the top right corner, you will be able to see the ad account number. Copy it without hyphens and use it in
customer_idfield.
Enter the start date in the format
2017-01-25(UTC).Click on Test connection and add the data source
Add the new data source
info
It might take a couple of minutes to provision a new data source. Once the data source is added you will be able to query it using plain SQL
At this point, you will be able to browse the data structure of the newly added data source. Once the data source is successfully added, and you have verified it in the data browser -- you can use 3rd party tools like DBeaver to connect to the newly created data source. Refer to Using DBeaver
Detailed configuration Information
| No | Item | Required | Example | Notes |
|---|---|---|---|---|
| 1 | Google Credentials | Yes | ||
| 2 | Customer ID(s) | Yes | 6783948572,5839201945 | Comma separated list of (client) customer IDs. Each customer ID must be specified as a 10-digit number without dashes. More instruction on how to find this value in our docs. Metrics streams like AdGroupAdReport cannot be requested for a manager account. |
| 3 | Start Date | Yes | 2017-01-25 | UTC date and time in the format 2017-01-25. Any data before this date will not be replicated. |
| 4 | Custom GAQL Queries | No | ||
| 5 | Login Customer ID for Managed Accounts | No | 7349206847 | If your access to the customer account is through a manager account, this field is required and must be set to the customer ID of the manager account (10-digit number without dashes). More information about this field you can see here |
| 6 | Conversion Window | No | 14 | A conversion window is the period of time after an ad interaction (such as an ad click or video view) during which a conversion, such as a purchase, is recorded in Google Ads. For more information, see Google's documentation. |
| 7 | End Date | No | 2017-01-30 | UTC date and time in the format 2017-01-25. Any data after this date will not be replicated. |
Tables in the Google ads connector
| No | Table Name | Columns | Primary Keys | Read Mode | Inc. Sync Keys | API Info |
|---|---|---|---|---|---|---|
| 1 | ad_groups | 28 | ad_group.id, segments.date | Full Refresh, Incremental | segments.date | API Reference |
| 2 | ad_group_labels | 4 | ad_group_label.resource_name | Full Refresh | API Reference | |
| 3 | keyword_report | 14 | Full Refresh, Incremental | segments.date | ||
| 4 | ad_group_ad_report | 140 | Full Refresh, Incremental | segments.date | API Reference | |
| 5 | shopping_performance_report | 59 | Full Refresh, Incremental | segments.date | API Reference | |
| 6 | geographic_report | 5 | Full Refresh, Incremental | segments.date | ||
| 7 | click_view | 16 | click_view.gclid, segments.date | Full Refresh, Incremental | segments.date | API Reference |
| 8 | ad_group_ads | 135 | ad_group_ad.ad.id, segments.date | Full Refresh, Incremental | segments.date | API Reference |
| 9 | display_keyword_performance_report | 80 | Full Refresh, Incremental | segments.date | ||
| 10 | campaigns | 83 | campaign.id, segments.date | Full Refresh, Incremental | segments.date | API Reference |
| 11 | campaign_labels | 4 | campaign_label.resource_name | Full Refresh | API Reference | |
| 12 | service_accounts | 20 | ||||
| 13 | accounts | 21 | customer.id, segments.date | Full Refresh, Incremental | segments.date | API Reference |
| 14 | display_topics_performance_report | 79 | Full Refresh, Incremental | segments.date | ||
| 15 | account_performance_report | 57 | Full Refresh, Incremental | segments.date | API Reference | |
| 16 | ad_group_ad_labels | 4 | ad_group_ad_label.resource_name | Full Refresh | API Reference | |
| 17 | user_location_report | 45 | Full Refresh, Incremental | segments.date | API Reference |
Table: ad_groups
| No | Column Name | Type | Notes |
|---|---|---|---|
| 1 | ad_group.excluded_parent_asset_field_types | VARCHAR | |
| 2 | ad_group.type | VARCHAR | |
| 3 | ad_group.ad_rotation_mode | VARCHAR | |
| 4 | ad_group.effective_target_cpa_micros | INTEGER | |
| 5 | ad_group.campaign | VARCHAR | |
| 6 | ad_group.optimized_targeting_enabled | BOOLEAN | |
| 7 | ad_group.url_custom_parameters | VARCHAR | |
| 8 | ad_group.name | VARCHAR | |
| 9 | ad_group.cpm_bid_micros | INTEGER | |
| 10 | ad_group.resource_name | VARCHAR | |
| 11 | ad_group.status | VARCHAR | |
| 12 | ad_group.effective_target_roas | DOUBLE | |
| 13 | ad_group.targeting_setting.target_restrictions | VARCHAR | |
| 14 | ad_group.target_roas | DOUBLE | |
| 15 | ad_group.final_url_suffix | VARCHAR | |
| 16 | ad_group.labels | VARCHAR | |
| 17 | ad_group.target_cpm_micros | INTEGER | |
| 18 | ad_group.percent_cpc_bid_micros | INTEGER | |
| 19 | ad_group.id | INTEGER | Primary Key |
| 20 | ad_group.effective_target_cpa_source | VARCHAR | |
| 21 | ad_group.tracking_url_template | VARCHAR | |
| 22 | ad_group.cpc_bid_micros | INTEGER | |
| 23 | ad_group.effective_target_roas_source | VARCHAR | |
| 24 | ad_group.target_cpa_micros | INTEGER | |
| 25 | ad_group.base_ad_group | VARCHAR | |
| 26 | ad_group.display_custom_bid_dimension | VARCHAR | |
| 27 | ad_group.cpv_bid_micros | INTEGER | |
| 28 | segments.date | VARCHAR | Incremental sync key, Primary Key |
Table: ad_group_labels
| No | Column Name | Type | Notes |
|---|---|---|---|
| 1 | ad_group_label.resource_name | VARCHAR | Primary Key |
| 2 | label.resource_name | VARCHAR | |
| 3 | ad_group.resource_name | VARCHAR | |
| 4 | label.name | VARCHAR |
Table: keyword_report
| No | Column Name | Type | Notes |
|---|---|---|---|
| 1 | ad_group_criterion.negative | BOOLEAN | |
| 2 | ad_group_criterion.keyword.text | VARCHAR | |
| 3 | ad_group_criterion.keyword.match_type | VARCHAR | |
| 4 | metrics.impressions | INTEGER | |
| 5 | ad_group.id | INTEGER | |
| 6 | customer.descriptive_name | VARCHAR | |
| 7 | metrics.clicks | INTEGER | |
| 8 | ad_group_criterion.criterion_id | INTEGER | |
| 9 | metrics.historical_quality_score | INTEGER | |
| 10 | ad_group_criterion.type | VARCHAR | |
| 11 | campaign.bidding_strategy_type | VARCHAR | |
| 12 | metrics.ctr | DOUBLE | |
| 13 | metrics.cost_micros | INTEGER | |
| 14 | segments.date | VARCHAR | Incremental sync key |
Table: ad_group_ad_report
| No | Column Name | Type | Notes |
|---|---|---|---|
| 1 | ad_group_ad.ad_group | VARCHAR | |
| 2 | ad_group_ad.ad.responsive_search_ad.descriptions | VARCHAR | |
| 3 | segments.month | VARCHAR | |
| 4 | metrics.value_per_current_model_attributed_conversion | DOUBLE | |
| 5 | customer.currency_code | VARCHAR | |
| 6 | metrics.engagements | INTEGER | |
| 7 | ad_group_ad.ad.responsive_display_ad.format_setting | VARCHAR | |
| 8 | ad_group_ad.ad.responsive_display_ad.main_color | VARCHAR | |
| 9 | metrics.all_conversions | DOUBLE | |
| 10 | metrics.percent_new_visitors | DOUBLE | |
| 11 | ad_group_ad.ad.app_ad.headlines | VARCHAR | |
| 12 | metrics.gmail_forwards | INTEGER | |
| 13 | ad_group_ad.ad.responsive_display_ad.descriptions | VARCHAR | |
| 14 | ad_group_ad.ad.expanded_dynamic_search_ad.description | VARCHAR | |
| 15 | segments.day_of_week | VARCHAR | |
| 16 | ad_group_ad.ad.final_mobile_urls | VARCHAR | |
| 17 | metrics.ctr | DOUBLE | |
| 18 | metrics.video_quartile_p25_rate | DOUBLE | |
| 19 | ad_group_ad.ad.id | INTEGER | |
| 20 | ad_group_ad.ad.legacy_responsive_display_ad.short_headline | VARCHAR | |
| 21 | ad_group_ad.ad.text_ad.headline | VARCHAR | |
| 22 | ad_group_ad.ad.display_url | VARCHAR | |
| 23 | ad_group_ad.ad.responsive_display_ad.promo_text | VARCHAR | |
| 24 | metrics.view_through_conversions | INTEGER | |
| 25 | ad_group_ad.ad.responsive_display_ad.square_logo_images | VARCHAR | |
| 26 | ad_group_ad.ad.system_managed_resource_source | VARCHAR | |
| 27 | ad_group_ad.ad.legacy_responsive_display_ad.allow_flexible_color | BOOLEAN | |
| 28 | ad_group_ad.ad.image_ad.pixel_width | INTEGER | |
| 29 | campaign.status | VARCHAR | |
| 30 | metrics.current_model_attributed_conversions_value | DOUBLE | |
| 31 | metrics.top_impression_percentage | DOUBLE | |
| 32 | metrics.active_view_ctr | DOUBLE | |
| 33 | ad_group_ad.ad.responsive_search_ad.headlines | VARCHAR | |
| 34 | metrics.cross_device_conversions | DOUBLE | |
| 35 | ad_group.base_ad_group | VARCHAR | |
| 36 | ad_group_ad.ad.responsive_display_ad.marketing_images | VARCHAR | |
| 37 | metrics.cost_micros | INTEGER | |
| 38 | campaign.base_campaign | VARCHAR | |
| 39 | ad_group_ad.ad.image_ad.mime_type | VARCHAR | |
| 40 | metrics.interaction_event_types | VARCHAR | |
| 41 | metrics.current_model_attributed_conversions | DOUBLE | |
| 42 | ad_group_ad.ad.legacy_responsive_display_ad.logo_image | VARCHAR | |
| 43 | metrics.average_time_on_site | DOUBLE | |
| 44 | metrics.active_view_impressions | INTEGER | |
| 45 | metrics.video_view_rate | DOUBLE | |
| 46 | ad_group_ad.ad.responsive_display_ad.call_to_action_text | VARCHAR | |
| 47 | metrics.all_conversions_from_interactions_rate | DOUBLE | |
| 48 | ad_group_ad.ad.legacy_responsive_display_ad.format_setting | VARCHAR | |
| 49 | ad_group.status | VARCHAR | |
| 50 | metrics.active_view_measurable_impressions | INTEGER | |
| 51 | metrics.cost_per_conversion | DOUBLE | |
| 52 | ad_group_ad.ad.image_ad.pixel_height | INTEGER | |
| 53 | ad_group_ad.policy_summary.approval_status | VARCHAR | |
| 54 | metrics.bounce_rate | DOUBLE | |
| 55 | ad_group_ad.ad_strength | VARCHAR | |
| 56 | metrics.conversions_value | DOUBLE | |
| 57 | ad_group_ad.ad.responsive_display_ad.logo_images | VARCHAR | |
| 58 | metrics.average_cost | DOUBLE | |
| 59 | ad_group_ad.ad.text_ad.description2 | VARCHAR | |
| 60 | ad_group_ad.ad.text_ad.description1 | VARCHAR | |
| 61 | ad_group_ad.ad.app_ad.images | VARCHAR | |
| 62 | ad_group_ad.ad.responsive_display_ad.price_prefix | VARCHAR | |
| 63 | ad_group.id | INTEGER | |
| 64 | metrics.active_view_viewability | DOUBLE | |
| 65 | ad_group_ad.status | VARCHAR | |
| 66 | ad_group_ad.ad.responsive_display_ad.long_headline | VARCHAR | |
| 67 | metrics.all_conversions_value | DOUBLE | |
| 68 | ad_group_ad.ad.image_ad.name | VARCHAR | |
| 69 | campaign.name | VARCHAR | |
| 70 | customer.descriptive_name | VARCHAR | |
| 71 | ad_group_ad.ad.expanded_text_ad.description | VARCHAR | |
| 72 | customer.id | INTEGER | |
| 73 | metrics.value_per_conversion | DOUBLE | |
| 74 | ad_group_ad.ad.responsive_display_ad.business_name | VARCHAR | |
| 75 | metrics.active_view_measurable_cost_micros | INTEGER | |
| 76 | ad_group_ad.ad.legacy_responsive_display_ad.price_prefix | VARCHAR | |
| 77 | segments.date | VARCHAR | Incremental sync key |
| 78 | ad_group_ad.ad.expanded_text_ad.description2 | VARCHAR | |
| 79 | metrics.conversions | DOUBLE | |
| 80 | ad_group_ad.ad.expanded_text_ad.headline_part2 | VARCHAR | |
| 81 | ad_group_ad.ad.device_preference | VARCHAR | |
| 82 | ad_group_ad.ad.expanded_text_ad.headline_part1 | VARCHAR | |
| 83 | segments.year | INTEGER | |
| 84 | customer.time_zone | VARCHAR | |
| 85 | campaign.id | INTEGER | |
| 86 | metrics.engagement_rate | DOUBLE | |
| 87 | ad_group_ad.ad.expanded_text_ad.headline_part3 | VARCHAR | |
| 88 | ad_group_ad.ad.responsive_display_ad.square_marketing_images | VARCHAR | |
| 89 | ad_group.name | VARCHAR | |
| 90 | ad_group_ad.ad.legacy_responsive_display_ad.square_logo_image | VARCHAR | |
| 91 | ad_group_ad.ad.tracking_url_template | VARCHAR | |
| 92 | segments.quarter | VARCHAR | |
| 93 | metrics.cost_per_current_model_attributed_conversion | DOUBLE | |
| 94 | ad_group_ad.ad.legacy_responsive_display_ad.long_headline | VARCHAR | |
| 95 | ad_group_ad.ad.responsive_display_ad.youtube_videos | VARCHAR | |
| 96 | ad_group_ad.ad.legacy_responsive_display_ad.call_to_action_text | VARCHAR | |
| 97 | ad_group_ad.ad.final_urls | VARCHAR | |
| 98 | ad_group_ad.ad.responsive_display_ad.allow_flexible_color | BOOLEAN | |
| 99 | ad_group_ad.ad.legacy_responsive_display_ad.square_marketing_image | VARCHAR | |
| 100 | metrics.average_page_views | DOUBLE | |
| 101 | metrics.video_quartile_p50_rate | DOUBLE | |
| 102 | ad_group_ad.ad.responsive_search_ad.path1 | VARCHAR | |
| 103 | metrics.interaction_rate | DOUBLE | |
| 104 | metrics.impressions | INTEGER | |
| 105 | ad_group_ad.ad.responsive_search_ad.path2 | VARCHAR | |
| 106 | ad_group_ad.ad.app_ad.mandatory_ad_text | VARCHAR | |
| 107 | ad_group_ad.ad.legacy_responsive_display_ad.business_name | VARCHAR | |
| 108 | metrics.video_views | INTEGER | |
| 109 | metrics.gmail_secondary_clicks | INTEGER | |
| 110 | metrics.active_view_cpm | DOUBLE | |
| 111 | ad_group_ad.ad.responsive_display_ad.headlines | VARCHAR | |
| 112 | ad_group_ad.ad.image_ad.image_url | VARCHAR | |
| 113 | metrics.conversions_from_interactions_rate | DOUBLE | |
| 114 | ad_group_ad.ad.added_by_google_ads | BOOLEAN | |
| 115 | ad_group_ad.ad.expanded_text_ad.path1 | VARCHAR | |
| 116 | ad_group_ad.ad.expanded_text_ad.path2 | VARCHAR | |
| 117 | metrics.interactions | INTEGER | |
| 118 | metrics.average_cpm | DOUBLE | |
| 119 | ad_group_ad.ad.legacy_responsive_display_ad.main_color | VARCHAR | |
| 120 | ad_group_ad.ad.responsive_display_ad.accent_color | VARCHAR | |
| 121 | ad_group_ad.ad.url_custom_parameters | VARCHAR | |
| 122 | ad_group_ad.ad.app_ad.descriptions | VARCHAR | |
| 123 | metrics.average_cpv | DOUBLE | |
| 124 | segments.week | VARCHAR | |
| 125 | ad_group_ad.ad.legacy_responsive_display_ad.accent_color | VARCHAR | |
| 126 | metrics.clicks | INTEGER | |
| 127 | ad_group_ad.ad.legacy_responsive_display_ad.marketing_image | VARCHAR | |
| 128 | metrics.active_view_measurability | DOUBLE | |
| 129 | metrics.average_cpc | DOUBLE | |
| 130 | metrics.average_cpe | DOUBLE | |
| 131 | ad_group_ad.ad.app_ad.html5_media_bundles | VARCHAR | |
| 132 | ad_group_ad.ad.app_ad.youtube_videos | VARCHAR | |
| 133 | metrics.video_quartile_p75_rate | DOUBLE | |
| 134 | ad_group_ad.ad.legacy_responsive_display_ad.promo_text | VARCHAR | |
| 135 | segments.ad_network_type | VARCHAR | |
| 136 | metrics.value_per_all_conversions | DOUBLE | |
| 137 | metrics.video_quartile_p100_rate | DOUBLE | |
| 138 | metrics.gmail_saves | INTEGER | |
| 139 | ad_group_ad.ad.type | VARCHAR | |
| 140 | metrics.cost_per_all_conversions | DOUBLE |
Table: shopping_performance_report
| No | Column Name | Type | Notes |
|---|---|---|---|
| 1 | metrics.conversions | DOUBLE | |
| 2 | segments.month | VARCHAR | |
| 3 | segments.year | INTEGER | |
| 4 | segments.product_channel | VARCHAR | |
| 5 | campaign.id | INTEGER | |
| 6 | segments.product_bidding_category_level1 | VARCHAR | |
| 7 | metrics.all_conversions | DOUBLE | |
| 8 | segments.product_bidding_category_level2 | VARCHAR | |
| 9 | segments.product_bidding_category_level3 | VARCHAR | |
| 10 | segments.product_bidding_category_level4 | VARCHAR | |
| 11 | segments.product_bidding_category_level5 | VARCHAR | |
| 12 | ad_group.name | VARCHAR | |
| 13 | segments.product_country | VARCHAR | |
| 14 | segments.day_of_week | VARCHAR | |
| 15 | segments.quarter | VARCHAR | |
| 16 | metrics.ctr | DOUBLE | |
| 17 | metrics.impressions | INTEGER | |
| 18 | segments.product_type_l5 | VARCHAR | |
| 19 | segments.product_type_l2 | VARCHAR | |
| 20 | segments.product_type_l1 | VARCHAR | |
| 21 | segments.product_type_l4 | VARCHAR | |
| 22 | campaign.status | VARCHAR | |
| 23 | segments.product_type_l3 | VARCHAR | |
| 24 | segments.product_brand | VARCHAR | |
| 25 | metrics.cross_device_conversions | DOUBLE | |
| 26 | segments.product_merchant_id | INTEGER | |
| 27 | metrics.conversions_from_interactions_rate | DOUBLE | |
| 28 | metrics.cost_micros | INTEGER | |
| 29 | segments.click_type | VARCHAR | |
| 30 | segments.device | VARCHAR | |
| 31 | segments.week | VARCHAR | |
| 32 | segments.product_item_id | VARCHAR | |
| 33 | metrics.clicks | INTEGER | |
| 34 | metrics.all_conversions_from_interactions_rate | DOUBLE | |
| 35 | segments.product_channel_exclusivity | VARCHAR | |
| 36 | segments.product_custom_attribute4 | VARCHAR | |
| 37 | segments.product_condition | VARCHAR | |
| 38 | ad_group.status | VARCHAR | |
| 39 | segments.product_custom_attribute1 | VARCHAR | |
| 40 | segments.product_custom_attribute0 | VARCHAR | |
| 41 | metrics.cost_per_conversion | DOUBLE | |
| 42 | segments.product_custom_attribute3 | VARCHAR | |
| 43 | segments.product_custom_attribute2 | VARCHAR | |
| 44 | metrics.average_cpc | DOUBLE | |
| 45 | metrics.conversions_value | DOUBLE | |
| 46 | segments.ad_network_type | VARCHAR | |
| 47 | ad_group.id | INTEGER | |
| 48 | segments.product_language | VARCHAR | |
| 49 | metrics.value_per_all_conversions | DOUBLE | |
| 50 | metrics.all_conversions_value | DOUBLE | |
| 51 | segments.product_title | VARCHAR | |
| 52 | campaign.name | VARCHAR | |
| 53 | customer.descriptive_name | VARCHAR | |
| 54 | customer.id | INTEGER | |
| 55 | segments.product_aggregator_id | INTEGER | |
| 56 | segments.product_store_id | VARCHAR | |
| 57 | metrics.value_per_conversion | DOUBLE | |
| 58 | metrics.cost_per_all_conversions | DOUBLE | |
| 59 | segments.date | VARCHAR | Incremental sync key |
Table: geographic_report
| No | Column Name | Type | Notes |
|---|---|---|---|
| 1 | customer.descriptive_name | VARCHAR | |
| 2 | geographic_view.country_criterion_id | INTEGER | |
| 3 | geographic_view.location_type | VARCHAR | |
| 4 | ad_group.id | INTEGER | |
| 5 | segments.date | VARCHAR | Incremental sync key |
Table: click_view
| No | Column Name | Type | Notes |
|---|---|---|---|
| 1 | campaign.network_settings.target_search_network | BOOLEAN | |
| 2 | click_view.gclid | VARCHAR | Primary Key |
| 3 | click_view.keyword_info.text | VARCHAR | |
| 4 | segments.ad_network_type | VARCHAR | |
| 5 | campaign.network_settings.target_google_search | BOOLEAN | |
| 6 | campaign.id | INTEGER | |
| 7 | click_view.ad_group_ad | VARCHAR | |
| 8 | ad_group.id | INTEGER | |
| 9 | click_view.keyword | VARCHAR | |
| 10 | click_view.keyword_info.match_type | VARCHAR | |
| 11 | campaign.name | VARCHAR | |
| 12 | campaign.network_settings.target_content_network | BOOLEAN | |
| 13 | ad_group.name | VARCHAR | |
| 14 | customer.id | INTEGER | |
| 15 | campaign.network_settings.target_partner_search_network | BOOLEAN | |
| 16 | segments.date | VARCHAR | Incremental sync key, Primary Key |
Table: ad_group_ads
| No | Column Name | Type | Notes |
|---|---|---|---|
| 1 | ad_group_ad.ad_group | VARCHAR | |
| 2 | ad_group_ad.ad.responsive_search_ad.descriptions | VARCHAR | |
| 3 | ad_group_ad.ad.video_responsive_ad.descriptions | VARCHAR | |
| 4 | ad_group_ad.ad.local_ad.headlines | VARCHAR | |
| 5 | ad_group_ad.ad.responsive_display_ad.format_setting | VARCHAR | |
| 6 | ad_group_ad.ad.responsive_display_ad.main_color | VARCHAR | |
| 7 | ad_group_ad.ad.app_ad.headlines | VARCHAR | |
| 8 | ad_group_ad.ad.responsive_display_ad.descriptions | VARCHAR | |
| 9 | ad_group_ad.ad.expanded_dynamic_search_ad.description | VARCHAR | |
| 10 | ad_group_ad.ad.shopping_product_ad | VARCHAR | |
| 11 | ad_group_ad.ad.final_mobile_urls | VARCHAR | |
| 12 | ad_group_ad.ad.local_ad.call_to_actions | VARCHAR | |
| 13 | ad_group_ad.ad.video_responsive_ad.call_to_actions | VARCHAR | |
| 14 | ad_group_ad.ad.call_ad.phone_number | VARCHAR | |
| 15 | ad_group_ad.ad.id | INTEGER | Primary Key |
| 16 | ad_group_ad.ad.legacy_responsive_display_ad.short_headline | VARCHAR | |
| 17 | ad_group_ad.ad.text_ad.headline | VARCHAR | |
| 18 | ad_group_ad.ad.display_url | VARCHAR | |
| 19 | ad_group_ad.ad.responsive_display_ad.promo_text | VARCHAR | |
| 20 | ad_group_ad.ad.responsive_display_ad.square_logo_images | VARCHAR | |
| 21 | ad_group_ad.ad.system_managed_resource_source | VARCHAR | |
| 22 | ad_group_ad.ad.smart_campaign_ad.headlines | VARCHAR | |
| 23 | ad_group_ad.ad.image_ad.pixel_width | INTEGER | |
| 24 | ad_group_ad.ad.legacy_responsive_display_ad.allow_flexible_color | BOOLEAN | |
| 25 | ad_group_ad.ad.name | VARCHAR | |
| 26 | ad_group_ad.ad.responsive_search_ad.headlines | VARCHAR | |
| 27 | ad_group_ad.ad.url_collections | VARCHAR | |
| 28 | ad_group_ad.ad.responsive_display_ad.marketing_images | VARCHAR | |
| 29 | ad_group_ad.ad.call_ad.call_tracked | BOOLEAN | |
| 30 | ad_group_ad.ad.expanded_dynamic_search_ad.description2 | VARCHAR | |
| 31 | ad_group_ad.ad.image_ad.preview_pixel_height | INTEGER | |
| 32 | ad_group_ad.ad.image_ad.mime_type | VARCHAR | |
| 33 | ad_group_ad.ad.call_ad.business_name | VARCHAR | |
| 34 | ad_group_ad.ad.legacy_responsive_display_ad.logo_image | VARCHAR | |
| 35 | ad_group_ad.ad.app_engagement_ad.videos | VARCHAR | |
| 36 | ad_group_ad.ad.video_ad.in_stream.action_button_label | VARCHAR | |
| 37 | ad_group_ad.ad.local_ad.path1 | VARCHAR | |
| 38 | ad_group_ad.ad.local_ad.path2 | VARCHAR | |
| 39 | ad_group_ad.ad.responsive_display_ad.call_to_action_text | VARCHAR | |
| 40 | ad_group_ad.ad.legacy_responsive_display_ad.format_setting | VARCHAR | |
| 41 | ad_group_ad.ad.responsive_display_ad.control_spec.enable_asset_enhancements | BOOLEAN | |
| 42 | ad_group_ad.ad.image_ad.pixel_height | INTEGER | |
| 43 | ad_group_ad.policy_summary.approval_status | VARCHAR | |
| 44 | ad_group_ad.ad_strength | VARCHAR | |
| 45 | ad_group_ad.ad.legacy_app_install_ad | VARCHAR | |
| 46 | ad_group_ad.ad.responsive_display_ad.logo_images | VARCHAR | |
| 47 | ad_group_ad.ad.responsive_display_ad.control_spec.enable_autogen_video | BOOLEAN | |
| 48 | ad_group_ad.ad.text_ad.description2 | VARCHAR | |
| 49 | ad_group_ad.ad.app_ad.images | VARCHAR | |
| 50 | ad_group_ad.ad.app_engagement_ad.images | VARCHAR | |
| 51 | ad_group_ad.ad.text_ad.description1 | VARCHAR | |
| 52 | ad_group_ad.ad.responsive_display_ad.price_prefix | VARCHAR | |
| 53 | ad_group_ad.ad.smart_campaign_ad.descriptions | VARCHAR | |
| 54 | ad_group_ad.status | VARCHAR | |
| 55 | ad_group_ad.ad.responsive_display_ad.long_headline | VARCHAR | |
| 56 | ad_group_ad.ad.image_ad.name | VARCHAR | |
| 57 | ad_group_ad.ad.expanded_text_ad.description | VARCHAR | |
| 58 | ad_group_ad.ad.image_ad.preview_image_url | VARCHAR | |
| 59 | ad_group_ad.ad.responsive_display_ad.business_name | VARCHAR | |
| 60 | ad_group_ad.ad.legacy_responsive_display_ad.price_prefix | VARCHAR | |
| 61 | ad_group_ad.labels | VARCHAR | |
| 62 | ad_group_ad.ad.expanded_text_ad.description2 | VARCHAR | |
| 63 | segments.date | VARCHAR | Incremental sync key, Primary Key |
| 64 | ad_group_ad.ad.video_ad.in_feed.headline | VARCHAR | |
| 65 | ad_group_ad.ad.call_ad.disable_call_conversion | BOOLEAN | |
| 66 | ad_group_ad.ad.expanded_text_ad.headline_part2 | VARCHAR | |
| 67 | ad_group_ad.policy_summary.review_status | VARCHAR | |
| 68 | ad_group_ad.ad.device_preference | VARCHAR | |
| 69 | ad_group_ad.ad.expanded_text_ad.headline_part1 | VARCHAR | |
| 70 | ad_group_ad.ad.shopping_comparison_listing_ad.headline | VARCHAR | |
| 71 | ad_group_ad.ad.expanded_text_ad.headline_part3 | VARCHAR | |
| 72 | ad_group_ad.ad.call_ad.phone_number_verification_url | VARCHAR | |
| 73 | ad_group_ad.ad.local_ad.videos | VARCHAR | |
| 74 | ad_group_ad.ad.responsive_display_ad.square_marketing_images | VARCHAR | |
| 75 | ad_group_ad.ad.call_ad.headline1 | VARCHAR | |
| 76 | ad_group_ad.ad.legacy_responsive_display_ad.square_logo_image | VARCHAR | |
| 77 | ad_group_ad.ad.tracking_url_template | VARCHAR | |
| 78 | ad_group_ad.ad.call_ad.conversion_reporting_state | VARCHAR | |
| 79 | ad_group_ad.ad.legacy_responsive_display_ad.long_headline | VARCHAR | |
| 80 | ad_group_ad.ad.call_ad.headline2 | VARCHAR | |
| 81 | ad_group_ad.ad.responsive_display_ad.youtube_videos | VARCHAR | |
| 82 | ad_group_ad.ad.legacy_responsive_display_ad.call_to_action_text | VARCHAR | |
| 83 | ad_group_ad.ad.video_responsive_ad.headlines | VARCHAR | |
| 84 | ad_group_ad.ad.final_urls | VARCHAR | |
| 85 | ad_group_ad.ad.responsive_display_ad.allow_flexible_color | BOOLEAN | |
| 86 | ad_group_ad.ad.legacy_responsive_display_ad.square_marketing_image | VARCHAR | |
| 87 | ad_group_ad.ad.app_engagement_ad.headlines | VARCHAR | |
| 88 | ad_group_ad.ad.resource_name | VARCHAR | |
| 89 | ad_group_ad.ad.responsive_search_ad.path1 | VARCHAR | |
| 90 | ad_group_ad.policy_summary.policy_topic_entries | VARCHAR | |
| 91 | ad_group_ad.ad.final_url_suffix | VARCHAR | |
| 92 | ad_group_ad.ad.responsive_search_ad.path2 | VARCHAR | |
| 93 | ad_group_ad.ad.legacy_responsive_display_ad.description | VARCHAR | |
| 94 | ad_group_ad.ad.app_ad.mandatory_ad_text | VARCHAR | |
| 95 | ad_group_ad.ad.legacy_responsive_display_ad.business_name | VARCHAR | |
| 96 | ad_group_ad.ad.video_responsive_ad.long_headlines | VARCHAR | |
| 97 | ad_group_ad.resource_name | VARCHAR | |
| 98 | ad_group_ad.ad.hotel_ad | VARCHAR | |
| 99 | ad_group_ad.ad.responsive_display_ad.headlines | VARCHAR | |
| 100 | ad_group_ad.ad.image_ad.image_url | VARCHAR | |
| 101 | ad_group_ad.ad.video_responsive_ad.videos | VARCHAR | |
| 102 | ad_group_ad.ad.added_by_google_ads | BOOLEAN | |
| 103 | ad_group_ad.ad.expanded_text_ad.path1 | VARCHAR | |
| 104 | ad_group_ad.ad.expanded_text_ad.path2 | VARCHAR | |
| 105 | ad_group_ad.ad.legacy_responsive_display_ad.main_color | VARCHAR | |
| 106 | ad_group_ad.ad.responsive_display_ad.accent_color | VARCHAR | |
| 107 | ad_group_ad.ad.url_custom_parameters | VARCHAR | |
| 108 | ad_group_ad.ad.app_ad.descriptions | VARCHAR | |
| 109 | ad_group_ad.ad.legacy_responsive_display_ad.accent_color | VARCHAR | |
| 110 | ad_group_ad.ad.legacy_responsive_display_ad.marketing_image | VARCHAR | |
| 111 | ad_group_ad.ad.video_ad.in_feed.description2 | VARCHAR | |
| 112 | ad_group_ad.ad.call_ad.country_code | VARCHAR | |
| 113 | ad_group_ad.ad.video_ad.in_feed.description1 | VARCHAR | |
| 114 | ad_group_ad.ad.display_upload_ad.display_upload_product_type | VARCHAR | |
| 115 | ad_group_ad.ad.local_ad.descriptions | VARCHAR | |
| 116 | ad_group_ad.ad.call_ad.conversion_action | VARCHAR | |
| 117 | ad_group_ad.ad.app_engagement_ad.descriptions | VARCHAR | |
| 118 | ad_group_ad.ad.call_ad.description2 | VARCHAR | |
| 119 | ad_group_ad.ad.app_ad.html5_media_bundles | VARCHAR | |
| 120 | ad_group_ad.ad.call_ad.description1 | VARCHAR | |
| 121 | ad_group_ad.ad.final_app_urls | VARCHAR | |
| 122 | ad_group_ad.ad.app_ad.youtube_videos | VARCHAR | |
| 123 | ad_group_ad.ad.image_ad.preview_pixel_width | INTEGER | |
| 124 | ad_group_ad.ad.legacy_responsive_display_ad.promo_text | VARCHAR | |
| 125 | ad_group_ad.ad.video_ad.out_stream.headline | VARCHAR | |
| 126 | ad_group_ad.ad.display_upload_ad.media_bundle | VARCHAR | |
| 127 | ad_group_ad.ad.video_responsive_ad.companion_banners | VARCHAR | |
| 128 | ad_group_ad.ad.local_ad.marketing_images | VARCHAR | |
| 129 | ad_group_ad.ad.call_ad.path1 | VARCHAR | |
| 130 | ad_group_ad.ad.call_ad.path2 | VARCHAR | |
| 131 | ad_group_ad.ad.type | VARCHAR | |
| 132 | ad_group_ad.ad.video_ad.out_stream.description | VARCHAR | |
| 133 | ad_group_ad.ad.shopping_smart_ad | VARCHAR | |
| 134 | ad_group_ad.ad.video_ad.in_stream.action_headline | VARCHAR | |
| 135 | ad_group_ad.ad.local_ad.logo_images | VARCHAR |
Table: display_keyword_performance_report
| No | Column Name | Type | Notes |
|---|---|---|---|
| 1 | metrics.conversions | DOUBLE | |
| 2 | segments.month | VARCHAR | |
| 3 | ad_group_criterion.status | VARCHAR | |
| 4 | customer.currency_code | VARCHAR | |
| 5 | segments.year | INTEGER | |
| 6 | customer.time_zone | VARCHAR | |
| 7 | metrics.engagements | INTEGER | |
| 8 | campaign.id | INTEGER | |
| 9 | metrics.engagement_rate | DOUBLE | |
| 10 | ad_group_criterion.final_urls | VARCHAR | |
| 11 | metrics.all_conversions | DOUBLE | |
| 12 | metrics.gmail_forwards | INTEGER | |
| 13 | ad_group.name | VARCHAR | |
| 14 | campaign.bidding_strategy | VARCHAR | |
| 15 | ad_group_criterion.effective_cpv_bid_source | VARCHAR | |
| 16 | segments.day_of_week | VARCHAR | |
| 17 | segments.quarter | VARCHAR | |
| 18 | ad_group.targeting_setting.target_restrictions | VARCHAR | |
| 19 | campaign.bidding_strategy_type | VARCHAR | |
| 20 | metrics.ctr | DOUBLE | |
| 21 | ad_group_criterion.tracking_url_template | VARCHAR | |
| 22 | ad_group_criterion.effective_cpc_bid_micros | INTEGER | |
| 23 | ad_group_criterion.negative | BOOLEAN | |
| 24 | metrics.video_quartile_p25_rate | DOUBLE | |
| 25 | metrics.video_quartile_p50_rate | DOUBLE | |
| 26 | metrics.interaction_rate | DOUBLE | |
| 27 | metrics.impressions | INTEGER | |
| 28 | metrics.view_through_conversions | INTEGER | |
| 29 | metrics.video_views | INTEGER | |
| 30 | campaign.status | VARCHAR | |
| 31 | metrics.gmail_secondary_clicks | INTEGER | |
| 32 | metrics.active_view_cpm | DOUBLE | |
| 33 | metrics.active_view_ctr | DOUBLE | |
| 34 | metrics.cross_device_conversions | DOUBLE | |
| 35 | ad_group.base_ad_group | VARCHAR | |
| 36 | metrics.conversions_from_interactions_rate | DOUBLE | |
| 37 | metrics.cost_micros | INTEGER | |
| 38 | campaign.base_campaign | VARCHAR | |
| 39 | ad_group_criterion.effective_cpv_bid_micros | INTEGER | |
| 40 | metrics.interactions | INTEGER | |
| 41 | metrics.average_cpm | DOUBLE | |
| 42 | ad_group_criterion.keyword.text | VARCHAR | |
| 43 | metrics.interaction_event_types | VARCHAR | |
| 44 | ad_group_criterion.keyword.match_type | VARCHAR | |
| 45 | metrics.average_cpv | DOUBLE | |
| 46 | segments.device | VARCHAR | |
| 47 | ad_group_criterion.final_mobile_urls | VARCHAR | |
| 48 | segments.week | VARCHAR | |
| 49 | metrics.active_view_impressions | INTEGER | |
| 50 | metrics.video_view_rate | DOUBLE | |
| 51 | metrics.clicks | INTEGER | |
| 52 | ad_group_criterion.effective_cpc_bid_source | VARCHAR | |
| 53 | ad_group_criterion.criterion_id | INTEGER | |
| 54 | metrics.all_conversions_from_interactions_rate | DOUBLE | |
| 55 | ad_group.status | VARCHAR | |
| 56 | metrics.active_view_measurable_impressions | INTEGER | |
| 57 | ad_group_criterion.url_custom_parameters | VARCHAR | |
| 58 | metrics.cost_per_conversion | DOUBLE | |
| 59 | metrics.active_view_measurability | DOUBLE | |
| 60 | metrics.average_cpc | DOUBLE | |
| 61 | metrics.average_cpe | DOUBLE | |
| 62 | metrics.conversions_value | DOUBLE | |
| 63 | metrics.average_cost | DOUBLE | |
| 64 | metrics.video_quartile_p75_rate | DOUBLE | |
| 65 | segments.ad_network_type | VARCHAR | |
| 66 | metrics.active_view_viewability | DOUBLE | |
| 67 | ad_group.id | INTEGER | |
| 68 | metrics.value_per_all_conversions | DOUBLE | |
| 69 | metrics.video_quartile_p100_rate | DOUBLE | |
| 70 | metrics.gmail_saves | INTEGER | |
| 71 | metrics.all_conversions_value | DOUBLE | |
| 72 | campaign.name | VARCHAR | |
| 73 | customer.descriptive_name | VARCHAR | |
| 74 | customer.id | INTEGER | |
| 75 | metrics.value_per_conversion | DOUBLE | |
| 76 | ad_group_criterion.effective_cpm_bid_source | VARCHAR | |
| 77 | metrics.active_view_measurable_cost_micros | INTEGER | |
| 78 | ad_group_criterion.effective_cpm_bid_micros | INTEGER | |
| 79 | metrics.cost_per_all_conversions | DOUBLE | |
| 80 | segments.date | VARCHAR | Incremental sync key |
Table: campaigns
| No | Column Name | Type | Notes |
|---|---|---|---|
| 1 | metrics.conversions | DOUBLE | |
| 2 | campaign.target_roas.cpc_bid_floor_micros | INTEGER | |
| 3 | campaign.commission.commission_rate_micros | INTEGER | |
| 4 | campaign.target_impression_share.cpc_bid_ceiling_micros | INTEGER | |
| 5 | campaign.vanity_pharma.vanity_pharma_display_url_mode | VARCHAR | |
| 6 | campaign.id | INTEGER | Primary Key |
| 7 | campaign.target_cpm.target_frequency_goal.time_unit | VARCHAR | |
| 8 | campaign.ad_serving_optimization_status | VARCHAR | |
| 9 | campaign.geo_target_type_setting.positive_geo_target_type | VARCHAR | |
| 10 | campaign.target_cpa.target_cpa_micros | INTEGER | |
| 11 | campaign.bidding_strategy | VARCHAR | |
| 12 | campaign.percent_cpc.cpc_bid_ceiling_micros | INTEGER | |
| 13 | campaign.percent_cpc.enhanced_cpc_enabled | BOOLEAN | |
| 14 | campaign.excluded_parent_asset_field_types | VARCHAR | |
| 15 | campaign.final_url_suffix | VARCHAR | |
| 16 | campaign.optimization_goal_setting.optimization_goal_types | VARCHAR | |
| 17 | campaign.app_campaign_setting.app_store | VARCHAR | |
| 18 | campaign.bidding_strategy_type | VARCHAR | |
| 19 | campaign.frequency_caps | VARCHAR | |
| 20 | campaign.shopping_setting.campaign_priority | INTEGER | |
| 21 | campaign.target_impression_share.location_fraction_micros | INTEGER | |
| 22 | metrics.ctr | DOUBLE | |
| 23 | campaign.advertising_channel_sub_type | VARCHAR | |
| 24 | campaign.manual_cpm | VARCHAR | |
| 25 | campaign.network_settings.target_search_network | BOOLEAN | |
| 26 | campaign.targeting_setting.target_restrictions | VARCHAR | |
| 27 | campaign.target_impression_share.location | VARCHAR | |
| 28 | campaign.network_settings.target_google_search | BOOLEAN | |
| 29 | campaign.optimization_score | DOUBLE | |
| 30 | metrics.impressions | DOUBLE | |
| 31 | campaign.end_date | VARCHAR | |
| 32 | campaign.target_cpa.cpc_bid_ceiling_micros | INTEGER | |
| 33 | campaign.manual_cpv | VARCHAR | |
| 34 | metrics.video_views | DOUBLE | |
| 35 | campaign.status | VARCHAR | |
| 36 | campaign.accessible_bidding_strategy | VARCHAR | |
| 37 | campaign.dynamic_search_ads_setting.feeds | VARCHAR | |
| 38 | segments.hour | DOUBLE | |
| 39 | campaign.labels | VARCHAR | |
| 40 | campaign.target_spend.target_spend_micros | INTEGER | |
| 41 | campaign.app_campaign_setting.bidding_strategy_goal_type | VARCHAR | |
| 42 | campaign.target_spend.cpc_bid_ceiling_micros | INTEGER | |
| 43 | campaign.shopping_setting.sales_country | VARCHAR | |
| 44 | metrics.cost_micros | INTEGER | |
| 45 | campaign.target_roas.cpc_bid_ceiling_micros | INTEGER | |
| 46 | campaign.base_campaign | VARCHAR | |
| 47 | campaign.vanity_pharma.vanity_pharma_text | VARCHAR | |
| 48 | campaign.advertising_channel_type | VARCHAR | |
| 49 | campaign.maximize_conversions.target_cpa_micros | INTEGER | |
| 50 | campaign.target_roas.target_roas | DOUBLE | |
| 51 | campaign.start_date | VARCHAR | |
| 52 | campaign.geo_target_type_setting.negative_geo_target_type | VARCHAR | |
| 53 | campaign.dynamic_search_ads_setting.use_supplied_urls_only | BOOLEAN | |
| 54 | campaign.tracking_setting.tracking_url | VARCHAR | |
| 55 | campaign.experiment_type | VARCHAR | |
| 56 | metrics.clicks | INTEGER | |
| 57 | campaign.real_time_bidding_setting.opt_in | BOOLEAN | |
| 58 | campaign.payment_mode | VARCHAR | |
| 59 | campaign.maximize_conversion_value.target_roas | DOUBLE | |
| 60 | campaign.dynamic_search_ads_setting.domain_name | VARCHAR | |
| 61 | campaign.manual_cpc.enhanced_cpc_enabled | BOOLEAN | |
| 62 | metrics.conversions_value | DOUBLE | |
| 63 | campaign.dynamic_search_ads_setting.language_code | VARCHAR | |
| 64 | campaign.shopping_setting.enable_local | BOOLEAN | |
| 65 | campaign.video_brand_safety_suitability | VARCHAR | |
| 66 | campaign.selective_optimization.conversion_actions | VARCHAR | |
| 67 | campaign.campaign_budget | VARCHAR | |
| 68 | campaign.tracking_url_template | VARCHAR | |
| 69 | metrics.video_quartile_p100_rate | DOUBLE | |
| 70 | campaign.target_cpa.cpc_bid_floor_micros | INTEGER | |
| 71 | campaign.name | VARCHAR | |
| 72 | campaign.network_settings.target_content_network | BOOLEAN | |
| 73 | campaign.serving_status | VARCHAR | |
| 74 | campaign.target_cpm.target_frequency_goal.target_count | INTEGER | |
| 75 | campaign.app_campaign_setting.app_id | VARCHAR | |
| 76 | campaign_budget.amount_micros | INTEGER | |
| 77 | campaign.network_settings.target_partner_search_network | BOOLEAN | |
| 78 | campaign.local_campaign_setting.location_source_type | VARCHAR | |
| 79 | campaign.resource_name | VARCHAR | |
| 80 | campaign.shopping_setting.merchant_id | INTEGER | |
| 81 | campaign.hotel_setting.hotel_center_id | INTEGER | |
| 82 | campaign.url_custom_parameters | VARCHAR | |
| 83 | segments.date | VARCHAR | Incremental sync key, Primary Key |
Table: campaign_labels
| No | Column Name | Type | Notes |
|---|---|---|---|
| 1 | campaign_label.resource_name | VARCHAR | Primary Key |
| 2 | label.resource_name | VARCHAR | |
| 3 | campaign.resource_name | VARCHAR | |
| 4 | label.name | VARCHAR |
Table: service_accounts
| No | Column Name | Type | Notes |
|---|---|---|---|
| 1 | customer.call_reporting_setting.call_conversion_action | VARCHAR | |
| 2 | customer.tracking_url_template | VARCHAR | |
| 3 | customer.currency_code | VARCHAR | |
| 4 | customer.call_reporting_setting.call_reporting_enabled | BOOLEAN | |
| 5 | customer.conversion_tracking_setting.cross_account_conversion_tracking_id | INTEGER | |
| 6 | customer.time_zone | VARCHAR | |
| 7 | customer.optimization_score | DOUBLE | |
| 8 | customer.final_url_suffix | VARCHAR | |
| 9 | customer.pay_per_conversion_eligibility_failure_reasons | VARCHAR | |
| 10 | customer.auto_tagging_enabled | BOOLEAN | |
| 11 | customer.test_account | BOOLEAN | |
| 12 | customer.descriptive_name | VARCHAR | |
| 13 | customer.remarketing_setting.google_global_site_tag | VARCHAR | |
| 14 | customer.id | INTEGER | |
| 15 | customer.manager | BOOLEAN | |
| 16 | customer.resource_name | VARCHAR | |
| 17 | customer.call_reporting_setting.call_conversion_reporting_enabled | BOOLEAN | |
| 18 | customer.optimization_score_weight | DOUBLE | |
| 19 | customer.conversion_tracking_setting.conversion_tracking_id | INTEGER | |
| 20 | customer.has_partners_badge | BOOLEAN |
Table: accounts
| No | Column Name | Type | Notes |
|---|---|---|---|
| 1 | customer.call_reporting_setting.call_conversion_action | VARCHAR | |
| 2 | customer.tracking_url_template | VARCHAR | |
| 3 | customer.currency_code | VARCHAR | |
| 4 | customer.call_reporting_setting.call_reporting_enabled | BOOLEAN | |
| 5 | customer.conversion_tracking_setting.cross_account_conversion_tracking_id | INTEGER | |
| 6 | customer.time_zone | VARCHAR | |
| 7 | customer.optimization_score | DOUBLE | |
| 8 | customer.final_url_suffix | VARCHAR | |
| 9 | customer.pay_per_conversion_eligibility_failure_reasons | VARCHAR | |
| 10 | customer.auto_tagging_enabled | BOOLEAN | |
| 11 | customer.test_account | BOOLEAN | |
| 12 | customer.descriptive_name | VARCHAR | |
| 13 | customer.remarketing_setting.google_global_site_tag | VARCHAR | |
| 14 | customer.id | INTEGER | Primary Key |
| 15 | customer.manager | BOOLEAN | |
| 16 | customer.resource_name | VARCHAR | |
| 17 | customer.call_reporting_setting.call_conversion_reporting_enabled | BOOLEAN | |
| 18 | customer.optimization_score_weight | DOUBLE | |
| 19 | customer.conversion_tracking_setting.conversion_tracking_id | INTEGER | |
| 20 | customer.has_partners_badge | BOOLEAN | |
| 21 | segments.date | VARCHAR | Incremental sync key, Primary Key |
Table: display_topics_performance_report
| No | Column Name | Type | Notes |
|---|---|---|---|
| 1 | metrics.conversions | DOUBLE | |
| 2 | segments.month | VARCHAR | |
| 3 | ad_group_criterion.status | VARCHAR | |
| 4 | customer.currency_code | VARCHAR | |
| 5 | segments.year | INTEGER | |
| 6 | customer.time_zone | VARCHAR | |
| 7 | metrics.engagements | INTEGER | |
| 8 | campaign.id | INTEGER | |
| 9 | metrics.engagement_rate | DOUBLE | |
| 10 | ad_group_criterion.final_urls | VARCHAR | |
| 11 | metrics.all_conversions | DOUBLE | |
| 12 | ad_group_criterion.topic.path | VARCHAR | |
| 13 | metrics.gmail_forwards | INTEGER | |
| 14 | ad_group.name | VARCHAR | |
| 15 | campaign.bidding_strategy | VARCHAR | |
| 16 | segments.day_of_week | VARCHAR | |
| 17 | segments.quarter | VARCHAR | |
| 18 | ad_group.targeting_setting.target_restrictions | VARCHAR | |
| 19 | campaign.bidding_strategy_type | VARCHAR | |
| 20 | metrics.ctr | DOUBLE | |
| 21 | ad_group_criterion.tracking_url_template | VARCHAR | |
| 22 | ad_group_criterion.effective_cpc_bid_micros | INTEGER | |
| 23 | ad_group_criterion.negative | BOOLEAN | |
| 24 | metrics.video_quartile_p25_rate | DOUBLE | |
| 25 | metrics.video_quartile_p50_rate | DOUBLE | |
| 26 | metrics.interaction_rate | DOUBLE | |
| 27 | metrics.impressions | INTEGER | |
| 28 | metrics.view_through_conversions | INTEGER | |
| 29 | metrics.video_views | INTEGER | |
| 30 | campaign.status | VARCHAR | |
| 31 | metrics.gmail_secondary_clicks | INTEGER | |
| 32 | metrics.active_view_cpm | DOUBLE | |
| 33 | metrics.active_view_ctr | DOUBLE | |
| 34 | metrics.cross_device_conversions | DOUBLE | |
| 35 | ad_group.base_ad_group | VARCHAR | |
| 36 | metrics.conversions_from_interactions_rate | DOUBLE | |
| 37 | metrics.cost_micros | INTEGER | |
| 38 | campaign.base_campaign | VARCHAR | |
| 39 | metrics.interactions | INTEGER | |
| 40 | metrics.average_cpm | DOUBLE | |
| 41 | metrics.interaction_event_types | VARCHAR | |
| 42 | metrics.average_cpv | DOUBLE | |
| 43 | segments.device | VARCHAR | |
| 44 | ad_group_criterion.final_mobile_urls | VARCHAR | |
| 45 | segments.week | VARCHAR | |
| 46 | metrics.active_view_impressions | INTEGER | |
| 47 | metrics.video_view_rate | DOUBLE | |
| 48 | metrics.clicks | INTEGER | |
| 49 | ad_group_criterion.effective_cpc_bid_source | VARCHAR | |
| 50 | ad_group_criterion.criterion_id | INTEGER | |
| 51 | metrics.all_conversions_from_interactions_rate | DOUBLE | |
| 52 | ad_group.status | VARCHAR | |
| 53 | metrics.active_view_measurable_impressions | INTEGER | |
| 54 | ad_group_criterion.url_custom_parameters | VARCHAR | |
| 55 | metrics.cost_per_conversion | DOUBLE | |
| 56 | metrics.active_view_measurability | DOUBLE | |
| 57 | metrics.average_cpc | DOUBLE | |
| 58 | metrics.average_cpe | DOUBLE | |
| 59 | metrics.conversions_value | DOUBLE | |
| 60 | metrics.average_cost | DOUBLE | |
| 61 | ad_group_criterion.topic.topic_constant | VARCHAR | |
| 62 | metrics.video_quartile_p75_rate | DOUBLE | |
| 63 | ad_group_criterion.bid_modifier | DOUBLE | |
| 64 | segments.ad_network_type | VARCHAR | |
| 65 | metrics.active_view_viewability | DOUBLE | |
| 66 | ad_group.id | INTEGER | |
| 67 | metrics.value_per_all_conversions | DOUBLE | |
| 68 | metrics.video_quartile_p100_rate | DOUBLE | |
| 69 | metrics.gmail_saves | INTEGER | |
| 70 | metrics.all_conversions_value | DOUBLE | |
| 71 | campaign.name | VARCHAR | |
| 72 | customer.descriptive_name | VARCHAR | |
| 73 | customer.id | INTEGER | |
| 74 | metrics.value_per_conversion | DOUBLE | |
| 75 | ad_group_criterion.effective_cpm_bid_source | VARCHAR | |
| 76 | metrics.active_view_measurable_cost_micros | INTEGER | |
| 77 | ad_group_criterion.effective_cpm_bid_micros | INTEGER | |
| 78 | metrics.cost_per_all_conversions | DOUBLE | |
| 79 | segments.date | VARCHAR | Incremental sync key |
Table: account_performance_report
| No | Column Name | Type | Notes |
|---|---|---|---|
| 1 | metrics.conversions | DOUBLE | |
| 2 | segments.month | VARCHAR | |
| 3 | customer.currency_code | VARCHAR | |
| 4 | segments.year | INTEGER | |
| 5 | customer.time_zone | VARCHAR | |
| 6 | metrics.engagements | INTEGER | |
| 7 | metrics.engagement_rate | DOUBLE | |
| 8 | metrics.all_conversions | DOUBLE | |
| 9 | customer.test_account | BOOLEAN | |
| 10 | segments.day_of_week | VARCHAR | |
| 11 | segments.quarter | VARCHAR | |
| 12 | metrics.search_budget_lost_impression_share | DOUBLE | |
| 13 | metrics.content_impression_share | DOUBLE | |
| 14 | metrics.ctr | DOUBLE | |
| 15 | metrics.search_rank_lost_impression_share | DOUBLE | |
| 16 | metrics.interaction_rate | DOUBLE | |
| 17 | metrics.impressions | INTEGER | |
| 18 | metrics.view_through_conversions | INTEGER | |
| 19 | metrics.video_views | INTEGER | |
| 20 | metrics.content_budget_lost_impression_share | DOUBLE | |
| 21 | metrics.active_view_cpm | DOUBLE | |
| 22 | metrics.active_view_ctr | DOUBLE | |
| 23 | metrics.cross_device_conversions | DOUBLE | |
| 24 | metrics.conversions_from_interactions_rate | DOUBLE | |
| 25 | metrics.cost_micros | INTEGER | |
| 26 | metrics.interactions | INTEGER | |
| 27 | metrics.average_cpm | DOUBLE | |
| 28 | metrics.content_rank_lost_impression_share | DOUBLE | |
| 29 | metrics.interaction_event_types | VARCHAR | |
| 30 | metrics.average_cpv | DOUBLE | |
| 31 | segments.device | VARCHAR | |
| 32 | segments.week | VARCHAR | |
| 33 | metrics.active_view_impressions | INTEGER | |
| 34 | metrics.video_view_rate | DOUBLE | |
| 35 | metrics.clicks | INTEGER | |
| 36 | customer.manager | BOOLEAN | |
| 37 | metrics.all_conversions_from_interactions_rate | DOUBLE | |
| 38 | metrics.search_exact_match_impression_share | DOUBLE | |
| 39 | metrics.active_view_measurable_impressions | INTEGER | |
| 40 | metrics.cost_per_conversion | DOUBLE | |
| 41 | metrics.active_view_measurability | DOUBLE | |
| 42 | metrics.average_cpc | DOUBLE | |
| 43 | metrics.average_cpe | DOUBLE | |
| 44 | metrics.conversions_value | DOUBLE | |
| 45 | metrics.average_cost | DOUBLE | |
| 46 | segments.ad_network_type | VARCHAR | |
| 47 | metrics.active_view_viewability | DOUBLE | |
| 48 | metrics.value_per_all_conversions | DOUBLE | |
| 49 | metrics.all_conversions_value | DOUBLE | |
| 50 | customer.auto_tagging_enabled | BOOLEAN | |
| 51 | customer.descriptive_name | VARCHAR | |
| 52 | customer.id | INTEGER | |
| 53 | metrics.search_impression_share | DOUBLE | |
| 54 | metrics.value_per_conversion | DOUBLE | |
| 55 | metrics.active_view_measurable_cost_micros | INTEGER | |
| 56 | metrics.cost_per_all_conversions | DOUBLE | |
| 57 | segments.date | VARCHAR | Incremental sync key |
Table: ad_group_ad_labels
| No | Column Name | Type | Notes |
|---|---|---|---|
| 1 | ad_group_ad_label.resource_name | VARCHAR | Primary Key |
| 2 | ad_group_ad.ad.resource_name | VARCHAR | |
| 3 | label.resource_name | VARCHAR | |
| 4 | label.name | VARCHAR |
Table: user_location_report
| No | Column Name | Type | Notes |
|---|---|---|---|
| 1 | campaign.base_campaign | VARCHAR | |
| 2 | metrics.conversions | DOUBLE | |
| 3 | segments.month | VARCHAR | |
| 4 | metrics.interactions | DOUBLE | |
| 5 | segments.year | INTEGER | |
| 6 | customer.currency_code | VARCHAR | |
| 7 | metrics.average_cpm | DOUBLE | |
| 8 | customer.time_zone | VARCHAR | |
| 9 | metrics.interaction_event_types | VARCHAR | |
| 10 | metrics.average_cpv | DOUBLE | |
| 11 | campaign.id | INTEGER | |
| 12 | metrics.all_conversions | DOUBLE | |
| 13 | segments.week | VARCHAR | |
| 14 | ad_group.name | VARCHAR | |
| 15 | metrics.video_view_rate | DOUBLE | |
| 16 | metrics.clicks | DOUBLE | |
| 17 | metrics.all_conversions_from_interactions_rate | DOUBLE | |
| 18 | user_location_view.country_criterion_id | INTEGER | |
| 19 | user_location_view.resource_name | VARCHAR | |
| 20 | ad_group.status | VARCHAR | |
| 21 | segments.day_of_week | VARCHAR | |
| 22 | segments.quarter | VARCHAR | |
| 23 | metrics.cost_per_conversion | DOUBLE | |
| 24 | metrics.average_cpc | DOUBLE | |
| 25 | metrics.ctr | DOUBLE | |
| 26 | metrics.conversions_value | DOUBLE | |
| 27 | metrics.average_cost | DOUBLE | |
| 28 | segments.ad_network_type | VARCHAR | |
| 29 | metrics.interaction_rate | DOUBLE | |
| 30 | metrics.impressions | DOUBLE | |
| 31 | metrics.value_per_all_conversions | DOUBLE | |
| 32 | metrics.view_through_conversions | DOUBLE | |
| 33 | metrics.all_conversions_value | DOUBLE | |
| 34 | campaign.name | VARCHAR | |
| 35 | metrics.video_views | DOUBLE | |
| 36 | customer.descriptive_name | VARCHAR | |
| 37 | campaign.status | VARCHAR | |
| 38 | customer.id | INTEGER | |
| 39 | metrics.value_per_conversion | DOUBLE | |
| 40 | metrics.cross_device_conversions | DOUBLE | |
| 41 | ad_group.base_ad_group | VARCHAR | |
| 42 | metrics.conversions_from_interactions_rate | DOUBLE | |
| 43 | metrics.cost_micros | DOUBLE | |
| 44 | segments.date | VARCHAR | Incremental sync key |
| 45 | metrics.cost_per_all_conversions | DOUBLE |
External Resources
- Google Ads Account
- Linked
- Google Ads Manager Account
- Google's Instructions
- Customer Id(s)
- Login Customer Id For Managed Accounts
- Conversion Window
- Client Id, Client Secret, Refresh Token, And Optionally, The Access Token
- Keyword
- Geographic
- Display_keyword_report
- Display_topics_report
- Metrics
- Date
- Limitations
- Google Ads Query Language
- Query Builder
- Selectability Between Segments And Metrics
- Google Ads Api Limits
Zipstack Cloud features a powerful SQL querying engine on top of many types of connectors, including those from Trino, some custom connectors and connectors from the open source Airbyte project. Some Zipstack cloud connectors are designed to utilize and expand upon Airbyte's connector protocol, but they do not use Airbyte's EL core. Additionally, some parts of the documentation for these connectors have been adapted from the connector documentation found in Airbyte's open source project.