SearchAdsReports
Create, Read or Delete a report.
Table Specific Information
Select
The 本製品 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 本製品. Note: AccountId is required for Select on this table
- AccountId supports the '='.
- ReportJobId supports the '=,IN'.
- ReportJobStatus supports the '=,IN'.
- ReportType supports the '=,IN'.
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. |