Skip to main content
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.

Written By Lauri Raivio

Last updated 16 days ago

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.

What is the Google Ads connector

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

  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.

Authenticating Google Ads

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

Configuring the Google Ads connector

When you set up the connector, you provide:

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

Tables and columns synced from Google Ads

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

ColumnTypeDescription
_kaivo_idSTRINGPrimary key that uniquely identifies the row. Auto-generated by Kaivo.
customer_currency_codeSTRINGThe currency code used for the customer's account
customer_descriptive_nameSTRINGThe descriptive name assigned to the customer account
customer_time_zoneSTRINGThe time zone setting for the customer account
metrics_active_view_cpmFLOAT64Cost per thousand active viewable impressions
metrics_active_view_ctrFLOAT64Active view click-through rate
metrics_active_view_impressionsINT64Number of active view viewable impressions
metrics_active_view_measurabilityFLOAT64Active view measurability percentage
metrics_active_view_measurable_cost_microsINT64Cost for active view measurable impressions
metrics_active_view_measurable_impressionsINT64Number of active view measurable impressions
metrics_active_view_viewabilityFLOAT64Active view viewability percentage
segments_ad_network_typeSTRINGType of ad network
metrics_all_conversions_from_interactions_rateFLOAT64Rate of conversions from interactions
metrics_all_conversions_valueFLOAT64Total value of all conversions
metrics_all_conversionsFLOAT64Total number of conversions
metrics_average_costFLOAT64Average cost per click
metrics_average_cpcFLOAT64Average cost per click
metrics_average_cpeFLOAT64Average cost per engagement
metrics_average_cpmFLOAT64Average cost per thousand impressions
metrics_trueview_average_cpvFLOAT64Average cost per view
customer_managerBOOLThe manager assigned to the customer account
metrics_clicksINT64Total number of clicks
metrics_content_budget_lost_impression_shareFLOAT64Percentage of budget lost due to content network impressions
metrics_content_impression_shareFLOAT64Impression share on the content network
metrics_content_rank_lost_impression_shareFLOAT64Percentage of rank lost due to content network impressions
... and 33 more columns

Nested subtables

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

  • account_performance_report__metrics_interaction_event_types (4 columns)
ColumnTypeDescription
_kaivo_idSTRINGPrimary key that uniquely identifies the row. Auto-generated by Kaivo.
campaign_idINT64The unique identifier of the campaign to which the ad group belongs.
ad_group_ad_rotation_modeSTRINGThe rotation mode for ads within the ad group.
ad_group_base_ad_groupSTRINGThe base ad group associated with this ad group.
ad_group_campaignSTRINGThe campaign to which the ad group belongs.
metrics_cost_microsINT64The cost in micros for the ad group.
ad_group_cpc_bid_microsINT64The cost-per-click bid for the ad group in micros.
ad_group_cpm_bid_microsINT64The cost-per-thousand impressions bid for the ad group in micros.
ad_group_cpv_bid_microsINT64The cost-per-view bid for the ad group in micros.
ad_group_display_custom_bid_dimensionSTRINGCustom bid dimension settings for the display network.
ad_group_effective_target_cpa_microsINT64The effective target cost-per-acquisition bid in micros.
ad_group_effective_target_cpa_sourceSTRINGThe source of the effective target CPA bid.
ad_group_effective_target_roasFLOAT64The effective target return on ad spend bid.
ad_group_effective_target_roas_sourceSTRINGThe source of the effective target ROAS bid.
ad_group_optimized_targeting_enabledBOOLIndicates whether optimized targeting is enabled for the ad group.
ad_group_final_url_suffixSTRINGThe final URL suffix for the ad group.
ad_group_idINT64The unique identifier for the ad group.
ad_group_nameSTRINGThe name of the ad group.
ad_group_percent_cpc_bid_microsINT64The percentage of the cost-per-click bid that is paid for the ad group.
ad_group_resource_nameSTRINGThe resource name of the ad group.
ad_group_statusSTRINGThe status of the ad group.
ad_group_target_cpa_microsINT64The target cost-per-acquisition bid in micros for the ad group.
ad_group_target_cpm_microsINT64The target cost-per-thousand impressions bid in micros for the ad group.
ad_group_target_roasFLOAT64The target return on ad spend bid for the ad group.
ad_group_tracking_url_templateSTRINGThe tracking URL template for the ad group.
... and 3 more columns

Nested subtables

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)
ColumnTypeDescription
_kaivo_idSTRINGPrimary key that uniquely identifies the row. Auto-generated by Kaivo.
ad_group_idINT64The ID of the ad group this ad belongs to.
ad_group_ad_ad_added_by_google_adsBOOLSpecifies whether the ad was created by Google Ads.
ad_group_ad_ad_app_ad_mandatory_ad_textSTRINGMandatory text for App ads.
ad_group_ad_ad_device_preferenceSTRINGThe device preference for the ad.
ad_group_ad_ad_display_upload_ad_display_upload_product_typeSTRINGThe product type for display upload ads.
ad_group_ad_ad_display_upload_ad_media_bundleSTRINGThe media bundle for display upload ads.
ad_group_ad_ad_display_urlSTRINGThe display URL for the ad.
ad_group_ad_ad_expanded_dynamic_search_ad_descriptionSTRINGDescription for Expanded Dynamic Search ads.
ad_group_ad_ad_expanded_dynamic_search_ad_description2STRINGAdditional description for Expanded Dynamic Search ads.
ad_group_ad_ad_expanded_text_ad_descriptionSTRINGDescription for Expanded Text ads.
ad_group_ad_ad_expanded_text_ad_description2STRINGAdditional description for Expanded Text ads.
ad_group_ad_ad_expanded_text_ad_headline_part1STRINGHeadline part 1 for Expanded Text ads.
ad_group_ad_ad_expanded_text_ad_headline_part2STRINGHeadline part 2 for Expanded Text ads.
ad_group_ad_ad_expanded_text_ad_headline_part3STRINGHeadline part 3 for Expanded Text ads.
ad_group_ad_ad_expanded_text_ad_path1STRINGPath field 1 for Expanded Text ads.
ad_group_ad_ad_expanded_text_ad_path2STRINGPath field 2 for Expanded Text ads.
ad_group_ad_ad_final_url_suffixSTRINGThe final URL suffix for the ad.
ad_group_ad_ad_hotel_adSTRINGRepresentation of a hotel ad.
ad_group_ad_ad_idINT64The ID of the ad.
ad_group_ad_ad_image_ad_image_urlSTRINGThe URL of the image for Image ads.
ad_group_ad_ad_image_ad_mime_typeSTRINGThe MIME type of the image for Image ads.
ad_group_ad_ad_image_ad_nameSTRINGThe name of the image for Image ads.
ad_group_ad_ad_image_ad_pixel_heightINT64The pixel height of the image for Image ads.
ad_group_ad_ad_image_ad_pixel_widthINT64The pixel width of the image for Image ads.
... and 60 more columns

