Supernova home
Documentation menu

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 _synced_at and _deleted; the column reference below lists source columns only.

Table reference#

customer#

titan.google_ads.customer has 10 source columns.

google_ads.customer10 columns
idstringpk

Source field id.

descriptive_namestring

Source field descriptiveName.

currency_codestring

Source field currencyCode.

time_zonestring

Source field timeZone.

statusstring

Source field status.

auto_tagging_enabledboolean

Source field autoTaggingEnabled.

managerboolean

Source field manager.

test_accountboolean

Source field testAccount.

optimization_scorefloat

Source field optimizationScore.

has_partners_badgeboolean

Source field hasPartnersBadge.

campaign#

titan.google_ads.campaign has 27 source columns.

google_ads.campaign27 columns
idstringpk

Source field id.

namestring

Source field name.

statusstring

Source field status.

advertising_channel_typestring

Source field advertisingChannelType.

advertising_channel_sub_typestring

Source field advertisingChannelSubType.

bidding_strategy_typestring

Source field biddingStrategyType.

budget_idstring

Source field budgetId.

bidding_strategy_idstring

Source field biddingStrategyId.

start_date_timedatetime

Source field startDateTime.

end_date_timedatetime

Source field endDateTime.

serving_statusstring

Source field servingStatus.

payment_modestring

Source field paymentMode.

optimization_scorefloat

Source field optimizationScore.

target_search_networkboolean

Source field targetSearchNetwork.

target_content_networkboolean

Source field targetContentNetwork.

target_partner_search_networkboolean

Source field targetPartnerSearchNetwork.

shopping_merchant_idstring

Source field shoppingMerchantId.

shopping_feed_labelstring

Source field shoppingFeedLabel.

shopping_campaign_priorityinteger

Source field shoppingCampaignPriority.

shopping_enable_localboolean

Source field shoppingEnableLocal.

base_campaign_idstring

Source field baseCampaignId.

labelsjson

Source field labels.

dsa_domain_namestring

Source field dsaDomainName.

dsa_language_codestring

Source field dsaLanguageCode.

app_idstring

Source field appId.

app_storestring

Source field appStore.

campaign_budget#

titan.google_ads.campaign_budget has 12 source columns.

google_ads.campaign_budget12 columns
idstringpk

Source field id.

namestring

Source field name.

amount_microsinteger

Source field amountMicros.

total_amount_microsinteger

Source field totalAmountMicros.

statusstring

Source field status.

periodstring

Source field period.

typestring

Source field type.

explicitly_sharedboolean

Source field explicitlyShared.

reference_countinteger

Source field referenceCount.

aligned_bidding_strategy_idstring

Source field alignedBiddingStrategyId.

ad_group#

titan.google_ads.ad_group has 22 source columns.

google_ads.ad_group22 columns
idstringpk

Source field id.

namestring

Source field name.

statusstring

Source field status.

typestring

Source field type.

campaign_idstring

Source field campaignId.

cpc_bid_microsinteger

Source field cpcBidMicros.

effective_cpc_bid_microsinteger

Source field effectiveCpcBidMicros.

cpm_bid_microsinteger

Source field cpmBidMicros.

target_cpa_microsinteger

Source field targetCpaMicros.

target_roasdecimal(28,6)

Source field targetRoas.

cpv_bid_microsinteger

Source field cpvBidMicros.

target_cpm_microsinteger

Source field targetCpmMicros.

target_cpv_microsinteger

Source field targetCpvMicros.

target_cpc_microsinteger

Source field targetCpcMicros.

percent_cpc_bid_microsinteger

Source field percentCpcBidMicros.

fixed_cpm_microsinteger

Source field fixedCpmMicros.

effective_target_cpa_microsinteger

Source field effectiveTargetCpaMicros.

effective_target_roasdecimal(28,6)

Source field effectiveTargetRoas.

effective_target_cpcinteger

Source field effectiveTargetCpc.

optimized_targeting_enabledboolean

Source field optimizedTargetingEnabled.

labelsjson

Source field labels.

base_ad_group_idstring

Source field baseAdGroupId.

ad_group_ad#

titan.google_ads.ad_group_ad has 14 source columns.

google_ads.ad_group_ad14 columns
ad_idstringpk

Source field adId.

ad_group_idstringpk

Source field adGroupId.

campaign_idstring

Source field campaignId.

statusstring

Source field status.

ad_typestring

Source field adType.

ad_strengthstring

Source field adStrength.

namestring

Source field name.

final_urlsjson

Source field finalUrls.

final_mobile_urlsjson

Source field finalMobileUrls.

display_urlstring

Source field displayUrl.

added_by_google_adsboolean

Source field addedByGoogleAds.

path1string

Source field path1.

path2string

Source field path2.

labelsjson

Source field labels.

ad_group_criterion#

titan.google_ads.ad_group_criterion has 19 source columns.

google_ads.ad_group_criterion19 columns
criterion_idstringpk

Source field criterionId.

ad_group_idstringpk

Source field adGroupId.

campaign_idstring

Source field campaignId.

typestring

Source field type.

statusstring

Source field status.

display_namestring

Source field displayName.

negativeboolean

Source field negative.

keyword_textstring

Source field keywordText.

keyword_match_typestring

Source field keywordMatchType.

quality_scoreinteger

Source field qualityScore.

creative_quality_scorestring

Source field creativeQualityScore.

post_click_quality_scorestring

Source field postClickQualityScore.

search_predicted_ctrstring

Source field searchPredictedCtr.

bid_modifierdecimal(28,6)

Source field bidModifier.

cpc_bid_microsinteger

Source field cpcBidMicros.

