DisplayAdsConversionTrackers
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 '='.
- 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 '='.
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. |