ReportSearchAdsCampaign_asset
Returns Campaign_asset report data. A simple SELECT statement creates and retrieves the last seven days of report data.
Table-Specific Information
SELECT
The connector uses 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.
| Column | Supported Operators |
| AccountId | = |
| ReportJobId | = |
| ReportDateRangeType | = |
| DateRangeStartDate | = |
| DateRangeEndDate | = |
For example:
SELECT * FROM ReportSearchAdsCampaign_asset WHERE AccountId = '125466'
SELECT * FROM ReportSearchAdsCampaign_asset WHERE AccountId = '125466' AND ReportJobId = '123456'
SELECT * FROM ReportSearchAdsCampaign_asset WHERE AccountId = '125466' AND ReportDateRangeType = 'LAST_7_DAYS'
SELECT * FROM ReportSearchAdsCampaign_asset WHERE AccountId = '125466' AND ReportDateRangeType = 'CUSTOM_DATE' AND DateRangeStartDate = '2022-02-12' AND DateRangeEndDate = '2022-04-29'
Note: The report is dynamic. The columns may vary depending on the API.
Columns
| Name | Type | References | Description |
| ReportJobId | String | Report Job ID. | |
| AccountId | String | Account identifier. | |
| AccountName | String | Account Name | |
| CampaignID | Long | Campaign identifier. | |
| Campaignname | String | Campaign name | |
| Cost | Long | Cost | |
| Impressions | Long | Impressions | |
| Clicks | Long | Clicks | |
| CTR | Double | CTR | |
| Avg_CPC | Double | Avg. CPC | |
| EditorialStatus | String | Editorial Status | |
| AddisplayassetID | Long | Ad display asset ID | |
| Addisplayassettype | String | Ad display asset type | |
| StartDate | String | Start Date | |
| EndDate | String | End Date | |
| TrackingURL | String | Tracking URL | |
| Customparameter | String | Custom parameter | |
| FinalURL | String | Final URL | |
| SmartphonefinalURL | String | Smartphone final URL | |
| Callouttext | String | Callout text | |
| Call | String | Call | |
| Conversions | Double | Conversions | |
| Conv_rate | Double | Conv. rate | |
| Conv_value | Double | Conv. value | |
| Cost_conv_ | Double | Cost/conv. | |
| Conv_value_conv_ | Double | Conv. value/conv. | |
| Conversions_all_ | Double | Conversions (all) | |
| Conv_rate_all_ | Double | Conv. rate (all) | |
| Conv_value_all_ | Double | Conv. value (all) | |
| Cost_conv_all_ | Double | Cost/conv. (all) | |
| Conv_value_all_conv_all_ | Double | Conv. value (all)/conv. (all) | |
| Cross_deviceconv_ | Double | Cross-device conv. | |
| CampaigntrackingID | Long | Campaign tracking ID | |
| AddisplayassettrackingID | Long | Ad display asset tracking ID | |
| Quicklinktext | String | Quick link text | |
| Quicklinkdescription1 | String | Quick link description 1 | |
| Quicklinkdescription2 | String | Quick link description 2 | |
| Supplementalcategory | String | Supplemental category | |
| Supplementaltext | String | Supplemental text | |
| Medianame | String | Media name | |
| Aspectratio | String | Aspect ratio | |
| Showadson | String | Show ads on | |
| ClickType | String | ClickType | |
| Device | String | Dimension: Device | |
| Day | String | Dimension: Day | |
| Dayoftheweek | String | Day of the week | |
| Quarter | String | Dimension: Quarter | |
| Year | String | Dimension: Year | |
| Month | String | Dimension: Month | |
| MonthofYear | String | Month of Year | |
| Week_Mon_Sun_ | String | Week (Mon-Sun) | |
| ConversionTrackingPurpose | String | Conversion Tracking Purpose | |
| Conversionname | String | Conversion name | |
| Conv_value_cost | Double | Conv. value/cost | |
| Conv_value_all_cost | Double | Conv. value (all)/cost | |
| Businessname | String | Business name |
Pseudocolumns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるデータを詳細に制御することができます。
| Name | Type | Description | |
| ReportDateRangeType | String | ReportDefinitionService ReportDateRangeType displays a date range of the report | |
| DateRangeStartDate | String | The compilation start date | |
| DateRangeEndDate | String | The compilation end date. |