Excel Add-In for Yahoo! Ads

Build 24.0.9062

BrandLiftsQuestions

Brand lift survey contents. 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 本製品.

  • AccountId supports the '='.
  • BrandLiftId supports the '=,IN'.
  • ApprovalStatus supports the '=,IN'.
  • CampaignId supports the '=,IN'.

For example, the following queries are processed server side:

SELECT * FROM BrandLiftsQuestions WHERE AccountId = '1002504155'

SELECT * FROM BrandLiftsQuestions WHERE AccountId = '45896' AND BrandLiftId IN ('23534', '45986')

SELECT * FROM BrandLiftsQuestions WHERE AccountId = '45896'

SELECT * FROM BrandLiftsQuestions WHERE AccountId = '45896' AND CampaignId IN ('48855')

Columns

Name Type References Description
BrandLiftId 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.
AnswerOption1 String Answer Option1
AnswerOption2 String Answer Option2
AnswerOption3 String Answer Option3
AnswerOption4 String Answer Option4
AnswerOption5 String Answer Option5
Goal String Survey Goal.
PreApproveId String Preapprove ID.
Question String Question
QuestionId Int64 Question ID.

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