Power BI Connector for Google Ads

Build 24.0.9062

Recommendation

A recommendation.

Columns

Name Type Behavior Description
CustomerId Long ATTRIBUTE Output only. The ID of the customer.
RecommendationAdGroup String ATTRIBUTE Output only. The ad group targeted by this recommendation. This will be set only when the recommendation affects a single ad group. This field will be set for the following recommendation types: KEYWORD, OPTIMIZE_AD_ROTATION, RESPONSIVE_SEARCH_AD, RESPONSIVE_SEARCH_AD_ASSET, TEXT_AD
RecommendationCallAssetRecommendation String ATTRIBUTE Output only. The call asset recommendation.
RecommendationCalloutAssetRecommendation String ATTRIBUTE Output only. The callout asset recommendation.
RecommendationCampaign String ATTRIBUTE Output only. The campaign targeted by this recommendation. This field will be set for the following recommendation types: CALL_EXTENSION, CALLOUT_EXTENSION, ENHANCED_CPC_OPT_IN, USE_BROAD_MATCH_KEYWORD, KEYWORD, KEYWORD_MATCH_TYPE, UPGRADE_LOCAL_CAMPAIGN_TO_PERFORMANCE_MAX, MAXIMIZE_CLICKS_OPT_IN, MAXIMIZE_CONVERSIONS_OPT_IN, OPTIMIZE_AD_ROTATION, RESPONSIVE_SEARCH_AD, RESPONSIVE_SEARCH_AD_ASSET, SEARCH_PARTNERS_OPT_IN, DISPLAY_EXPANSION_OPT_IN, SITELINK_EXTENSION, TARGET_CPA_OPT_IN, TARGET_ROAS_OPT_IN, TEXT_AD, UPGRADE_SMART_SHOPPING_CAMPAIGN_TO_PERFORMANCE_MAX, RAISE_TARGET_CPA_BID_TOO_LOW, FORECASTING_SET_TARGET_ROAS, SHOPPING_ADD_AGE_GROUP, SHOPPING_ADD_COLOR, SHOPPING_ADD_GENDER, SHOPPING_ADD_SIZE, SHOPPING_ADD_GTIN, SHOPPING_ADD_MORE_IDENTIFIERS, SHOPPING_ADD_PRODUCTS_TO_CAMPAIGN, SHOPPING_FIX_DISAPPROVED_PRODUCTS, SHOPPING_MIGRATE_REGULAR_SHOPPING_CAMPAIGN_OFFERS_TO_PERFORMANCE_MAX, DYNAMIC_IMAGE_EXTENSION_OPT_IN, RAISE_TARGET_CPA, LOWER_TARGET_ROAS, FORECASTING_SET_TARGET_CPA, SET_TARGET_CPA, SET_TARGET_ROAS, MAXIMIZE_CONVERSION_VALUE_OPT_IN, IMPROVE_GOOGLE_TAG_COVERAGE, PERFORMANCE_MAX_FINAL_URL_OPT_IN
RecommendationCampaignBudget String ATTRIBUTE Output only. The budget targeted by this recommendation. This will be set only when the recommendation affects a single campaign budget. This field will be set for the following recommendation types: CAMPAIGN_BUDGET, FORECASTING_CAMPAIGN_BUDGET, MARGINAL_ROI_CAMPAIGN_BUDGET, MOVE_UNUSED_BUDGET
RecommendationCampaignBudgetRecommendation String ATTRIBUTE Output only. The campaign budget recommendation.
RecommendationCampaigns String ATTRIBUTE Output only. The campaigns targeted by this recommendation. This field will be set for the following recommendation types: CAMPAIGN_BUDGET, FORECASTING_CAMPAIGN_BUDGET, MARGINAL_ROI_CAMPAIGN_BUDGET and MOVE_UNUSED_BUDGET
RecommendationCustomAudienceOptInRecommendation String ATTRIBUTE Output only. The custom audience opt in recommendation.
RecommendationDismissed Bool ATTRIBUTE Output only. Whether the recommendation is dismissed or not.
RecommendationDisplayExpansionOptInRecommendation String ATTRIBUTE Output only. The Display Expansion opt-in recommendation.
RecommendationDynamicImageExtensionOptInRecommendation String ATTRIBUTE Output only. Recommendation to enable dynamic image extensions on the account, allowing Google to find the best images from ad landing pages and complement text ads.
RecommendationEnhancedCpcOptInRecommendation String ATTRIBUTE Output only. The Enhanced Cost-Per-Click Opt-In recommendation.
RecommendationForecastingCampaignBudgetRecommendation String ATTRIBUTE Output only. The forecasting campaign budget recommendation.
RecommendationForecastingSetTargetCpaRecommendation String ATTRIBUTE Output only. The forecasting set target CPA recommendation.
RecommendationForecastingSetTargetRoasRecommendation String ATTRIBUTE Output only. The forecasting set target ROAS recommendation.
RecommendationImpact String ATTRIBUTE Output only. The impact on account performance as a result of applying the recommendation.
RecommendationImproveDemandGenAdStrengthRecommendation String ATTRIBUTE Output only. The improve Demand Gen ad strength recommendation.
RecommendationImproveGoogleTagCoverageRecommendation String ATTRIBUTE Output only. Recommendation to deploy Google Tag on more pages.
RecommendationImprovePerformanceMaxAdStrengthRecommendation String ATTRIBUTE Output only. The improve Performance Max ad strength recommendation.
RecommendationKeywordMatchTypeRecommendation String ATTRIBUTE Output only. The keyword match type recommendation.
RecommendationKeywordRecommendation String ATTRIBUTE Output only. The keyword recommendation.
RecommendationLeadFormAssetRecommendation String ATTRIBUTE Output only. The lead form asset recommendation.
RecommendationLowerTargetRoasRecommendation String ATTRIBUTE Output only. Recommendation to lower Target ROAS.
RecommendationMarginalRoiCampaignBudgetRecommendation String ATTRIBUTE Output only. The marginal ROI campaign budget recommendation.
RecommendationMaximizeClicksOptInRecommendation String ATTRIBUTE Output only. The MaximizeClicks Opt-In recommendation.
RecommendationMaximizeConversionValueOptInRecommendation String ATTRIBUTE Output only. The Maximize Conversion Value opt-in recommendation.
RecommendationMaximizeConversionsOptInRecommendation String ATTRIBUTE Output only. The MaximizeConversions Opt-In recommendation.
RecommendationMigrateDynamicSearchAdsCampaignToPerformanceMaxRecommendation String ATTRIBUTE Output only. The Dynamic Search Ads to Performance Max migration recommendation.
RecommendationMoveUnusedBudgetRecommendation String ATTRIBUTE Output only. The move unused budget recommendation.
RecommendationOptimizeAdRotationRecommendation String ATTRIBUTE Output only. The Optimize Ad Rotation recommendation.
RecommendationPerformanceMaxFinalUrlOptInRecommendation String ATTRIBUTE Output only. Recommendation to turn on Final URL expansion for your Performance Max campaigns.
RecommendationPerformanceMaxOptInRecommendation String ATTRIBUTE Output only. The Performance Max Opt In recommendation.
RecommendationRaiseTargetCpaBidTooLowRecommendation String ATTRIBUTE Output only. The raise target CPA bid too low recommendation.
RecommendationRaiseTargetCpaRecommendation String ATTRIBUTE Output only. Recommendation to raise Target CPA.
RecommendationRefreshCustomerMatchListRecommendation String ATTRIBUTE Output only. The refresh customer list recommendation.
RecommendationResourceName String ATTRIBUTE Immutable. The resource name of the recommendation. customers/{customer_id}/recommendations/{recommendation_id}
RecommendationResponsiveSearchAdAssetRecommendation String ATTRIBUTE Output only. The responsive search ad asset recommendation.
RecommendationResponsiveSearchAdImproveAdStrengthRecommendation String ATTRIBUTE Output only. The responsive search ad improve ad strength recommendation.
RecommendationResponsiveSearchAdRecommendation String ATTRIBUTE Output only. The add responsive search ad recommendation.
RecommendationSearchPartnersOptInRecommendation String ATTRIBUTE Output only. The Search Partners Opt-In recommendation.
RecommendationSetTargetCpaRecommendation String ATTRIBUTE Output only. The set target CPA recommendation.
RecommendationSetTargetRoasRecommendation String ATTRIBUTE Output only. The set target ROAS recommendation.
RecommendationShoppingAddAgeGroupRecommendation String ATTRIBUTE Output only. The shopping add age group recommendation.
RecommendationShoppingAddColorRecommendation String ATTRIBUTE Output only. The shopping add color recommendation.
RecommendationShoppingAddGenderRecommendation String ATTRIBUTE Output only. The shopping add gender recommendation.
RecommendationShoppingAddGtinRecommendation String ATTRIBUTE Output only. The shopping add GTIN recommendation.
RecommendationShoppingAddMoreIdentifiersRecommendation String ATTRIBUTE Output only. The shopping add more identifiers recommendation.
RecommendationShoppingAddProductsToCampaignRecommendation String ATTRIBUTE Output only. The shopping add products to campaign recommendation.
RecommendationShoppingAddSizeRecommendation String ATTRIBUTE Output only. The shopping add size recommendation.
RecommendationShoppingFixDisapprovedProductsRecommendation String ATTRIBUTE Output only. The shopping fix disapproved products recommendation.
RecommendationShoppingFixMerchantCenterAccountSuspensionWarningRecommendation String ATTRIBUTE Output only. The shopping fix Merchant Center account suspension warning recommendation.
RecommendationShoppingFixSuspendedMerchantCenterAccountRecommendation String ATTRIBUTE Output only. The shopping fix suspended Merchant Center account recommendation.
RecommendationShoppingMigrateRegularShoppingCampaignOffersToPerformanceMaxRecommendation String ATTRIBUTE Output only. The shopping migrate Regular Shopping Campaign offers to Performance Max recommendation.
RecommendationShoppingTargetAllOffersRecommendation String ATTRIBUTE Output only. The shopping target all offers recommendation.
RecommendationSitelinkAssetRecommendation String ATTRIBUTE Output only. The sitelink asset recommendation.
RecommendationTargetCpaOptInRecommendation String ATTRIBUTE Output only. The TargetCPA opt-in recommendation.
RecommendationTargetRoasOptInRecommendation String ATTRIBUTE Output only. The Target ROAS opt-in recommendation.
RecommendationTextAdRecommendation String ATTRIBUTE Output only. Add expanded text ad recommendation.
RecommendationType String ATTRIBUTE Output only. The type of recommendation.