effective_cpc_bid_microsinteger

Source field effectiveCpcBidMicros.

final_urlsjson

Source field finalUrls.

labelsjson

Source field labels.

base_campaign_idstring

Source field baseCampaignId.

campaign_criterion#

titan.google_ads.campaign_criterion has 34 source columns.

google_ads.campaign_criterion34 columns
criterion_idstringpk

Source field criterionId.

campaign_idstringpk

Source field campaignId.

typestring

Source field type.

statusstring

Source field status.

display_namestring

Source field displayName.

negativeboolean

Source field negative.

bid_modifierdecimal(28,6)

Source field bidModifier.

geo_target_constant_idstring

Source field geoTargetConstantId.

language_constant_idstring

Source field languageConstantId.

language_codestring

Source field languageCode.

language_namestring

Source field languageName.

keyword_textstring

Source field keywordText.

keyword_match_typestring

Source field keywordMatchType.

device_typestring

Source field deviceType.

age_range_typestring

Source field ageRangeType.

gender_typestring

Source field genderType.

income_range_typestring

Source field incomeRangeType.

parental_status_typestring

Source field parentalStatusType.

user_interest_idstring

Source field userInterestId.

user_list_idstring

Source field userListId.

placement_urlstring

Source field placementUrl.

topic_constant_idstring

Source field topicConstantId.

youtube_channel_idstring

Source field youtubeChannelId.

youtube_video_idstring

Source field youtubeVideoId.

carrier_country_codestring

Source field carrierCountryCode.

carrier_namestring

Source field carrierName.

mobile_device_idstring

Source field mobileDeviceId.

operating_system_version_idstring

Source field operatingSystemVersionId.

content_label_typestring

Source field contentLabelType.

ip_block_ip_addressstring

Source field ipBlockIpAddress.

mobile_app_category_idstring

Source field mobileAppCategoryId.

mobile_application_app_idstring

Source field mobileApplicationAppId.

mobile_application_namestring

Source field mobileApplicationName.

mobile_app_category_namestring

Source field mobileAppCategoryName.

conversion_action#

titan.google_ads.conversion_action has 19 source columns.

google_ads.conversion_action19 columns
idstringpk

Source field id.

namestring

Source field name.

statusstring

Source field status.

typestring

Source field type.

categorystring

Source field category.

originstring

Source field origin.

primary_for_goalboolean

Source field primaryForGoal.

owner_customer_idstring

Source field ownerCustomerId.

include_in_conversions_metricboolean

Source field includeInConversionsMetric.

counting_typestring

Source field countingType.

click_through_lookback_window_daysinteger

Source field clickThroughLookbackWindowDays.

view_through_lookback_window_daysinteger

Source field viewThroughLookbackWindowDays.

phone_call_duration_secondsinteger

Source field phoneCallDurationSeconds.

app_idstring

Source field appId.

default_valuedecimal(28,6)

Source field defaultValue.

default_currency_codestring

Source field defaultCurrencyCode.

always_use_default_valueboolean

Source field alwaysUseDefaultValue.

attribution_modelstring

Source field attributionModel.

data_driven_model_statusstring

Source field dataDrivenModelStatus.

bidding_strategy#

titan.google_ads.bidding_strategy has 15 source columns.

google_ads.bidding_strategy15 columns
idstringpk

Source field id.

namestring

Source field name.

statusstring

Source field status.

typestring

Source field type.

currency_codestring

Source field currencyCode.

effective_currency_codestring

Source field effectiveCurrencyCode.

aligned_campaign_budget_idstring

Source field alignedCampaignBudgetId.

campaign_countinteger

Source field campaignCount.

non_removed_campaign_countinteger

Source field nonRemovedCampaignCount.

target_cpa_microsinteger

Source field targetCpaMicros.

target_roasdecimal(28,6)

Source field targetRoas.

cpc_bid_ceiling_microsinteger

Source field cpcBidCeilingMicros.

cpc_bid_floor_microsinteger

Source field cpcBidFloorMicros.

target_impression_share_microsinteger

Source field targetImpressionShareMicros.

target_impression_share_locationstring

Source field targetImpressionShareLocation.

label#

titan.google_ads.label has 5 source columns.

google_ads.label5 columns
idstringpk

Source field id.

namestring

Source field name.

statusstring

Source field status.

background_colorstring

Source field backgroundColor.

descriptionstring

Source field description.

audience#

titan.google_ads.audience has 6 source columns.

google_ads.audience6 columns
idstringpk

Source field id.

namestring

Source field name.

statusstring

Source field status.

descriptionstring

Source field description.

scopestring

Source field scope.

dimensionsjson

Source field dimensions.

user_interest#

titan.google_ads.user_interest has 5 source columns.

google_ads.user_interest5 columns
idstringpk

Source field id.

namestring

Source field name.

taxonomy_typestring

Source field taxonomyType.

parent_idstring

Source field parentId.

launched_to_allboolean

Source field launchedToAll.

asset_group#

titan.google_ads.asset_group has 11 source columns.

google_ads.asset_group11 columns
idstringpk

Source field id.

campaign_idstring

Source field campaignId.

namestring

Source field name.

statusstring

Source field status.

primary_statusstring

Source field primaryStatus.

ad_strengthstring

Source field adStrength.

path1string

Source field path1.

path2string

Source field path2.

final_urlsjson

Source field finalUrls.

final_mobile_urlsjson

Source field finalMobileUrls.

primary_status_reasonsjson

Source field primaryStatusReasons.

asset_group_asset#

titan.google_ads.asset_group_asset has 5 source columns.

google_ads.asset_group_asset5 columns
asset_group_idstringpk

Source field assetGroupId.

