Power BI Connector for Google Ads

Build 24.0.9062

BiddingDataExclusion

Represents a bidding data exclusion. See 'About data exclusions' at https://support.google.com/google-ads/answer/10370710.

Columns

Name Type Behavior Description
BiddingDataExclusionAdvertisingChannelTypes String ATTRIBUTE The data_exclusion will apply to all the campaigns under the listed channels retroactively as well as going forward when the scope of this exclusion is CHANNEL. The supported advertising channel types are DISPLAY, SEARCH and SHOPPING. Note: a data exclusion with both advertising_channel_types and campaign_ids is not supported.

使用できる値は次のとおりです。DEMAND_GEN, DISPLAY, HOTEL, LOCAL, LOCAL_SERVICES, MULTI_CHANNEL, PERFORMANCE_MAX, SEARCH, SHOPPING, SMART, TRAVEL, UNKNOWN, UNSPECIFIED, VIDEO

BiddingDataExclusionCampaigns String ATTRIBUTE The data exclusion will apply to the campaigns listed when the scope of this exclusion is CAMPAIGN. The maximum number of campaigns per event is 2000. Note: a data exclusion with both advertising_channel_types and campaign_ids is not supported.
BiddingDataExclusionDataExclusionId Long ATTRIBUTE Output only. The ID of the data exclusion.
BiddingDataExclusionDescription String ATTRIBUTE The description of the data exclusion. The description can be at most 2048 characters.
BiddingDataExclusionDevices String ATTRIBUTE If not specified, all devices will be included in this exclusion. Otherwise, only the specified targeted devices will be included in this exclusion.

使用できる値は次のとおりです。CONNECTED_TV, DESKTOP, MOBILE, OTHER, TABLET, UNKNOWN, UNSPECIFIED

BiddingDataExclusionEndDateTime String ATTRIBUTE Required. The exclusive end time of the data exclusion in yyyy-MM-dd HH:mm:ss format. The length of [start_date_time, end_date_time) interval must be within (0, 14 days].
BiddingDataExclusionName String ATTRIBUTE The name of the data exclusion. The name can be at most 255 characters.
BiddingDataExclusionResourceName String ATTRIBUTE Immutable. The resource name of the data exclusion. Data exclusion resource names have the form: customers/{customer_id}/biddingDataExclusions/{data_exclusion_id}
BiddingDataExclusionScope String ATTRIBUTE The scope of the data exclusion.

使用できる値は次のとおりです。CAMPAIGN, CHANNEL, CUSTOMER, UNKNOWN, UNSPECIFIED

BiddingDataExclusionStartDateTime String ATTRIBUTE Required. The inclusive start time of the data exclusion in yyyy-MM-dd HH:mm:ss format. A data exclusion is backward looking and should be used for events that start in the past and end either in the past or future.
BiddingDataExclusionStatus String ATTRIBUTE Output only. The status of the data exclusion.

使用できる値は次のとおりです。ENABLED, REMOVED, 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