ADO.NET Provider for Google Ads

Build 26.0.9655

BiddingStrategy

A bidding strategy.

View-Specific Information

Select

Google Ads does not allow every column to be selected in a single query, as some data conflicts if selected together. Therefore, when issuing a query that selects all columns, only the default metrics, segments, and attributes are returned. In general, these defaults are the same fields that are exposed through the Ads console. To use the nondefault fields, explicitly select them in your query.

Filters can also be used in the WHERE clause using the following supported operators: =, !=, >, >=, <, <=, LIKE, NOT LIKE, IN, NOT IN . Note that all filters must be joined by AND, as OR is not supported by the Ads API.

Columns

Name Type Behavior Description
BiddingStrategyAlignedCampaignBudgetId Long ATTRIBUTE ID of the campaign budget that this portfolio bidding strategy
BiddingStrategyCampaignCount Long ATTRIBUTE Output only. The number of campaigns attached to this bidding strategy.
BiddingStrategyCurrencyCode String ATTRIBUTE Immutable. The currency used by the bidding strategy (ISO 4217 three-letter
BiddingStrategyEffectiveCurrencyCode String ATTRIBUTE Output only. The currency used by the bidding strategy (ISO 4217
BiddingStrategyEnhancedCpc String ATTRIBUTE A bidding strategy that raises bids for clicks that seem more likely to
BiddingStrategyId Long ATTRIBUTE Output only. The ID of the bidding strategy.
BiddingStrategyMaximizeConversionValueCpcBidCeilingMicros Long ATTRIBUTE Maximum bid limit that can be set by the bid strategy. The limit applies to all keywords managed by the strategy. Mutable for portfolio bidding strategies only.
BiddingStrategyMaximizeConversionValueCpcBidFloorMicros Long ATTRIBUTE Minimum bid limit that can be set by the bid strategy. The limit applies to all keywords managed by the strategy. Mutable for portfolio bidding strategies only.
BiddingStrategyMaximizeConversionValueTargetRoas Double ATTRIBUTE The target return on ad spend (ROAS) option. If set, the bid strategy will maximize revenue while averaging the target return on ad spend. If the target ROAS is high, the bid strategy may not be able to spend the full budget. If the target ROAS is not set, the bid strategy will aim to achieve the highest possible ROAS for the budget.
BiddingStrategyMaximizeConversionValueTargetRoasTolerancePercentMillis Long ATTRIBUTE The percent of ROAS(return on advertising spend) degradation tolerance allowed to increase traffic diversity and conversion volume, specified in millis (for example, 10,000 = 10%). A value of 10,000 means that the advertiser can expect ROAS degradation of up to 10% of the specified target ROAS.
BiddingStrategyMaximizeConversionsCpcBidCeilingMicros Long ATTRIBUTE Maximum bid limit that can be set by the bid strategy. The limit applies to all keywords managed by the strategy. Mutable for portfolio bidding strategies only.
BiddingStrategyMaximizeConversionsCpcBidFloorMicros Long ATTRIBUTE Minimum bid limit that can be set by the bid strategy. The limit applies to all keywords managed by the strategy. Mutable for portfolio bidding strategies only.
BiddingStrategyMaximizeConversionsTargetCpaMicros Long ATTRIBUTE The target cost-per-action (CPA) option. This is the average amount that you would like to spend per conversion action specified in micro units of the bidding strategy's currency. If set, the bid strategy will get as many conversions as possible at or below the target cost-per-action. If the target CPA is not set, the bid strategy will aim to achieve the lowest possible CPA given the budget.
BiddingStrategyName String ATTRIBUTE The name of the bidding strategy.
BiddingStrategyNonRemovedCampaignCount Long ATTRIBUTE Output only. The number of non-removed campaigns attached to this bidding
BiddingStrategyResourceName String ATTRIBUTE Immutable. The resource name of the bidding strategy.
BiddingStrategyStatus String ATTRIBUTE Output only. The status of the bidding strategy.

The allowed values are ENABLED, REMOVED, UNKNOWN.

BiddingStrategyTargetCpaCpcBidCeilingMicros Long ATTRIBUTE Maximum bid limit that can be set by the bid strategy. The limit applies to all keywords managed by the strategy. This should only be set for portfolio bid strategies.
BiddingStrategyTargetCpaCpcBidFloorMicros Long ATTRIBUTE Minimum bid limit that can be set by the bid strategy. The limit applies to all keywords managed by the strategy. This should only be set for portfolio bid strategies.
BiddingStrategyTargetCpaTargetCpaMicros Long ATTRIBUTE Average CPA target. This target should be greater than or equal to minimum billable unit based on the currency for the account.
BiddingStrategyTargetImpressionShareCpcBidCeilingMicros Long ATTRIBUTE The highest CPC bid the automated bidding system is permitted to specify. This is a required field entered by the advertiser that sets the ceiling and specified in local micros.
BiddingStrategyTargetImpressionShareLocation String ATTRIBUTE The targeted location on the search results page.

The allowed values are ABSOLUTE_TOP_OF_PAGE, ANYWHERE_ON_PAGE, TOP_OF_PAGE, UNKNOWN.

BiddingStrategyTargetImpressionShareLocationFractionMicros Long ATTRIBUTE The chosen fraction of ads to be shown in the targeted location in micros. For example, 1% equals 10,000.
BiddingStrategyTargetRoasCpcBidCeilingMicros Long ATTRIBUTE Maximum bid limit that can be set by the bid strategy. The limit applies to all keywords managed by the strategy. This should only be set for portfolio bid strategies.
BiddingStrategyTargetRoasCpcBidFloorMicros Long ATTRIBUTE Minimum bid limit that can be set by the bid strategy. The limit applies to all keywords managed by the strategy. This should only be set for portfolio bid strategies.
BiddingStrategyTargetRoasTargetRoas Double ATTRIBUTE Required. The chosen revenue (based on conversion data) per unit of spend. Value must be between 0.01 and 1000.0, inclusive.
BiddingStrategyTargetRoasTargetRoasTolerancePercentMillis Long ATTRIBUTE The percent of ROAS(return on advertising spend) degradation tolerance allowed to increase traffic diversity and conversion volume, specified in millis (for example, 10,000 = 10%). A value of 10,000 means that the advertiser can expect ROAS degradation of up to 10% of the specified target ROAS. This field is only mutable for portfolio bidding strategies.
BiddingStrategyTargetSpendCpcBidCeilingMicros Long ATTRIBUTE Maximum bid limit that can be set by the bid strategy. The limit applies to all keywords managed by the strategy.
BiddingStrategyTargetSpendTargetSpendMicros Long ATTRIBUTE Deprecated: The spend target under which to maximize clicks. A TargetSpend bidder will attempt to spend the smaller of this value or the natural throttling spend amount. If not specified, the budget is used as the spend target. This field is deprecated and should no longer be used. See https://ads-developers.googleblog.com/2020/05/reminder-about-sunset-creation-of.html for details.
BiddingStrategyType String ATTRIBUTE Output only. The type of the bidding strategy.

The allowed values are COMMISSION, ENHANCED_CPC, FIXED_CPM, FIXED_SHARE_OF_VOICE, INVALID, MANUAL_CPA, MANUAL_CPC, MANUAL_CPM, MANUAL_CPV, MAXIMIZE_CONVERSIONS, MAXIMIZE_CONVERSION_VALUE, PAGE_ONE_PROMOTED, PERCENT_CPC, TARGET_CPA, TARGET_CPC, TARGET_CPM, TARGET_CPV, TARGET_IMPRESSION_SHARE, TARGET_OUTRANK_SHARE, TARGET_ROAS, TARGET_SPEND, UNKNOWN.

CustomerId Long ATTRIBUTE Output only. The ID of the customer.
AllConversions Double METRIC The total number of conversions. This includes all conversions regardless
AllConversionsFromInteractionsRate Double METRIC All conversions from interactions (as oppose to view through conversions)
AllConversionsValue Double METRIC The value of all conversions.
AverageCpc Double METRIC The total cost of all clicks divided by the total number of clicks
AverageCpm Double METRIC Average cost-per-thousand impressions (CPM).
AverageTargetCpaMicros Long METRIC The average Target CPA, or unset if not available (for example, for
AverageTargetRoas Double METRIC The average Target ROAS, or unset if not available (for example, for
Clicks Long METRIC The number of clicks.
ClicksUniqueQueryClusters Long METRIC Unique query intent cluster count for clicks.
Conversions Double METRIC The number of conversions. This only includes conversion actions which
ConversionsFromInteractionsRate Double METRIC Conversions from interactions divided by the number of ad interactions
ConversionsUniqueQueryClusters Long METRIC Unique query intent cluster count for conversions.
ConversionsValue Double METRIC The value of conversions. This only includes conversion actions which
CostMicros Long METRIC The sum of your cost-per-click (CPC) and cost-per-thousand impressions
CostPerAllConversions Double METRIC The cost of ad interactions divided by all conversions.
CostPerConversion Double METRIC The cost of ad interactions divided by conversions. This only includes
CrossDeviceConversions Double METRIC Conversions from when a customer clicks on a Google Ads ad on one device,
Ctr Double METRIC The number of clicks your ad receives (Clicks) divided by the number
Impressions Long METRIC Count of how often your ad has appeared on a search results page or
ImpressionsUniqueQueryClusters Long METRIC Unique query intent cluster count for impressions.
ValuePerAllConversions Double METRIC The value of all conversions divided by the number of all conversions.
ValuePerConversion Double METRIC The value of conversions divided by the number of conversions. This only
ViewThroughConversions Long METRIC The total number of view-through conversions.
AdSubNetworkType String SEGMENT Ad sub network type. Currently only available for ads running as part of

The allowed values are UNKNOWN, UNSEGMENTED, YOUTUBE_INFEED, YOUTUBE_INSTREAM, YOUTUBE_SHORTS.

ConversionAction String SEGMENT Resource name of the conversion action.
ConversionActionCategory String SEGMENT Conversion action category.

The allowed values are ADD_TO_CART, BEGIN_CHECKOUT, BOOK_APPOINTMENT, CONTACT, CONVERTED_LEAD, DEFAULT, DOWNLOAD, ENGAGEMENT, GET_DIRECTIONS, IMPORTED_LEAD, OUTBOUND_CLICK, PAGE_VIEW, PHONE_CALL_LEAD, PURCHASE, QUALIFIED_LEAD, REQUEST_QUOTE, SIGNUP, STORE_SALE, STORE_VISIT, SUBMIT_LEAD_FORM, SUBSCRIBE_PAID, UNKNOWN, YOUTUBE_FOLLOW_ON_VIEWS.

ConversionActionName String SEGMENT Conversion action name.
Date Date SEGMENT Date to which metrics apply.
DayOfWeek String SEGMENT Day of the week, for example, MONDAY.

The allowed values are FRIDAY, MONDAY, SATURDAY, SUNDAY, THURSDAY, TUESDAY, UNKNOWN, WEDNESDAY.

Device String SEGMENT Device to which metrics apply.

The allowed values are CONNECTED_TV, DESKTOP, MOBILE, OTHER, TABLET, UNKNOWN.

ExternalConversionSource String SEGMENT External conversion source.

The allowed values are AD_CALL_METRICS, ANALYTICS, ANALYTICS_SEARCH_ADS_360, ANDROID_FIRST_OPEN, ANDROID_IN_APP, APP_UNSPECIFIED, CLICK_TO_CALL, DISPLAY_AND_VIDEO_360_FLOODLIGHT, FIREBASE, FIREBASE_SEARCH_ADS_360, FLOODLIGHT, GOOGLE_ATTRIBUTION, GOOGLE_HOSTED, GOOGLE_PLAY, IOS_FIRST_OPEN, IOS_IN_APP, SALESFORCE, SEARCH_ADS_360, STORE_SALES, STORE_SALES_CRM, STORE_SALES_DIRECT_UPLOAD, STORE_SALES_PAYMENT_NETWORK, STORE_VISITS, THIRD_PARTY_APP_ANALYTICS, UNKNOWN, UPLOAD, UPLOAD_CALLS, WEBPAGE, WEBSITE_CALL_METRICS.

Hour Int SEGMENT Hour of day as a number between 0 and 23, inclusive.
Month Date SEGMENT Month as represented by the date of the first day of a month. Formatted as
MonthOfYear String SEGMENT Month of the year, for example, January.

The allowed values are APRIL, AUGUST, DECEMBER, FEBRUARY, JANUARY, JULY, JUNE, MARCH, MAY, NOVEMBER, OCTOBER, SEPTEMBER, UNKNOWN.

Period String SEGMENT Predefined date range.

The allowed values are TODAY, YESTERDAY, LAST_7_DAYS, LAST_BUSINESS_WEEK, THIS_MONTH, LAST_MONTH, LAST_14_DAYS, LAST_30_DAYS, THIS_WEEK_SUN_TODAY, THIS_WEEK_MON_TODAY, LAST_WEEK_SUN_SAT, LAST_WEEK_MON_SUN.

Quarter Date SEGMENT Quarter as represented by the date of the first day of a quarter.
Week Date SEGMENT Week as defined as Monday through Sunday, and represented by the date of
Year Int SEGMENT Year, formatted as yyyy.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer more granular control over the data returned from the data source.

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

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 26.0.9655