Nested subtables

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)
ColumnTypeDescription
_kaivo_idSTRINGPrimary key that uniquely identifies the row. Auto-generated by Kaivo.
ad_group_idINT64The ID of the Ad Group to which the ad belongs.
ad_group_ad_ad_idINT64The ID of the Ad associated with the Ad Group Ad.
ad_group_ad_ad_resource_nameSTRINGThe resource name of the Ad associated with the Ad Group Ad.
ad_group_ad_label_resource_nameSTRINGThe resource name of the Ad Group Ad Label.
label_nameSTRINGThe name of the label associated with the Ad Group Ad.
label_resource_nameSTRINGThe resource name of the label associated with the Ad Group Ad.
label_idINT64The ID of the label associated with the Ad Group Ad.
_kaivo_extracted_atTIMESTAMPTimestamp that shows when the row was extracted. Auto-generated by Kaivo.
ColumnTypeDescription
_kaivo_idSTRINGPrimary key that uniquely identifies the row. Auto-generated by Kaivo.
ad_group_ad_ad_legacy_responsive_display_ad_accent_colorSTRINGAccent color for the legacy responsive display ad.
ad_group_idINT64The ID of the ad group.
customer_currency_codeSTRINGThe currency code of the customer.
customer_descriptive_nameSTRINGThe descriptive name of the customer.
customer_time_zoneSTRINGThe time zone of the customer.
metrics_active_view_cpmFLOAT64Cost per thousand active viewable impressions.
metrics_active_view_ctrFLOAT64Active view click-through rate.
metrics_active_view_impressionsINT64Number of active viewable impressions.
metrics_active_view_measurabilityFLOAT64Measurability of active view impressions.
metrics_active_view_measurable_cost_microsINT64Cost of measurable active viewable impressions.
metrics_active_view_measurable_impressionsINT64Number of measurable active viewable impressions.
metrics_active_view_viewabilityFLOAT64Viewability of active view impressions.
ad_group_ad_ad_groupSTRINGThe ad group associated with the ad group ad data.
ad_group_nameSTRINGThe name of the ad group.
ad_group_statusSTRINGThe status of the ad group.
segments_ad_network_typeSTRINGType of ad network where the ad was displayed.
ad_group_ad_ad_strengthSTRINGStrength of the ad.
ad_group_ad_ad_typeSTRINGThe type of the ad.
metrics_all_conversions_from_interactions_rateFLOAT64Rate of all conversions from interactions.
metrics_all_conversions_valueFLOAT64Total value of all conversions.
metrics_all_conversionsFLOAT64Total number of all conversions.
ad_group_ad_ad_legacy_responsive_display_ad_allow_flexible_colorBOOLFlag indicating if flexible color is allowed for the legacy responsive display ad.
ad_group_ad_ad_added_by_google_adsBOOLFlag indicating if the ad was added by Google Ads.
metrics_average_costFLOAT64Average cost per click.
... and 99 more columns

