ADO.NET Provider for Yahoo! Ads

Build 24.0.9062

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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062