SearchAdsReports

Create, Read or Delete a report.

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 rest of the filter is executed client side within the connector. Note: AccountId is required for Select on this table

AccountId supports the '='.
ReportJobId supports the '=,IN'.
ReportJobStatus supports the '=,IN'.
ReportType supports the '=,IN'.

For example:

SELECT * FROM SearchAdsReports WHERE AccountId = '125466'

INSERT

Insert can be executed by specifying the AccountId, Fields, ReportDateRangeType, ReportName and ReportType 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 SearchAdsReports (AccountId,Fields,ReportDateRangeType,ReportName,ReportType) VALUES ('1234339','ACCOUNT_ID,ACCOUNT_NAME,COST,CLICKS,CLICK_RATE','TODAY','MyAccountReport','ACCOUNT')

DELETE

Delete can be executed by specifying the AccountId and ReportJobId in the WHERE Clause. For example:

DELETE FROM SearchAdsReports WHERE AccountId = '1234' AND ReportJobId = '89756'

Columns


Name	Type	ReadOnly	References	Description
ReportJobId [KEY]	String	True		Report Job ID.
AccountId	Int64	True	SearchAdsAccounts.AccountId	Account ID.
CompleteTime	Datetime	False		Completion time of Report Job request
DateRangeStartDate	Date	False		Start date.
DateRangeEndDate	Date	False		End date.
Fields	String	False		Item name of the report.
Filters	String	False		Object displays filtering report conditions.
ReportCompressType	String	False		Displays if defined download report is compressed. 使用できる値は次のとおりです。NONE, ZIP, UNKNOWN
ReportDateRangeType	String	False		Displays a date range of the report. 使用できる値は次のとおりです。TODAY, YESTERDAY, LAST_7_DAYS, LAST_WEEK, LAST_14_DAYS, LAST_30_DAYS, LAST_BUSINESS_WEEK, THIS_MONTH, LAST_MONTH, ALL_TIME, CUSTOM_DATE, UNKNOWN
ReportDownloadEncode	String	False		Displays a character code of the report. 使用できる値は次のとおりです。UTF8, SJIS, EUC, UTF16LE, UNKNOWN
ReportDownloadFormat	String	False		Displays a file format of the report. 使用できる値は次のとおりです。CSV, XML, TSV, UNKNOWN
ReportIncludeDeleted	String	False		Describes whether to output deleted items on the report or not. 使用できる値は次のとおりです。TRUE, FALSE, UNKNOWN
ReportIncludeZeroImpressions	String	False		Describes whether including 0 impression line in the report or not. 使用できる値は次のとおりです。TRUE, FALSE, UNKNOWN
ReportJobErrorDetail	String	False		Error details of Report Job.
ReportJobStatus	String	False		A status of the requested report. 使用できる値は次のとおりです。WAIT, COMPLETED, IN_PROGRESS, FAILED, UNKNOWN
ReportLanguage	String	False		A language selection for report definition. 使用できる値は次のとおりです。JA, EN, UNKNOWN
ReportName	String	False		Name of the report.
ReportType	String	False		Displays a type of available report. 使用できる値は次のとおりです。ACCOUNT, CAMPAIGN, ADGROUP, AD, KEYWORDS, SEARCH_QUERY, GEO, FEED_ITEM, GEO_TARGET, SCHEDULE_TARGET, BID_STRATEGY, AD_CUSTOMIZERS, TARGET_LIST, LANDING_PAGE_URL, KEYWORDLESSS_QUERY, WEBPAGE_CRITERION, UNKNOWN
RequestTime	Datetime	False		Start time of Report Job request.
SortFields	String	False		Describes sort details of report definition.

Pseudo-Columns

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


Name	Type	Description
ReferenceNumber	String	This column will be used in Bulk operations to get specific values from the Temp tables.