Nested subtables

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)
ColumnTypeDescription
_kaivo_idSTRINGPrimary key that uniquely identifies the row. Auto-generated by Kaivo.
ad_group_idINT64The ID of the ad group to which the bidding strategy belongs.
bidding_strategy_aligned_campaign_budget_idINT64The ID of the campaign budget aligned with the bidding strategy.
bidding_strategy_campaign_countINT64The count of campaigns using this bidding strategy.
bidding_strategy_currency_codeSTRINGThe currency code used for the bidding strategy.
bidding_strategy_effective_currency_codeSTRINGThe effective currency code for the bidding strategy.
bidding_strategy_enhanced_cpcSTRINGFlag indicating if Enhanced CPC is enabled for the bidding strategy.
bidding_strategy_idINT64The ID of the bidding strategy.
bidding_strategy_maximize_conversion_value_cpc_bid_ceiling_microsINT64The maximum CPC bid ceiling in micros for maximize conversion value strategy.
bidding_strategy_maximize_conversion_value_cpc_bid_floor_microsINT64The minimum CPC bid floor in micros for maximize conversion value strategy.
bidding_strategy_maximize_conversion_value_target_roasFLOAT64The target return on ad spend for maximize conversion value strategy.
bidding_strategy_maximize_conversions_cpc_bid_ceiling_microsINT64The maximum CPC bid ceiling in micros for maximize conversions strategy.
bidding_strategy_maximize_conversions_cpc_bid_floor_microsINT64The minimum CPC bid floor in micros for maximize conversions strategy.
bidding_strategy_maximize_conversions_target_cpa_microsINT64The target cost per acquisition in micros for maximize conversions strategy.
bidding_strategy_nameSTRINGThe name of the bidding strategy.
bidding_strategy_non_removed_campaign_countINT64The count of non-removed campaigns using this bidding strategy.
bidding_strategy_resource_nameSTRINGThe resource name of the bidding strategy.
bidding_strategy_statusSTRINGThe status of the bidding strategy (e.g., enabled or paused).
bidding_strategy_target_cpa_cpc_bid_ceiling_microsINT64The maximum CPC bid ceiling in micros for target CPA strategy.
bidding_strategy_target_cpa_cpc_bid_floor_microsINT64The minimum CPC bid floor in micros for target CPA strategy.
bidding_strategy_target_cpa_target_cpa_microsINT64The target cost per acquisition in micros for target CPA strategy.
bidding_strategy_target_impression_share_cpc_bid_ceiling_microsINT64The maximum CPC bid ceiling in micros for target impression share strategy.
bidding_strategy_target_impression_share_locationSTRINGThe targeted location for the impression share strategy.
bidding_strategy_target_impression_share_location_fraction_microsINT64The targeted impression share fraction in micros.
bidding_strategy_target_roas_cpc_bid_ceiling_microsINT64The maximum CPC bid ceiling in micros for target ROAS strategy.
... and 7 more columns
ColumnTypeDescription
_kaivo_idSTRINGPrimary key that uniquely identifies the row. Auto-generated by Kaivo.
deleted_atSTRINGThe date when the ad group criterion was deleted.
change_status_last_change_date_timeSTRINGThe date and time of the last change made to the ad group criterion.
ad_group_idINT64The ID of the ad group associated with the ad group criterion.
ad_group_criterion_ad_groupSTRINGThe ad group to which the ad group criterion belongs.
ad_group_criterion_age_range_typeSTRINGThe age range targeting type for the ad group criterion.
ad_group_criterion_app_payment_model_typeSTRINGThe app payment model type for the ad group criterion.
ad_group_criterion_approval_statusSTRINGThe approval status of the ad group criterion.
ad_group_criterion_audience_audienceSTRINGThe audience targeting for the ad group criterion.
ad_group_criterion_bid_modifierFLOAT64The bid modifier for the ad group criterion.
ad_group_criterion_combined_audience_combined_audienceSTRINGThe combined audience targeting for the ad group criterion.
ad_group_criterion_cpc_bid_microsINT64The CPC bid amount in micros for the ad group criterion.
ad_group_criterion_cpm_bid_microsINT64The CPM bid amount in micros for the ad group criterion.
ad_group_criterion_cpv_bid_microsINT64The CPV bid amount in micros for the ad group criterion.
ad_group_criterion_criterion_idINT64The ID of the ad group criterion.
ad_group_criterion_custom_affinity_custom_affinitySTRINGThe custom affinity targeting for the ad group criterion.
ad_group_criterion_custom_audience_custom_audienceSTRINGThe custom audience targeting for the ad group criterion.
ad_group_criterion_custom_intent_custom_intentSTRINGThe custom intent targeting for the ad group criterion.
ad_group_criterion_display_nameSTRINGThe display name of the ad group criterion.
ad_group_criterion_effective_cpc_bid_microsINT64The effective CPC bid amount in micros for the ad group criterion.
ad_group_criterion_effective_cpc_bid_sourceSTRINGThe source of the effective CPC bid for the ad group criterion.
ad_group_criterion_effective_cpm_bid_microsINT64The effective CPM bid amount in micros for the ad group criterion.
ad_group_criterion_effective_cpm_bid_sourceSTRINGThe source of the effective CPM bid for the ad group criterion.
ad_group_criterion_effective_cpv_bid_microsINT64The effective CPV bid amount in micros for the ad group criterion.
ad_group_criterion_effective_cpv_bid_sourceSTRINGThe source of the effective CPV bid for the ad group criterion.
... and 36 more columns

