DisplayAdsConversionTrackerWebConversionSnippets
Retrieve the details of tracking script information of Web Conversion Tracker. The columns values set read-only false can be inserted in the parent table using Temp tables.
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 DisplayAdsConversionTrackerWebConversionSnippets WHERE AccountId = '1002504155' SELECT * FROM DisplayAdsConversionTrackerWebConversionSnippets WHERE AccountId = '1002504155' AND ConversionTrackerId = '1307071'
Columns
| Name | Type | References | Description |
| AccountId | Int64 |
DisplayAdsAccounts.AccountId | Account ID. |
| ConversionTrackerId | Int64 | Conversion Tracker ID. | |
| AppConversionPlatform | String | Target platform of the app conversion.
使用できる値は次のとおりです。ITUNES, ANDROID_MARKET, UNKNOWN | |
| AppId | String | App ID of the object to be tracked. | |
| Category | String | Category for ConversionTracker
使用できる値は次のとおりです。NONE, DEFAULT, PAGE_VIEW, PURCHASE, SIGNUP, LEAD, DOWNLOAD, UNKNOWN | |
| ConversionTrackerType | String | Conversion type.
使用できる値は次のとおりです。WEB_CONVERSION, APP_CONVERSION, IMPORT_CONVERSION, UNKNOWN | |
| CountingType | String | conversion measurement method
使用できる値は次のとおりです。ONE_PER_CLICK, MANY_PER_CLICK, UNKNOWN | |
| ExcludeFromBidding | String | use or not for auto bidding.
使用できる値は次のとおりです。FALSE, TRUE, UNKNOWN デフォルト値はFALSEです。 | |
| Status | String | ConversionTracker status
使用できる値は次のとおりです。ENABLED, DISABLED, UNKNOWN | |
| AdvancedTag | String | The new format of conversion tag avoids the impacts such as changes made to the browser. | |
| WebConversionSnippetType | String | Type of tracking script.
使用できる値は次のとおりです。IMG, JS, UNKNOWN |
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 |