asset_idstringpk

Source field assetId.

field_typestringpk

Source field fieldType.

statusstring

Source field status.

sourcestring

Source field source.

asset#

titan.google_ads.asset has 38 source columns.

google_ads.asset38 columns
idstringpk

Source field id.

namestring

Source field name.

typestring

Source field type.

sourcestring

Source field source.

final_urlsjson

Source field finalUrls.

final_mobile_urlsjson

Source field finalMobileUrls.

tracking_url_templatestring

Source field trackingUrlTemplate.

final_url_suffixstring

Source field finalUrlSuffix.

text_asset_textstring

Source field textAssetText.

image_urlstring

Source field imageUrl.

image_file_sizeinteger

Source field imageFileSize.

image_mime_typestring

Source field imageMimeType.

youtube_video_idstring

Source field youtubeVideoId.

youtube_video_titlestring

Source field youtubeVideoTitle.

sitelink_link_textstring

Source field sitelinkLinkText.

callout_textstring

Source field calloutText.

structured_snippet_headerstring

Source field structuredSnippetHeader.

structured_snippet_valuesjson

Source field structuredSnippetValues.

call_country_codestring

Source field callCountryCode.

call_phone_numberstring

Source field callPhoneNumber.

call_conversion_actionstring

Source field callConversionAction.

promotion_targetstring

Source field promotionTarget.

promotion_discount_modifierstring

Source field promotionDiscountModifier.

promotion_redemption_start_datestring

Source field promotionRedemptionStartDate.

promotion_redemption_end_datestring

Source field promotionRedemptionEndDate.

promotion_occasionstring

Source field promotionOccasion.

promotion_language_codestring

Source field promotionLanguageCode.

promotion_percent_offinteger

Source field promotionPercentOff.

promotion_money_amount_off_microsinteger

Source field promotionMoneyAmountOffMicros.

lead_form_business_namestring

Source field leadFormBusinessName.

lead_form_call_to_actionstring

Source field leadFormCallToAction.

lead_form_descriptionstring

Source field leadFormDescription.

lead_form_headlinestring

Source field leadFormHeadline.

price_typestring

Source field priceType.

price_price_qualifierstring

Source field pricePriceQualifier.

page_feed_page_urlstring

Source field pageFeedPageUrl.

asset_group_listing_group_filter#

titan.google_ads.asset_group_listing_group_filter has 13 source columns.

google_ads.asset_group_listing_group_filter13 columns
idstringpk

Source field id.

asset_group_idstring

Source field assetGroupId.

parent_idstring

Source field parentId.

typestring

Source field type.

pathjson

Source field path.

product_brand_valuestring

Source field productBrandValue.

product_item_id_valuestring

Source field productItemIdValue.

product_category_levelstring

Source field productCategoryLevel.

product_category_idstring

Source field productCategoryId.

product_channel_channelstring

Source field productChannelChannel.

product_condition_conditionstring

Source field productConditionCondition.

product_custom_attribute_indexstring

Source field productCustomAttributeIndex.

product_custom_attribute_valuestring

Source field productCustomAttributeValue.

asset_group_signal#

titan.google_ads.asset_group_signal has 5 source columns.

google_ads.asset_group_signal5 columns
resource_namestringpk

Source field resourceName.

asset_group_idstring

Source field assetGroupId.

search_theme_textstring

Source field searchThemeText.

audience_signaljson

Source field audienceSignal.

disapproval_reasonsjson

Source field disapprovalReasons.

campaign_label#

titan.google_ads.campaign_label has 2 source columns.

google_ads.campaign_label2 columns
campaign_idstringpk

Source field campaignId.

label_idstringpk

Source field labelId.

ad_group_label#

titan.google_ads.ad_group_label has 2 source columns.

google_ads.ad_group_label2 columns
ad_group_idstringpk

Source field adGroupId.

label_idstringpk

Source field labelId.

ad_group_ad_label#

titan.google_ads.ad_group_ad_label has 3 source columns.

google_ads.ad_group_ad_label3 columns
ad_group_idstringpk

Source field adGroupId.

ad_idstringpk

Source field adId.

label_idstringpk

Source field labelId.

ad_group_criterion_label#

titan.google_ads.ad_group_criterion_label has 3 source columns.

google_ads.ad_group_criterion_label3 columns
ad_group_idstringpk

Source field adGroupId.

criterion_idstringpk

Source field criterionId.

label_idstringpk

Source field labelId.

account_metrics#

titan.google_ads.account_metrics has 24 source columns.

google_ads.account_metrics24 columns
datedatepk

Source field date.

devicestringpk

Source field device.

ad_network_typestringpk

Source field adNetworkType.

impressionsinteger

Source field impressions.

clicksinteger

Source field clicks.

interactionsinteger

Source field interactions.

video_viewsinteger

Source field videoViews.

view_through_conversionsinteger

Source field viewThroughConversions.

cost_microsinteger

Source field costMicros.

average_cpcinteger

Source field averageCpc.

average_cpminteger

Source field averageCpm.

average_costinteger

Source field averageCost.

cost_per_conversioninteger

Source field costPerConversion.

conversionsfloat

Source field conversions.

all_conversionsfloat

Source field allConversions.

conversions_valuedecimal(28,2)

Source field conversionsValue.

all_conversions_valuedecimal(28,2)

Source field allConversionsValue.

ctrfloat

Source field ctr.

interaction_ratefloat

Source field interactionRate.

conversions_from_interactions_ratefloat

Source field conversionsFromInteractionsRate.

video_view_ratefloat

Source field videoViewRate.

search_impression_sharefloat

Source field searchImpressionShare.