Nested subtables

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)
ColumnTypeDescription
_kaivo_idSTRINGPrimary key that uniquely identifies the row. Auto-generated by Kaivo.
ad_group_idINT64The ID of the ad group to which the criterion label belongs.
label_idINT64The ID of the label assigned to the ad group criterion.
ad_group_criterion_label_ad_group_criterionSTRINGThe ad group criterion to which the label is applied.
ad_group_criterion_label_labelSTRINGThe label assigned to the ad group criterion.
ad_group_criterion_label_resource_nameSTRINGThe resource name of the ad group criterion label.
ad_group_criterion_criterion_idINT64The ID of the criterion associated with the ad group.
_kaivo_extracted_atTIMESTAMPTimestamp that shows when the row was extracted. Auto-generated by Kaivo.
ColumnTypeDescription
_kaivo_idSTRINGPrimary key that uniquely identifies the row. Auto-generated by Kaivo.
ad_group_idINT64The unique identifier of the ad group.
label_idINT64The unique identifier of the label.
ad_group_resource_nameSTRINGThe resource name of the ad group.
ad_group_label_resource_nameSTRINGThe resource name of the ad group label.
label_nameSTRINGThe name of the label.
label_resource_nameSTRINGThe resource name of the label.
_kaivo_extracted_atTIMESTAMPTimestamp that shows when the row was extracted. Auto-generated by Kaivo.
ColumnTypeDescription
_kaivo_idSTRINGPrimary key that uniquely identifies the row. Auto-generated by Kaivo.
deleted_atSTRINGThe timestamp indicating when the ad group criterion was deleted, if applicable.
change_status_last_change_date_timeSTRINGThe date and time of the last change made to the ad group criterion.
ad_group_criterion_resource_nameSTRINGThe resource name of the ad group criterion.
ad_group_idINT64The ID of the ad group associated with the criterion.
ad_group_criterion_criterion_idINT64The ID of the criterion defining the ad group criterion.
ad_group_criterion_listing_group_case_value_activity_country_valueSTRINGThe country where the activity related to the ad group criterion takes place.
ad_group_criterion_listing_group_case_value_activity_id_valueSTRINGThe ID of the activity related to the ad group criterion.
ad_group_criterion_listing_group_case_value_activity_rating_valueINT64The rating of the activity related to the ad group criterion.
ad_group_criterion_listing_group_case_value_hotel_city_city_criterionSTRINGThe city where the hotel related to the ad group criterion is located.
ad_group_criterion_listing_group_case_value_hotel_class_valueINT64The class of the hotel related to the ad group criterion.
ad_group_criterion_listing_group_case_value_hotel_country_region_country_region_criterionSTRINGThe country region where the hotel related to the ad group criterion is located.
ad_group_criterion_listing_group_case_value_hotel_id_valueSTRINGThe ID of the hotel related to the ad group criterion.
ad_group_criterion_listing_group_case_value_hotel_state_state_criterionSTRINGThe state where the hotel related to the ad group criterion is located.
ad_group_criterion_listing_group_case_value_product_category_category_idINT64The ID of the category to which the product related to the ad group criterion belongs.
ad_group_criterion_listing_group_case_value_product_category_levelSTRINGThe category level of the product related to the ad group criterion.
ad_group_criterion_listing_group_case_value_product_brand_valueSTRINGThe brand of the product related to the ad group criterion.
ad_group_criterion_listing_group_case_value_product_channel_channelSTRINGThe channel where the product related to the ad group criterion is sold.
ad_group_criterion_listing_group_case_value_product_channel_exclusivity_channel_exclusivitySTRINGThe exclusivity level of the product on its distribution channel related to the ad group criterion.
ad_group_criterion_listing_group_case_value_product_condition_conditionSTRINGThe condition of the product related to the ad group criterion.
ad_group_criterion_listing_group_case_value_product_custom_attribute_indexSTRINGThe custom attribute index of the product related to the ad group criterion.
ad_group_criterion_listing_group_case_value_product_custom_attribute_valueSTRINGThe custom attribute value of the product related to the ad group criterion.
ad_group_criterion_listing_group_case_value_product_item_id_valueSTRINGThe ID of the product item related to the ad group criterion.
ad_group_criterion_listing_group_case_value_product_type_levelSTRINGThe level of product type related to the ad group criterion.
ad_group_criterion_listing_group_case_value_product_type_valueSTRINGThe value of the product type related to the ad group criterion.
... and 3 more columns
ColumnTypeDescription
_kaivo_idSTRINGPrimary key that uniquely identifies the row. Auto-generated by Kaivo.
customer_idINT64Unique identifier for the customer associated with the audience segment.
audience_descriptionSTRINGDescription of the audience segment, providing more details about the specific audience group.
audience_exclusion_dimensionSTRINGDimension used to exclude specific criteria from targeting this audience.
audience_idINT64Unique identifier for the audience segment.
audience_nameSTRINGName or title given to the audience segment.
audience_resource_nameSTRINGResource name associated with the audience segment.
audience_statusSTRINGStatus of the audience segment indicating if it is active or inactive.
_kaivo_extracted_atTIMESTAMPTimestamp that shows when the row was extracted. Auto-generated by Kaivo.

Nested subtables

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

  • audience__audience_dimensions (4 columns)
ColumnTypeDescription
_kaivo_idSTRINGPrimary key that uniquely identifies the row. Auto-generated by Kaivo.
campaign_accessible_bidding_strategySTRINGThe accessible bidding strategy of the campaign.
campaign_ad_serving_optimization_statusSTRINGThe optimization status for serving ads within the campaign.
campaign_advertising_channel_sub_typeSTRINGThe sub-type of advertising channel for the campaign.
campaign_advertising_channel_typeSTRINGThe type of advertising channel for the campaign.
campaign_app_campaign_setting_app_idSTRINGThe ID of the app associated with the app campaign setting.
campaign_app_campaign_setting_app_storeSTRINGThe app store for the mobile app associated with the app campaign setting.
campaign_app_campaign_setting_bidding_strategy_goal_typeSTRINGThe goal type for the app campaign's bidding strategy.
campaign_base_campaignSTRINGThe base campaign linked to the current campaign.
campaign_bidding_strategySTRINGThe bidding strategy used for the campaign.
campaign_bidding_strategy_typeSTRINGThe type of bidding strategy employed for the campaign.
campaign_campaign_budgetSTRINGThe budget allocated for the campaign.
campaign_budget_amount_microsINT64The budget amount in micros allocated for the campaign.
campaign_commission_commission_rate_microsINT64The commission rate in micros for the campaign.
campaign_dynamic_search_ads_setting_domain_nameSTRINGThe domain name set for dynamic search ads within the campaign.
campaign_dynamic_search_ads_setting_language_codeSTRINGThe language code associated with dynamic search ads.
campaign_dynamic_search_ads_setting_use_supplied_urls_onlyBOOLFlag indicating whether only supplied URLs are used for dynamic search ads.
campaign_end_date_timeSTRINGThe end date of the campaign.
campaign_experiment_typeSTRINGThe type of experiment conducted for the campaign.
campaign_final_url_suffixSTRINGThe final URL suffix used for tracking in the campaign.
campaign_geo_target_type_setting_negative_geo_target_typeSTRINGThe negative geo target type settings for the campaign.
campaign_geo_target_type_setting_positive_geo_target_typeSTRINGThe positive geo target type settings for the campaign.
campaign_hotel_setting_hotel_center_idINT64The hotel center ID associated with hotel campaigns.
campaign_idINT64The unique identifier of the campaign.
campaign_local_campaign_setting_location_source_typeSTRINGThe source type for location targeting in local campaigns.
... and 65 more columns

