Skip to content
Book a demoStart free
Connectors

Google Ads connector

Set up the Google Ads connector in Kaivo: authentication, configuration, the 27 BigQuery tables it syncs, and answers to common questions.

Google Ads connector pricing, tier and credits on kaivo.io

Kaivo is a fully managed data platform that syncs your Google Ads data into a Google BigQuery warehouse and keeps it up to date automatically. There is no pipeline to build and no infrastructure to run, so you can spend your time analysing your marketing and sales data instead of moving it.

Sync your Google Ads campaigns, spend, and conversions into BigQuery with Kaivo to track performance alongside your other marketing channels.

CategoryMarketing & Sales
AuthenticationOAuth
SetupSelf-service

Getting started with the Google Ads connector

Section titled “Getting started with the Google Ads connector”
  1. Sign up for Kaivo and create a workspace.
  2. Connect your Google Ads account.
  3. Choose which tables to sync.
  4. Wait for the initial sync to finish.
  5. Query your data in BigQuery or your favourite AI or BI tool.

Connect by signing in to your Google account. Kaivo runs the connection for you, so you never share a password.

When you set up the connector, you provide:

Field Description
Customer ID
Specify the account where we should fetch data as a 10-digit number without dashes.

Where can I find Google Ads Customer ID?

  1. Sign in to your Google Ads account.
  2. Click the help icon in the top right corner.
  3. Find “Customer ID” at the bottom of the menu.For detailed instructions on finding this value, you can check Google’s documentation.

| | Start Date |

Any data before this date will not be fetched.

| | Conversion Window |

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.

|

Kaivo syncs 27 tables from Google Ads into a dedicated dataset in your BigQuery warehouse. Click any table to see its columns and types.

