ADO.NET Provider for Yahoo! Ads

Build 24.0.9062

DisplayAdsConversionTrackers

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 '='.
  • AppConversionAppConversionPlatform supports the '='.
  • AppConversionAppId supports the '=,IN'.
  • Category supports the '=,IN'.
  • ConversionTrackerId supports the '=,IN'.
  • ConversionTrackerType supports the '=,IN'.
  • CountingType supports the '='.
  • ExcludeFromBidding supports the '='.
  • Status supports the '=,IN'.
  • StatsEndDate supports the '='.
  • StatsStartDate supports the '='.
  • StatsPeriod supports the '='.
For example:
SELECT * FROM DisplayAdsConversionTrackers WHERE AccountId = '1002504155'

SELECT * FROM DisplayAdsConversionTrackers WHERE AccountId = '1002504155' AND ConversionTrackerId = '1307071'

INSERT

Insert can be executed by specifying the AccountId, ConversionTrackerName, Status, Category, ConversionTrackerType, AppConversionPlatform 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 DisplayAdsConversionTrackers (AccountId, ConversionTrackerName, Status, Category, ConversionTrackerType, AppConversionPlatform) VALUES ('1002504155', 'vtest', 'ENABLED', 'DEFAULT', 'WEB_CONVERSION', 'ANDROID_MARKET')

UPDATE

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

UPDATE DisplayAdsConversionTrackers SET ConversionTrackerName = 'test' WHERE AccountId = '1002504155' AND ConversionTrackerId = '1307071'

Columns

Name Type ReadOnly References Description
ConversionTrackerId [KEY] Int64 True

Conversion Tracker ID.

AccountId Int64 True

DisplayAdsAccounts.AccountId

Account ID.

AllConversions Int64 False

Conversions (all).

AllConversionValue String False

Conversion value (all).

AppConversionPlatform String False

Target platform of the app conversion.

使用できる値は次のとおりです。ITUNES, ANDROID_MARKET, UNKNOWN

AppConversionType String False

Type of counting conversions for app.FIRST_OPEN' will be counted as one conversion of app install for mobile app campaign, when the app first opened.

使用できる値は次のとおりです。FIRST_OPEN, UNKNOWN

デフォルト値はFIRST_OPENです。

AppId String False

App ID of the object to be tracked.

Category String False

Category for ConversionTracker

使用できる値は次のとおりです。NONE, DEFAULT, PAGE_VIEW, PURCHASE, SIGNUP, LEAD, DOWNLOAD, UNKNOWN

Conversions Int64 False

Conversions.

ConversionsViaAdClick Int64 False

Conversions (via click).

ConversionTrackerName String False

Conversion Tracker Name.

ConversionTrackerType String False

Conversion type.

使用できる値は次のとおりです。WEB_CONVERSION, APP_CONVERSION, IMPORT_CONVERSION, UNKNOWN

ConversionValue String False

Conv. value/conv.

ConversionValueViaAdClick String False

Conv. value (via click).

CountingType String False

conversion measurement method

使用できる値は次のとおりです。ONE_PER_CLICK, MANY_PER_CLICK, UNKNOWN

CrossDeviceConversions Int64 False

Cross-device conv.

ExcludeFromBidding String False

use or not for auto bidding.

使用できる値は次のとおりです。FALSE, TRUE, UNKNOWN

デフォルト値はFALSEです。

MeasurementPeriod Int64 False

Counting period (Unit: Day). Can be specified within the range of 7 to 90 days. The default value in ADD operation will be 30.

デフォルト値は30です。

MeasurementPeriodView Int64 False

Counting period (Video view) .Can be specified within the range of 1 to 30. The default value in ADD operation will be 1

デフォルト値は1です。

MostRecentConversionDate Date False

The date of the most recent conversion.

Status String False

ConversionTracker status

使用できる値は次のとおりです。ENABLED, DISABLED, UNKNOWN

UserRevenueValue Int64 False

Revenue value for Conversions.The default value in ADD operation will be 0.

デフォルト値は0です。

ViewThroughConversions Int64 False

View through conversions

WebConversionSnippet String False

Type of tracking script

IsPreviousConversion String False

It is a flag that indicates whether to include conversion tracker information that includes conversion tag which conversion label is not set.

AdvancedMatchingEnabled String False

It is management flag for whether or not to use advanced matching.

Pseudo-Columns

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

Name Type Description
StatsEndDate Date

Acquisition end date of stats information.

StatsStartDate Date

Acquisition start date of stats information.

StatsPeriod String

summarized period of statistics

使用できる値は次のとおりです。DEFINITE_VALUE_YESTERDAY, DEFINITE_VALUE_LASTBSDAY, DEFINITE_VALUE_LASTWEEK, DEFINITE_VALUE_WEEK, DEFINITE_VALUE_TWOWEEK, DEFINITE_VALUE_THIRTYDAY, DEFINITE_VALUE_LASTMONTH, REALTIME_TODAY, REALTIME_MONTH, REALTIME_LAST25MONTH, REALTIME_LAST37MONTH, CUSTOM_DATE, UNKNOWN

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