Nested subtables

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)
ColumnTypeDescription
_kaivo_idSTRINGPrimary key that uniquely identifies the row. Auto-generated by Kaivo.
customer_idINT64The ID of the customer associated with the bidding strategy.
campaign_idINT64The ID of the campaign associated with the bidding strategy.
bidding_strategy_aligned_campaign_budget_idINT64The ID of the campaign budget that this bidding strategy is aligned with.
bidding_strategy_campaign_countINT64The total count of campaigns that are using this bidding strategy.
bidding_strategy_currency_codeSTRINGThe currency code used by the bidding strategy.
bidding_strategy_effective_currency_codeSTRINGThe effective currency code applied by the bidding strategy across campaigns.
bidding_strategy_enhanced_cpcSTRINGIndicates if Enhanced CPC (ECPC) is enabled for this bidding strategy.
bidding_strategy_idINT64The unique ID of the bidding strategy.
bidding_strategy_maximize_conversion_value_cpc_bid_ceiling_microsINT64The maximum CPC bid ceiling in micros for Maximize Conversion Value strategy.
bidding_strategy_maximize_conversion_value_cpc_bid_floor_microsINT64The minimum CPC bid floor in micros for Maximize Conversion Value strategy.
bidding_strategy_maximize_conversion_value_target_roasFLOAT64The target Return on Ad Spend (ROAS) for Maximize Conversion Value strategy.
bidding_strategy_maximize_conversions_cpc_bid_ceiling_microsINT64The maximum CPC bid ceiling in micros for Maximize Conversions strategy.
bidding_strategy_maximize_conversions_cpc_bid_floor_microsINT64The minimum CPC bid floor in micros for Maximize Conversions strategy.
bidding_strategy_maximize_conversions_target_cpa_microsINT64The target Cost per Acquisition (CPA) in micros for Maximize Conversions strategy.
bidding_strategy_nameSTRINGThe name of the bidding strategy.
bidding_strategy_non_removed_campaign_countINT64The count of active campaigns that are using this bidding strategy.
bidding_strategy_resource_nameSTRINGThe resource name of the bidding strategy.
bidding_strategy_statusSTRINGThe status of the bidding strategy.
bidding_strategy_target_cpa_cpc_bid_ceiling_microsINT64The maximum CPC bid ceiling in micros for Target CPA strategy.
bidding_strategy_target_cpa_cpc_bid_floor_microsINT64The minimum CPC bid floor in micros for Target CPA strategy.
bidding_strategy_target_cpa_target_cpa_microsINT64The target Cost per Acquisition (CPA) in micros for Target CPA strategy.
bidding_strategy_target_impression_share_cpc_bid_ceiling_microsINT64The maximum CPC bid ceiling in micros for Target Impression Share strategy.
bidding_strategy_target_impression_share_locationSTRINGThe targeted location for Impression Share in Target Impression Share strategy.
bidding_strategy_target_impression_share_location_fraction_microsINT64The fraction of requested location's impressions targeted by Target Impression Share.
... and 8 more columns
ColumnTypeDescription
_kaivo_idSTRINGPrimary key that uniquely identifies the row. Auto-generated by Kaivo.
customer_idINT64The ID of the customer associated with the campaign budget.
campaign_idINT64The ID of the campaign associated with the campaign budget.
campaign_budget_aligned_bidding_strategy_idINT64The ID of the bidding strategy aligned with the campaign budget.
campaign_budget_amount_microsINT64The amount in micros (millionths of the currency unit) for the campaign budget.
campaign_budget_delivery_methodSTRINGThe delivery method of the campaign budget (ACCELERATED or STANDARD).
campaign_budget_explicitly_sharedBOOLIndicates whether the budget is explicitly shared among multiple campaigns.
campaign_budget_has_recommended_budgetBOOLIndicates if there is a recommended budget for the campaign budget.
campaign_budget_idINT64The ID of the campaign budget.
campaign_budget_nameSTRINGThe name of the campaign budget.
campaign_budget_periodSTRINGThe time period covered by the campaign budget.
campaign_budget_recommended_budget_amount_microsINT64The recommended amount in micros for the campaign budget.
campaign_budget_recommended_budget_estimated_change_weekly_clicksINT64Estimated change in weekly clicks if recommended budget is applied.
campaign_budget_recommended_budget_estimated_change_weekly_cost_microsINT64Estimated change in weekly cost in micros if recommended budget is applied.
campaign_budget_recommended_budget_estimated_change_weekly_interactionsINT64Estimated change in weekly interactions if recommended budget is applied.
campaign_budget_recommended_budget_estimated_change_weekly_viewsINT64Estimated change in weekly views if recommended budget is applied.
campaign_budget_reference_countINT64The count of references to the campaign budget.
campaign_budget_resource_nameSTRINGThe resource name of the campaign budget.
campaign_budget_statusSTRINGThe status of the campaign budget.
campaign_budget_total_amount_microsINT64The total amount in micros of the campaign budget.
campaign_budget_typeSTRINGThe type of the campaign budget.
segments_dateDATEDate segment used for filtering data.
segments_budget_campaign_association_status_campaignSTRINGThe campaign associated with the budget and its status.
segments_budget_campaign_association_status_statusSTRINGThe status of the budget association with the campaign.
metrics_all_conversionsFLOAT64The total number of conversions for all conversion actions.
... and 27 more columns

Nested subtables

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

  • campaign_budget__metrics_interaction_event_types (4 columns)
