SearchAdsConversionTracker

Create, Read or Update ConversionTracker information.

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 '='.
ConversionTrackerId supports the '=,IN'.
AppConversionAppId supports the '=,IN'.
Category supports the '=,IN'.
ConversionCountingType supports the '=,IN'.
ConversionTrackerType supports the '=,IN'.
ExcludeFromBidding supports the '=,IN'.
Status supports the '=,IN'.
WebConversionTrackingCodeType supports the '=,IN'.
StartDate supports the '='.
EndDate supports the '='.

For example:

SELECT * FROM SearchAdsConversionTracker WHERE AccountId = '12346';

SELECT * FROM SearchAdsConversionTracker WHERE AccountId = '12346' AND ConversionTrackerId = '12323';

INSERT

Insert can be executed by specifying the AccountId, AppConversionAppConversionType, AppConversionAppPlatform, Category, ConversionTrackerName, ConversionTrackerType, Status, WebConversionMarkupLanguage and WebConversionTrackingCodeType 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 SearchAdsConversionTracker (AccountId,ConversionTrackerName,ConversionTrackerType,Category,Status,WebConversionMarkUpLanguage,WebConversionTrackingCodeType) values (1234339,'TestConversionTracker','WEB_CONVERSION','DEFAULT','ENABLED','HTML','WEBPAGE')

UPDATE

Update can be executed by specifying the AccountId, ConversionTrackerId and ConversionTrackerType in the WHERE Clause. The columns that are not read-only can be Updated. For example:

UPDATE SearchAdsConversionTracker SET ConversionTrackerName = 'UpdatingConversionTracker', ConversionTrackerType = 'WEB_CONVERSION', AllConversions = '10', AllConversionValue = '10000' WHERE AccountId = '1234339' AND ConversionTrackerId = '2375518'

Columns


