SearchAdsConversionTracker
Create, Read or Update ConversionTracker information.
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 '='.
- 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. |