Tableau Connector for Yahoo! Ads

Build 24.0.9062

SearchLiftskeywords

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

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 '='.
  • SearchLiftId supports the '=,IN'.
  • CampaignId supports the '=,IN'.

For example:

SELECT * FROM SearchLiftskeywords WHERE AccountId = '1002504155'

SELECT * FROM SearchLiftskeywords WHERE AccountId = '1002504155' AND SearchLiftId = '1234567'

SELECT * FROM SearchLiftskeywords WHERE AccountId = '1002504155' AND CampaignId IN ('1234567', '25678')

Columns

Name Type References Description
SearchLiftId Int64 SearchLift ID.
AccountId Int64

DisplayAdsAccounts.AccountId

Account ID.
CampaignId Int64

DisplayAdsCampaigns.CampaignId

Campaign ID
Keyword String Keyword.
KeywordCategory String keyword category

使用できる値は次のとおりです。BRAND, SERVICE, CAMPAIGN, UNKNOWN

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