ColumnTypeDescription
_kaivo_idSTRINGPrimary key that uniquely identifies the row. Auto-generated by Kaivo.
deleted_atSTRINGTimestamp indicating when the criterion was deleted.
change_status_last_change_date_timeSTRINGThe date and time of the last change made to the criterion.
campaign_idINT64The unique identifier for the campaign associated with the criterion.
campaign_criterion_resource_nameSTRINGThe resource name of the criterion.
campaign_criterion_campaignSTRINGThe specific campaign this criterion is targeting.
campaign_criterion_age_range_typeSTRINGThe age range targeting type for the criterion.
campaign_criterion_mobile_application_nameSTRINGThe name of the mobile application targeted by the criterion.
campaign_criterion_negativeBOOLIndicates whether the criterion is a negative targeting criterion.
campaign_criterion_youtube_channel_channel_idSTRINGThe YouTube channel ID targeted by the criterion.
campaign_criterion_youtube_video_video_idSTRINGThe YouTube video ID targeted by the criterion.
_kaivo_extracted_atTIMESTAMPTimestamp that shows when the row was extracted. Auto-generated by Kaivo.
ColumnTypeDescription
_kaivo_idSTRINGPrimary key that uniquely identifies the row. Auto-generated by Kaivo.
campaign_idINT64The unique identifier for the campaign.
label_idINT64The unique identifier for the label.
campaign_resource_nameSTRINGThe resource name of the campaign.
campaign_label_resource_nameSTRINGThe resource name of the relationship between a campaign and a label.
label_nameSTRINGThe name of the label.
label_resource_nameSTRINGThe resource name of the label.
_kaivo_extracted_atTIMESTAMPTimestamp that shows when the row was extracted. Auto-generated by Kaivo.
ColumnTypeDescription
_kaivo_idSTRINGPrimary key that uniquely identifies the row. Auto-generated by Kaivo.
ad_group_nameSTRINGThe name of the ad group.
click_view_gclidSTRINGThe Google Click Identifier for tracking purposes.
click_view_ad_group_adSTRINGDetails of the ad in the ad group that was clicked.
click_view_keywordSTRINGThe keyword that triggered the ad click.
click_view_keyword_info_match_typeSTRINGThe match type of the keyword triggering the ad click.
click_view_keyword_info_textSTRINGThe text of the keyword that triggered the ad click.
campaign_idINT64The unique identifier for the campaign.
ad_group_idINT64The unique identifier for the ad group.
segments_dateDATEThe date when the click occurred.
customer_idINT64The unique identifier for the customer account.
campaign_nameSTRINGThe name of the campaign.
segments_ad_network_typeSTRINGType of ad network where the click originated.
campaign_network_settings_target_content_networkBOOLBoolean indicating if the campaign is targeting the content network.
campaign_network_settings_target_google_searchBOOLBoolean indicating if the campaign is targeting Google search.
campaign_network_settings_target_partner_search_networkBOOLBoolean indicating if the campaign is targeting partner search network.
campaign_network_settings_target_search_networkBOOLBoolean indicating if the campaign is targeting search network.
_kaivo_extracted_atTIMESTAMPTimestamp that shows when the row was extracted. Auto-generated by Kaivo.
ColumnTypeDescription
_kaivo_idSTRINGPrimary key that uniquely identifies the row. Auto-generated by Kaivo.
customer_auto_tagging_enabledBOOLIndicates whether auto-tagging is enabled for the customer
customer_call_reporting_setting_call_conversion_actionSTRINGThe call conversion action associated with the customer's call reporting setting
customer_call_reporting_setting_call_conversion_reporting_enabledBOOLIndicates whether call conversion reporting is enabled
customer_call_reporting_setting_call_reporting_enabledBOOLIndicates whether call reporting is enabled for the customer
customer_conversion_tracking_setting_conversion_tracking_idINT64The conversion tracking ID set for the customer
customer_conversion_tracking_setting_cross_account_conversion_tracking_idINT64The cross-account conversion tracking ID set for the customer
customer_currency_codeSTRINGThe currency code used for the customer
customer_descriptive_nameSTRINGThe descriptive name of the customer account
customer_final_url_suffixSTRINGThe final URL suffix for the customer
customer_has_partners_badgeBOOLIndicates whether the customer has a partners badge
customer_idINT64The unique identifier of the customer
customer_managerBOOLThe manager associated with the customer
customer_optimization_scoreFLOAT64The optimization score of the customer
customer_optimization_score_weightFLOAT64The weight of the optimization score for the customer
customer_remarketing_setting_google_global_site_tagSTRINGThe Google global site tag set for customer's remarketing
customer_resource_nameSTRINGThe resource name of the customer
customer_test_accountBOOLIndicates whether the customer account is a test account
customer_time_zoneSTRINGThe time zone set for the customer account
customer_tracking_url_templateSTRINGThe tracking URL template for the customer
segments_dateDATEThe date segment format
_kaivo_extracted_atTIMESTAMPTimestamp that shows when the row was extracted. Auto-generated by Kaivo.

Nested subtables

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

  • customer__customer_pay_per_conversion_eligibility_failure_reasons (4 columns)
ColumnTypeDescription
_kaivo_idSTRINGPrimary key that uniquely identifies the row. Auto-generated by Kaivo.
customer_label_resource_nameSTRINGThe resource name that uniquely identifies the customer label in the system.
customer_label_customerSTRINGThe name or details of the customer that the label is associated with.
customer_idINT64The unique identifier of the customer associated with the label.
customer_label_labelSTRINGThe category or tag applied to the customer for specific identification or grouping.
_kaivo_extracted_atTIMESTAMPTimestamp that shows when the row was extracted. Auto-generated by Kaivo.
ColumnTypeDescription
_kaivo_idSTRINGPrimary key that uniquely identifies the row. Auto-generated by Kaivo.
customer_currency_codeSTRINGThe currency code of the customer
customer_descriptive_nameSTRINGThe descriptive name of the customer
customer_time_zoneSTRINGThe time zone of the customer
metrics_active_view_cpmFLOAT64The active view CPM metric
metrics_active_view_ctrFLOAT64The active view CTR metric
metrics_active_view_impressionsINT64The number of active view impressions
metrics_active_view_measurabilityFLOAT64The measurability of active view impressions
metrics_active_view_measurable_cost_microsINT64The cost of meausurable active view impressions in micros
metrics_active_view_measurable_impressionsINT64The number of measurable active view impressions
metrics_active_view_viewabilityFLOAT64The viewability of active view impressions
ad_group_idINT64The ID of the ad group
ad_group_nameSTRINGThe name of the ad group
ad_group_statusSTRINGThe status of the ad group
segments_ad_network_typeSTRINGThe type of ad network
metrics_all_conversions_from_interactions_rateFLOAT64The rate of conversions from interactions
metrics_all_conversions_valueFLOAT64The total value of all conversions
metrics_all_conversionsFLOAT64The total number of conversions
metrics_average_costFLOAT64The average cost per click
metrics_average_cpcFLOAT64The average cost per click
metrics_average_cpeFLOAT64The average cost per engagement
metrics_average_cpmFLOAT64The average cost per thousand impressions
metrics_trueview_average_cpvFLOAT64The average cost per view
ad_group_base_ad_groupSTRINGThe base ad group associated with the keyword
campaign_base_campaignSTRINGThe base campaign associated with the ad group
... and 52 more columns

