CData Python Connector for Yahoo! Ads

Build 24.0.9062

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 本製品 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 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

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