account_performance_report (58 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
customer_currency_code STRING The currency code used for the customer’s account
customer_descriptive_name STRING The descriptive name assigned to the customer account
customer_time_zone STRING The time zone setting for the customer account
metrics_active_view_cpm FLOAT64 Cost per thousand active viewable impressions
metrics_active_view_ctr FLOAT64 Active view click-through rate
metrics_active_view_impressions INT64 Number of active view viewable impressions
metrics_active_view_measurability FLOAT64 Active view measurability percentage
metrics_active_view_measurable_cost_micros INT64 Cost for active view measurable impressions
metrics_active_view_measurable_impressions INT64 Number of active view measurable impressions
metrics_active_view_viewability FLOAT64 Active view viewability percentage
segments_ad_network_type STRING Type of ad network
metrics_all_conversions_from_interactions_rate FLOAT64 Rate of conversions from interactions
metrics_all_conversions_value FLOAT64 Total value of all conversions
metrics_all_conversions FLOAT64 Total number of conversions
metrics_average_cost FLOAT64 Average cost per click
metrics_average_cpc FLOAT64 Average cost per click
metrics_average_cpe FLOAT64 Average cost per engagement
metrics_average_cpm FLOAT64 Average cost per thousand impressions
metrics_trueview_average_cpv FLOAT64 Average cost per view
customer_manager BOOL The manager assigned to the customer account
metrics_clicks INT64 Total number of clicks
metrics_content_budget_lost_impression_share FLOAT64 Percentage of budget lost due to content network impressions
metrics_content_impression_share FLOAT64 Impression share on the content network
metrics_content_rank_lost_impression_share FLOAT64 Percentage of rank lost due to content network impressions
… and 33 more columns

Repeating fields are split into their own tables, listed here with their column counts.

  • account_performance_report__metrics_interaction_event_types (4 columns)
ad_group (28 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
campaign_id INT64 The unique identifier of the campaign to which the ad group belongs.
ad_group_ad_rotation_mode STRING The rotation mode for ads within the ad group.
ad_group_base_ad_group STRING The base ad group associated with this ad group.
ad_group_campaign STRING The campaign to which the ad group belongs.
metrics_cost_micros INT64 The cost in micros for the ad group.
ad_group_cpc_bid_micros INT64 The cost-per-click bid for the ad group in micros.
ad_group_cpm_bid_micros INT64 The cost-per-thousand impressions bid for the ad group in micros.
ad_group_cpv_bid_micros INT64 The cost-per-view bid for the ad group in micros.
ad_group_display_custom_bid_dimension STRING Custom bid dimension settings for the display network.
ad_group_effective_target_cpa_micros INT64 The effective target cost-per-acquisition bid in micros.
ad_group_effective_target_cpa_source STRING The source of the effective target CPA bid.
ad_group_effective_target_roas FLOAT64 The effective target return on ad spend bid.
ad_group_effective_target_roas_source STRING The source of the effective target ROAS bid.
ad_group_optimized_targeting_enabled BOOL Indicates whether optimized targeting is enabled for the ad group.
ad_group_final_url_suffix STRING The final URL suffix for the ad group.
ad_group_id INT64 The unique identifier for the ad group.
ad_group_name STRING The name of the ad group.
ad_group_percent_cpc_bid_micros INT64 The percentage of the cost-per-click bid that is paid for the ad group.
ad_group_resource_name STRING The resource name of the ad group.
ad_group_status STRING The status of the ad group.
ad_group_target_cpa_micros INT64 The target cost-per-acquisition bid in micros for the ad group.
ad_group_target_cpm_micros INT64 The target cost-per-thousand impressions bid in micros for the ad group.
ad_group_target_roas FLOAT64 The target return on ad spend bid for the ad group.
ad_group_tracking_url_template STRING The tracking URL template for the ad group.
… and 3 more columns

Repeating fields are split into their own tables, listed here with their column counts.

  • ad_group__ad_group_excluded_parent_asset_field_types (4 columns)
  • ad_group__ad_group_labels (4 columns)
  • ad_group__ad_group_targeting_setting_target_restrictions (4 columns)
  • ad_group__ad_group_url_custom_parameters (4 columns)
ad_group_ad (85 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
ad_group_id INT64 The ID of the ad group this ad belongs to.
ad_group_ad_ad_added_by_google_ads BOOL Specifies whether the ad was created by Google Ads.
ad_group_ad_ad_app_ad_mandatory_ad_text STRING Mandatory text for App ads.
ad_group_ad_ad_device_preference STRING The device preference for the ad.
ad_group_ad_ad_display_upload_ad_display_upload_product_type STRING The product type for display upload ads.
ad_group_ad_ad_display_upload_ad_media_bundle STRING The media bundle for display upload ads.
ad_group_ad_ad_display_url STRING The display URL for the ad.
ad_group_ad_ad_expanded_dynamic_search_ad_description STRING Description for Expanded Dynamic Search ads.
ad_group_ad_ad_expanded_dynamic_search_ad_description2 STRING Additional description for Expanded Dynamic Search ads.
ad_group_ad_ad_expanded_text_ad_description STRING Description for Expanded Text ads.
ad_group_ad_ad_expanded_text_ad_description2 STRING Additional description for Expanded Text ads.
ad_group_ad_ad_expanded_text_ad_headline_part1 STRING Headline part 1 for Expanded Text ads.
ad_group_ad_ad_expanded_text_ad_headline_part2 STRING Headline part 2 for Expanded Text ads.
ad_group_ad_ad_expanded_text_ad_headline_part3 STRING Headline part 3 for Expanded Text ads.
ad_group_ad_ad_expanded_text_ad_path1 STRING Path field 1 for Expanded Text ads.
ad_group_ad_ad_expanded_text_ad_path2 STRING Path field 2 for Expanded Text ads.
ad_group_ad_ad_final_url_suffix STRING The final URL suffix for the ad.
ad_group_ad_ad_hotel_ad STRING Representation of a hotel ad.
ad_group_ad_ad_id INT64 The ID of the ad.
ad_group_ad_ad_image_ad_image_url STRING The URL of the image for Image ads.
ad_group_ad_ad_image_ad_mime_type STRING The MIME type of the image for Image ads.
ad_group_ad_ad_image_ad_name STRING The name of the image for Image ads.
ad_group_ad_ad_image_ad_pixel_height INT64 The pixel height of the image for Image ads.
ad_group_ad_ad_image_ad_pixel_width INT64 The pixel width of the image for Image ads.
… and 60 more columns

Repeating fields are split into their own tables, listed here with their column counts.

  • ad_group_ad__ad_group_ad_ad_app_ad_descriptions (4 columns)
  • ad_group_ad__ad_group_ad_ad_app_ad_headlines (4 columns)
  • ad_group_ad__ad_group_ad_ad_app_ad_html5_media_bundles (4 columns)
  • ad_group_ad__ad_group_ad_ad_app_ad_images (4 columns)
  • ad_group_ad__ad_group_ad_ad_app_ad_youtube_videos (4 columns)
  • ad_group_ad__ad_group_ad_ad_app_engagement_ad_descriptions (4 columns)
  • ad_group_ad__ad_group_ad_ad_app_engagement_ad_headlines (4 columns)
  • ad_group_ad__ad_group_ad_ad_app_engagement_ad_images (4 columns)
  • ad_group_ad__ad_group_ad_ad_app_engagement_ad_videos (4 columns)
  • ad_group_ad__ad_group_ad_ad_final_app_urls (4 columns)
  • ad_group_ad__ad_group_ad_ad_final_mobile_urls (4 columns)
  • ad_group_ad__ad_group_ad_ad_final_urls (4 columns)
  • ad_group_ad__ad_group_ad_ad_local_ad_call_to_actions (4 columns)
  • ad_group_ad__ad_group_ad_ad_local_ad_descriptions (4 columns)
  • ad_group_ad__ad_group_ad_ad_local_ad_headlines (4 columns)
  • ad_group_ad__ad_group_ad_ad_local_ad_logo_images (4 columns)
  • ad_group_ad__ad_group_ad_ad_local_ad_marketing_images (4 columns)
  • ad_group_ad__ad_group_ad_ad_local_ad_videos (4 columns)
  • ad_group_ad__ad_group_ad_ad_responsive_display_ad_descriptions (4 columns)
  • ad_group_ad__ad_group_ad_ad_responsive_display_ad_headlines (4 columns)
  • ad_group_ad__ad_group_ad_ad_responsive_display_ad_logo_images (4 columns)
  • ad_group_ad__ad_group_ad_ad_responsive_display_ad_marketing_images (4 columns)
  • ad_group_ad__ad_group_ad_ad_responsive_display_ad_square_logo_images (4 columns)
  • ad_group_ad__ad_group_ad_ad_responsive_display_ad_square_marketing_images (4 columns)
  • ad_group_ad__ad_group_ad_ad_responsive_display_ad_youtube_videos (4 columns)
  • ad_group_ad__ad_group_ad_ad_responsive_search_ad_descriptions (4 columns)
  • ad_group_ad__ad_group_ad_ad_responsive_search_ad_headlines (4 columns)
  • ad_group_ad__ad_group_ad_ad_smart_campaign_ad_descriptions (4 columns)
  • ad_group_ad__ad_group_ad_ad_smart_campaign_ad_headlines (4 columns)
  • ad_group_ad__ad_group_ad_ad_url_collections (4 columns)
  • ad_group_ad__ad_group_ad_ad_url_custom_parameters (4 columns)
  • ad_group_ad__ad_group_ad_ad_video_responsive_ad_call_to_actions (4 columns)
  • ad_group_ad__ad_group_ad_ad_video_responsive_ad_companion_banners (4 columns)
  • ad_group_ad__ad_group_ad_ad_video_responsive_ad_descriptions (4 columns)
  • ad_group_ad__ad_group_ad_ad_video_responsive_ad_headlines (4 columns)
  • ad_group_ad__ad_group_ad_ad_video_responsive_ad_long_headlines (4 columns)
  • ad_group_ad__ad_group_ad_ad_video_responsive_ad_videos (4 columns)
  • ad_group_ad__ad_group_ad_labels (4 columns)
  • ad_group_ad__ad_group_ad_policy_summary_policy_topic_entries (4 columns)
ad_group_ad_label (9 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
ad_group_id INT64 The ID of the Ad Group to which the ad belongs.
ad_group_ad_ad_id INT64 The ID of the Ad associated with the Ad Group Ad.
ad_group_ad_ad_resource_name STRING The resource name of the Ad associated with the Ad Group Ad.
ad_group_ad_label_resource_name STRING The resource name of the Ad Group Ad Label.
label_name STRING The name of the label associated with the Ad Group Ad.
label_resource_name STRING The resource name of the label associated with the Ad Group Ad.
label_id INT64 The ID of the label associated with the Ad Group Ad.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
ad_group_ad_legacy (124 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
ad_group_ad_ad_legacy_responsive_display_ad_accent_color STRING Accent color for the legacy responsive display ad.
ad_group_id INT64 The ID of the ad group.
customer_currency_code STRING The currency code of the customer.
customer_descriptive_name STRING The descriptive name of the customer.
customer_time_zone STRING The time zone of the customer.
metrics_active_view_cpm FLOAT64 Cost per thousand active viewable impressions.
metrics_active_view_ctr FLOAT64 Active view click-through rate.
metrics_active_view_impressions INT64 Number of active viewable impressions.
metrics_active_view_measurability FLOAT64 Measurability of active view impressions.
metrics_active_view_measurable_cost_micros INT64 Cost of measurable active viewable impressions.
metrics_active_view_measurable_impressions INT64 Number of measurable active viewable impressions.
metrics_active_view_viewability FLOAT64 Viewability of active view impressions.
ad_group_ad_ad_group STRING The ad group associated with the ad group ad data.
ad_group_name STRING The name of the ad group.
ad_group_status STRING The status of the ad group.
segments_ad_network_type STRING Type of ad network where the ad was displayed.
ad_group_ad_ad_strength STRING Strength of the ad.
ad_group_ad_ad_type STRING The type of the ad.
metrics_all_conversions_from_interactions_rate FLOAT64 Rate of all conversions from interactions.
metrics_all_conversions_value FLOAT64 Total value of all conversions.
metrics_all_conversions FLOAT64 Total number of all conversions.
ad_group_ad_ad_legacy_responsive_display_ad_allow_flexible_color BOOL Flag indicating if flexible color is allowed for the legacy responsive display ad.
ad_group_ad_ad_added_by_google_ads BOOL Flag indicating if the ad was added by Google Ads.
metrics_average_cost FLOAT64 Average cost per click.
… and 99 more columns

Repeating fields are split into their own tables, listed here with their column counts.

  • ad_group_ad_legacy__ad_group_ad_ad_final_mobile_urls (4 columns)
  • ad_group_ad_legacy__ad_group_ad_ad_final_urls (4 columns)
  • ad_group_ad_legacy__ad_group_ad_ad_url_custom_parameters (4 columns)
  • ad_group_ad_legacy__metrics_interaction_event_types (4 columns)
  • ad_group_ad_legacy__ad_group_ad_ad_responsive_display_ad_descriptions (4 columns)
  • ad_group_ad_legacy__ad_group_ad_ad_responsive_display_ad_headlines (4 columns)
  • ad_group_ad_legacy__ad_group_ad_ad_responsive_display_ad_logo_images (4 columns)
  • ad_group_ad_legacy__ad_group_ad_ad_responsive_display_ad_square_logo_images (4 columns)
  • ad_group_ad_legacy__ad_group_ad_ad_responsive_display_ad_marketing_images (4 columns)
  • ad_group_ad_legacy__ad_group_ad_ad_responsive_display_ad_square_marketing_images (4 columns)
  • ad_group_ad_legacy__ad_group_ad_ad_responsive_display_ad_youtube_videos (4 columns)
  • ad_group_ad_legacy__ad_group_ad_ad_responsive_search_ad_descriptions (4 columns)
  • ad_group_ad_legacy__ad_group_ad_ad_responsive_search_ad_headlines (4 columns)
  • ad_group_ad_legacy__ad_group_ad_ad_app_ad_descriptions (4 columns)
  • ad_group_ad_legacy__ad_group_ad_ad_app_ad_headlines (4 columns)
  • ad_group_ad_legacy__ad_group_ad_ad_app_ad_html5_media_bundles (4 columns)
  • ad_group_ad_legacy__ad_group_ad_ad_app_ad_images (4 columns)
  • ad_group_ad_legacy__ad_group_ad_ad_app_ad_youtube_videos (4 columns)
ad_group_bidding_strategy (32 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
ad_group_id INT64 The ID of the ad group to which the bidding strategy belongs.
bidding_strategy_aligned_campaign_budget_id INT64 The ID of the campaign budget aligned with the bidding strategy.
bidding_strategy_campaign_count INT64 The count of campaigns using this bidding strategy.
bidding_strategy_currency_code STRING The currency code used for the bidding strategy.
bidding_strategy_effective_currency_code STRING The effective currency code for the bidding strategy.
bidding_strategy_enhanced_cpc STRING Flag indicating if Enhanced CPC is enabled for the bidding strategy.
bidding_strategy_id INT64 The ID of the bidding strategy.
bidding_strategy_maximize_conversion_value_cpc_bid_ceiling_micros INT64 The maximum CPC bid ceiling in micros for maximize conversion value strategy.
bidding_strategy_maximize_conversion_value_cpc_bid_floor_micros INT64 The minimum CPC bid floor in micros for maximize conversion value strategy.
bidding_strategy_maximize_conversion_value_target_roas FLOAT64 The target return on ad spend for maximize conversion value strategy.
bidding_strategy_maximize_conversions_cpc_bid_ceiling_micros INT64 The maximum CPC bid ceiling in micros for maximize conversions strategy.
bidding_strategy_maximize_conversions_cpc_bid_floor_micros INT64 The minimum CPC bid floor in micros for maximize conversions strategy.
bidding_strategy_maximize_conversions_target_cpa_micros INT64 The target cost per acquisition in micros for maximize conversions strategy.
bidding_strategy_name STRING The name of the bidding strategy.
bidding_strategy_non_removed_campaign_count INT64 The count of non-removed campaigns using this bidding strategy.
bidding_strategy_resource_name STRING The resource name of the bidding strategy.
bidding_strategy_status STRING The status of the bidding strategy (e.g., enabled or paused).
bidding_strategy_target_cpa_cpc_bid_ceiling_micros INT64 The maximum CPC bid ceiling in micros for target CPA strategy.
bidding_strategy_target_cpa_cpc_bid_floor_micros INT64 The minimum CPC bid floor in micros for target CPA strategy.
bidding_strategy_target_cpa_target_cpa_micros INT64 The target cost per acquisition in micros for target CPA strategy.
bidding_strategy_target_impression_share_cpc_bid_ceiling_micros INT64 The maximum CPC bid ceiling in micros for target impression share strategy.
bidding_strategy_target_impression_share_location STRING The targeted location for the impression share strategy.
bidding_strategy_target_impression_share_location_fraction_micros INT64 The targeted impression share fraction in micros.
bidding_strategy_target_roas_cpc_bid_ceiling_micros INT64 The maximum CPC bid ceiling in micros for target ROAS strategy.
… and 7 more columns
ad_group_criterion (61 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
deleted_at STRING The date when the ad group criterion was deleted.
change_status_last_change_date_time STRING The date and time of the last change made to the ad group criterion.
ad_group_id INT64 The ID of the ad group associated with the ad group criterion.
ad_group_criterion_ad_group STRING The ad group to which the ad group criterion belongs.
ad_group_criterion_age_range_type STRING The age range targeting type for the ad group criterion.
ad_group_criterion_app_payment_model_type STRING The app payment model type for the ad group criterion.
ad_group_criterion_approval_status STRING The approval status of the ad group criterion.
ad_group_criterion_audience_audience STRING The audience targeting for the ad group criterion.
ad_group_criterion_bid_modifier FLOAT64 The bid modifier for the ad group criterion.
ad_group_criterion_combined_audience_combined_audience STRING The combined audience targeting for the ad group criterion.
ad_group_criterion_cpc_bid_micros INT64 The CPC bid amount in micros for the ad group criterion.
ad_group_criterion_cpm_bid_micros INT64 The CPM bid amount in micros for the ad group criterion.
ad_group_criterion_cpv_bid_micros INT64 The CPV bid amount in micros for the ad group criterion.
ad_group_criterion_criterion_id INT64 The ID of the ad group criterion.
ad_group_criterion_custom_affinity_custom_affinity STRING The custom affinity targeting for the ad group criterion.
ad_group_criterion_custom_audience_custom_audience STRING The custom audience targeting for the ad group criterion.
ad_group_criterion_custom_intent_custom_intent STRING The custom intent targeting for the ad group criterion.
ad_group_criterion_display_name STRING The display name of the ad group criterion.
ad_group_criterion_effective_cpc_bid_micros INT64 The effective CPC bid amount in micros for the ad group criterion.
ad_group_criterion_effective_cpc_bid_source STRING The source of the effective CPC bid for the ad group criterion.
ad_group_criterion_effective_cpm_bid_micros INT64 The effective CPM bid amount in micros for the ad group criterion.
ad_group_criterion_effective_cpm_bid_source STRING The source of the effective CPM bid for the ad group criterion.
ad_group_criterion_effective_cpv_bid_micros INT64 The effective CPV bid amount in micros for the ad group criterion.
ad_group_criterion_effective_cpv_bid_source STRING The source of the effective CPV bid for the ad group criterion.
… and 36 more columns

Repeating fields are split into their own tables, listed here with their column counts.

  • ad_group_criterion__ad_group_criterion_disapproval_reasons (4 columns)
  • ad_group_criterion__ad_group_criterion_final_mobile_urls (4 columns)
  • ad_group_criterion__ad_group_criterion_final_urls (4 columns)
  • ad_group_criterion__ad_group_criterion_labels (4 columns)
  • ad_group_criterion__ad_group_criterion_topic_path (4 columns)
  • ad_group_criterion__ad_group_criterion_url_custom_parameters (4 columns)
  • ad_group_criterion__ad_group_criterion_webpage_conditions (4 columns)
  • ad_group_criterion__ad_group_criterion_webpage_sample_sample_urls (4 columns)
ad_group_criterion_label (8 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
ad_group_id INT64 The ID of the ad group to which the criterion label belongs.
label_id INT64 The ID of the label assigned to the ad group criterion.
ad_group_criterion_label_ad_group_criterion STRING The ad group criterion to which the label is applied.
ad_group_criterion_label_label STRING The label assigned to the ad group criterion.
ad_group_criterion_label_resource_name STRING The resource name of the ad group criterion label.
ad_group_criterion_criterion_id INT64 The ID of the criterion associated with the ad group.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
ad_group_label (8 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
ad_group_id INT64 The unique identifier of the ad group.
label_id INT64 The unique identifier of the label.
ad_group_resource_name STRING The resource name of the ad group.
ad_group_label_resource_name STRING The resource name of the ad group label.
label_name STRING The name of the label.
label_resource_name STRING The resource name of the label.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
ad_listing_group_criterion (28 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
deleted_at STRING The timestamp indicating when the ad group criterion was deleted, if applicable.
change_status_last_change_date_time STRING The date and time of the last change made to the ad group criterion.
ad_group_criterion_resource_name STRING The resource name of the ad group criterion.
ad_group_id INT64 The ID of the ad group associated with the criterion.
ad_group_criterion_criterion_id INT64 The ID of the criterion defining the ad group criterion.
ad_group_criterion_listing_group_case_value_activity_country_value STRING The country where the activity related to the ad group criterion takes place.
ad_group_criterion_listing_group_case_value_activity_id_value STRING The ID of the activity related to the ad group criterion.
ad_group_criterion_listing_group_case_value_activity_rating_value INT64 The rating of the activity related to the ad group criterion.
ad_group_criterion_listing_group_case_value_hotel_city_city_criterion STRING The city where the hotel related to the ad group criterion is located.
ad_group_criterion_listing_group_case_value_hotel_class_value INT64 The class of the hotel related to the ad group criterion.
ad_group_criterion_listing_group_case_value_hotel_country_region_country_region_criterion STRING The country region where the hotel related to the ad group criterion is located.
ad_group_criterion_listing_group_case_value_hotel_id_value STRING The ID of the hotel related to the ad group criterion.
ad_group_criterion_listing_group_case_value_hotel_state_state_criterion STRING The state where the hotel related to the ad group criterion is located.
ad_group_criterion_listing_group_case_value_product_category_category_id INT64 The ID of the category to which the product related to the ad group criterion belongs.
ad_group_criterion_listing_group_case_value_product_category_level STRING The category level of the product related to the ad group criterion.
ad_group_criterion_listing_group_case_value_product_brand_value STRING The brand of the product related to the ad group criterion.
ad_group_criterion_listing_group_case_value_product_channel_channel STRING The channel where the product related to the ad group criterion is sold.
ad_group_criterion_listing_group_case_value_product_channel_exclusivity_channel_exclusivity STRING The exclusivity level of the product on its distribution channel related to the ad group criterion.
ad_group_criterion_listing_group_case_value_product_condition_condition STRING The condition of the product related to the ad group criterion.
ad_group_criterion_listing_group_case_value_product_custom_attribute_index STRING The custom attribute index of the product related to the ad group criterion.
ad_group_criterion_listing_group_case_value_product_custom_attribute_value STRING The custom attribute value of the product related to the ad group criterion.
ad_group_criterion_listing_group_case_value_product_item_id_value STRING The ID of the product item related to the ad group criterion.
ad_group_criterion_listing_group_case_value_product_type_level STRING The level of product type related to the ad group criterion.
ad_group_criterion_listing_group_case_value_product_type_value STRING The value of the product type related to the ad group criterion.
… and 3 more columns
audience (9 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
customer_id INT64 Unique identifier for the customer associated with the audience segment.
audience_description STRING Description of the audience segment, providing more details about the specific audience group.
audience_exclusion_dimension STRING Dimension used to exclude specific criteria from targeting this audience.
audience_id INT64 Unique identifier for the audience segment.
audience_name STRING Name or title given to the audience segment.
audience_resource_name STRING Resource name associated with the audience segment.
audience_status STRING Status of the audience segment indicating if it is active or inactive.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Repeating fields are split into their own tables, listed here with their column counts.

  • audience__audience_dimensions (4 columns)
campaign (90 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
campaign_accessible_bidding_strategy STRING The accessible bidding strategy of the campaign.
campaign_ad_serving_optimization_status STRING The optimization status for serving ads within the campaign.
campaign_advertising_channel_sub_type STRING The sub-type of advertising channel for the campaign.
campaign_advertising_channel_type STRING The type of advertising channel for the campaign.
campaign_app_campaign_setting_app_id STRING The ID of the app associated with the app campaign setting.
campaign_app_campaign_setting_app_store STRING The app store for the mobile app associated with the app campaign setting.
campaign_app_campaign_setting_bidding_strategy_goal_type STRING The goal type for the app campaign’s bidding strategy.
campaign_base_campaign STRING The base campaign linked to the current campaign.
campaign_bidding_strategy STRING The bidding strategy used for the campaign.
campaign_bidding_strategy_type STRING The type of bidding strategy employed for the campaign.
campaign_campaign_budget STRING The budget allocated for the campaign.
campaign_budget_amount_micros INT64 The budget amount in micros allocated for the campaign.
campaign_commission_commission_rate_micros INT64 The commission rate in micros for the campaign.
campaign_dynamic_search_ads_setting_domain_name STRING The domain name set for dynamic search ads within the campaign.
campaign_dynamic_search_ads_setting_language_code STRING The language code associated with dynamic search ads.
campaign_dynamic_search_ads_setting_use_supplied_urls_only BOOL Flag indicating whether only supplied URLs are used for dynamic search ads.
campaign_end_date_time STRING The end date of the campaign.
campaign_experiment_type STRING The type of experiment conducted for the campaign.
campaign_final_url_suffix STRING The final URL suffix used for tracking in the campaign.
campaign_geo_target_type_setting_negative_geo_target_type STRING The negative geo target type settings for the campaign.
campaign_geo_target_type_setting_positive_geo_target_type STRING The positive geo target type settings for the campaign.
campaign_hotel_setting_hotel_center_id INT64 The hotel center ID associated with hotel campaigns.
campaign_id INT64 The unique identifier of the campaign.
campaign_local_campaign_setting_location_source_type STRING The source type for location targeting in local campaigns.
… and 65 more columns

Repeating fields are split into their own tables, listed here with their column counts.

  • campaign__campaign_excluded_parent_asset_field_types (4 columns)
  • campaign__campaign_frequency_caps (4 columns)
  • campaign__campaign_labels (4 columns)
  • campaign__campaign_optimization_goal_setting_optimization_goal_types (4 columns)
  • campaign__campaign_selective_optimization_conversion_actions (4 columns)
  • campaign__campaign_targeting_setting_target_restrictions (4 columns)
  • campaign__campaign_url_custom_parameters (4 columns)
  • campaign__metrics_interaction_event_types (4 columns)
campaign_bidding_strategy (33 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
customer_id INT64 The ID of the customer associated with the bidding strategy.
campaign_id INT64 The ID of the campaign associated with the bidding strategy.
bidding_strategy_aligned_campaign_budget_id INT64 The ID of the campaign budget that this bidding strategy is aligned with.
bidding_strategy_campaign_count INT64 The total count of campaigns that are using this bidding strategy.
bidding_strategy_currency_code STRING The currency code used by the bidding strategy.
bidding_strategy_effective_currency_code STRING The effective currency code applied by the bidding strategy across campaigns.
bidding_strategy_enhanced_cpc STRING Indicates if Enhanced CPC (ECPC) is enabled for this bidding strategy.
bidding_strategy_id INT64 The unique ID of the bidding strategy.
bidding_strategy_maximize_conversion_value_cpc_bid_ceiling_micros INT64 The maximum CPC bid ceiling in micros for Maximize Conversion Value strategy.
bidding_strategy_maximize_conversion_value_cpc_bid_floor_micros INT64 The minimum CPC bid floor in micros for Maximize Conversion Value strategy.
bidding_strategy_maximize_conversion_value_target_roas FLOAT64 The target Return on Ad Spend (ROAS) for Maximize Conversion Value strategy.
bidding_strategy_maximize_conversions_cpc_bid_ceiling_micros INT64 The maximum CPC bid ceiling in micros for Maximize Conversions strategy.
bidding_strategy_maximize_conversions_cpc_bid_floor_micros INT64 The minimum CPC bid floor in micros for Maximize Conversions strategy.
bidding_strategy_maximize_conversions_target_cpa_micros INT64 The target Cost per Acquisition (CPA) in micros for Maximize Conversions strategy.
bidding_strategy_name STRING The name of the bidding strategy.
bidding_strategy_non_removed_campaign_count INT64 The count of active campaigns that are using this bidding strategy.
bidding_strategy_resource_name STRING The resource name of the bidding strategy.
bidding_strategy_status STRING The status of the bidding strategy.
bidding_strategy_target_cpa_cpc_bid_ceiling_micros INT64 The maximum CPC bid ceiling in micros for Target CPA strategy.
bidding_strategy_target_cpa_cpc_bid_floor_micros INT64 The minimum CPC bid floor in micros for Target CPA strategy.
bidding_strategy_target_cpa_target_cpa_micros INT64 The target Cost per Acquisition (CPA) in micros for Target CPA strategy.
bidding_strategy_target_impression_share_cpc_bid_ceiling_micros INT64 The maximum CPC bid ceiling in micros for Target Impression Share strategy.
bidding_strategy_target_impression_share_location STRING The targeted location for Impression Share in Target Impression Share strategy.
bidding_strategy_target_impression_share_location_fraction_micros INT64 The fraction of requested location’s impressions targeted by Target Impression Share.
… and 8 more columns
campaign_budget (52 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
customer_id INT64 The ID of the customer associated with the campaign budget.
campaign_id INT64 The ID of the campaign associated with the campaign budget.
campaign_budget_aligned_bidding_strategy_id INT64 The ID of the bidding strategy aligned with the campaign budget.
campaign_budget_amount_micros INT64 The amount in micros (millionths of the currency unit) for the campaign budget.
campaign_budget_delivery_method STRING The delivery method of the campaign budget (ACCELERATED or STANDARD).
campaign_budget_explicitly_shared BOOL Indicates whether the budget is explicitly shared among multiple campaigns.
campaign_budget_has_recommended_budget BOOL Indicates if there is a recommended budget for the campaign budget.
campaign_budget_id INT64 The ID of the campaign budget.
campaign_budget_name STRING The name of the campaign budget.
campaign_budget_period STRING The time period covered by the campaign budget.
campaign_budget_recommended_budget_amount_micros INT64 The recommended amount in micros for the campaign budget.
campaign_budget_recommended_budget_estimated_change_weekly_clicks INT64 Estimated change in weekly clicks if recommended budget is applied.
campaign_budget_recommended_budget_estimated_change_weekly_cost_micros INT64 Estimated change in weekly cost in micros if recommended budget is applied.
campaign_budget_recommended_budget_estimated_change_weekly_interactions INT64 Estimated change in weekly interactions if recommended budget is applied.
campaign_budget_recommended_budget_estimated_change_weekly_views INT64 Estimated change in weekly views if recommended budget is applied.
campaign_budget_reference_count INT64 The count of references to the campaign budget.
campaign_budget_resource_name STRING The resource name of the campaign budget.
campaign_budget_status STRING The status of the campaign budget.
campaign_budget_total_amount_micros INT64 The total amount in micros of the campaign budget.
campaign_budget_type STRING The type of the campaign budget.
segments_date DATE Date segment used for filtering data.
segments_budget_campaign_association_status_campaign STRING The campaign associated with the budget and its status.
segments_budget_campaign_association_status_status STRING The status of the budget association with the campaign.
metrics_all_conversions FLOAT64 The total number of conversions for all conversion actions.
… and 27 more columns

Repeating fields are split into their own tables, listed here with their column counts.

  • campaign_budget__metrics_interaction_event_types (4 columns)
campaign_criterion (12 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
deleted_at STRING Timestamp indicating when the criterion was deleted.
change_status_last_change_date_time STRING The date and time of the last change made to the criterion.
campaign_id INT64 The unique identifier for the campaign associated with the criterion.
campaign_criterion_resource_name STRING The resource name of the criterion.
campaign_criterion_campaign STRING The specific campaign this criterion is targeting.
campaign_criterion_age_range_type STRING The age range targeting type for the criterion.
campaign_criterion_mobile_application_name STRING The name of the mobile application targeted by the criterion.
campaign_criterion_negative BOOL Indicates whether the criterion is a negative targeting criterion.
campaign_criterion_youtube_channel_channel_id STRING The YouTube channel ID targeted by the criterion.
campaign_criterion_youtube_video_video_id STRING The YouTube video ID targeted by the criterion.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
campaign_label (8 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
campaign_id INT64 The unique identifier for the campaign.
label_id INT64 The unique identifier for the label.
campaign_resource_name STRING The resource name of the campaign.
campaign_label_resource_name STRING The resource name of the relationship between a campaign and a label.
label_name STRING The name of the label.
label_resource_name STRING The resource name of the label.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
click_view (18 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
ad_group_name STRING The name of the ad group.
click_view_gclid STRING The Google Click Identifier for tracking purposes.
click_view_ad_group_ad STRING Details of the ad in the ad group that was clicked.
click_view_keyword STRING The keyword that triggered the ad click.
click_view_keyword_info_match_type STRING The match type of the keyword triggering the ad click.
click_view_keyword_info_text STRING The text of the keyword that triggered the ad click.
campaign_id INT64 The unique identifier for the campaign.
ad_group_id INT64 The unique identifier for the ad group.
segments_date DATE The date when the click occurred.
customer_id INT64 The unique identifier for the customer account.
campaign_name STRING The name of the campaign.
segments_ad_network_type STRING Type of ad network where the click originated.
campaign_network_settings_target_content_network BOOL Boolean indicating if the campaign is targeting the content network.
campaign_network_settings_target_google_search BOOL Boolean indicating if the campaign is targeting Google search.
campaign_network_settings_target_partner_search_network BOOL Boolean indicating if the campaign is targeting partner search network.
campaign_network_settings_target_search_network BOOL Boolean indicating if the campaign is targeting search network.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
customer (22 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
customer_auto_tagging_enabled BOOL Indicates whether auto-tagging is enabled for the customer
customer_call_reporting_setting_call_conversion_action STRING The call conversion action associated with the customer’s call reporting setting
customer_call_reporting_setting_call_conversion_reporting_enabled BOOL Indicates whether call conversion reporting is enabled
customer_call_reporting_setting_call_reporting_enabled BOOL Indicates whether call reporting is enabled for the customer
customer_conversion_tracking_setting_conversion_tracking_id INT64 The conversion tracking ID set for the customer
customer_conversion_tracking_setting_cross_account_conversion_tracking_id INT64 The cross-account conversion tracking ID set for the customer
customer_currency_code STRING The currency code used for the customer
customer_descriptive_name STRING The descriptive name of the customer account
customer_final_url_suffix STRING The final URL suffix for the customer
customer_has_partners_badge BOOL Indicates whether the customer has a partners badge
customer_id INT64 The unique identifier of the customer
customer_manager BOOL The manager associated with the customer
customer_optimization_score FLOAT64 The optimization score of the customer
customer_optimization_score_weight FLOAT64 The weight of the optimization score for the customer
customer_remarketing_setting_google_global_site_tag STRING The Google global site tag set for customer’s remarketing
customer_resource_name STRING The resource name of the customer
customer_test_account BOOL Indicates whether the customer account is a test account
customer_time_zone STRING The time zone set for the customer account
customer_tracking_url_template STRING The tracking URL template for the customer
segments_date DATE The date segment format
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Repeating fields are split into their own tables, listed here with their column counts.

  • customer__customer_pay_per_conversion_eligibility_failure_reasons (4 columns)
customer_label (6 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
customer_label_resource_name STRING The resource name that uniquely identifies the customer label in the system.
customer_label_customer STRING The name or details of the customer that the label is associated with.
customer_id INT64 The unique identifier of the customer associated with the label.
customer_label_label STRING The category or tag applied to the customer for specific identification or grouping.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
display_keyword_view (77 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
customer_currency_code STRING The currency code of the customer
customer_descriptive_name STRING The descriptive name of the customer
customer_time_zone STRING The time zone of the customer
metrics_active_view_cpm FLOAT64 The active view CPM metric
metrics_active_view_ctr FLOAT64 The active view CTR metric
metrics_active_view_impressions INT64 The number of active view impressions
metrics_active_view_measurability FLOAT64 The measurability of active view impressions
metrics_active_view_measurable_cost_micros INT64 The cost of meausurable active view impressions in micros
metrics_active_view_measurable_impressions INT64 The number of measurable active view impressions
metrics_active_view_viewability FLOAT64 The viewability of active view impressions
ad_group_id INT64 The ID of the ad group
ad_group_name STRING The name of the ad group
ad_group_status STRING The status of the ad group
segments_ad_network_type STRING The type of ad network
metrics_all_conversions_from_interactions_rate FLOAT64 The rate of conversions from interactions
metrics_all_conversions_value FLOAT64 The total value of all conversions
metrics_all_conversions FLOAT64 The total number of conversions
metrics_average_cost FLOAT64 The average cost per click
metrics_average_cpc FLOAT64 The average cost per click
metrics_average_cpe FLOAT64 The average cost per engagement
metrics_average_cpm FLOAT64 The average cost per thousand impressions
metrics_trueview_average_cpv FLOAT64 The average cost per view
ad_group_base_ad_group STRING The base ad group associated with the keyword
campaign_base_campaign STRING The base campaign associated with the ad group
… and 52 more columns

Repeating fields are split into their own tables, listed here with their column counts.

  • display_keyword_view__ad_group_criterion_final_mobile_urls (4 columns)
  • display_keyword_view__ad_group_criterion_final_urls (4 columns)
  • display_keyword_view__metrics_interaction_event_types (4 columns)
  • display_keyword_view__ad_group_targeting_setting_target_restrictions (4 columns)
  • display_keyword_view__ad_group_criterion_url_custom_parameters (4 columns)
geographic_view (8 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
customer_id INT64 The ID of the customer associated with the geographic view data
customer_descriptive_name STRING The descriptive name of the customer associated with the geographic view data
geographic_view_country_criterion_id INT64 The criterion ID for the country in the geographic view data
geographic_view_location_type STRING The type of location (such as city or region) in the geographic view data
ad_group_id INT64 The ID of the ad group associated with the geographic view data
segments_date DATE The date segment within the geographic view data
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
geographic_view_with_metrics (47 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
customer_id INT64 The ID of the customer associated with the geographic report data.
customer_descriptive_name STRING The descriptive name of the customer.
customer_currency_code STRING The currency code used by the customer.
customer_time_zone STRING The time zone set for the customer.
geographic_view_country_criterion_id INT64 The criterion ID for the country in the geographic view data.
geographic_view_location_type STRING The type of location (such as city or region) in the geographic view data.
geographic_view_resource_name STRING The resource name of the geographic view.
ad_group_id INT64 The ID of the ad group.
ad_group_name STRING The name of the ad group.
ad_group_status STRING The status of the ad group.
ad_group_base_ad_group STRING The base ad group resource name.
campaign_base_campaign STRING The base campaign resource name.
campaign_id INT64 The ID of the campaign.
campaign_name STRING The name of the campaign.
campaign_status STRING The status of the campaign.
segments_date DATE The date segment for the geographic report data.
segments_day_of_week STRING The day of the week.
segments_month STRING The month.
segments_week STRING The week of the year.
segments_quarter STRING The quarter of the year.
segments_year INT64 The year.
metrics_all_conversions FLOAT64 Total number of conversions for all actions.
metrics_all_conversions_from_interactions_rate FLOAT64 The rate of all conversions from interactions.
metrics_all_conversions_value FLOAT64 The total value of all conversions.
… and 22 more columns
keyword_view (27 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
customer_id INT64 The unique ID of the customer.
customer_descriptive_name STRING The name or description of the customer.
campaign_id INT64 The ID of the campaign the keyword belongs to.
ad_group_id INT64 The ID of the ad group the keyword belongs to.
ad_group_criterion_type STRING The type of the ad group criterion (e.g., keyword, placement).
ad_group_criterion_keyword_text STRING The actual text of the keyword.
ad_group_criterion_negative BOOL Specifies whether the keyword is a negative keyword.
ad_group_criterion_keyword_match_type STRING The match type of the keyword (e.g., exact, broad, phrase).
metrics_historical_quality_score INT64 The historical quality score of the keyword.
metrics_ctr FLOAT64 The click-through rate (clicks divided by impressions) for the keyword.
segments_date DATE The date when the data was recorded.
campaign_bidding_strategy_type STRING The type of bidding strategy used for the campaign.
metrics_clicks INT64 The number of clicks on the keyword.
metrics_cost_micros INT64 The cost of the keyword advertising in micros.
metrics_impressions INT64 The number of times the keyword was displayed.
metrics_active_view_impressions INT64 The number of viewable impressions.
metrics_active_view_measurability FLOAT64 The ratio of viewable impressions to the number of measurable impressions.
metrics_active_view_measurable_cost_micros INT64 The cost for measurable viewable impressions in micros.
metrics_active_view_measurable_impressions INT64 The number of impressions that were measurable for viewability.
metrics_active_view_viewability FLOAT64 The ratio of viewable impressions to measurable impressions.
metrics_conversions FLOAT64 The number of conversions attributed to the keyword.
metrics_conversions_value FLOAT64 The total value of conversions attributed to the keyword.
metrics_interactions INT64 The total number of interactions (clicks, video views, etc.) on the keyword.
metrics_view_through_conversions INT64 The number of conversions that occurred after a view of the ad without a click.
… and 2 more columns

Repeating fields are split into their own tables, listed here with their column counts.

  • keyword_view__metrics_interaction_event_types (4 columns)
label (9 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
customer_id INT64 The unique identifier of the customer associated with the label.
label_id INT64 The unique identifier of the label.
label_name STRING The name associated with the label.
label_resource_name STRING The resource name of the label.
label_status STRING The status of the label.
label_text_label_background_color STRING The background color of the text label.
label_text_label_description STRING The description associated with the text label.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
shopping_performance_view (61 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
customer_descriptive_name STRING The descriptive name of the customer account.
ad_group_id INT64 The ID of the ad group associated with the data.
ad_group_name STRING The name of the ad group associated with the data.
ad_group_status STRING The status of the ad group.
segments_ad_network_type STRING The type of ad network.
segments_product_aggregator_id INT64 The ID of the product aggregator.
metrics_all_conversions_from_interactions_rate FLOAT64 The rate of conversions from interactions.
metrics_all_conversions_value FLOAT64 The total value of all conversions.
metrics_all_conversions FLOAT64 The total number of conversions.
metrics_average_cpc FLOAT64 The average cost per click.
segments_product_brand STRING The brand of the product.
campaign_id INT64 The ID of the campaign associated with the data.
campaign_name STRING The name of the campaign associated with the data.
campaign_status STRING The status of the campaign.
segments_product_category_level1 STRING The first level product category.
segments_product_category_level2 STRING The second level product category.
segments_product_category_level3 STRING The third level product category.
segments_product_category_level4 STRING The fourth level product category.
segments_product_category_level5 STRING The fifth level product category.
segments_product_channel STRING The product channel.
segments_product_channel_exclusivity STRING The product channel exclusivity.
segments_click_type STRING The type of click.
metrics_clicks INT64 The total number of clicks.
metrics_conversions_from_interactions_rate FLOAT64 The rate of conversions from interactions.
… and 36 more columns
topic_view (76 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
topic_view_resource_name STRING The resource name of the topic view.
customer_currency_code STRING The currency code of the customer associated with the topic view.
customer_descriptive_name STRING The descriptive name of the customer associated with the topic view.
customer_time_zone STRING The time zone of the customer associated with the topic view.
metrics_active_view_cpm FLOAT64 The active view CPM metric.
metrics_active_view_ctr FLOAT64 The active view click-through rate metric.
metrics_active_view_impressions INT64 The number of active view impressions metric.
metrics_active_view_measurability FLOAT64 The active view measurability metric.
metrics_active_view_measurable_cost_micros INT64 The cost of measurable active view impressions in micros.
metrics_active_view_measurable_impressions INT64 The number of measurable active view impressions metric.
metrics_active_view_viewability FLOAT64 The active view viewability metric.
ad_group_id INT64 The ID of the ad group associated with the topic view.
ad_group_name STRING The name of the ad group associated with the topic view.
ad_group_status STRING The status of the ad group associated with the topic view.
segments_ad_network_type STRING The type of ad network segment.
metrics_all_conversions_from_interactions_rate FLOAT64 The rate of all conversions from interactions metric.
metrics_all_conversions_value FLOAT64 The value of all conversions metric.
metrics_all_conversions FLOAT64 The total number of all conversions metric.
metrics_average_cost FLOAT64 The average cost metric.
metrics_average_cpc FLOAT64 The average CPC (Cost Per Click) metric.
metrics_average_cpe FLOAT64 The average CPE (Cost Per Engagement) metric.
metrics_average_cpm FLOAT64 The average CPM (Cost Per Thousand Impressions) metric.
metrics_trueview_average_cpv FLOAT64 The average CPV (Cost Per View) metric.
ad_group_base_ad_group STRING The base ad group associated with the topic view.
… and 51 more columns

Repeating fields are split into their own tables, listed here with their column counts.

  • topic_view__ad_group_criterion_topic_path (4 columns)
  • topic_view__ad_group_criterion_final_mobile_urls (4 columns)
  • topic_view__ad_group_criterion_final_urls (4 columns)
  • topic_view__metrics_interaction_event_types (4 columns)
  • topic_view__ad_group_targeting_setting_target_restrictions (4 columns)
  • topic_view__ad_group_criterion_url_custom_parameters (4 columns)
user_location_view (47 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
segments_date DATE The date related to the user location view data.
segments_day_of_week STRING The day of the week.
segments_month STRING The month.
segments_week STRING The week of the year.
segments_quarter STRING The quarter of the year.
segments_year INT64 The year.
segments_ad_network_type STRING The type of ad network.
customer_currency_code STRING The currency code used by the customer.
customer_id INT64 The ID of the customer.
customer_descriptive_name STRING The descriptive name of the customer.
customer_time_zone STRING The time zone set for the customer.
user_location_view_country_criterion_id INT64 The country criterion ID for the user location.
user_location_view_targeting_location BOOL The targeted location for the user location view.
user_location_view_resource_name STRING The resource name associated with the user location view.
campaign_base_campaign STRING The base campaign information tied to the user location view data.
campaign_id INT64 The ID of the campaign linked to the user location view data.
campaign_name STRING The name of the campaign associated with the user location view data.
campaign_status STRING The status of the campaign related to the user location view data.
ad_group_name STRING The name of the ad group associated with the user location view data.
ad_group_status STRING The status of the ad group related to the user location view data.
ad_group_base_ad_group STRING The base ad group information related to the user location view data.
metrics_all_conversions FLOAT64 Total number of conversions for all actions.
metrics_all_conversions_from_interactions_rate FLOAT64 The rate of all conversions from interactions.
metrics_all_conversions_value FLOAT64 The total value of all conversions.
… and 22 more columns

Repeating fields are split into their own tables, listed here with their column counts.

  • user_location_view__metrics_interaction_event_types (4 columns)

After the first load, Kaivo keeps your BigQuery warehouse up to date for you. Where Google Ads supports it, each sync pulls only new and changed records so it stays fast; otherwise it refreshes the whole table. Every record keeps its original ID, so you won’t get duplicate rows.

How long does the initial sync take for Google Ads?

Section titled “How long does the initial sync take for Google Ads?”

It depends on how much history is in your Google Ads account. Most initial syncs finish within minutes, while large accounts can take a few hours. After that, syncs only fetch new and changed records, so they’re much faster.

Yes. You pick which tables to sync when you set up the connection and can change the selection later. Tables you don’t select are never copied to your warehouse.

What happens when Google Ads’s schema changes?

Section titled “What happens when Google Ads’s schema changes?”

New fields are never added automatically. You choose which fields to sync, so data you haven’t selected (sensitive personal data, for example) never lands in your warehouse. When a new field appears, it becomes available for you to add. What happens to removed or renamed fields depends on a table’s sync mode: full-refresh tables always match what’s currently in Google Ads, so dropped fields disappear, while incremental tables keep their existing columns and history, so an old field stays and newly added fields fill in over time.

How do I handle GDPR or data deletion requests?

Section titled “How do I handle GDPR or data deletion requests?”

Your data lives in your own Kaivo-managed BigQuery warehouse, so the most direct option is to delete or anonymise specific records right in BigQuery. If you delete data in Google Ads instead, full-refresh tables drop it on the next sync, while incremental tables keep it, so you would remove the row in BigQuery or ask us to run a full refresh. To remove everything, delete the Google Ads connector in Kaivo and all of its synced data is deleted with it.

Combine Google Ads spend and conversions with your other ad platforms in BigQuery for one view of marketing.

Track impressions, clicks, cost, and conversions by campaign to see what works.

Join spend with conversions to measure return on ad spend and cost per acquisition.

Monitor daily spend against budget so you can catch overspend early.

Use Google Ads data in your AI and BI tools

Section titled “Use Google Ads data in your AI and BI tools”

Once Google Ads data lands in your Kaivo-managed BigQuery warehouse, you can explore it with AI tools or any BI tool that connects to BigQuery. Here’s how the most common destinations work with Google Ads data.

Use Kaivo’s MCP server to give Claude secure, workspace-scoped access to your data. Setup guide →

Microsoft’s BI tool with a native BigQuery connector. Supports direct query and scheduled refresh. Setup guide →

Free Google BI tool with native BigQuery support. One-click connection to your Kaivo warehouse; great for SMB teams on Google Workspace. Setup guide →

The premium analytics standard, with native BigQuery integration. Setup guide →

Use Connected Sheets to query BigQuery directly from a spreadsheet, with no SQL. Setup guide →

Connect via Power Query’s BigQuery connector. Setup guide →

Open-source BI tool with strong BigQuery support. Setup guide →

See our pricing page for Google Ads connector pricing and plan details.