absolute_top_impression_percentagefloat

Source field absoluteTopImpressionPercentage.

conversions_from_interactions_value_per_interactionfloat

Source field conversionsFromInteractionsValuePerInteraction.

campaign_metrics#

titan.google_ads.campaign_metrics has 25 source columns.

google_ads.campaign_metrics25 columns
campaign_idstringpk

Source field campaignId.

datedatepk

Source field date.

devicestringpk

Source field device.

ad_network_typestringpk

Source field adNetworkType.

impressionsinteger

Source field impressions.

clicksinteger

Source field clicks.

interactionsinteger

Source field interactions.

video_viewsinteger

Source field videoViews.

view_through_conversionsinteger

Source field viewThroughConversions.

cost_microsinteger

Source field costMicros.

average_cpcinteger

Source field averageCpc.

average_cpminteger

Source field averageCpm.

average_costinteger

Source field averageCost.

cost_per_conversioninteger

Source field costPerConversion.

conversionsfloat

Source field conversions.

all_conversionsfloat

Source field allConversions.

conversions_valuedecimal(28,2)

Source field conversionsValue.

all_conversions_valuedecimal(28,2)

Source field allConversionsValue.

ctrfloat

Source field ctr.

interaction_ratefloat

Source field interactionRate.

conversions_from_interactions_ratefloat

Source field conversionsFromInteractionsRate.

video_view_ratefloat

Source field videoViewRate.

search_impression_sharefloat

Source field searchImpressionShare.

absolute_top_impression_percentagefloat

Source field absoluteTopImpressionPercentage.

conversions_from_interactions_value_per_interactionfloat

Source field conversionsFromInteractionsValuePerInteraction.

ad_group_metrics#

titan.google_ads.ad_group_metrics has 26 source columns.

google_ads.ad_group_metrics26 columns
ad_group_idstringpk

Source field adGroupId.

campaign_idstringpk

Source field campaignId.

datedatepk

Source field date.

devicestringpk

Source field device.

ad_network_typestringpk

Source field adNetworkType.

impressionsinteger

Source field impressions.

clicksinteger

Source field clicks.

interactionsinteger

Source field interactions.

video_viewsinteger

Source field videoViews.

view_through_conversionsinteger

Source field viewThroughConversions.

cost_microsinteger

Source field costMicros.

average_cpcinteger

Source field averageCpc.

average_cpminteger

Source field averageCpm.

average_costinteger

Source field averageCost.

cost_per_conversioninteger

Source field costPerConversion.

conversionsfloat

Source field conversions.

all_conversionsfloat

Source field allConversions.

conversions_valuedecimal(28,2)

Source field conversionsValue.

all_conversions_valuedecimal(28,2)

Source field allConversionsValue.

ctrfloat

Source field ctr.

interaction_ratefloat

Source field interactionRate.

conversions_from_interactions_ratefloat

Source field conversionsFromInteractionsRate.

video_view_ratefloat

Source field videoViewRate.

search_impression_sharefloat

Source field searchImpressionShare.

absolute_top_impression_percentagefloat

Source field absoluteTopImpressionPercentage.

conversions_from_interactions_value_per_interactionfloat

Source field conversionsFromInteractionsValuePerInteraction.

ad_metrics#

titan.google_ads.ad_metrics has 28 source columns.

google_ads.ad_metrics28 columns
ad_group_idstringpk

Source field adGroupId.

ad_idstringpk

Source field adId.

campaign_idstringpk

Source field campaignId.

datedatepk

Source field date.

devicestringpk

Source field device.

ad_network_typestringpk

Source field adNetworkType.

keyword_criterion_idstringpk

Source field keywordCriterionId.

impressionsinteger

Source field impressions.

clicksinteger

Source field clicks.

interactionsinteger

Source field interactions.

video_viewsinteger

Source field videoViews.

view_through_conversionsinteger

Source field viewThroughConversions.

cost_microsinteger

Source field costMicros.

average_cpcinteger

Source field averageCpc.

average_cpminteger

Source field averageCpm.

average_costinteger

Source field averageCost.

cost_per_conversioninteger

Source field costPerConversion.

conversionsfloat

Source field conversions.

all_conversionsfloat

Source field allConversions.

conversions_valuedecimal(28,2)

Source field conversionsValue.

all_conversions_valuedecimal(28,2)

Source field allConversionsValue.

ctrfloat

Source field ctr.

interaction_ratefloat

Source field interactionRate.

conversions_from_interactions_ratefloat

Source field conversionsFromInteractionsRate.

video_view_ratefloat

Source field videoViewRate.

search_impression_sharefloat

Source field searchImpressionShare.

absolute_top_impression_percentagefloat

Source field absoluteTopImpressionPercentage.

conversions_from_interactions_value_per_interactionfloat

Source field conversionsFromInteractionsValuePerInteraction.

keyword_metrics#

titan.google_ads.keyword_metrics has 25 source columns.

google_ads.keyword_metrics25 columns
ad_group_idstringpk

Source field adGroupId.

criterion_idstringpk

Source field criterionId.

campaign_idstringpk

Source field campaignId.

datedatepk

Source field date.

impressionsinteger

Source field impressions.

clicksinteger

Source field clicks.

interactionsinteger

Source field interactions.

video_viewsinteger

Source field videoViews.

view_through_conversionsinteger

Source field viewThroughConversions.

cost_microsinteger

Source field costMicros.

average_cpcinteger

Source field averageCpc.

average_cpminteger

Source field averageCpm.

average_costinteger

Source field averageCost.

cost_per_conversioninteger

Source field costPerConversion.

conversionsfloat

Source field conversions.

all_conversionsfloat

