Tableau Connector for Google Ads

Build 24.0.9062

AccessibleBiddingStrategy

Represents a view of BiddingStrategies owned by and shared with the customer. In contrast to BiddingStrategy, this resource includes strategies owned by managers of the customer and shared with this customer - in addition to strategies owned by this customer. This resource does not provide metrics and only exposes a limited subset of the BiddingStrategy attributes.

Columns

Name Type Behavior Description
AccessibleBiddingStrategyId Long ATTRIBUTE Output only. The ID of the bidding strategy.
AccessibleBiddingStrategyMaximizeConversionValueTargetRoas Double ATTRIBUTE Output only. 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.
AccessibleBiddingStrategyMaximizeConversionsTargetCpaMicros Long ATTRIBUTE Output only. The target cost per acquisition (CPA) option. This is the average amount that you would like to spend per acquisition.
AccessibleBiddingStrategyName String ATTRIBUTE Output only. The name of the bidding strategy.
AccessibleBiddingStrategyOwnerCustomerId Long ATTRIBUTE Output only. The ID of the Customer which owns the bidding strategy.
AccessibleBiddingStrategyOwnerDescriptiveName String ATTRIBUTE Output only. descriptive_name of the Customer which owns the bidding strategy.
AccessibleBiddingStrategyResourceName String ATTRIBUTE Output only. The resource name of the accessible bidding strategy. AccessibleBiddingStrategy resource names have the form: customers/{customer_id}/accessibleBiddingStrategies/{bidding_strategy_id}
AccessibleBiddingStrategyTargetCpaTargetCpaMicros Long ATTRIBUTE Output only. Average CPA target. This target should be greater than or equal to minimum billable unit based on the currency for the account.
AccessibleBiddingStrategyTargetImpressionShareCpcBidCeilingMicros Long ATTRIBUTE Output only. 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.
AccessibleBiddingStrategyTargetImpressionShareLocation String ATTRIBUTE Output only. The targeted location on the search results page.

使用できる値は次のとおりです。ABSOLUTE_TOP_OF_PAGE, ANYWHERE_ON_PAGE, TOP_OF_PAGE, UNKNOWN, UNSPECIFIED

AccessibleBiddingStrategyTargetImpressionShareLocationFractionMicros Long ATTRIBUTE The chosen fraction of ads to be shown in the targeted location in micros. For example, 1% equals 10,000.
AccessibleBiddingStrategyTargetRoasTargetRoas Double ATTRIBUTE Output only. The chosen revenue (based on conversion data) per unit of spend.
AccessibleBiddingStrategyTargetSpendCpcBidCeilingMicros Long ATTRIBUTE Output only. Maximum bid limit that can be set by the bid strategy. The limit applies to all keywords managed by the strategy.
AccessibleBiddingStrategyTargetSpendTargetSpendMicros Long ATTRIBUTE Output only. 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.
AccessibleBiddingStrategyType String ATTRIBUTE Output only. The type of the bidding strategy.

使用できる値は次のとおりです。COMMISSION, ENHANCED_CPC, FIXED_CPM, INVALID, MANUAL_CPA, MANUAL_CPC, MANUAL_CPM, MANUAL_CPV, MAXIMIZE_CONVERSIONS, MAXIMIZE_CONVERSION_VALUE, PAGE_ONE_PROMOTED, PERCENT_CPC, TARGET_CPA, TARGET_CPM, TARGET_CPV, TARGET_IMPRESSION_SHARE, TARGET_OUTRANK_SHARE, TARGET_ROAS, TARGET_SPEND, UNKNOWN, UNSPECIFIED

CustomerId Long ATTRIBUTE Output only. The ID of the customer.

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