Power BI Connector for Yahoo! Ads

Build 24.0.9062

SearchAdsAdGroupAdAdResponsiveSearchAdHeadlines

Retrieve the details of AdGroupAd ReponsiveSearchAd Headlines.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 is required to make a request and the rest of the filter is executed client-side within the 本製品.

  • AdId supports the '=,IN'.
  • AccountId supports the '='.
  • AdGroupId supports the '=,IN'.
  • AdType supports the '=,IN'.
  • ApprovalStatus supports the '=,IN'.
  • CampaignId supports the '=,IN'.
  • UserStatus supports the '=,IN'.
  • ContainsLabel supports the '='.
  • LabelId supports the '='.
  • StartDate supports the '='.
  • EndDate supports the '='.

For example, the following queries are processed server side:

SELECT * FROM SearchAdsAdGroupAdAdResponsiveSearchAdHeadlines WHERE AccountId = '25687';

SELECT * FROM SearchAdsAdGroupAdAdResponsiveSearchAdHeadlines WHERE AccountId = '25687' AND AdId IN ('456971');	

SELECT * FROM SearchAdsAdGroupAdAdResponsiveSearchAdHeadlines WHERE AccountId = '25687' AND AdGroupId IN ('8520');

Columns

Name Type References Description
AdId Int64 Ad ID.
AccountId Int64

SearchAdsAccounts.AccountId

Account ID.
AdGroupId Int64

SearchAdsAdGroups.AdGroupId

Ad group ID.
AdType String Device type and number of title and description character.

使用できる値は次のとおりです。EXTENDED_TEXT_AD, DYNAMIC_SEARCH_LINKED_AD, TEXT_AD2, APP_AD, RESPONSIVE_SEARCH_AD, UNKNOWN

ApprovalStatus String Displays Editorial Status.

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

DisapprovalReasonCodes String Reject reason code.
PinnedField String A field that specifies where to fix the display position of the description.

使用できる値は次のとおりです。SPECIFIED, DESCRIPTION1, DESCRIPTION2, UNKNOWN

Text String Text of parameter.
ActiveStatus String Displays the availability of assets appears.

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

Pseudo-Columns

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

Name Type Description
ContainsLabel String Describes acquisition flag of label data.

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

LabelIds Int64 Label Ids.
StartDate Date This is the start date of the search target period.
EndDate Date This is the end date of the search target period.
ReferenceNumber String This column will be used in Bulk operations to get specific values from the Temp tables.

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