使用できる値は次のとおりです。CALLOUT_ASSET, CALL_ASSET, CAMPAIGN_BUDGET, CUSTOM_AUDIENCE_OPT_IN, DISPLAY_EXPANSION_OPT_IN, DYNAMIC_IMAGE_EXTENSION_OPT_IN, ENHANCED_CPC_OPT_IN, FORECASTING_CAMPAIGN_BUDGET, FORECASTING_SET_TARGET_CPA, FORECASTING_SET_TARGET_ROAS, IMPROVE_DEMAND_GEN_AD_STRENGTH, IMPROVE_GOOGLE_TAG_COVERAGE, IMPROVE_PERFORMANCE_MAX_AD_STRENGTH, KEYWORD, KEYWORD_MATCH_TYPE, LEAD_FORM_ASSET, LOWER_TARGET_ROAS, MARGINAL_ROI_CAMPAIGN_BUDGET, MAXIMIZE_CLICKS_OPT_IN, MAXIMIZE_CONVERSIONS_OPT_IN, MAXIMIZE_CONVERSION_VALUE_OPT_IN, MIGRATE_DYNAMIC_SEARCH_ADS_CAMPAIGN_TO_PERFORMANCE_MAX, MOVE_UNUSED_BUDGET, OPTIMIZE_AD_ROTATION, PERFORMANCE_MAX_FINAL_URL_OPT_IN, PERFORMANCE_MAX_OPT_IN, RAISE_TARGET_CPA, RAISE_TARGET_CPA_BID_TOO_LOW, REFRESH_CUSTOMER_MATCH_LIST, RESPONSIVE_SEARCH_AD, RESPONSIVE_SEARCH_AD_ASSET, RESPONSIVE_SEARCH_AD_IMPROVE_AD_STRENGTH, SEARCH_PARTNERS_OPT_IN, SET_TARGET_CPA, SET_TARGET_ROAS, SHOPPING_ADD_AGE_GROUP, SHOPPING_ADD_COLOR, SHOPPING_ADD_GENDER, SHOPPING_ADD_GTIN, SHOPPING_ADD_MORE_IDENTIFIERS, SHOPPING_ADD_PRODUCTS_TO_CAMPAIGN, SHOPPING_ADD_SIZE, SHOPPING_FIX_DISAPPROVED_PRODUCTS, SHOPPING_FIX_MERCHANT_CENTER_ACCOUNT_SUSPENSION_WARNING, SHOPPING_FIX_SUSPENDED_MERCHANT_CENTER_ACCOUNT, SHOPPING_MIGRATE_REGULAR_SHOPPING_CAMPAIGN_OFFERS_TO_PERFORMANCE_MAX, SHOPPING_TARGET_ALL_OFFERS, SITELINK_ASSET, TARGET_CPA_OPT_IN, TARGET_ROAS_OPT_IN, TEXT_AD, UNKNOWN, UNSPECIFIED, UPGRADE_LOCAL_CAMPAIGN_TO_PERFORMANCE_MAX, UPGRADE_SMART_SHOPPING_CAMPAIGN_TO_PERFORMANCE_MAX, USE_BROAD_MATCH_KEYWORD

RecommendationUpgradeLocalCampaignToPerformanceMaxRecommendation String ATTRIBUTE Output only. The upgrade a Local campaign to a Performance Max campaign recommendation.
RecommendationUpgradeSmartShoppingCampaignToPerformanceMaxRecommendation String ATTRIBUTE Output only. The upgrade a Smart Shopping campaign to a Performance Max campaign recommendation.
RecommendationUseBroadMatchKeywordRecommendation String ATTRIBUTE Output only. The use broad match keyword recommendation.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似列フィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Name Type Description
ManagerId Long Id of the manager account on behalf of which you are requesting customer data.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062