Nested subtables

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)
ColumnTypeDescription
_kaivo_idSTRINGPrimary key that uniquely identifies the row. Auto-generated by Kaivo.
customer_idINT64The ID of the customer associated with the geographic view data
customer_descriptive_nameSTRINGThe descriptive name of the customer associated with the geographic view data
geographic_view_country_criterion_idINT64The criterion ID for the country in the geographic view data
geographic_view_location_typeSTRINGThe type of location (such as city or region) in the geographic view data
ad_group_idINT64The ID of the ad group associated with the geographic view data
segments_dateDATEThe date segment within the geographic view data
_kaivo_extracted_atTIMESTAMPTimestamp that shows when the row was extracted. Auto-generated by Kaivo.
ColumnTypeDescription
_kaivo_idSTRINGPrimary key that uniquely identifies the row. Auto-generated by Kaivo.
customer_idINT64The ID of the customer associated with the geographic report data.
customer_descriptive_nameSTRINGThe descriptive name of the customer.
customer_currency_codeSTRINGThe currency code used by the customer.
customer_time_zoneSTRINGThe time zone set for the customer.
geographic_view_country_criterion_idINT64The criterion ID for the country in the geographic view data.
geographic_view_location_typeSTRINGThe type of location (such as city or region) in the geographic view data.
geographic_view_resource_nameSTRINGThe resource name of the geographic view.
ad_group_idINT64The ID of the ad group.
ad_group_nameSTRINGThe name of the ad group.
ad_group_statusSTRINGThe status of the ad group.
ad_group_base_ad_groupSTRINGThe base ad group resource name.
campaign_base_campaignSTRINGThe base campaign resource name.
campaign_idINT64The ID of the campaign.
campaign_nameSTRINGThe name of the campaign.
campaign_statusSTRINGThe status of the campaign.
segments_dateDATEThe date segment for the geographic report data.
segments_day_of_weekSTRINGThe day of the week.
segments_monthSTRINGThe month.
segments_weekSTRINGThe week of the year.
segments_quarterSTRINGThe quarter of the year.
segments_yearINT64The year.
metrics_all_conversionsFLOAT64Total number of conversions for all actions.
metrics_all_conversions_from_interactions_rateFLOAT64The rate of all conversions from interactions.
metrics_all_conversions_valueFLOAT64The total value of all conversions.
... and 22 more columns
ColumnTypeDescription
_kaivo_idSTRINGPrimary key that uniquely identifies the row. Auto-generated by Kaivo.
customer_idINT64The unique ID of the customer.
customer_descriptive_nameSTRINGThe name or description of the customer.
campaign_idINT64The ID of the campaign the keyword belongs to.
ad_group_idINT64The ID of the ad group the keyword belongs to.
ad_group_criterion_typeSTRINGThe type of the ad group criterion (e.g., keyword, placement).
ad_group_criterion_keyword_textSTRINGThe actual text of the keyword.
ad_group_criterion_negativeBOOLSpecifies whether the keyword is a negative keyword.
ad_group_criterion_keyword_match_typeSTRINGThe match type of the keyword (e.g., exact, broad, phrase).
metrics_historical_quality_scoreINT64The historical quality score of the keyword.
metrics_ctrFLOAT64The click-through rate (clicks divided by impressions) for the keyword.
segments_dateDATEThe date when the data was recorded.
campaign_bidding_strategy_typeSTRINGThe type of bidding strategy used for the campaign.
metrics_clicksINT64The number of clicks on the keyword.
metrics_cost_microsINT64The cost of the keyword advertising in micros.
metrics_impressionsINT64The number of times the keyword was displayed.
metrics_active_view_impressionsINT64The number of viewable impressions.
metrics_active_view_measurabilityFLOAT64The ratio of viewable impressions to the number of measurable impressions.
metrics_active_view_measurable_cost_microsINT64The cost for measurable viewable impressions in micros.
metrics_active_view_measurable_impressionsINT64The number of impressions that were measurable for viewability.
metrics_active_view_viewabilityFLOAT64The ratio of viewable impressions to measurable impressions.
metrics_conversionsFLOAT64The number of conversions attributed to the keyword.
metrics_conversions_valueFLOAT64The total value of conversions attributed to the keyword.
metrics_interactionsINT64The total number of interactions (clicks, video views, etc.) on the keyword.
metrics_view_through_conversionsINT64The number of conversions that occurred after a view of the ad without a click.
... and 2 more columns

Nested subtables

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

  • keyword_view__metrics_interaction_event_types (4 columns)