Name	Type	ReadOnly	References	Description
ConversionTrackerId [KEY]	Int64	True		ConversionTracker ID. If conversionTrackerType is APP_LINK_CONVERSION, this field is required.
AccountId	Int64	False	SearchAdsAccounts.AccountId	Account ID.
AllConversions	Int64	False		Total number of conversions to be included to auto bidding and to be excluded from auto bidding.
AllConversionValue	String	False		Total value of conversions to be included to auto bidding and to be exluded from auto bidding.
AppConversionAppConversionType	String	False		Describes App conversion type. If the conversionTrackerType is APP_CONVERSION, this field will be required in ADD operation. 使用できる値は次のとおりです。DOWNLOAD, IN_APP_PURCHASE, FIRST_OPEN, UNKNOWN
AppConversionAppId	String	False		Application ID. If the conversionTrackerType is APP_CONVERSION, this field will be required in ADD operation.
AppConversionAppPlatform	String	False		App platform. If the conversionTrackerType is APP_CONVERSION, this field will be required in ADD operation. 使用できる値は次のとおりです。ANDROID_MARKET, UNKNOWN
AppConversionAppPostbackUrlIsRemoveUrl	String	False		The clear flag of postback URL. 使用できる値は次のとおりです。TRUE, UNKNOWN
AppConversionAppPostbackUrlUrl	String	False		URL
AppConversionSnippetId	Int64	False		Conversion ID.
AppConversionSnippetLabel	String	False		Conversion tracker label.
AppLinkConversionAdvancedSnippet	String	False		The new format of conversion tag avoids the impacts such as changes made to the browser.
AppLinkConversionAppEventType	String	False		Application Event Type.
AppLinkConversionAppId	String	False		Application ID.
AppLinkConversionAppLinkPlatform	String	False		Describes Application Platform. 使用できる値は次のとおりです。ANDROID, UNKNOWN
AppLinkConversionAppVendorId	String	False		Application Vendor ID.
Category	String	False		A category for ConversionTracker. LEAD cannot be specified in SET operation. In ADD and SET operation, if the conversionTrackerType is APP_LINK_CONVERSION, there is a limit to the values that can be specified by appEventType.appEventType can be confirmed by appEvent.appEventType obtained by ConversionTrackerService/getAppEventType. In case of first_open, only DOWNLOAD can be selected. In case of in_app_purchase, only PURCHASE can be selected. In other cases, any value can be selected. 使用できる値は次のとおりです。DEFAULT, PAGE_VIEW, PURCHASE, SIGNUP, LEAD, DOWNLOAD, UNKNOWN
ConversionCountingType	String	False		Desribes how to count conversions. The default value in ADD operation will be ONE_PER_CLICK. In ADD and SET operation, if conversionTrackerType is APP_LINK_CONVERSION and appEventType is first_open, Only ONE_PER_CLICK can be specified. AppEventType can be confirmed by appEvent.appEventType obtained by ConversionTrackerService/getAppEventType. 使用できる値は次のとおりです。ONE_PER_CLICK, MANY_PER_CLICK, UNKNOWN
Conversions	Int64	False		Conversions which counts as included to Auto Bidding setting. CountingType specifies whether one-per-click or many-per-click.
ConversionTrackerName	String	False		ConversionTracker Name.
ConversionTrackerTrackId	Int64	False		ConversionTracker ID for tracking.
ConversionTrackerType	String	False		Describes conversion type. 使用できる値は次のとおりです。WEB_CONVERSION, APP_CONVERSION, APP_LINK_CONVERSION, UNKNOWN
ConversionValue	String	False		Conversion value to be included to auto bidding.
ExcludeFromBidding	String	False		Describes whether exclude the data for Auto Bidding setting or not. 使用できる値は次のとおりです。TRUE, FALSE, UNKNOWN デフォルト値はFALSEです。
MeasurementPeriod	Int64	False		Counting period of conversoins (days). It is available between 7 to 90 days. For Mobile App Download, this period is fixed as 30 days. This field is optional in ADD and SET operation. The default value in ADD operation will be 30. In ADD and SET operation, if conversionTrackerType is APP_LINK_CONVERSION and appEventType is first_open, Only 30 can be specified. AppEventType can be confirmed by appEvent.appEventType obtained by ConversionTrackerService/getAppEventType.
MostRecentConversionDate	Date	False		The most latest date when conversion occured.
Status	String	False		It shows ConversionTracker status. 使用できる値は次のとおりです。ENABLED, DISABLED, UNKNOWN
UserRevenueValue	String	False		The value of revenue of the conversion tracker specified by user. When the sales revenue of 1 conversion is fixed value, you are able to review the total sales on reports by specifying the amount on this item. If it is not specified on ADD request, the value 0 is set. This field is optional in ADD and SET operation. In ADD and SET operation, if conversionTrackerType is APP_LINK_CONVERSION and appEventType is in_app_purchase, it will be ignored even if specified. AppEventType can be confirmed by appEvent. AppEventType obtained by ConversionTrackerService/getAppEventType.
WebConversionAdvancedSnippet	String	False		The new format of conversion tag avoids the impacts such as changes made to the browser. If the conversionTrackerType is WEB_CONVERSION, this field will be required in ADD operation.
WebConversionMarkupLanguage	String	False		ConversionTrackerServiceMarkupLanguage shows ConversionTrackerServiceMarkupLanguage for Snipet. If the conversionTrackerType is WEB_CONVERSION, this field will be required in ADD operation. 使用できる値は次のとおりです。HTML, CHTML, XHTML, WML, UNKNOWN
WebConversionTrackingCodeType	String	False		ConversionTrackerServiceTrackingCodeType describes tracking type of web page. If the conversionTrackerType is WEB_CONVERSION, this field will be required in ADD operation. 使用できる値は次のとおりです。WEBPAGE, CLICK_TO_CALL, IMPORT, UNKNOWN

Pseudo-Columns

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


Name	Type	Description
StartDate	Date	Conversion performance aggregation period start
EndDate	Date	Conversion performance aggregation period end.
ReferenceNumber	String	This column will be used in Bulk operations to get specific values from the Temp tables.