To view the Asset Combination report, a simple SELECT statement generates and retrieves the report for the last 7 days.

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 '='.
• ReportJobId supports the '='.
• ReportDateRangeType supports the '='.
• DateRangeStartDate supports the '='.
• DateRangeEndDate supports the '='.

SELECT * FROM ReportSearchAdsAsset_combinations WHERE AccountId = '125466'
SELECT * FROM ReportSearchAdsAsset_combinations WHERE AccountId = '125466' AND ReportJobId = '123456'
SELECT * FROM ReportSearchAdsAsset_combinations WHERE AccountId = '125466' AND ReportDateRangeType = 'LAST_7_DAYS'
SELECT * FROM ReportSearchAdsAsset_combinations WHERE AccountId = '125466' AND ReportDateRangeType = 'CUSTOM_DATE' and DateRangeStartDate = '2022-02-12' AND DateRangeEndDate = '2022-04-29'

Note: Since the Report is Dynamic, so the columns may vary depending upon the API.

Columns

Pseudo-Columns

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