ColumnTypeDescription
_kaivo_idSTRINGPrimary key that uniquely identifies the row. Auto-generated by Kaivo.
customer_idINT64The unique identifier of the customer associated with the label.
label_idINT64The unique identifier of the label.
label_nameSTRINGThe name associated with the label.
label_resource_nameSTRINGThe resource name of the label.
label_statusSTRINGThe status of the label.
label_text_label_background_colorSTRINGThe background color of the text label.
label_text_label_descriptionSTRINGThe description associated with the text label.
_kaivo_extracted_atTIMESTAMPTimestamp that shows when the row was extracted. Auto-generated by Kaivo.
ColumnTypeDescription
_kaivo_idSTRINGPrimary key that uniquely identifies the row. Auto-generated by Kaivo.
customer_descriptive_nameSTRINGThe descriptive name of the customer account.
ad_group_idINT64The ID of the ad group associated with the data.
ad_group_nameSTRINGThe name of the ad group associated with the data.
ad_group_statusSTRINGThe status of the ad group.
segments_ad_network_typeSTRINGThe type of ad network.
segments_product_aggregator_idINT64The ID of the product aggregator.
metrics_all_conversions_from_interactions_rateFLOAT64The rate of conversions from interactions.
metrics_all_conversions_valueFLOAT64The total value of all conversions.
metrics_all_conversionsFLOAT64The total number of conversions.
metrics_average_cpcFLOAT64The average cost per click.
segments_product_brandSTRINGThe brand of the product.
campaign_idINT64The ID of the campaign associated with the data.
campaign_nameSTRINGThe name of the campaign associated with the data.
campaign_statusSTRINGThe status of the campaign.
segments_product_category_level1STRINGThe first level product category.
segments_product_category_level2STRINGThe second level product category.
segments_product_category_level3STRINGThe third level product category.
segments_product_category_level4STRINGThe fourth level product category.
segments_product_category_level5STRINGThe fifth level product category.
segments_product_channelSTRINGThe product channel.
segments_product_channel_exclusivitySTRINGThe product channel exclusivity.
segments_click_typeSTRINGThe type of click.
metrics_clicksINT64The total number of clicks.
metrics_conversions_from_interactions_rateFLOAT64The rate of conversions from interactions.
... and 36 more columns
ColumnTypeDescription
_kaivo_idSTRINGPrimary key that uniquely identifies the row. Auto-generated by Kaivo.
topic_view_resource_nameSTRINGThe resource name of the topic view.
customer_currency_codeSTRINGThe currency code of the customer associated with the topic view.
customer_descriptive_nameSTRINGThe descriptive name of the customer associated with the topic view.
customer_time_zoneSTRINGThe time zone of the customer associated with the topic view.
metrics_active_view_cpmFLOAT64The active view CPM metric.
metrics_active_view_ctrFLOAT64The active view click-through rate metric.
metrics_active_view_impressionsINT64The number of active view impressions metric.
metrics_active_view_measurabilityFLOAT64The active view measurability metric.
metrics_active_view_measurable_cost_microsINT64The cost of measurable active view impressions in micros.
metrics_active_view_measurable_impressionsINT64The number of measurable active view impressions metric.
metrics_active_view_viewabilityFLOAT64The active view viewability metric.
ad_group_idINT64The ID of the ad group associated with the topic view.
ad_group_nameSTRINGThe name of the ad group associated with the topic view.
ad_group_statusSTRINGThe status of the ad group associated with the topic view.
segments_ad_network_typeSTRINGThe type of ad network segment.
metrics_all_conversions_from_interactions_rateFLOAT64The rate of all conversions from interactions metric.
metrics_all_conversions_valueFLOAT64The value of all conversions metric.
metrics_all_conversionsFLOAT64The total number of all conversions metric.
metrics_average_costFLOAT64The average cost metric.
metrics_average_cpcFLOAT64The average CPC (Cost Per Click) metric.
metrics_average_cpeFLOAT64The average CPE (Cost Per Engagement) metric.
metrics_average_cpmFLOAT64The average CPM (Cost Per Thousand Impressions) metric.
metrics_trueview_average_cpvFLOAT64The average CPV (Cost Per View) metric.
ad_group_base_ad_groupSTRINGThe base ad group associated with the topic view.
... and 51 more columns

Nested subtables

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)
ColumnTypeDescription
_kaivo_idSTRINGPrimary key that uniquely identifies the row. Auto-generated by Kaivo.
segments_dateDATEThe date related to the user location view data.
segments_day_of_weekSTRINGThe day of the week.
segments_monthSTRINGThe month.
segments_weekSTRINGThe week of the year.
segments_quarterSTRINGThe quarter of the year.
segments_yearINT64The year.
segments_ad_network_typeSTRINGThe type of ad network.
customer_currency_codeSTRINGThe currency code used by the customer.
customer_idINT64The ID of the customer.
customer_descriptive_nameSTRINGThe descriptive name of the customer.
customer_time_zoneSTRINGThe time zone set for the customer.
user_location_view_country_criterion_idINT64The country criterion ID for the user location.
user_location_view_targeting_locationBOOLThe targeted location for the user location view.
user_location_view_resource_nameSTRINGThe resource name associated with the user location view.
campaign_base_campaignSTRINGThe base campaign information tied to the user location view data.
campaign_idINT64The ID of the campaign linked to the user location view data.
campaign_nameSTRINGThe name of the campaign associated with the user location view data.
campaign_statusSTRINGThe status of the campaign related to the user location view data.
ad_group_nameSTRINGThe name of the ad group associated with the user location view data.
ad_group_statusSTRINGThe status of the ad group related to the user location view data.
ad_group_base_ad_groupSTRINGThe base ad group information related to the user location view data.
metrics_all_conversionsFLOAT64Total number of conversions for all actions.
metrics_all_conversions_from_interactions_rateFLOAT64The rate of all conversions from interactions.
metrics_all_conversions_valueFLOAT64The total value of all conversions.
... and 22 more columns

Nested subtables

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

  • user_location_view__metrics_interaction_event_types (4 columns)

How the Google Ads sync works

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.

Frequently asked questions

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.

Can I sync only some tables or columns?

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?

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?

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.

Common use cases for Google Ads data

Cross-channel reporting

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

Campaign performance

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

ROAS and CPA

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

Budget pacing

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

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.

Claude

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

Power BI

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

Data Studio

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

Tableau

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

Google Sheets

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

Excel

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

Metabase

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

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

Was this helpful?

Still need help? Share an idea