ビュー
ビューは、カラムと疑似カラムで構成されます。ビューは、データを示すという点でテーブルに似ていますが、ビューでは更新はサポートされません。通常、ビューとして表されるエンティティは、読み取り専用のエンティティです。多くの場合、これらのデータはストアドプロシージャを使用することで更新できます(その機能がデータソースに適用できる場合)。
ビューに対しては、通常のテーブルと同じようにクエリを実行でき、このときに返されるデータも同様です。
ビューとして公開されるクエリなどの動的ビューや、project_team ワークアイテムの特定の組み合わせを検索するためのビューがサポートされています。
CData Python Connector for Yahoo! Ads ビュー
| Name | Description |
| AccountAuthorities | Get account authority information. |
| AudienceCategories | Get the list of audience category |
| AudienceListContentCombinationAudienceListCombinations | Retrieve the details of Combination of Audience list information. The columns values set read-only false can be inserted in the parent table using Temp tables. |
| AudienceListContentCombinationAudienceListCombinationsAudienceLists | Retrieve the details of Audience list. The columns values set read-only false can be inserted in the parent table using Temp tables. |
| AudienceListContentCombinationAudienceListRulesRuleConditions | Retrieve the details of AudienceList Rules RuleConditions. The columns values set read-only false can be inserted in the parent table using Temp tables. |
| AudienceListContentRuleAudienceListRules | Retrieve the details of ContentRuleAudience List Rules. The columns values set read-only false can be inserted in the parent table using Temp tables. |
| AudienceListContentSimilarityAudienceListAudienceListSizeReaches | Retrieve the details of each reaches of Audience list size. The columns values set read-only false can be inserted in the parent table using Temp tables. |
| AudienceListContentWebsiteVisitorsAudienceListRules | Retrieve the details of ContentWebsiteVisitorsAudience List Rules. The columns values set read-only false can be inserted in the parent table using Temp tables. |
| AudienceListContentWebsiteVisitorsAudienceListRulesRuleConditions | Retrieve the details of ContentWebsiteVisistorsAudienceList Rules RuleConditions. The columns values set read-only false can be inserted in the parent table using Temp tables. |
| BrandLifts | Get the BrandLift information. |
| BrandLiftsQuestions | Brand lift survey contents. The columns values set read-only false can be inserted in the parent table using Temp tables. |
| BusinessCategories | Get the list of business category |
| CampaignMigrations | Get the migration status. |
| ContentsKeywordIdea | Retrieves the keyword for contents targeting. |
| ContentsKeywordListsContentsKeyword | Get the contents keyeord list |
| ConversionGroupConversions | Get ConversionGroup information of specified account |
| DisplayAdsAccountLinks | Get the account link information. |
| DisplayAdsAdGroupAdCarouselAdCarousels | Retrieve the information of carousel ad. |
| DisplayAdsAdGroupAdServiceLabels | Retrieve the details of AdGroupAdService Labels. The columns values set read-only false can be inserted in the parent table using Temp tables |
| DisplayAdsAdGroupServiceLabels | Retrieve the details of AdGroup Labels. The columns values set read-only false can be inserted in the parent table using Temp tables. |
| DisplayAdsBalance | Get the account balance. |
| DisplayAdsCampaignServiceLabels | Retrieve the details of DisplayAdsCampaign Labels. The columns values set read-only false can be inserted in the parent table using Temp tables. |
| DisplayAdsConversionTrackerWebConversionSnippets | Retrieve the details of tracking script information of Web Conversion Tracker. The columns values set read-only false can be inserted in the parent table using Temp tables. |
| DisplayAdsDisapprovalReasons | Get the list of response from recommendation with EditorialReason. |
| DisplayAdsGeographicLocations | Get the information list of geo targeting. |
| DisplayAdsReportFields | Retrieve the available report fields for a given report type. |
| DisplayAdsReportFilters | Retrieve the details of filtering report conditions. The columns values set read-only false can be inserted in the parent table using Temp tables. |
| DisplayAdsReportReportTypeConditionConversionPathAccountSettingSubAccounts | Retrieve the details of account and its product type. The columns values set read-only false can be inserted in the parent table using Temp tables. |
| DisplayAdsReportReportTypeConditionConversionPathFilters | Retrieve the details of flag which indicates whether to include view interaction in Conversion Path Report. |
| DisplayAdsReportReportTypeConditionCrossCampaignReachesReportConditionCrossCampaignGoals | Retrieve the details of account and campaign goal that is subject to Cross-campaign Reach Report combination. |
| DisplayAdsReportReportTypeConditionCrossCampaignReachesReportConditionCrossCampaignIds | Retrieve the details of condition to create each report type |
| DisplayAdsReportSortFields | Retrieve the sort details of report definition. The columns values set read-only false can be inserted in the parent table using Temp tables. |
| DisplayAdsReportTypeConditionCrossCampaignBuyingTypes | Retrieve the details of Condition to create Cross-campaign Reach Report. The columns values set read-only false can be inserted in the parent table using Temp tables. |
| FeedData | Get the status of uploaded item list. |
| FeedItemGoogleProductCategories | Get Google product category that can be specified for Feed item information. |
| FeedSetConditionSets | Retrieve the details of Conditions of Item Set information. The columns values set read-only false can be inserted in the parent table using Temp tables. |
| FeedSetConditionSetsOrCondition | Retrieve the details of Conditions of Item Set information. The columns values set read-only false can be inserted in the parent table using Temp tables. |
| GetUploadUserListStatus | Get the upload status of the user list. |
| GuaranteedAdGroupAdGroupTargets | Retrieve the targeting information specified in ad group.This object is required if you are adding ad group via GuaranteedAdGroupService. The columns values set read-only false can be inserted in the parent table using Temp tables. |
| GuaranteedAdGroupAdLabels | Retrieve the details of GuaranteedAdGroupAds Labels. The columns values set read-only false can be inserted in the parent table using Temp tables. |
| GuaranteedAdGroupLabels | Retrieve the details of GuaranteedAdGroup Labels. The columns values set read-only false can be inserted in the parent table using Temp tables. |
| GuaranteedCampaignLabels | Retrieve the details of GuaranteedCampaigns Labels. The columns values set read-only false can be inserted in the parent table using Temp tables. |
| GuaranteedInventoryInventories | Get details of guaranteed campaign and information about inventory status of product |
| GuaranteedInventoryInventoriesAdRequirements | Get details of guaranteed campaign and information about inventory status of product |
| GuaranteedInventoryInventoriesInventoryResults | Get details of guaranteed campaign and information about inventory status of product |
| GuaranteedInventoryInventoriesInventoryResultUnavailableReasons | Get details of guaranteed campaign and information about inventory status of product |
| GuaranteedInventoryInventoriesPredictionResults | Get details of guaranteed campaign and information about inventory status of product |
| GuaranteedInventoryInventoriesTargets | Get details of guaranteed campaign and information about inventory status of product |
| GuaranteedPreview | Read the preview of guaranteed campaign. |
| GuaranteedPreviewPanels | It holds information about the preview material. |
| GuaranteedSimulationAdCategories | Get the list of ad categories in the delivery simulation of the guaranteed campaign. |
| GuaranteedSimulationAdRequirements | Retrieve details of conditions for composing the guaranteed ad. |
| GuaranteedSimulationInventoryResult | Retrieve details of conditions for composing the guaranteed ad. |
| GuaranteedSimulationInventoryResultUnavailableReasons | Retrieve details of conditions for composing the guaranteed ad. |
| GuaranteedSimulationPackageAdRequirements | Retrieve the details of conditions for composing the guaranteed ad. The columns values set read-only false can be inserted in the parent table using Temp tables. |
| GuaranteedSimulationPackages | Get the package list for the delivery simulation of the guaranteed campaign. |
| GuaranteedSimulationPackagesPackagePermittedAdScheduleTargetPermittedTargets | Retrieve the details of Configuration information of Ad Schedule targeting. The columns values set read-only false can be inserted in the parent table using Temp tables. |
| GuaranteedSimulationPackagesPackagePermittedAgeTargetPermittedTargets | Retrieve the details of Configuration information of age targeting. The columns values set read-only false can be inserted in the parent table using Temp tables. |
| GuaranteedSimulationPackagesPackagePermittedAppTargetPermittedTargets | Retrieve the details of Configuration information of App targeting. The columns values set read-only false can be inserted in the parent table using Temp tables. |
| GuaranteedSimulationPackagesPackagePermittedAudienceCategoryTargetPermittedTargets | Retrieve the details of Configuration information of audience category targeting. The columns values set read-only false can be inserted in the parent table using Temp tables. |
| GuaranteedSimulationPackagesPackagePermittedDeviceTargetPermittedTargets | Retrieve the details of Configuration information of Device targeting. The columns values set read-only false can be inserted in the parent table using Temp tables. |
| GuaranteedSimulationPackagesPackagePermittedGenderTargetPermittedTargets | Retrieve the details of Configuration information of Gender targeting. The columns values set read-only false can be inserted in the parent table using Temp tables. |
| GuaranteedSimulationPackagesPackagePermittedGeoTargetPermittedTargets | Retrieve the details of Configuration information of Geo targeting. The columns values set read-only false can be inserted in the parent table using Temp tables. |
| GuaranteedSimulationPackagesPackagePermittedOsTargetPermittedTargets | Retrieve the details of Configuration information of OS targeting. The columns values set read-only false can be inserted in the parent table using Temp tables. |
| GuaranteedSimulationPackagesPackagePermittedPlacementCategoryTargetPermittedTargets | Retrieve the details of Configuration information of placement category targeting. The columns values set read-only false can be inserted in the parent table using Temp tables. |
| GuaranteedSimulationPackagesPackagePermittedPositionTargetPermittedTargets | Retrieve the details of Configuration information of position targeting. The columns values set read-only false can be inserted in the parent table using Temp tables. |
| GuaranteedSimulationPackagesPackagePermittedSiteRetargetingTargetPermittedTargets | Retrieve the details of site retargeting settings. The columns values set read-only false can be inserted in the parent table using Temp tables. |
| GuaranteedSimulationPredictionResults | Retrieve details of prediction result of the guaranteed campaign. The columns values set read-only false can be inserted in the parent table using Temp tables. |
| GuaranteedSimulationsAdCategories | Get the list of ad categories in the delivery simulation of the guaranteed campaign. |
| GuaranteedSimulationTargets | Retrieve details of targeting information about the delivery simulation of the guaranteed campaign. The columns values set read-only false can be inserted in the parent table using Temp tables. |
| MediaAdFormats | Get an acceptable format (MediaAdFormat) of ad creatives. |
| OsVersions | Get the version of OS. |
| PlacementUrlIdeas | Get the candidate URL |
| PlacementUrlListUrls | Retrieve the details of PlacementUrlLists Urls. The columns values set read-only false can be inserted in the parent table using Temp tables. |
| RecommendationCampaignBiddingStrategyToTargetCpaCampaignBiddingStrategyToTargetCpaCampaignList | Retrieve the details of campaign that is suitable for using autobidding. The columns values set read-only false can be inserted in the parent table using Temp tables. |
| RecommendationDailyBudgetOverDailyBudgetOverCampaignLists | Retrieve the information about campaigns that reached the daily budget. The columns values set read-only false can be inserted in the parent table using Temp tables. |
| RecommendationImpsShareBudgetLossOverImpsShareBudgetLossOverCampaignLists | Retrieve the information of campaigns that have a large lost impression share (budget). The columns values set read-only false can be inserted in the parent table using Temp tables. |
| Recommendations | Get Recommendations information. |
| RecommendationSearchKeywordIdeaSearchKeywordIdeaSearchKeywordLists | Retrieve the details of recommended search keyword to add. The columns values set read-only false can be inserted in the parent table using Temp tables. |
| SearchKeywordIdeas | Get the keyword for search targeting. |
| SearchKeywordListSearchKeywords | Retrieve the details of search keyword. The columns values set read-only false can be inserted in the parent table using Temp tables. |
| SearchLifts | Get SearchLift information. |
| 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. |
| SiteCategories | Get the list of site category. |
| StationPlacementCategories | Get list of station information included in placement category list. |
| StationPlacementCategoryPlacementCategories | Get list of station information included in placement category list. |
| Stats | Get the stats information of each campaign, ad group, ad, image and video. |
| ThirdPartyTrackingDomains | Get the domain and vendor name that can be specified for the third-party scripting URL. |
| VideosVideoSettingExtraSpecs | It is an additional video quality that can be used other than the regular video qualities. The columns values set read-only false can be inserted in the parent table using Temp tables. |