BrandLifts
Get the BrandLift information.
Table Specific Information
SELECT
The connector 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 connector.
- AccountId supports the '='.
- BrandLiftId supports the '=,IN'.
- ApprovalStatus supports the '=,IN'.
- CampaignId supports the '=,IN'.
SELECT * FROM BrandLifts WHERE AccountId = '45896'
SELECT * FROM BrandLifts WHERE AccountId = '45896' AND BrandLiftId IN ('23534', '45986')
SELECT * FROM BrandLifts WHERE AccountId = '45896' AND CampaignId IN ('48855')
Columns
| Name | Type | References | Description |
| BrandLiftId [KEY] | Int64 | Brand Lift ID. | |
| AccountId | Int64 |
DisplayAdsAccounts.AccountId | Account ID. |
| ApprovalStatus | String | Approval status of survey information
使用できる値は次のとおりです。APPROVED, APPROVED_WITH_REVIEW, REVIEW, PRE_DISAPPROVED, POST_DISAPPROVED, UNKNOWN | |
| CampaignId | Int64 |
DisplayAdsCampaigns.CampaignId | Campaign ID. |
| CampaignName | String | Campaign Name. | |
| CampaignStartDate | Date | Campaign Start Date. | |
| DisapprovalReason | String | Disapproval Reason. | |
| DisapprovalReasonCodes | String | Disapproval Reason Codes. | |
| NotificationBusinessIds | String | Yahoo! JAPAN Business ID to send notifications. | |
| Questions | String | Describes the brand lift survey contents. | |
| ReviewCompleteDate | Datetime | Review Complete Date. | |
| SubmitDate | Datetime | Submit Date. |