Source field allConversions.

conversions_valuedecimal(28,2)

Source field conversionsValue.

all_conversions_valuedecimal(28,2)

Source field allConversionsValue.

ctrfloat

Source field ctr.

interaction_ratefloat

Source field interactionRate.

conversions_from_interactions_ratefloat

Source field conversionsFromInteractionsRate.

video_view_ratefloat

Source field videoViewRate.

search_impression_sharefloat

Source field searchImpressionShare.

absolute_top_impression_percentagefloat

Source field absoluteTopImpressionPercentage.

conversions_from_interactions_value_per_interactionfloat

Source field conversionsFromInteractionsValuePerInteraction.

search_term_metrics#

titan.google_ads.search_term_metrics has 29 source columns.

google_ads.search_term_metrics29 columns
campaign_idstringpk

Source field campaignId.

ad_group_idstringpk

Source field adGroupId.

search_termstringpk

Source field searchTerm.

datedatepk

Source field date.

statusstring

Source field status.

keyword_criterion_idstringpk

Source field keywordCriterionId.

search_term_match_typestring

Source field searchTermMatchType.

keyword_textstring

Source field keywordText.

impressionsinteger

Source field impressions.

clicksinteger

Source field clicks.

interactionsinteger

Source field interactions.

video_viewsinteger

Source field videoViews.

view_through_conversionsinteger

Source field viewThroughConversions.

cost_microsinteger

Source field costMicros.

average_cpcinteger

Source field averageCpc.

average_cpminteger

Source field averageCpm.

average_costinteger

Source field averageCost.

cost_per_conversioninteger

Source field costPerConversion.

conversionsfloat

Source field conversions.

all_conversionsfloat

Source field allConversions.

conversions_valuedecimal(28,2)

Source field conversionsValue.

all_conversions_valuedecimal(28,2)

Source field allConversionsValue.

ctrfloat

Source field ctr.

interaction_ratefloat

Source field interactionRate.

conversions_from_interactions_ratefloat

Source field conversionsFromInteractionsRate.

video_view_ratefloat

Source field videoViewRate.

search_impression_sharefloat

Source field searchImpressionShare.

absolute_top_impression_percentagefloat

Source field absoluteTopImpressionPercentage.

conversions_from_interactions_value_per_interactionfloat

Source field conversionsFromInteractionsValuePerInteraction.

asset_group_metrics#

titan.google_ads.asset_group_metrics has 24 source columns.

google_ads.asset_group_metrics24 columns
asset_group_idstringpk

Source field assetGroupId.

campaign_idstringpk

Source field campaignId.

datedatepk

Source field date.

impressionsinteger

Source field impressions.

clicksinteger

Source field clicks.

interactionsinteger

Source field interactions.

video_viewsinteger

Source field videoViews.

view_through_conversionsinteger

Source field viewThroughConversions.

cost_microsinteger

Source field costMicros.

average_cpcinteger

Source field averageCpc.

average_cpminteger

Source field averageCpm.

average_costinteger

Source field averageCost.

cost_per_conversioninteger

Source field costPerConversion.

conversionsfloat

Source field conversions.

all_conversionsfloat

Source field allConversions.

conversions_valuedecimal(28,2)

Source field conversionsValue.

all_conversions_valuedecimal(28,2)

Source field allConversionsValue.

ctrfloat

Source field ctr.

interaction_ratefloat

Source field interactionRate.

conversions_from_interactions_ratefloat

Source field conversionsFromInteractionsRate.

video_view_ratefloat

Source field videoViewRate.

search_impression_sharefloat

Source field searchImpressionShare.

absolute_top_impression_percentagefloat

Source field absoluteTopImpressionPercentage.

conversions_from_interactions_value_per_interactionfloat

Source field conversionsFromInteractionsValuePerInteraction.

geographic_view#

titan.google_ads.geographic_view has 28 source columns.

google_ads.geographic_view28 columns
campaign_idstringpk

Source field campaignId.

datedatepk

Source field date.

geo_target_constant_idstringpk

Source field geoTargetConstantId.

location_typestringpk

Source field locationType.

country_criterion_idstring

Source field countryCriterionId.

country_namestring

Source field countryName.

geo_target_namestring

Source field geoTargetName.

impressionsinteger

Source field impressions.

clicksinteger

Source field clicks.

interactionsinteger

Source field interactions.

video_viewsinteger

Source field videoViews.

view_through_conversionsinteger

Source field viewThroughConversions.

cost_microsinteger

Source field costMicros.

average_cpcinteger

Source field averageCpc.

average_cpminteger

Source field averageCpm.

average_costinteger

Source field averageCost.

cost_per_conversioninteger

Source field costPerConversion.

conversionsfloat

Source field conversions.

all_conversionsfloat

Source field allConversions.

conversions_valuedecimal(28,2)

Source field conversionsValue.

all_conversions_valuedecimal(28,2)

Source field allConversionsValue.

ctrfloat

Source field ctr.

interaction_ratefloat

Source field interactionRate.

conversions_from_interactions_ratefloat

Source field conversionsFromInteractionsRate.

video_view_ratefloat

Source field videoViewRate.

search_impression_sharefloat

Source field searchImpressionShare.

absolute_top_impression_percentagefloat

Source field absoluteTopImpressionPercentage.

conversions_from_interactions_value_per_interactionfloat

Source field conversionsFromInteractionsValuePerInteraction.

user_location_view#

titan.google_ads.user_location_view has 28 source columns.

google_ads.user_location_view28 columns
campaign_idstringpk

Source field campaignId.

datedatepk

Source field date.

geo_target_constant_idstringpk

Source field geoTargetConstantId.

