ReportDisplayAdsCampaign_budget
Returns Campaign_budget report data. A simple SELECT statement creates and retrieves the last seven days of report data.
Table-Specific Information
SELECT
The 本製品 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 本製品.
| Column | Supported Operators |
| AccountId | = |
| ReportJobId | = |
| ReportDateRangeType | = |
| DateRangeStartDate | = |
| DateRangeEndDate | = |
For example:
SELECT * FROM ReportDisplayAdsCampaign_budget WHERE AccountId = '125466'
SELECT * FROM ReportDisplayAdsCampaign_budget WHERE AccountId = '125466' AND ReportJobId = '123456'
SELECT * FROM ReportDisplayAdsCampaign_budget WHERE AccountId = '125466' AND ReportDateRangeType = 'LAST_7_DAYS'
SELECT * FROM ReportDisplayAdsCampaign_budget 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 | Long | Account identifier. | |
| AccountName | String | Account Name | |
| Campaigndeliverysettings | String | Campaign delivery settings | |
| Month | String | Dimension: Month | |
| Week_Mon_Sun_ | String | Week (Mon-Sun) | |
| Daily | String | Dimension: Daily | |
| Device | String | Device | |
| ObjectiveofConversionTracking | String | Objective of Conversion Tracking | |
| ConversionName | String | Conversion Name | |
| ConversionID | String | Conversion ID | |
| OS | String | OS | |
| Web_App | String | Web/App | |
| CampaignType | String | Campaign Type | |
| AppID_Packagename | String | App ID/Package name | |
| AppName | String | App Name | |
| AppOS | String | App OS | |
| Campaigngoals | String | Campaign goals | |
| Campaignsubtype | String | Campaign subtype | |
| Campaignbuyingtype | String | Campaign buying type | |
| Packagetype | String | Package type | |
| Packagename | String | Package name | |
| Campaigndeliverytype | String | Campaign delivery type | |
| Impressions | Long | Impressions | |
| CTR | Double | CTR | |
| Cost | Double | Cost | |
| Clicks | Long | Clicks | |
| Avg_CPC | Double | Avg. CPC | |
| Avg_position | Double | Avg. position | |
| Viewableimpressions | Long | Viewable impressions | |
| Avg_CPV | Double | Avg. CPV | |
| 25_videoviews | Long | 25% video views | |
| 50_videoviews | Long | 50% video views | |
| 75_videoviews | Long | 75% video views | |
| 95_videoviews | Long | 95% video views | |
| 100_videoviews | Long | 100% video views | |
| Avg_videoviewrate | Double | Avg. video view rate | |
| Avg_durationofvideoviewed | Double | Avg. duration of video viewed | |
| Videoviews | Long | Video views | |
| Paidvideoviews_CPV_ | Long | Paid video views (CPV) | |
| Paidvideoviewrate_CPV_ | Double | Paid video view rate (CPV) | |
| 3secvideoviews | Long | 3 sec video views | |
| Conversions | Long | Conversions | |
| Conv_rate | Double | Conv. rate | |
| Cost_conv_ | Double | Cost/conv. | |
| Conv_value | Long | Conv. value | |
| Conv_value_conv_ | Double | Conv. value/conv. | |
| Conversions_all_ | Long | Conversions (all) | |
| Conv_rate_all_ | Double | Conv. rate (all) | |
| Cost_conv_all_ | Double | Cost/conv. (all) | |
| Conv_value_all_ | Long | Conv. value (all) | |
| Conv_value_all_conv_all_ | Double | Conv. value (all)/conv. (all) | |
| Conversions_viaclick_ | Long | Conversions (via click) | |
| Conv_rate_viaclick_ | Double | Conv. rate (via click) | |
| Cost_conv_viaclick_ | Double | Cost/conv. (via click) | |
| Conv_value_viaclick_ | Long | Conv. value (via click) | |
| Conv_value_viaclick_conv_viaclick_ | Double | Conv. value (via click)/conv. (via click) | |
| Cross_deviceconv_ | Long | Cross-device conv. | |
| Conv_value_cost | Double | Conv. value/cost | |
| Conv_value_all_cost | Double | Conv. value (all)/cost | |
| Conv_value_viaclick_cost | Double | Conv. value (via click)/cost | |
| Avg_CPM | Double | Avg. CPM | |
| Avg_vCPM | Double | Avg. vCPM | |
| Measuredimpressions | Long | Measured impressions | |
| Viewableclicks | Long | Viewable clicks | |
| Measuredimpressionrate | Double | Measured impression rate | |
| Viewableimpressionrate | Double | Viewable impression rate | |
| ViewableCTR | Double | Viewable CTR | |
| 10secvideoviews | Long | 10 sec video views | |
| View_throughconversions | Long | View-through conversions | |
| Videoviewthroughrate | Double | Video view through rate | |
| Impressionshare | Double | Impression share | |
| Lostimpressionshare_budget_ | Double | Lost impression share (budget) | |
| Lostimpressionshare_rank_ | Double | Lost impression share (rank) | |
| SharedbudgetID | Long | Shared budget ID | |
| Sharedbudgetname | String | Shared budget name | |
| Dailysharedbudget | Long | Daily shared budget | |
| Sharedcampaigns | Long | Shared campaigns | |
| Targetcampaigns | String | Target campaigns | |
| Installs | Long | Installs | |
| Installs_click_ | Long | Installs (click) | |
| Conversionsafterinstall | Long | Conversions after install | |
| Conversionsafterinstall_click_ | Long | Conversions after install (click) | |
| Conversionsafterinstall_all_ | Long | Conversions after install (all) | |
| Conversionsafterinstall_click_all_ | Long | Conversions after install (click) (all) | |
| Conversionvalueafterinstall | Double | Conversion value after install | |
| Conversionvalueafterinstall_click_ | Double | Conversion value after install (click) | |
| Conversionvalueafterinstall_all_ | Double | Conversion value after install (all) | |
| Conversionvalueafterinstall_click_all_ | Double | Conversion value after install (click) (all) | |
| Costperinstall | Double | Cost per install | |
| Costperinstall_click_ | Double | Cost per install (click) | |
| CPAafterinstall | Double | CPA after install | |
| CPAafterinstall_click_ | Double | CPA after install (click) | |
| Conversionvalueafterinstall_cost | Double | Conversion value after install/cost | |
| Conversionvalue_click_afterinstall_cost | Double | Conversion value (click) after install/cost |
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. |