ビュー

ビューは、データを示すという点でテーブルに似ていますが、ビューは読み取り専用です。

クエリは、ビューに対して通常のテーブルと同様に実行することができます。

CData SSIS Components for Yahoo! Ads ビュー


Name	Description
AdGroupAdAdResponsiveSearchAdReviewDescriptions	Retrieve the details for AdGroupAd ResponsiveSearchAd Review Descriptions.The columns values set read-only false can be inserted in the parent table using Temp tables
AdGroupAdAdResponsiveSearchAdReviewHeadlines	Retrieve the details of AdGroupAd ReponsiveSearchAd Review Headlines.The columns values set read-only false can be inserted in the parent table using Temp tables
AdGroupCriteriaLabels	Retrieve the details of AdGroupCriteria Labels.The columns values set read-only false can be inserted in the parent table using Temp tables
AdGroupWebpageParameterConditions	Retrieve the details of AdGroupWebpage WebpageParameterConditions.The columns values set read-only false can be inserted in the parent table using Temp tables
AppEventTracker	Get AppEventType informations.
ApplinkVendors	Get App measurement vendor information list.
AssetDataCallAssetSchedules	Asset value information for phone number options.
AssetDataCallOutAssetSchedules	Asset value information for callout options.
AssetDataQuickLinkAssetSchedules	Asset value information for quicklink options.
CampaignWebpageParameterConditions	Retrieves the details of CampaignWebpage WebpageParameterConditions.The columns values set read-only false can be inserted in the parent table using Temp tables
CustomKeys	Get custom key information
KeywordPlanIdeas	Suggests new related keywords based on the specified value.
OfflineConversions.rsd	Get registered offline conversion data information.
PageFeedAsset	Getpage feed asset, upload or bulk download.
PageFeedAssetReviewSummary	Gets registered approval records of page feed asset and summary of each status.
PageFeedAssetServiceJobStatus	Gets processing status about upload or download.
PageFeedAssetServiceUploadJob	Gets processing status about upload or download.
ReportSearchAdsAccount	To view the Account report. Simple Select statement will create and retrieve last 7 days report
ReportSearchAdsAd	To view the Ad report. Simple Select statement will create and retrieve last 7 days report
ReportSearchAdsAdgroup	To view the Adgroup report. Simple Select statement will create and retrieve last 7 days report
ReportSearchAdsAsset_combinations	To view the Asset Combination report, a simple SELECT statement generates and retrieves the report for the last 7 days.
ReportSearchAdsBid_strategy	To view the Bid_strategy report. Simple Select statement will create and retrieve last 7 days report
ReportSearchAdsCampaign	To view the Campaign report. Simple Select statement will create and retrieve last 7 days report
ReportSearchAdsFeed_item	To view the Feed_item report. Simple Select statement will create and retrieve last 7 days report
ReportSearchAdsGeo	To view the Geo report. Simple Select statement will create and retrieve last 7 days report
ReportSearchAdsGeo_target	To view the Geo_target report. Simple Select statement will create and retrieve last 7 days report
ReportSearchAdsKeywordless_query	To view the Keywordless_query report. Simple Select statement will create and retrieve last 7 days report
ReportSearchAdsKeywords	To view the Keywords report. Simple Select statement will create and retrieve last 7 days report
ReportSearchAdsLanding_page_url	To view the Landing_page_url report. Simple Select statement will create and retrieve last 7 days report
ReportSearchAdsSchedule_target	To view the Schedule_target report. Simple Select statement will create and retrieve last 7 days report
ReportSearchAdsSearch_query	To view the Search_query report. Simple Select statement will create and retrieve last 7 days report
ReportSearchAdsWebpage_criterion	To view the Webpage_criterion report. Simple Select statement will create and retrieve last 7 days report
SearchAdsAccountLinks	Get account link information.
SearchAdsAdGroupAdAdResponsiveSearchAdDescriptions	Retrieve the details for AdGroupAd ResponsiveSearchAd Descriptions.The columns values set read-only false can be inserted in the parent table using Temp tables
SearchAdsAdGroupAdAdResponsiveSearchAdHeadlines	Retrieve the details of AdGroupAd ReponsiveSearchAd Headlines.The columns values set read-only false can be inserted in the parent table using Temp tables
SearchAdsAdGroupAdServiceLabels	Retrieve the details of AdGroupAd Labels. The columns values set read-only false can be inserted in the parent table using Temp tables.
SearchAdsAdGroupServiceLabels	Retrieve the details of AdGroup Labels
SearchAdsAuditLogEventSelector	Retrieve the details of AuditLog EventSelector.The columns values set read-only false can be inserted in the parent table using Temp tables
SearchAdsBalance	Get the account balance.
SearchAdsBaseAccount	Get lists of all accounts (MCC and ad accounts).
SearchAdsCampaignServiceLabels	Retrieve the details of Campaign Labels.The columns values set read-only false can be inserted in the parent table using Temp tables
SearchAdsCampaignSettings	Retrive the details of campaign settings.The columns values set read-only false can be inserted in the parent table using Temp tables
SearchAdsDisapprovalReasons	Get EditorialReason and recommended resolution list.
SearchAdsGeographicLocations	Get the information list of geo targeting.
SearchAdsReportFields	Returns the available report fields for a given report type.The columns values set read-only false can be inserted in the parent table using Temp tables
SearchAdsReportFilters	Retrieves the details of Report Filters.The columns values set read-only false can be inserted in the parent table using Temp tables
SearchAdsReportSortFields	Retrieve the sort details of report definition.The columns values set read-only false can be inserted in the parent table using Temp tables
SearchAdsRetargetingListLogicalGroupLogicalOperand	Retrieve the details of RetargetingList LogicalTargetList LogicalGroup LogicalOperand.The columns values set read-only false can be inserted in the parent table using Temp tables
SearchAdsRetargetingListLogicalGroups	Retrieve the details of RetargetingList LogicalTargetList LogicalGroup.The columns values set read-only false can be inserted in the parent table using Temp tables
SearchAdsRetargetingListRuleBaseTargetListRuleRuleItems	Retrieves the details of RetargetingList RuleBaseTargetList Rule RuleItems.The columns values set read-only false can be inserted in the parent table using Temp tables
SearchAdsRetargetingListRuleBaseTargetListRules	Retrieves the details of RetargetingList RuleBaseTargetList Rules.The columns values set read-only false can be inserted in the parent table using Temp tables
SsaAccounts	Read SSA account information for Search Ads.