country_criterion_idstring

Source field countryCriterionId.

country_namestring

Source field countryName.

geo_target_namestring

Source field geoTargetName.

targeting_locationbooleanpk

Source field targetingLocation.

impressionsinteger

Source field impressions.

clicksinteger

Source field clicks.

interactionsinteger

Source field interactions.

video_viewsinteger

Source field videoViews.

view_through_conversionsinteger

Source field viewThroughConversions.

cost_microsinteger

Source field costMicros.

average_cpcinteger

Source field averageCpc.

average_cpminteger

Source field averageCpm.

average_costinteger

Source field averageCost.

cost_per_conversioninteger

Source field costPerConversion.

conversionsfloat

Source field conversions.

all_conversionsfloat

Source field allConversions.

conversions_valuedecimal(28,2)

Source field conversionsValue.

all_conversions_valuedecimal(28,2)

Source field allConversionsValue.

ctrfloat

Source field ctr.

interaction_ratefloat

Source field interactionRate.

conversions_from_interactions_ratefloat

Source field conversionsFromInteractionsRate.

video_view_ratefloat

Source field videoViewRate.

search_impression_sharefloat

Source field searchImpressionShare.

absolute_top_impression_percentagefloat

Source field absoluteTopImpressionPercentage.

conversions_from_interactions_value_per_interactionfloat

Source field conversionsFromInteractionsValuePerInteraction.

age_range_view#

titan.google_ads.age_range_view has 26 source columns.

google_ads.age_range_view26 columns
campaign_idstringpk

Source field campaignId.

ad_group_idstringpk

Source field adGroupId.

datedatepk

Source field date.

age_range_typestringpk

Source field ageRangeType.

criterion_idstring

Source field criterionId.

impressionsinteger

Source field impressions.

clicksinteger

Source field clicks.

interactionsinteger

Source field interactions.

video_viewsinteger

Source field videoViews.

view_through_conversionsinteger

Source field viewThroughConversions.

cost_microsinteger

Source field costMicros.

average_cpcinteger

Source field averageCpc.

average_cpminteger

Source field averageCpm.

average_costinteger

Source field averageCost.

cost_per_conversioninteger

Source field costPerConversion.

conversionsfloat

Source field conversions.

all_conversionsfloat

Source field allConversions.

conversions_valuedecimal(28,2)

Source field conversionsValue.

all_conversions_valuedecimal(28,2)

Source field allConversionsValue.

ctrfloat

Source field ctr.

interaction_ratefloat

Source field interactionRate.

conversions_from_interactions_ratefloat

Source field conversionsFromInteractionsRate.

video_view_ratefloat

Source field videoViewRate.

search_impression_sharefloat

Source field searchImpressionShare.

absolute_top_impression_percentagefloat

Source field absoluteTopImpressionPercentage.

conversions_from_interactions_value_per_interactionfloat

Source field conversionsFromInteractionsValuePerInteraction.

gender_view#

titan.google_ads.gender_view has 26 source columns.

google_ads.gender_view26 columns
campaign_idstringpk

Source field campaignId.

ad_group_idstringpk

Source field adGroupId.

datedatepk

Source field date.

gender_typestringpk

Source field genderType.

criterion_idstring

Source field criterionId.

impressionsinteger

Source field impressions.

clicksinteger

Source field clicks.

interactionsinteger

Source field interactions.

video_viewsinteger

Source field videoViews.

view_through_conversionsinteger

Source field viewThroughConversions.

cost_microsinteger

Source field costMicros.

average_cpcinteger

Source field averageCpc.

average_cpminteger

Source field averageCpm.

average_costinteger

Source field averageCost.

cost_per_conversioninteger

Source field costPerConversion.

conversionsfloat

Source field conversions.

all_conversionsfloat

Source field allConversions.

conversions_valuedecimal(28,2)

Source field conversionsValue.

all_conversions_valuedecimal(28,2)

Source field allConversionsValue.

ctrfloat

Source field ctr.

interaction_ratefloat

Source field interactionRate.

conversions_from_interactions_ratefloat

Source field conversionsFromInteractionsRate.

video_view_ratefloat

Source field videoViewRate.

search_impression_sharefloat

Source field searchImpressionShare.

absolute_top_impression_percentagefloat

Source field absoluteTopImpressionPercentage.

conversions_from_interactions_value_per_interactionfloat

Source field conversionsFromInteractionsValuePerInteraction.

income_range_view#

titan.google_ads.income_range_view has 26 source columns.

google_ads.income_range_view26 columns
campaign_idstringpk

Source field campaignId.

ad_group_idstringpk

Source field adGroupId.

datedatepk

Source field date.

income_range_typestringpk

Source field incomeRangeType.

criterion_idstring

Source field criterionId.

impressionsinteger

Source field impressions.

clicksinteger

Source field clicks.

interactionsinteger

Source field interactions.

video_viewsinteger

Source field videoViews.

view_through_conversionsinteger

Source field viewThroughConversions.

cost_microsinteger

Source field costMicros.

average_cpcinteger

Source field averageCpc.

average_cpminteger

Source field averageCpm.

average_costinteger

Source field averageCost.

cost_per_conversioninteger

Source field costPerConversion.

conversionsfloat

Source field conversions.

all_conversionsfloat

Source field allConversions.

conversions_valuedecimal(28,2)

Source field conversionsValue.

all_conversions_valuedecimal(28,2)

Source field allConversionsValue.

ctrfloat

Source field ctr.

interaction_ratefloat

Source field interactionRate.

conversions_from_interactions_ratefloat

Source field conversionsFromInteractionsRate.

video_view_ratefloat

