--- title: Google Ads description: Connect Google Ads, understand its sync behavior, and query every table and column it writes. species: reference --- # Google Ads Connect Google Ads with Google OAuth plus a customer id and optional manager id. The source writes 42 fixed tables under `titan.google_ads`. ```sql select id, descriptive_name, currency_code from titan.google_ads.customer limit 10 ``` ## Connect Google Ads 1. Open **Apps**, choose **Connect app**, and select **Google Ads**. 2. Enter Google OAuth plus a customer id and optional manager id. 3. Review the tables, then save the source. 4. Watch **Sync history** until the first run completes. Credentials are stored as secrets. They never become lake columns or appear in query results. ## Sync behavior Entity and performance tables share the connected account scope. Account selection happens during setup. A new source syncs when you connect it and then follows its schedule. The default recurring interval is 4 hours. An interrupted run keeps its completed progress and retries safely. Every lake table also has the [system columns](/v2/docs/concepts/your-lake#the-system-columns) `_synced_at` and `_deleted`; the column reference below lists source columns only. ## Table reference ### `customer` `titan.google_ads.customer` has 10 source columns. ```columns table=google_ads.customer id string pk Source field `id`. descriptive_name string Source field `descriptiveName`. currency_code string Source field `currencyCode`. time_zone string Source field `timeZone`. status string Source field `status`. auto_tagging_enabled boolean Source field `autoTaggingEnabled`. manager boolean Source field `manager`. test_account boolean Source field `testAccount`. optimization_score float Source field `optimizationScore`. has_partners_badge boolean Source field `hasPartnersBadge`. ``` ### `campaign` `titan.google_ads.campaign` has 27 source columns. ```columns table=google_ads.campaign id string pk Source field `id`. name string Source field `name`. status string Source field `status`. advertising_channel_type string Source field `advertisingChannelType`. advertising_channel_sub_type string Source field `advertisingChannelSubType`. bidding_strategy_type string Source field `biddingStrategyType`. budget_id string Source field `budgetId`. bidding_strategy_id string Source field `biddingStrategyId`. start_date_time datetime Source field `startDateTime`. end_date_time datetime Source field `endDateTime`. serving_status string Source field `servingStatus`. payment_mode string Source field `paymentMode`. optimization_score float Source field `optimizationScore`. target_google_search boolean Source field `targetGoogleSearch`. target_search_network boolean Source field `targetSearchNetwork`. target_content_network boolean Source field `targetContentNetwork`. target_partner_search_network boolean Source field `targetPartnerSearchNetwork`. shopping_merchant_id string Source field `shoppingMerchantId`. shopping_feed_label string Source field `shoppingFeedLabel`. shopping_campaign_priority integer Source field `shoppingCampaignPriority`. shopping_enable_local boolean Source field `shoppingEnableLocal`. base_campaign_id string Source field `baseCampaignId`. labels json Source field `labels`. dsa_domain_name string Source field `dsaDomainName`. dsa_language_code string Source field `dsaLanguageCode`. app_id string Source field `appId`. app_store string Source field `appStore`. ``` ### `campaign_budget` `titan.google_ads.campaign_budget` has 12 source columns. ```columns table=google_ads.campaign_budget id string pk Source field `id`. name string Source field `name`. amount_micros integer Source field `amountMicros`. total_amount_micros integer Source field `totalAmountMicros`. status string Source field `status`. period string Source field `period`. type string Source field `type`. explicitly_shared boolean Source field `explicitlyShared`. reference_count integer Source field `referenceCount`. has_recommended_budget boolean Source field `hasRecommendedBudget`. recommended_budget_amount_micros integer Source field `recommendedBudgetAmountMicros`. aligned_bidding_strategy_id string Source field `alignedBiddingStrategyId`. ``` ### `ad_group` `titan.google_ads.ad_group` has 22 source columns. ```columns table=google_ads.ad_group id string pk Source field `id`. name string Source field `name`. status string Source field `status`. type string Source field `type`. campaign_id string Source field `campaignId`. cpc_bid_micros integer Source field `cpcBidMicros`. effective_cpc_bid_micros integer Source field `effectiveCpcBidMicros`. cpm_bid_micros integer Source field `cpmBidMicros`. target_cpa_micros integer Source field `targetCpaMicros`. target_roas decimal(28,6) Source field `targetRoas`. cpv_bid_micros integer Source field `cpvBidMicros`. target_cpm_micros integer Source field `targetCpmMicros`. target_cpv_micros integer Source field `targetCpvMicros`. target_cpc_micros integer Source field `targetCpcMicros`. percent_cpc_bid_micros integer Source field `percentCpcBidMicros`. fixed_cpm_micros integer Source field `fixedCpmMicros`. effective_target_cpa_micros integer Source field `effectiveTargetCpaMicros`. effective_target_roas decimal(28,6) Source field `effectiveTargetRoas`. effective_target_cpc integer Source field `effectiveTargetCpc`. optimized_targeting_enabled boolean Source field `optimizedTargetingEnabled`. labels json Source field `labels`. base_ad_group_id string Source field `baseAdGroupId`. ``` ### `ad_group_ad` `titan.google_ads.ad_group_ad` has 14 source columns. ```columns table=google_ads.ad_group_ad ad_id string pk Source field `adId`. ad_group_id string pk Source field `adGroupId`. campaign_id string Source field `campaignId`. status string Source field `status`. ad_type string Source field `adType`. ad_strength string Source field `adStrength`. name string Source field `name`. final_urls json Source field `finalUrls`. final_mobile_urls json Source field `finalMobileUrls`. display_url string Source field `displayUrl`. added_by_google_ads boolean Source field `addedByGoogleAds`. path1 string Source field `path1`. path2 string Source field `path2`. labels json Source field `labels`. ``` ### `ad_group_criterion` `titan.google_ads.ad_group_criterion` has 19 source columns. ```columns table=google_ads.ad_group_criterion criterion_id string pk Source field `criterionId`. ad_group_id string pk Source field `adGroupId`. campaign_id string Source field `campaignId`. type string Source field `type`. status string Source field `status`. display_name string Source field `displayName`. negative boolean Source field `negative`. keyword_text string Source field `keywordText`. keyword_match_type string Source field `keywordMatchType`. quality_score integer Source field `qualityScore`. creative_quality_score string Source field `creativeQualityScore`. post_click_quality_score string Source field `postClickQualityScore`. search_predicted_ctr string Source field `searchPredictedCtr`. bid_modifier decimal(28,6) Source field `bidModifier`. cpc_bid_micros integer Source field `cpcBidMicros`. effective_cpc_bid_micros integer Source field `effectiveCpcBidMicros`. final_urls json Source field `finalUrls`. labels json Source field `labels`. base_campaign_id string Source field `baseCampaignId`. ``` ### `campaign_criterion` `titan.google_ads.campaign_criterion` has 34 source columns. ```columns table=google_ads.campaign_criterion criterion_id string pk Source field `criterionId`. campaign_id string pk Source field `campaignId`. type string Source field `type`. status string Source field `status`. display_name string Source field `displayName`. negative boolean Source field `negative`. bid_modifier decimal(28,6) Source field `bidModifier`. geo_target_constant_id string Source field `geoTargetConstantId`. language_constant_id string Source field `languageConstantId`. language_code string Source field `languageCode`. language_name string Source field `languageName`. keyword_text string Source field `keywordText`. keyword_match_type string Source field `keywordMatchType`. device_type string Source field `deviceType`. age_range_type string Source field `ageRangeType`. gender_type string Source field `genderType`. income_range_type string Source field `incomeRangeType`. parental_status_type string Source field `parentalStatusType`. user_interest_id string Source field `userInterestId`. user_list_id string Source field `userListId`. placement_url string Source field `placementUrl`. topic_constant_id string Source field `topicConstantId`. youtube_channel_id string Source field `youtubeChannelId`. youtube_video_id string Source field `youtubeVideoId`. carrier_country_code string Source field `carrierCountryCode`. carrier_name string Source field `carrierName`. mobile_device_id string Source field `mobileDeviceId`. operating_system_version_id string Source field `operatingSystemVersionId`. content_label_type string Source field `contentLabelType`. ip_block_ip_address string Source field `ipBlockIpAddress`. mobile_app_category_id string Source field `mobileAppCategoryId`. mobile_application_app_id string Source field `mobileApplicationAppId`. mobile_application_name string Source field `mobileApplicationName`. mobile_app_category_name string Source field `mobileAppCategoryName`. ``` ### `conversion_action` `titan.google_ads.conversion_action` has 19 source columns. ```columns table=google_ads.conversion_action id string pk Source field `id`. name string Source field `name`. status string Source field `status`. type string Source field `type`. category string Source field `category`. origin string Source field `origin`. primary_for_goal boolean Source field `primaryForGoal`. owner_customer_id string Source field `ownerCustomerId`. include_in_conversions_metric boolean Source field `includeInConversionsMetric`. counting_type string Source field `countingType`. click_through_lookback_window_days integer Source field `clickThroughLookbackWindowDays`. view_through_lookback_window_days integer Source field `viewThroughLookbackWindowDays`. phone_call_duration_seconds integer Source field `phoneCallDurationSeconds`. app_id string Source field `appId`. default_value decimal(28,6) Source field `defaultValue`. default_currency_code string Source field `defaultCurrencyCode`. always_use_default_value boolean Source field `alwaysUseDefaultValue`. attribution_model string Source field `attributionModel`. data_driven_model_status string Source field `dataDrivenModelStatus`. ``` ### `bidding_strategy` `titan.google_ads.bidding_strategy` has 15 source columns. ```columns table=google_ads.bidding_strategy id string pk Source field `id`. name string Source field `name`. status string Source field `status`. type string Source field `type`. currency_code string Source field `currencyCode`. effective_currency_code string Source field `effectiveCurrencyCode`. aligned_campaign_budget_id string Source field `alignedCampaignBudgetId`. campaign_count integer Source field `campaignCount`. non_removed_campaign_count integer Source field `nonRemovedCampaignCount`. target_cpa_micros integer Source field `targetCpaMicros`. target_roas decimal(28,6) Source field `targetRoas`. cpc_bid_ceiling_micros integer Source field `cpcBidCeilingMicros`. cpc_bid_floor_micros integer Source field `cpcBidFloorMicros`. target_impression_share_micros integer Source field `targetImpressionShareMicros`. target_impression_share_location string Source field `targetImpressionShareLocation`. ``` ### `label` `titan.google_ads.label` has 5 source columns. ```columns table=google_ads.label id string pk Source field `id`. name string Source field `name`. status string Source field `status`. background_color string Source field `backgroundColor`. description string Source field `description`. ``` ### `audience` `titan.google_ads.audience` has 6 source columns. ```columns table=google_ads.audience id string pk Source field `id`. name string Source field `name`. status string Source field `status`. description string Source field `description`. scope string Source field `scope`. dimensions json Source field `dimensions`. ``` ### `user_interest` `titan.google_ads.user_interest` has 5 source columns. ```columns table=google_ads.user_interest id string pk Source field `id`. name string Source field `name`. taxonomy_type string Source field `taxonomyType`. parent_id string Source field `parentId`. launched_to_all boolean Source field `launchedToAll`. ``` ### `asset_group` `titan.google_ads.asset_group` has 11 source columns. ```columns table=google_ads.asset_group id string pk Source field `id`. campaign_id string Source field `campaignId`. name string Source field `name`. status string Source field `status`. primary_status string Source field `primaryStatus`. ad_strength string Source field `adStrength`. path1 string Source field `path1`. path2 string Source field `path2`. final_urls json Source field `finalUrls`. final_mobile_urls json Source field `finalMobileUrls`. primary_status_reasons json Source field `primaryStatusReasons`. ``` ### `asset_group_asset` `titan.google_ads.asset_group_asset` has 5 source columns. ```columns table=google_ads.asset_group_asset asset_group_id string pk Source field `assetGroupId`. asset_id string pk Source field `assetId`. field_type string pk Source field `fieldType`. status string Source field `status`. source string Source field `source`. ``` ### `asset` `titan.google_ads.asset` has 38 source columns. ```columns table=google_ads.asset id string pk Source field `id`. name string Source field `name`. type string Source field `type`. source string Source field `source`. final_urls json Source field `finalUrls`. final_mobile_urls json Source field `finalMobileUrls`. tracking_url_template string Source field `trackingUrlTemplate`. final_url_suffix string Source field `finalUrlSuffix`. text_asset_text string Source field `textAssetText`. image_url string Source field `imageUrl`. image_file_size integer Source field `imageFileSize`. image_mime_type string Source field `imageMimeType`. youtube_video_id string Source field `youtubeVideoId`. youtube_video_title string Source field `youtubeVideoTitle`. sitelink_link_text string Source field `sitelinkLinkText`. sitelink_description1 string Source field `sitelinkDescription1`. sitelink_description2 string Source field `sitelinkDescription2`. callout_text string Source field `calloutText`. structured_snippet_header string Source field `structuredSnippetHeader`. structured_snippet_values json Source field `structuredSnippetValues`. call_country_code string Source field `callCountryCode`. call_phone_number string Source field `callPhoneNumber`. call_conversion_action string Source field `callConversionAction`. promotion_target string Source field `promotionTarget`. promotion_discount_modifier string Source field `promotionDiscountModifier`. promotion_redemption_start_date string Source field `promotionRedemptionStartDate`. promotion_redemption_end_date string Source field `promotionRedemptionEndDate`. promotion_occasion string Source field `promotionOccasion`. promotion_language_code string Source field `promotionLanguageCode`. promotion_percent_off integer Source field `promotionPercentOff`. promotion_money_amount_off_micros integer Source field `promotionMoneyAmountOffMicros`. lead_form_business_name string Source field `leadFormBusinessName`. lead_form_call_to_action string Source field `leadFormCallToAction`. lead_form_description string Source field `leadFormDescription`. lead_form_headline string Source field `leadFormHeadline`. price_type string Source field `priceType`. price_price_qualifier string Source field `pricePriceQualifier`. page_feed_page_url string Source field `pageFeedPageUrl`. ``` ### `asset_group_listing_group_filter` `titan.google_ads.asset_group_listing_group_filter` has 13 source columns. ```columns table=google_ads.asset_group_listing_group_filter id string pk Source field `id`. asset_group_id string Source field `assetGroupId`. parent_id string Source field `parentId`. type string Source field `type`. path json Source field `path`. product_brand_value string Source field `productBrandValue`. product_item_id_value string Source field `productItemIdValue`. product_category_level string Source field `productCategoryLevel`. product_category_id string Source field `productCategoryId`. product_channel_channel string Source field `productChannelChannel`. product_condition_condition string Source field `productConditionCondition`. product_custom_attribute_index string Source field `productCustomAttributeIndex`. product_custom_attribute_value string Source field `productCustomAttributeValue`. ``` ### `asset_group_signal` `titan.google_ads.asset_group_signal` has 5 source columns. ```columns table=google_ads.asset_group_signal resource_name string pk Source field `resourceName`. asset_group_id string Source field `assetGroupId`. search_theme_text string Source field `searchThemeText`. audience_signal json Source field `audienceSignal`. disapproval_reasons json Source field `disapprovalReasons`. ``` ### `campaign_label` `titan.google_ads.campaign_label` has 2 source columns. ```columns table=google_ads.campaign_label campaign_id string pk Source field `campaignId`. label_id string pk Source field `labelId`. ``` ### `ad_group_label` `titan.google_ads.ad_group_label` has 2 source columns. ```columns table=google_ads.ad_group_label ad_group_id string pk Source field `adGroupId`. label_id string pk Source field `labelId`. ``` ### `ad_group_ad_label` `titan.google_ads.ad_group_ad_label` has 3 source columns. ```columns table=google_ads.ad_group_ad_label ad_group_id string pk Source field `adGroupId`. ad_id string pk Source field `adId`. label_id string pk Source field `labelId`. ``` ### `ad_group_criterion_label` `titan.google_ads.ad_group_criterion_label` has 3 source columns. ```columns table=google_ads.ad_group_criterion_label ad_group_id string pk Source field `adGroupId`. criterion_id string pk Source field `criterionId`. label_id string pk Source field `labelId`. ``` ### `account_metrics` `titan.google_ads.account_metrics` has 24 source columns. ```columns table=google_ads.account_metrics date date pk Source field `date`. device string pk Source field `device`. ad_network_type string pk Source field `adNetworkType`. impressions integer Source field `impressions`. clicks integer Source field `clicks`. interactions integer Source field `interactions`. video_views integer Source field `videoViews`. view_through_conversions integer Source field `viewThroughConversions`. cost_micros integer Source field `costMicros`. average_cpc integer Source field `averageCpc`. average_cpm integer Source field `averageCpm`. average_cost integer Source field `averageCost`. cost_per_conversion integer Source field `costPerConversion`. conversions float Source field `conversions`. all_conversions float Source field `allConversions`. conversions_value decimal(28,2) Source field `conversionsValue`. all_conversions_value decimal(28,2) Source field `allConversionsValue`. ctr float Source field `ctr`. interaction_rate float Source field `interactionRate`. conversions_from_interactions_rate float Source field `conversionsFromInteractionsRate`. video_view_rate float Source field `videoViewRate`. search_impression_share float Source field `searchImpressionShare`. absolute_top_impression_percentage float Source field `absoluteTopImpressionPercentage`. conversions_from_interactions_value_per_interaction float Source field `conversionsFromInteractionsValuePerInteraction`. ``` ### `campaign_metrics` `titan.google_ads.campaign_metrics` has 25 source columns. ```columns table=google_ads.campaign_metrics campaign_id string pk Source field `campaignId`. date date pk Source field `date`. device string pk Source field `device`. ad_network_type string pk Source field `adNetworkType`. impressions integer Source field `impressions`. clicks integer Source field `clicks`. interactions integer Source field `interactions`. video_views integer Source field `videoViews`. view_through_conversions integer Source field `viewThroughConversions`. cost_micros integer Source field `costMicros`. average_cpc integer Source field `averageCpc`. average_cpm integer Source field `averageCpm`. average_cost integer Source field `averageCost`. cost_per_conversion integer Source field `costPerConversion`. conversions float Source field `conversions`. all_conversions float Source field `allConversions`. conversions_value decimal(28,2) Source field `conversionsValue`. all_conversions_value decimal(28,2) Source field `allConversionsValue`. ctr float Source field `ctr`. interaction_rate float Source field `interactionRate`. conversions_from_interactions_rate float Source field `conversionsFromInteractionsRate`. video_view_rate float Source field `videoViewRate`. search_impression_share float Source field `searchImpressionShare`. absolute_top_impression_percentage float Source field `absoluteTopImpressionPercentage`. conversions_from_interactions_value_per_interaction float Source field `conversionsFromInteractionsValuePerInteraction`. ``` ### `ad_group_metrics` `titan.google_ads.ad_group_metrics` has 26 source columns. ```columns table=google_ads.ad_group_metrics ad_group_id string pk Source field `adGroupId`. campaign_id string pk Source field `campaignId`. date date pk Source field `date`. device string pk Source field `device`. ad_network_type string pk Source field `adNetworkType`. impressions integer Source field `impressions`. clicks integer Source field `clicks`. interactions integer Source field `interactions`. video_views integer Source field `videoViews`. view_through_conversions integer Source field `viewThroughConversions`. cost_micros integer Source field `costMicros`. average_cpc integer Source field `averageCpc`. average_cpm integer Source field `averageCpm`. average_cost integer Source field `averageCost`. cost_per_conversion integer Source field `costPerConversion`. conversions float Source field `conversions`. all_conversions float Source field `allConversions`. conversions_value decimal(28,2) Source field `conversionsValue`. all_conversions_value decimal(28,2) Source field `allConversionsValue`. ctr float Source field `ctr`. interaction_rate float Source field `interactionRate`. conversions_from_interactions_rate float Source field `conversionsFromInteractionsRate`. video_view_rate float Source field `videoViewRate`. search_impression_share float Source field `searchImpressionShare`. absolute_top_impression_percentage float Source field `absoluteTopImpressionPercentage`. conversions_from_interactions_value_per_interaction float Source field `conversionsFromInteractionsValuePerInteraction`. ``` ### `ad_metrics` `titan.google_ads.ad_metrics` has 28 source columns. ```columns table=google_ads.ad_metrics ad_group_id string pk Source field `adGroupId`. ad_id string pk Source field `adId`. campaign_id string pk Source field `campaignId`. date date pk Source field `date`. device string pk Source field `device`. ad_network_type string pk Source field `adNetworkType`. keyword_criterion_id string pk Source field `keywordCriterionId`. impressions integer Source field `impressions`. clicks integer Source field `clicks`. interactions integer Source field `interactions`. video_views integer Source field `videoViews`. view_through_conversions integer Source field `viewThroughConversions`. cost_micros integer Source field `costMicros`. average_cpc integer Source field `averageCpc`. average_cpm integer Source field `averageCpm`. average_cost integer Source field `averageCost`. cost_per_conversion integer Source field `costPerConversion`. conversions float Source field `conversions`. all_conversions float Source field `allConversions`. conversions_value decimal(28,2) Source field `conversionsValue`. all_conversions_value decimal(28,2) Source field `allConversionsValue`. ctr float Source field `ctr`. interaction_rate float Source field `interactionRate`. conversions_from_interactions_rate float Source field `conversionsFromInteractionsRate`. video_view_rate float Source field `videoViewRate`. search_impression_share float Source field `searchImpressionShare`. absolute_top_impression_percentage float Source field `absoluteTopImpressionPercentage`. conversions_from_interactions_value_per_interaction float Source field `conversionsFromInteractionsValuePerInteraction`. ``` ### `keyword_metrics` `titan.google_ads.keyword_metrics` has 25 source columns. ```columns table=google_ads.keyword_metrics ad_group_id string pk Source field `adGroupId`. criterion_id string pk Source field `criterionId`. campaign_id string pk Source field `campaignId`. date date pk Source field `date`. impressions integer Source field `impressions`. clicks integer Source field `clicks`. interactions integer Source field `interactions`. video_views integer Source field `videoViews`. view_through_conversions integer Source field `viewThroughConversions`. cost_micros integer Source field `costMicros`. average_cpc integer Source field `averageCpc`. average_cpm integer Source field `averageCpm`. average_cost integer Source field `averageCost`. cost_per_conversion integer Source field `costPerConversion`. conversions float Source field `conversions`. all_conversions float Source field `allConversions`. conversions_value decimal(28,2) Source field `conversionsValue`. all_conversions_value decimal(28,2) Source field `allConversionsValue`. ctr float Source field `ctr`. interaction_rate float Source field `interactionRate`. conversions_from_interactions_rate float Source field `conversionsFromInteractionsRate`. video_view_rate float Source field `videoViewRate`. search_impression_share float Source field `searchImpressionShare`. absolute_top_impression_percentage float Source field `absoluteTopImpressionPercentage`. conversions_from_interactions_value_per_interaction float Source field `conversionsFromInteractionsValuePerInteraction`. ``` ### `search_term_metrics` `titan.google_ads.search_term_metrics` has 29 source columns. ```columns table=google_ads.search_term_metrics campaign_id string pk Source field `campaignId`. ad_group_id string pk Source field `adGroupId`. search_term string pk Source field `searchTerm`. date date pk Source field `date`. status string Source field `status`. keyword_criterion_id string pk Source field `keywordCriterionId`. search_term_match_type string Source field `searchTermMatchType`. keyword_text string Source field `keywordText`. impressions integer Source field `impressions`. clicks integer Source field `clicks`. interactions integer Source field `interactions`. video_views integer Source field `videoViews`. view_through_conversions integer Source field `viewThroughConversions`. cost_micros integer Source field `costMicros`. average_cpc integer Source field `averageCpc`. average_cpm integer Source field `averageCpm`. average_cost integer Source field `averageCost`. cost_per_conversion integer Source field `costPerConversion`. conversions float Source field `conversions`. all_conversions float Source field `allConversions`. conversions_value decimal(28,2) Source field `conversionsValue`. all_conversions_value decimal(28,2) Source field `allConversionsValue`. ctr float Source field `ctr`. interaction_rate float Source field `interactionRate`. conversions_from_interactions_rate float Source field `conversionsFromInteractionsRate`. video_view_rate float Source field `videoViewRate`. search_impression_share float Source field `searchImpressionShare`. absolute_top_impression_percentage float Source field `absoluteTopImpressionPercentage`. conversions_from_interactions_value_per_interaction float Source field `conversionsFromInteractionsValuePerInteraction`. ``` ### `asset_group_metrics` `titan.google_ads.asset_group_metrics` has 24 source columns. ```columns table=google_ads.asset_group_metrics asset_group_id string pk Source field `assetGroupId`. campaign_id string pk Source field `campaignId`. date date pk Source field `date`. impressions integer Source field `impressions`. clicks integer Source field `clicks`. interactions integer Source field `interactions`. video_views integer Source field `videoViews`. view_through_conversions integer Source field `viewThroughConversions`. cost_micros integer Source field `costMicros`. average_cpc integer Source field `averageCpc`. average_cpm integer Source field `averageCpm`. average_cost integer Source field `averageCost`. cost_per_conversion integer Source field `costPerConversion`. conversions float Source field `conversions`. all_conversions float Source field `allConversions`. conversions_value decimal(28,2) Source field `conversionsValue`. all_conversions_value decimal(28,2) Source field `allConversionsValue`. ctr float Source field `ctr`. interaction_rate float Source field `interactionRate`. conversions_from_interactions_rate float Source field `conversionsFromInteractionsRate`. video_view_rate float Source field `videoViewRate`. search_impression_share float Source field `searchImpressionShare`. absolute_top_impression_percentage float Source field `absoluteTopImpressionPercentage`. conversions_from_interactions_value_per_interaction float Source field `conversionsFromInteractionsValuePerInteraction`. ``` ### `geographic_view` `titan.google_ads.geographic_view` has 28 source columns. ```columns table=google_ads.geographic_view campaign_id string pk Source field `campaignId`. date date pk Source field `date`. geo_target_constant_id string pk Source field `geoTargetConstantId`. location_type string pk Source field `locationType`. country_criterion_id string Source field `countryCriterionId`. country_name string Source field `countryName`. geo_target_name string Source field `geoTargetName`. impressions integer Source field `impressions`. clicks integer Source field `clicks`. interactions integer Source field `interactions`. video_views integer Source field `videoViews`. view_through_conversions integer Source field `viewThroughConversions`. cost_micros integer Source field `costMicros`. average_cpc integer Source field `averageCpc`. average_cpm integer Source field `averageCpm`. average_cost integer Source field `averageCost`. cost_per_conversion integer Source field `costPerConversion`. conversions float Source field `conversions`. all_conversions float Source field `allConversions`. conversions_value decimal(28,2) Source field `conversionsValue`. all_conversions_value decimal(28,2) Source field `allConversionsValue`. ctr float Source field `ctr`. interaction_rate float Source field `interactionRate`. conversions_from_interactions_rate float Source field `conversionsFromInteractionsRate`. video_view_rate float Source field `videoViewRate`. search_impression_share float Source field `searchImpressionShare`. absolute_top_impression_percentage float Source field `absoluteTopImpressionPercentage`. conversions_from_interactions_value_per_interaction float Source field `conversionsFromInteractionsValuePerInteraction`. ``` ### `user_location_view` `titan.google_ads.user_location_view` has 28 source columns. ```columns table=google_ads.user_location_view campaign_id string pk Source field `campaignId`. date date pk Source field `date`. geo_target_constant_id string pk Source field `geoTargetConstantId`. country_criterion_id string Source field `countryCriterionId`. country_name string Source field `countryName`. geo_target_name string Source field `geoTargetName`. targeting_location boolean pk Source field `targetingLocation`. impressions integer Source field `impressions`. clicks integer Source field `clicks`. interactions integer Source field `interactions`. video_views integer Source field `videoViews`. view_through_conversions integer Source field `viewThroughConversions`. cost_micros integer Source field `costMicros`. average_cpc integer Source field `averageCpc`. average_cpm integer Source field `averageCpm`. average_cost integer Source field `averageCost`. cost_per_conversion integer Source field `costPerConversion`. conversions float Source field `conversions`. all_conversions float Source field `allConversions`. conversions_value decimal(28,2) Source field `conversionsValue`. all_conversions_value decimal(28,2) Source field `allConversionsValue`. ctr float Source field `ctr`. interaction_rate float Source field `interactionRate`. conversions_from_interactions_rate float Source field `conversionsFromInteractionsRate`. video_view_rate float Source field `videoViewRate`. search_impression_share float Source field `searchImpressionShare`. absolute_top_impression_percentage float Source field `absoluteTopImpressionPercentage`. conversions_from_interactions_value_per_interaction float Source field `conversionsFromInteractionsValuePerInteraction`. ``` ### `age_range_view` `titan.google_ads.age_range_view` has 26 source columns. ```columns table=google_ads.age_range_view campaign_id string pk Source field `campaignId`. ad_group_id string pk Source field `adGroupId`. date date pk Source field `date`. age_range_type string pk Source field `ageRangeType`. criterion_id string Source field `criterionId`. impressions integer Source field `impressions`. clicks integer Source field `clicks`. interactions integer Source field `interactions`. video_views integer Source field `videoViews`. view_through_conversions integer Source field `viewThroughConversions`. cost_micros integer Source field `costMicros`. average_cpc integer Source field `averageCpc`. average_cpm integer Source field `averageCpm`. average_cost integer Source field `averageCost`. cost_per_conversion integer Source field `costPerConversion`. conversions float Source field `conversions`. all_conversions float Source field `allConversions`. conversions_value decimal(28,2) Source field `conversionsValue`. all_conversions_value decimal(28,2) Source field `allConversionsValue`. ctr float Source field `ctr`. interaction_rate float Source field `interactionRate`. conversions_from_interactions_rate float Source field `conversionsFromInteractionsRate`. video_view_rate float Source field `videoViewRate`. search_impression_share float Source field `searchImpressionShare`. absolute_top_impression_percentage float Source field `absoluteTopImpressionPercentage`. conversions_from_interactions_value_per_interaction float Source field `conversionsFromInteractionsValuePerInteraction`. ``` ### `gender_view` `titan.google_ads.gender_view` has 26 source columns. ```columns table=google_ads.gender_view campaign_id string pk Source field `campaignId`. ad_group_id string pk Source field `adGroupId`. date date pk Source field `date`. gender_type string pk Source field `genderType`. criterion_id string Source field `criterionId`. impressions integer Source field `impressions`. clicks integer Source field `clicks`. interactions integer Source field `interactions`. video_views integer Source field `videoViews`. view_through_conversions integer Source field `viewThroughConversions`. cost_micros integer Source field `costMicros`. average_cpc integer Source field `averageCpc`. average_cpm integer Source field `averageCpm`. average_cost integer Source field `averageCost`. cost_per_conversion integer Source field `costPerConversion`. conversions float Source field `conversions`. all_conversions float Source field `allConversions`. conversions_value decimal(28,2) Source field `conversionsValue`. all_conversions_value decimal(28,2) Source field `allConversionsValue`. ctr float Source field `ctr`. interaction_rate float Source field `interactionRate`. conversions_from_interactions_rate float Source field `conversionsFromInteractionsRate`. video_view_rate float Source field `videoViewRate`. search_impression_share float Source field `searchImpressionShare`. absolute_top_impression_percentage float Source field `absoluteTopImpressionPercentage`. conversions_from_interactions_value_per_interaction float Source field `conversionsFromInteractionsValuePerInteraction`. ``` ### `income_range_view` `titan.google_ads.income_range_view` has 26 source columns. ```columns table=google_ads.income_range_view campaign_id string pk Source field `campaignId`. ad_group_id string pk Source field `adGroupId`. date date pk Source field `date`. income_range_type string pk Source field `incomeRangeType`. criterion_id string Source field `criterionId`. impressions integer Source field `impressions`. clicks integer Source field `clicks`. interactions integer Source field `interactions`. video_views integer Source field `videoViews`. view_through_conversions integer Source field `viewThroughConversions`. cost_micros integer Source field `costMicros`. average_cpc integer Source field `averageCpc`. average_cpm integer Source field `averageCpm`. average_cost integer Source field `averageCost`. cost_per_conversion integer Source field `costPerConversion`. conversions float Source field `conversions`. all_conversions float Source field `allConversions`. conversions_value decimal(28,2) Source field `conversionsValue`. all_conversions_value decimal(28,2) Source field `allConversionsValue`. ctr float Source field `ctr`. interaction_rate float Source field `interactionRate`. conversions_from_interactions_rate float Source field `conversionsFromInteractionsRate`. video_view_rate float Source field `videoViewRate`. search_impression_share float Source field `searchImpressionShare`. absolute_top_impression_percentage float Source field `absoluteTopImpressionPercentage`. conversions_from_interactions_value_per_interaction float Source field `conversionsFromInteractionsValuePerInteraction`. ``` ### `parental_status_view` `titan.google_ads.parental_status_view` has 26 source columns. ```columns table=google_ads.parental_status_view campaign_id string pk Source field `campaignId`. ad_group_id string pk Source field `adGroupId`. date date pk Source field `date`. parental_status_type string pk Source field `parentalStatusType`. criterion_id string Source field `criterionId`. impressions integer Source field `impressions`. clicks integer Source field `clicks`. interactions integer Source field `interactions`. video_views integer Source field `videoViews`. view_through_conversions integer Source field `viewThroughConversions`. cost_micros integer Source field `costMicros`. average_cpc integer Source field `averageCpc`. average_cpm integer Source field `averageCpm`. average_cost integer Source field `averageCost`. cost_per_conversion integer Source field `costPerConversion`. conversions float Source field `conversions`. all_conversions float Source field `allConversions`. conversions_value decimal(28,2) Source field `conversionsValue`. all_conversions_value decimal(28,2) Source field `allConversionsValue`. ctr float Source field `ctr`. interaction_rate float Source field `interactionRate`. conversions_from_interactions_rate float Source field `conversionsFromInteractionsRate`. video_view_rate float Source field `videoViewRate`. search_impression_share float Source field `searchImpressionShare`. absolute_top_impression_percentage float Source field `absoluteTopImpressionPercentage`. conversions_from_interactions_value_per_interaction float Source field `conversionsFromInteractionsValuePerInteraction`. ``` ### `landing_page_view` `titan.google_ads.landing_page_view` has 26 source columns. ```columns table=google_ads.landing_page_view campaign_id string pk Source field `campaignId`. ad_group_id string pk Source field `adGroupId`. date date pk Source field `date`. expanded_final_url string pk Source field `expandedFinalUrl`. unexpanded_final_url string Source field `unexpandedFinalUrl`. impressions integer Source field `impressions`. clicks integer Source field `clicks`. interactions integer Source field `interactions`. video_views integer Source field `videoViews`. view_through_conversions integer Source field `viewThroughConversions`. cost_micros integer Source field `costMicros`. average_cpc integer Source field `averageCpc`. average_cpm integer Source field `averageCpm`. average_cost integer Source field `averageCost`. cost_per_conversion integer Source field `costPerConversion`. conversions float Source field `conversions`. all_conversions float Source field `allConversions`. conversions_value decimal(28,2) Source field `conversionsValue`. all_conversions_value decimal(28,2) Source field `allConversionsValue`. ctr float Source field `ctr`. interaction_rate float Source field `interactionRate`. conversions_from_interactions_rate float Source field `conversionsFromInteractionsRate`. video_view_rate float Source field `videoViewRate`. search_impression_share float Source field `searchImpressionShare`. absolute_top_impression_percentage float Source field `absoluteTopImpressionPercentage`. conversions_from_interactions_value_per_interaction float Source field `conversionsFromInteractionsValuePerInteraction`. ``` ### `ad_group_audience_view` `titan.google_ads.ad_group_audience_view` has 26 source columns. ```columns table=google_ads.ad_group_audience_view campaign_id string pk Source field `campaignId`. ad_group_id string pk Source field `adGroupId`. criterion_id string pk Source field `criterionId`. date date pk Source field `date`. display_name string Source field `displayName`. impressions integer Source field `impressions`. clicks integer Source field `clicks`. interactions integer Source field `interactions`. video_views integer Source field `videoViews`. view_through_conversions integer Source field `viewThroughConversions`. cost_micros integer Source field `costMicros`. average_cpc integer Source field `averageCpc`. average_cpm integer Source field `averageCpm`. average_cost integer Source field `averageCost`. cost_per_conversion integer Source field `costPerConversion`. conversions float Source field `conversions`. all_conversions float Source field `allConversions`. conversions_value decimal(28,2) Source field `conversionsValue`. all_conversions_value decimal(28,2) Source field `allConversionsValue`. ctr float Source field `ctr`. interaction_rate float Source field `interactionRate`. conversions_from_interactions_rate float Source field `conversionsFromInteractionsRate`. video_view_rate float Source field `videoViewRate`. search_impression_share float Source field `searchImpressionShare`. absolute_top_impression_percentage float Source field `absoluteTopImpressionPercentage`. conversions_from_interactions_value_per_interaction float Source field `conversionsFromInteractionsValuePerInteraction`. ``` ### `ad_schedule_view` `titan.google_ads.ad_schedule_view` has 30 source columns. ```columns table=google_ads.ad_schedule_view campaign_id string pk Source field `campaignId`. criterion_id string pk Source field `criterionId`. date date pk Source field `date`. day_of_week string Source field `dayOfWeek`. start_hour integer Source field `startHour`. end_hour integer Source field `endHour`. start_minute string Source field `startMinute`. end_minute string Source field `endMinute`. bid_modifier decimal(28,6) Source field `bidModifier`. impressions integer Source field `impressions`. clicks integer Source field `clicks`. interactions integer Source field `interactions`. video_views integer Source field `videoViews`. view_through_conversions integer Source field `viewThroughConversions`. cost_micros integer Source field `costMicros`. average_cpc integer Source field `averageCpc`. average_cpm integer Source field `averageCpm`. average_cost integer Source field `averageCost`. cost_per_conversion integer Source field `costPerConversion`. conversions float Source field `conversions`. all_conversions float Source field `allConversions`. conversions_value decimal(28,2) Source field `conversionsValue`. all_conversions_value decimal(28,2) Source field `allConversionsValue`. ctr float Source field `ctr`. interaction_rate float Source field `interactionRate`. conversions_from_interactions_rate float Source field `conversionsFromInteractionsRate`. video_view_rate float Source field `videoViewRate`. search_impression_share float Source field `searchImpressionShare`. absolute_top_impression_percentage float Source field `absoluteTopImpressionPercentage`. conversions_from_interactions_value_per_interaction float Source field `conversionsFromInteractionsValuePerInteraction`. ``` ### `shopping_performance_view` `titan.google_ads.shopping_performance_view` has 48 source columns. ```columns table=google_ads.shopping_performance_view campaign_id string pk Source field `campaignId`. ad_group_id string pk Source field `adGroupId`. date date pk Source field `date`. product_item_id string pk Source field `productItemId`. product_brand string pk Source field `productBrand`. product_category_l1 string pk Source field `productCategoryL1`. product_category_l2 string pk Source field `productCategoryL2`. product_category_l3 string pk Source field `productCategoryL3`. product_category_l4 string pk Source field `productCategoryL4`. product_category_l5 string pk Source field `productCategoryL5`. product_channel string pk Source field `productChannel`. product_channel_exclusivity string pk Source field `productChannelExclusivity`. product_condition string pk Source field `productCondition`. product_custom_attribute0 string pk Source field `productCustomAttribute0`. product_custom_attribute1 string pk Source field `productCustomAttribute1`. product_custom_attribute2 string pk Source field `productCustomAttribute2`. product_custom_attribute3 string pk Source field `productCustomAttribute3`. product_custom_attribute4 string pk Source field `productCustomAttribute4`. product_language string pk Source field `productLanguage`. product_merchant_id string pk Source field `productMerchantId`. product_store_id string pk Source field `productStoreId`. product_title string pk Source field `productTitle`. product_type_l1 string pk Source field `productTypeL1`. product_type_l2 string pk Source field `productTypeL2`. product_type_l3 string pk Source field `productTypeL3`. product_type_l4 string pk Source field `productTypeL4`. product_type_l5 string pk Source field `productTypeL5`. impressions integer Source field `impressions`. clicks integer Source field `clicks`. interactions integer Source field `interactions`. video_views integer Source field `videoViews`. view_through_conversions integer Source field `viewThroughConversions`. cost_micros integer Source field `costMicros`. average_cpc integer Source field `averageCpc`. average_cpm integer Source field `averageCpm`. average_cost integer Source field `averageCost`. cost_per_conversion integer Source field `costPerConversion`. conversions float Source field `conversions`. all_conversions float Source field `allConversions`. conversions_value decimal(28,2) Source field `conversionsValue`. all_conversions_value decimal(28,2) Source field `allConversionsValue`. ctr float Source field `ctr`. interaction_rate float Source field `interactionRate`. conversions_from_interactions_rate float Source field `conversionsFromInteractionsRate`. video_view_rate float Source field `videoViewRate`. search_impression_share float Source field `searchImpressionShare`. absolute_top_impression_percentage float Source field `absoluteTopImpressionPercentage`. conversions_from_interactions_value_per_interaction float Source field `conversionsFromInteractionsValuePerInteraction`. ``` ### `click_view` `titan.google_ads.click_view` has 12 source columns. ```columns table=google_ads.click_view gclid string pk Source field `gclid`. date date pk Source field `date`. campaign_id string Source field `campaignId`. ad_group_id string Source field `adGroupId`. ad_id string Source field `adId`. keyword_criterion_id string Source field `keywordCriterionId`. keyword_text string Source field `keywordText`. keyword_match_type string Source field `keywordMatchType`. page_number integer Source field `pageNumber`. area_of_interest_id string Source field `areaOfInterestId`. location_of_presence_id string Source field `locationOfPresenceId`. user_list_id string Source field `userListId`. ``` ### `change_event` `titan.google_ads.change_event` has 11 source columns. ```columns table=google_ads.change_event resource_name string pk Source field `resourceName`. change_date_time datetime Source field `changeDateTime`. change_resource_type string Source field `changeResourceType`. change_resource_name string Source field `changeResourceName`. client_type string Source field `clientType`. user_email string Source field `userEmail`. campaign_id string Source field `campaignId`. ad_group_id string Source field `adGroupId`. changed_fields string Source field `changedFields`. old_resource json Source field `oldResource`. new_resource json Source field `newResource`. ``` ### `geo_target_constant` `titan.google_ads.geo_target_constant` has 7 source columns. ```columns table=google_ads.geo_target_constant id string pk Source field `id`. name string Source field `name`. canonical_name string Source field `canonicalName`. country_code string Source field `countryCode`. target_type string Source field `targetType`. status string Source field `status`. parent_geo_target_id string Source field `parentGeoTargetId`. ``` ### `language_constant` `titan.google_ads.language_constant` has 4 source columns. ```columns table=google_ads.language_constant id string pk Source field `id`. name string Source field `name`. code string Source field `code`. targetable boolean Source field `targetable`. ``` ## Deletes and history Rows are merged by their source key. When the source can prove that a row was deleted, Supernova keeps the row and sets `_deleted` so queries can choose whether to include history. Filter current-state queries with `where not _deleted`.