GuaranteedSimulations

Create or Read information about 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 '='.
GuaranteedSimulationId supports the '=,IN'.

For example:

SELECT * FROM GuaranteedSimulations WHERE AccountId = '1002504155'

SELECT * FROM GuaranteedSimulations WHERE AccountId = '1231002504' AND GuaranteedSimulationId = '45698'

INSERT

Insert can be executed by specifying the AccountId, CampaignGoal, StartDate, EndDate, AdRequirements columns. The columns that are not read-only can be inserted optionally. Following is an example of how to insert into this table.

INSERT INTO GuaranteedSimulationAdRequirements#TEMP(AccountId, AdType, MediaAdFormat) values(1002504155, 'BANNER_VIDEO_AD','YJ_1350_760')
INSERT INTO GuaranteedSimulations(AccountId, CampaignGoal, StartDate, EndDate, AdRequirements) values(1002504155, 'abcd','20220830','20220831','GuaranteedSimulationAdRequirements#TEMP')

Columns


Name	Type	ReadOnly	References	Description
GuaranteedSimulationId [KEY]	Int64	True		Simulation ID.
AccountId	Int64	True	DisplayAdsAccounts.AccountId	Account ID.
ActionAfterVideoAdTap	String	False		Describes what happens after a video ad is tapped. 使用できる値は次のとおりです。NONE, FOR_VIEW, FOR_CLICK, UNKNOWN
AdCategoryIds	String	False	GuaranteedSimulationAdCategories.AdCategoryId	Ad category ID.
AdRequirements	String	False		Describes the conditions for composing the guaranteed ad.
AdPlaceType	String	False		Describes the ad placements. 使用できる値は次のとおりです。YAHOO_JAPAN_TOP, YAHOO_JAPAN_ALL, YAHOO_JAPAN_EXCLUSION_OF_TOP, UNKNOWN
CampaignGoal	String	False		Campaign goal.
StartDate	Date	False		Start date.
EndDate	Date	False		End date.
EndTime	Date	False		End Time.
LifetimeBudget	Int64	False		An amount of campaign's lifetime budget.
LowerBudgetLimit	Int64	False		Minimum reservable lifetime budget.
UpperBudgetLimit	Int64	False		Maximum reservable lifetime budget.
MaxReach	Int64	False		Maximum number of reaches.
MaxVImps	Int64	False		Maximum number of ad viewable impressions to same user.
PackageHistoryId	Int64	False		Package history ID.
PackageId	Int64	False		Package ID.
RequestedConditionResultLifetimeBudget	Int64	False		Lifetime budget.
RequestedConditionResultReach	Int64	False		Number of reaches.
RequestedConditionResultPrice	Int64	False		Price.
RequestedConditionResultSovRate	String	False		SOV (0.0% to 100.0%).
RequestedConditionResultVcpm	Int64	False		Number of reaches.
RequestedConditionResultViewableFrequency	String	False		Viewable frequency.
RequestedConditionResultVImps	Int64	False		Viewable impressions
ReservedConditionResultLifetimeBudget	Int64	False		Lifetime budget.
ReservedConditionResultLifetimePrice	Int64	False		Price.
ReservedConditionResultReach	Int64	False		Number of reaches.
ReservedConditionResultSovRate	String	False		SOV (0.0% to 100.0%).
ReservedConditionResultVcpm	Int64	False		Number of reaches.
ReservedConditionResultViewableFrequency	String	False		Viewable frequency.
ReservedConditionResultVImps	Int64	False		Viewable impressions
Results	String	False		Describes the prediction result of the guaranteed campaign.
InventoryResult	String	False		Describes the result of inventory check.
Reach	Int64	False		Number of reaches.
ReservationStatus	String	False		Describes the reservation availability status of guaranteed campaign. 使用できる値は次のとおりです。RESERVABLE, UNRESERVABLE, RESERVED, UNKNOWN
Slots	Int64	False		Number of buying slots.lifetimeBudget, reach, vImps and slots cannot be set at the same time.
SovRate	Int64	False		SOV (1% to 100%).
Targets	String	False		Object holds the targeting information about the delivery simulation of the guaranteed campaign.
UnreservableReason	String	False		Describes the reason why reservation is not possible. 使用できる値は次のとおりです。NOT_ENOUGH_DELIVERY_TARGET, OUT_OF_STOCK, UNKNOWN
ViewableFrequencyCapFrequencyLevel	String	False		Frequency setting level. 使用できる値は次のとおりです。CAMPIGN, UNKNOWN
ViewableFrequencyCapFrequencyTimeUnit	String	False		Frequency setting period. 使用できる値は次のとおりです。DAY, WEEK, MONTH, LIFETIME, UNKNOWN
ViewableFrequencyCapVImps	Int64	False		Maximum number of ad viewable impressions to same user.
VImps	Int64	False		Viewable impressions.

CData Python Connector for Yahoo! Ads

GuaranteedSimulations

Table Specific Information

SELECT

INSERT

Columns