GuaranteedSimulationPackages

Get the package list for the delivery simulation of the guaranteed campaign.

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 '='.
PackageId supports the '=,IN'.
PackageName supports the '='.
PackagePermittedAdPlaceTypesAdPlaceTypes supports the '=,IN'.
DeviceTypes supports the '=,IN'.
AdTypes supports the '=,IN'.

For example:

SELECT * FROM GuaranteedSimulationPackages WHERE AccountId = '1002504155'

SELECT * FROM GuaranteedSimulationPackages WHERE AccountId = '1002504155' AND PackageId = '12346'

SELECT * FROM GuaranteedSimulationPackages WHERE AccountId = '1002504155' AND PackageName = 'cdata'

Columns


Name	Type	References	Description
PackageId [KEY]	Int64		Package ID.
AccountId	Int64	DisplayAdsAccounts.AccountId	Account ID.
ActionAfterVideoAdTap	String		Describes what happens after a video ad is tapped. 使用できる値は次のとおりです。NONE, FOR_VIEW, FOR_CLICK, UNKNOWN
AdDeliveryDurationStartDate	Date		Start date of the ad delivery validity period.
AdDeliveryDurationEndDate	Date		End date of the ad delivery validity period.
AdRequirements	String		Describes the conditions for composing the guaranteed ad.
AdTypePermission	String		Describes the restriction of the package setting. 使用できる値は次のとおりです。FORBIDDEN, PERMITTED_NON_TARGET_ENABLE, PERMITTED_NON_TARGET_DISABLE, FIXED, UNKNOWN
BuyingTermBuyingTermType	String		Type of package purchase term. 使用できる値は次のとおりです。SINGLE_DAY, SINGLE_DAY, CUSTOM_RANGE, UNKNOWN
BuyingTermCustomRangeBuyingTermBuyingTermDateMinRange	Int64		The number of days in the package purchase term (minimum range).
BuyingTermCustomRangeBuyingTermBuyingTermDateMaxRange	Int64		The number of days in the package purchase term (maximum range).
BuyingTermSingleDayBuyingTermBuyingSingleDayTerm	Int64		Package purchase term (single day).
BuyingTermSingleTermBuyingTermBuyingSingleTermStartDate	Date		Start date of the package purchase term (single term).
BuyingTermSingleTermBuyingTermBuyingSingleTermEndDate	Date		End date of the package purchase term (single term).
InstreamDurationType	String		Describes the duration type of in-stream ads. 使用できる値は次のとおりです。MAX_6_SECONDS, MAX_15_SECONDS, MAX_30_SECONDS, UNLIMITED, UNKNOWN
PackageHistoryId	Int64		Package history ID.
PackageName	String		Package name.
PackagePermittedAdPlaceTypesAdPlaceTypes	String		Describes the ad placements. 使用できる値は次のとおりです。YAHOO_JAPAN_TOP, YAHOO_JAPAN_ALL, YAHOO_JAPAN_EXCLUSION_OF_TOP, UNKNOWN
PackagePermittedAdPlaceTypesPermission	String		Describes the restriction of the package setting. 使用できる値は次のとおりです。FORBIDDEN, PERMITTED_NON_TARGET_ENABLE, PERMITTED_NON_TARGET_DISABLE, FIXED, UNKNOWN
PackagePermittedAdScheduleTargetPermittedTargets	String		Configuration information of Ad Schedule targeting.
PackagePermittedAdScheduleTargetTargetPermission	String		Describes the restriction of the package setting. 使用できる値は次のとおりです。FORBIDDEN, PERMITTED_NON_TARGET_ENABLE, PERMITTED_NON_TARGET_DISABLE, FIXED, UNKNOWN
PackagePermittedAgeTargetPermittedTargets	String		Configuration information of age targeting.
PackagePermittedAgeTargetTargetPermission	String		Describes the restriction of the package setting. 使用できる値は次のとおりです。FORBIDDEN, PERMITTED_NON_TARGET_ENABLE, PERMITTED_NON_TARGET_DISABLE, FIXED, UNKNOWN
PackagePermittedAppTargetPermittedTargets	String		Configuration information of App targeting.
PackagePermittedAppTargetTargetPermission	String		Describes the restriction of the package setting. 使用できる値は次のとおりです。FORBIDDEN, PERMITTED_NON_TARGET_ENABLE, PERMITTED_NON_TARGET_DISABLE, FIXED, UNKNOWN
PackagePermittedAudienceCategoryTargetPermittedTargets	String		Configuration information of audience category targeting.
PackagePermittedAudienceCategoryTargetTargetPermission	String		Describes the restriction of the package setting. 使用できる値は次のとおりです。FORBIDDEN, PERMITTED_NON_TARGET_ENABLE, PERMITTED_NON_TARGET_DISABLE, FIXED, UNKNOWN
PackagePermittedAudienceListTargetTargetPermission	String		Describes the restriction of the package setting. 使用できる値は次のとおりです。FORBIDDEN, PERMITTED_NON_TARGET_ENABLE, PERMITTED_NON_TARGET_DISABLE, FIXED, UNKNOWN
PackagePermittedAudienceListTargetPermittedTargets	String		Describes the restriction of the package setting. 使用できる値は次のとおりです。FORBIDDEN, PERMITTED_NON_TARGET_ENABLE, PERMITTED_NON_TARGET_DISABLE, FIXED, UNKNOWN
PackagePermittedDeviceTargetPermittedTargets	String		Configuration information of Device targeting.
PackagePermittedDeviceTargetTargetPermission	String		Describes the restriction of the package setting. 使用できる値は次のとおりです。FORBIDDEN, PERMITTED_NON_TARGET_ENABLE, PERMITTED_NON_TARGET_DISABLE, FIXED, UNKNOWN
PackagePermittedGenderTargetPermittedTargets	String		Configuration information of Gender targeting.
PackagePermittedGenderTargetTargetPermission	String		Describes the restriction of the package setting. 使用できる値は次のとおりです。FORBIDDEN, PERMITTED_NON_TARGET_ENABLE, PERMITTED_NON_TARGET_DISABLE, FIXED, UNKNOWN
PackagePermittedGeoTargetPermittedTargets	String		Configuration information of Geo targeting.
PackagePermittedGeoTargetTargetPermission	String		Describes the restriction of the package setting. 使用できる値は次のとおりです。FORBIDDEN, PERMITTED_NON_TARGET_ENABLE, PERMITTED_NON_TARGET_DISABLE, FIXED, UNKNOWN
PackagePermittedOsTargetPermittedTargets	String		Configuration information of OS targeting.
PackagePermittedOsTargetTargetPermission	String		Describes the restriction of the package setting. 使用できる値は次のとおりです。FORBIDDEN, PERMITTED_NON_TARGET_ENABLE, PERMITTED_NON_TARGET_DISABLE, FIXED, UNKNOWN
PackagePermittedPlacementCategoryTargetPermittedTargets	String		Configuration information of placement category targeting.
PackagePermittedPlacementCategoryTargetPlacementMonopolyFlg	String		Describes whether it can be delivered to a monopoly place. 使用できる値は次のとおりです。TRUE, FALSE, UNKNOWN
PackagePermittedPlacementCategoryTargetPlacementDetailMax	String		The maximum number of placement category details.
PackagePermittedPlacementCategoryTargetTargetPermission	String		Describes the restriction of the package setting. 使用できる値は次のとおりです。FORBIDDEN, PERMITTED_NON_TARGET_ENABLE, PERMITTED_NON_TARGET_DISABLE, FIXED, UNKNOWN
PackagePermittedPositionTargetPermittedTargets	String		Configuration information of position targeting.
PackagePermittedPositionTargetTargetPermission	String		Describes the restriction of the package setting. 使用できる値は次のとおりです。FORBIDDEN, PERMITTED_NON_TARGET_ENABLE, PERMITTED_NON_TARGET_DISABLE, FIXED, UNKNOWN
PackagePermittedSiteRetargetingTargetPermittedTargets	String		A container for site retargeting settings.
PackagePermittedSiteRetargetingTargetTargetPermission	String		Describes the restriction of the package setting. 使用できる値は次のとおりです。FORBIDDEN, PERMITTED_NON_TARGET_ENABLE, PERMITTED_NON_TARGET_DISABLE, FIXED, UNKNOWN
PackagePermittedViewableFrequencyCapPermittedViewableFrequencyCapImpressionMin	Int64		Display count of viewable frequency cap (minimum).
PackagePermittedViewableFrequencyCapPermittedViewableFrequencyCapImpressionMax	Int64		Display count of viewable frequency cap (maximum).
PackagePermittedViewableFrequencyCapPermittedViewableFrequencyCapTimeUnits	String		Frequency setting period. 使用できる値は次のとおりです。DAY, WEEK, MONTH, LIFETIME, UNKNOWN
PackagePermittedViewableFrequencyCapViewableFrequencyCapLevels	String		Frequency setting level. 使用できる値は次のとおりです。CAMPAIGN, UNKNOWN
PackagePermittedViewableFrequencyCapViewableFrequencyCapPermission	String		Dscribes the restriction of the package setting. 使用できる値は次のとおりです。FORBIDDEN, PERMITTED_NON_TARGET_ENABLE, PERMITTED_NON_TARGET_DISABLE, FIXED, UNKNOWN
PackagePublicLevel	String		Describes the public level of package setting. 使用できる値は次のとおりです。PUBLIC, LIMITED, UNKNOWN
PricingPackagePriceType	String		Describes the purchase type of the package. 使用できる値は次のとおりです。VIMS_CUSTOM, VIMPS_SOV, VIMPS_REACH, SLOTS, UNKNOWN
PricingPackageSlotsPricingPackageFixedBudgetApplyTermType	String		Describes the application period of fixed product price. 使用できる値は次のとおりです。SINGLE_DAY, LIFETIME, UNKNOWN
PricingPackageSlotsPricingPackageFixedLifetimeBudget	Int64		Package price.
PricingPackageSlotsPricingPackageMinimumBuyingSlots	Int64		Minimum number of purchase slots.
PricingPackageSlotsPricingPackageSellingSlots	Int64		Number of selling slots.
PricingPackageVimpsCustomPricingPackageFixedLifetimeBudget	Int64		Package price.
PricingPackageVimpsCustomPricingPackageMaximumPurchaseVImps	Int64		Maximum purchase viewable impression.
PricingPackageVimpsCustomPricingPackageMinimumPurchaseVImps	Int64		Minimum purchase viewable impression.
PricingPackageVimpsReachPricingPackageFixedLifetimeBudget	Int64		Package price.
PricingPackageVimpsReachPricingPackageViewableReach	Int64		SOV (1% to 100%).
PricingPackageVimpsSOVPricingPackageFixedLifetimeBudget	Int64		Package price.
PricingPackageVimpsSOVPricingPackageSovRate	Int64		Viewable reach.
PromotionalDocumentFiles	String		Holds information about the promotional document.
RelatedDocumentFiles	String		Holds information about the package document.
Remarks	String		Remarks.
ReservationStartDate	Date		Start date of reservation period.
ReservationEndDate	Date		End date of reservation period.
SalesDocumentFileFileName	String		File name of the package document.
SalesDocumentFileUrl	String		Download URL of the package document.
SellingStartDate	Date		Start date of the package.
SellingEndDate	Date		End date of the package.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。


Name	Type	Description
DeviceTypes	String		Device Types
AdTypes	String		Ad Types

CData Python Connector for Yahoo! Ads

GuaranteedSimulationPackages

Table Specific Information

SELECT

Columns

Pseudo-Columns