Power BI Connector for Yahoo! Ads

Build 24.0.9062

AdGroupCriteriaLabels

Retrieve the details of AdGroupCriteria Labels.The columns values set read-only false can be inserted in the parent table using Temp tables

Table Specific Information

Select

The 本製品 will use the Yahoo! Ads API to process WHERE clause conditions built with the following column and operator. The AccountId and Use is required to make a request and the rest of the filter is executed client-side within the 本製品.

  • AccountId supports the '='.
  • AdGroupId supports the '=,IN'.
  • CriterionId supports the '=,IN'.
  • ApprovalStatus supports the '=,IN'.
  • CampaignId supports the '=,IN'.
  • KeywordMatchType supports the '='.
  • CriterionKeywordText supports the '='.
  • PortfolioBiddingId supports the '=,IN'.
  • ContainsLabelId supports the '='.
  • LabelIds supports the '=,IN'.
  • UserStatus supports the '=,IN'.
  • Usesupports the '='.
  • Min supports the '='.
  • Max supports the '='.

For example:

SELECT * FROM AdGroupCriteriaLabels WHERE AccountId = '1234339' AND USE = 'BIDDABLE'

SELECT * FROM AdGroupCriteriaLabels WHERE AccountId = '1234339' AND USE = 'BIDDABLE' AND AdGroupId = '303252478'

Columns

Name Type References Description
LabelId [KEY] Int64 Label ID.
CriterionId Long Criterion ID.
AccountId Int64

SearchAdsAccounts.AccountId

Account ID.
AdGroupId Int64

SearchAdsAdGroups.AdGroupId

Ad group ID.
ApprovalStatus String Displays Editorial Status.

使用できる値は次のとおりです。APPROVED, APPROVED_WITH_REVIEW, REVIEW, PRE_DISAPPROVED, POST_DISAPPROVED, UNKNOWN

UserStatus String Displays ad delivery status that can be set by an user.

使用できる値は次のとおりです。ACTIVE, PAUSED, UNKNOWN

CampaignId Int64

SearchAdsCampaigns.CampaignId

Campaign ID.
KeywordMatchType String Describes keyword match type.

使用できる値は次のとおりです。EXACT, PHRASE, BROAD, UNKNOWN

KeywordText String AdGroupCriterionServiceKeyword element.Maximum of 80 letters, 10 words.
Color String Color.
Description String Description.
LabelName String Label name.
Use String Describes criterion to be selected.

使用できる値は次のとおりです。BIDDABLE, NEGATIVE, UNKNOWN

Pseudo-Columns

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

Name Type Description
PortfolioBiddingId Int64 Auto bidding ID.
ContainsLabelId String Describes acquisition flag of label data.

使用できる値は次のとおりです。TRUE, FALSE, UNKNOWN

LabelIds Int64 Label ID.
Min Int64 Minimum value of the search range.
Max Int64 Maximum value of the search range..

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