Source field videoViewRate.

search_impression_sharefloat

Source field searchImpressionShare.

absolute_top_impression_percentagefloat

Source field absoluteTopImpressionPercentage.

conversions_from_interactions_value_per_interactionfloat

Source field conversionsFromInteractionsValuePerInteraction.

parental_status_view#

titan.google_ads.parental_status_view has 26 source columns.

google_ads.parental_status_view26 columns
campaign_idstringpk

Source field campaignId.

ad_group_idstringpk

Source field adGroupId.

datedatepk

Source field date.

parental_status_typestringpk

Source field parentalStatusType.

criterion_idstring

Source field criterionId.

impressionsinteger

Source field impressions.

clicksinteger

Source field clicks.

interactionsinteger

Source field interactions.

video_viewsinteger

Source field videoViews.

view_through_conversionsinteger

Source field viewThroughConversions.

cost_microsinteger

Source field costMicros.

average_cpcinteger

Source field averageCpc.

average_cpminteger

Source field averageCpm.

average_costinteger

Source field averageCost.

cost_per_conversioninteger

Source field costPerConversion.

conversionsfloat

Source field conversions.

all_conversionsfloat

Source field allConversions.

conversions_valuedecimal(28,2)

Source field conversionsValue.

all_conversions_valuedecimal(28,2)

Source field allConversionsValue.

ctrfloat

Source field ctr.

interaction_ratefloat

Source field interactionRate.

conversions_from_interactions_ratefloat

Source field conversionsFromInteractionsRate.

video_view_ratefloat

Source field videoViewRate.

search_impression_sharefloat

Source field searchImpressionShare.

absolute_top_impression_percentagefloat

Source field absoluteTopImpressionPercentage.

conversions_from_interactions_value_per_interactionfloat

Source field conversionsFromInteractionsValuePerInteraction.

landing_page_view#

titan.google_ads.landing_page_view has 26 source columns.

google_ads.landing_page_view26 columns
campaign_idstringpk

Source field campaignId.

ad_group_idstringpk

Source field adGroupId.

datedatepk

Source field date.

expanded_final_urlstringpk

Source field expandedFinalUrl.

unexpanded_final_urlstring

Source field unexpandedFinalUrl.

impressionsinteger

Source field impressions.

clicksinteger

Source field clicks.

interactionsinteger

Source field interactions.

video_viewsinteger

Source field videoViews.

view_through_conversionsinteger

Source field viewThroughConversions.

cost_microsinteger

Source field costMicros.

average_cpcinteger

Source field averageCpc.

average_cpminteger

Source field averageCpm.

average_costinteger

Source field averageCost.

cost_per_conversioninteger

Source field costPerConversion.

conversionsfloat

Source field conversions.

all_conversionsfloat

Source field allConversions.

conversions_valuedecimal(28,2)

Source field conversionsValue.

all_conversions_valuedecimal(28,2)

Source field allConversionsValue.

ctrfloat

Source field ctr.

interaction_ratefloat

Source field interactionRate.

conversions_from_interactions_ratefloat

Source field conversionsFromInteractionsRate.

video_view_ratefloat

Source field videoViewRate.

search_impression_sharefloat

Source field searchImpressionShare.

absolute_top_impression_percentagefloat

Source field absoluteTopImpressionPercentage.

conversions_from_interactions_value_per_interactionfloat

Source field conversionsFromInteractionsValuePerInteraction.

ad_group_audience_view#

titan.google_ads.ad_group_audience_view has 26 source columns.

google_ads.ad_group_audience_view26 columns
campaign_idstringpk

Source field campaignId.

ad_group_idstringpk

Source field adGroupId.

criterion_idstringpk

Source field criterionId.

datedatepk

Source field date.

display_namestring

Source field displayName.

impressionsinteger

Source field impressions.

clicksinteger

Source field clicks.

interactionsinteger

Source field interactions.

video_viewsinteger

Source field videoViews.

view_through_conversionsinteger

Source field viewThroughConversions.

cost_microsinteger

Source field costMicros.

average_cpcinteger

Source field averageCpc.

average_cpminteger

Source field averageCpm.

average_costinteger

Source field averageCost.

cost_per_conversioninteger

Source field costPerConversion.

conversionsfloat

Source field conversions.

all_conversionsfloat

Source field allConversions.

conversions_valuedecimal(28,2)

Source field conversionsValue.

all_conversions_valuedecimal(28,2)

Source field allConversionsValue.

ctrfloat

Source field ctr.

interaction_ratefloat

Source field interactionRate.

conversions_from_interactions_ratefloat

Source field conversionsFromInteractionsRate.

video_view_ratefloat

Source field videoViewRate.

search_impression_sharefloat

Source field searchImpressionShare.

absolute_top_impression_percentagefloat

Source field absoluteTopImpressionPercentage.

conversions_from_interactions_value_per_interactionfloat

Source field conversionsFromInteractionsValuePerInteraction.

ad_schedule_view#

titan.google_ads.ad_schedule_view has 30 source columns.

google_ads.ad_schedule_view30 columns
campaign_idstringpk

Source field campaignId.

criterion_idstringpk

Source field criterionId.

datedatepk

Source field date.

day_of_weekstring

Source field dayOfWeek.

start_hourinteger

Source field startHour.

end_hourinteger

Source field endHour.

start_minutestring

Source field startMinute.

end_minutestring

Source field endMinute.

bid_modifierdecimal(28,6)

Source field bidModifier.

impressionsinteger

Source field impressions.

clicksinteger

Source field clicks.

interactionsinteger

Source field interactions.

video_viewsinteger

Source field videoViews.

view_through_conversionsinteger

