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.ioKaivo 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
Section titled “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.
| Category | Marketing & Sales |
|---|---|
| Authentication | OAuth |
| Setup | Self-service |
Getting started with the Google Ads connector
Section titled “Getting started with the Google Ads connector”- Sign up for Kaivo and create a workspace.
- Connect your Google Ads account.
- Choose which tables to sync.
- Wait for the initial sync to finish.
- Query your data in BigQuery or your favourite AI or BI tool.
Authenticating Google Ads
Section titled “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
Section titled “Configuring the Google Ads connector”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?
- Sign in to your Google Ads account.
- Click the help icon in the top right corner.
- 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
Section titled “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.
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 |
Nested subtables
Section titled “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)
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 |
Nested subtables
Section titled “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)
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 |
Nested subtables
Section titled “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)
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 |
Nested subtables
Section titled “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)
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 |
Nested subtables
Section titled “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)
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. |
Nested subtables
Section titled “Nested subtables”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 |
Nested subtables
Section titled “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)
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 |
Nested subtables
Section titled “Nested subtables”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. |
Nested subtables
Section titled “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)
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 |
Nested subtables
Section titled “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)
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 |
Nested subtables
Section titled “Nested subtables”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 |
Nested subtables
Section titled “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)
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 |
Nested subtables
Section titled “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
Section titled “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
Section titled “Frequently asked questions”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.
Can I sync only some tables or columns?
Section titled “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?
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.
Common use cases for Google Ads data
Section titled “Common use cases for Google Ads data”Cross-channel reporting
Section titled “Cross-channel reporting”Combine Google Ads spend and conversions with your other ad platforms in BigQuery for one view of marketing.
Campaign performance
Section titled “Campaign performance”Track impressions, clicks, cost, and conversions by campaign to see what works.
ROAS and CPA
Section titled “ROAS and CPA”Join spend with conversions to measure return on ad spend and cost per acquisition.
Budget pacing
Section titled “Budget pacing”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.
Claude
Section titled “Claude”Use Kaivo’s MCP server to give Claude secure, workspace-scoped access to your data. Setup guide →
Power BI
Section titled “Power BI”Microsoft’s BI tool with a native BigQuery connector. Supports direct query and scheduled refresh. Setup guide →
Data Studio
Section titled “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
Section titled “Tableau”The premium analytics standard, with native BigQuery integration. Setup guide →
Google Sheets
Section titled “Google Sheets”Use Connected Sheets to query BigQuery directly from a spreadsheet, with no SQL. Setup guide →
Connect via Power Query’s BigQuery connector. Setup guide →
Metabase
Section titled “Metabase”Open-source BI tool with strong BigQuery support. Setup guide →
See our pricing page for Google Ads connector pricing and plan details.