Power BI Connector for Yahoo! Ads

Build 24.0.9062

BrandLifts

Get the BrandLift information.

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 本製品.

  • AccountId supports the '='.
  • BrandLiftId supports the '=,IN'.
  • ApprovalStatus supports the '=,IN'.
  • CampaignId supports the '=,IN'.
For example:
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.

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