Source field viewThroughConversions.

cost_microsinteger

Source field costMicros.

average_cpcinteger

Source field averageCpc.

average_cpminteger

Source field averageCpm.

average_costinteger

Source field averageCost.

cost_per_conversioninteger

Source field costPerConversion.

conversionsfloat

Source field conversions.

all_conversionsfloat

Source field allConversions.

conversions_valuedecimal(28,2)

Source field conversionsValue.

all_conversions_valuedecimal(28,2)

Source field allConversionsValue.

ctrfloat

Source field ctr.

interaction_ratefloat

Source field interactionRate.

conversions_from_interactions_ratefloat

Source field conversionsFromInteractionsRate.

video_view_ratefloat

Source field videoViewRate.

search_impression_sharefloat

Source field searchImpressionShare.

absolute_top_impression_percentagefloat

Source field absoluteTopImpressionPercentage.

conversions_from_interactions_value_per_interactionfloat

Source field conversionsFromInteractionsValuePerInteraction.

shopping_performance_view#

titan.google_ads.shopping_performance_view has 48 source columns.

google_ads.shopping_performance_view48 columns
campaign_idstringpk

Source field campaignId.

ad_group_idstringpk

Source field adGroupId.

datedatepk

Source field date.

product_item_idstringpk

Source field productItemId.

product_brandstringpk

Source field productBrand.

product_category_l1stringpk

Source field productCategoryL1.

product_category_l2stringpk

Source field productCategoryL2.

product_category_l3stringpk

Source field productCategoryL3.

product_category_l4stringpk

Source field productCategoryL4.

product_category_l5stringpk

Source field productCategoryL5.

product_channelstringpk

Source field productChannel.

product_channel_exclusivitystringpk

Source field productChannelExclusivity.

product_conditionstringpk

Source field productCondition.

product_custom_attribute0stringpk

Source field productCustomAttribute0.

product_custom_attribute1stringpk

Source field productCustomAttribute1.

product_custom_attribute2stringpk

Source field productCustomAttribute2.

product_custom_attribute3stringpk

Source field productCustomAttribute3.

product_custom_attribute4stringpk

Source field productCustomAttribute4.

product_languagestringpk

Source field productLanguage.

product_merchant_idstringpk

Source field productMerchantId.

product_store_idstringpk

Source field productStoreId.

product_titlestringpk

Source field productTitle.

product_type_l1stringpk

Source field productTypeL1.

product_type_l2stringpk

Source field productTypeL2.

product_type_l3stringpk

Source field productTypeL3.

product_type_l4stringpk

Source field productTypeL4.

product_type_l5stringpk

Source field productTypeL5.

impressionsinteger

Source field impressions.

clicksinteger

Source field clicks.

interactionsinteger

Source field interactions.

video_viewsinteger

Source field videoViews.

view_through_conversionsinteger

Source field viewThroughConversions.

cost_microsinteger

Source field costMicros.

average_cpcinteger

Source field averageCpc.

average_cpminteger

Source field averageCpm.

average_costinteger

Source field averageCost.

cost_per_conversioninteger

Source field costPerConversion.

conversionsfloat

Source field conversions.

all_conversionsfloat

Source field allConversions.

conversions_valuedecimal(28,2)

Source field conversionsValue.

all_conversions_valuedecimal(28,2)

Source field allConversionsValue.

ctrfloat

Source field ctr.

interaction_ratefloat

Source field interactionRate.

conversions_from_interactions_ratefloat

Source field conversionsFromInteractionsRate.

video_view_ratefloat

Source field videoViewRate.

search_impression_sharefloat

Source field searchImpressionShare.

absolute_top_impression_percentagefloat

Source field absoluteTopImpressionPercentage.

conversions_from_interactions_value_per_interactionfloat

Source field conversionsFromInteractionsValuePerInteraction.

click_view#

titan.google_ads.click_view has 12 source columns.

google_ads.click_view12 columns
gclidstringpk

Source field gclid.

datedatepk

Source field date.

campaign_idstring

Source field campaignId.

ad_group_idstring

Source field adGroupId.

ad_idstring

Source field adId.

keyword_criterion_idstring

Source field keywordCriterionId.

keyword_textstring

Source field keywordText.

keyword_match_typestring

Source field keywordMatchType.

page_numberinteger

Source field pageNumber.

area_of_interest_idstring

Source field areaOfInterestId.

location_of_presence_idstring

Source field locationOfPresenceId.

user_list_idstring

Source field userListId.

change_event#

titan.google_ads.change_event has 11 source columns.

google_ads.change_event11 columns
resource_namestringpk

Source field resourceName.

change_date_timedatetime

Source field changeDateTime.

change_resource_typestring

Source field changeResourceType.

change_resource_namestring

Source field changeResourceName.

client_typestring

Source field clientType.

user_emailstring

Source field userEmail.

campaign_idstring

Source field campaignId.

ad_group_idstring

Source field adGroupId.

changed_fieldsstring

Source field changedFields.

old_resourcejson

Source field oldResource.

new_resourcejson

Source field newResource.

geo_target_constant#

titan.google_ads.geo_target_constant has 7 source columns.

google_ads.geo_target_constant7 columns
idstringpk

Source field id.

namestring

Source field name.

canonical_namestring

Source field canonicalName.

country_codestring

Source field countryCode.

target_typestring

Source field targetType.

statusstring

Source field status.

parent_geo_target_idstring

Source field parentGeoTargetId.

language_constant#

titan.google_ads.language_constant has 4 source columns.

google_ads.language_constant4 columns
idstringpk

Source field id.

namestring

Source field name.

codestring

Source field code.

targetableboolean

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.