ReportDisplayAdsApp
To view the App report. Simple Select statement will create and retrieve last 7 days 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 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 ReportDisplayAdsApp WHERE AccountId = '125466' SELECT * FROM ReportDisplayAdsApp WHERE AccountId = '125466' AND ReportJobId = '123456' SELECT * FROM ReportDisplayAdsApp WHERE AccountId = '125466' AND ReportDateRangeType = 'LAST_7_DAYS' SELECT * FROM ReportDisplayAdsApp 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
| Name | Type | References | Description |
| ReportJobId | String | Report Job ID. | |
| AccountId | Long | AccountId | |
| AccountName | String | Account Name | |
| Campaignbuyingtype | String | Campaign buying type | |
| Packagename | String | Package name | |
| Lifetimebudget | Double | Lifetime budget | |
| CampaignID | Long | Campaign ID | |
| CampaignName | String | Campaign Name | |
| Campaigndeliverysettings | String | Campaign delivery settings | |
| AdGroupID | Long | Ad Group ID | |
| AdGroupName | String | Ad Group Name | |
| Adgroupdeliverysettings | String | Ad group delivery settings | |
| AdID | Long | Ad ID | |
| AdName | String | Ad Name | |
| Addeliverysettings | String | Ad delivery settings | |
| Adtype | String | Ad type | |
| Mainmediaformat | String | Main media format | |
| Responsiveadstype | String | Responsive ads type | |
| Title | String | Title | |
| Description1 | String | Description 1 | |
| Description2 | String | Description 2 | |
| DisplayURL | String | Display URL | |
| DestinationURL_campaignbanner_ | String | Destination URL (campaign banner) | |
| AppName | String | App Name | |
| AppOS | String | App OS | |
| AppID_Packagename | String | App ID/Package name | |
| Impressions | Long | Impressions | |
| Clicks | Long | Clicks | |
| CTR | Double | CTR | |
| Cost | Double | Cost | |
| Avg_CPC | Double | Avg. CPC | |
| Avg_position | Double | Avg. position | |
| Avg_CPM | Double | Avg. CPM | |
| Avg_vCPM | Double | Avg. vCPM | |
| 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. | |
| Conv_value_cost | Double | Conv. value/cost | |
| Cross_deviceconv_ | Long | Cross-device conv. | |
| View_throughconversions | Long | View-through conversions | |
| 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) | |
| Conv_value_all_cost | Double | Conv. value (all)/cost | |
| 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) | |
| Conv_value_viaclick_cost | Double | Conv. value (via click)/cost | |
| Viewableimpressions | Long | Viewable impressions | |
| Viewableimpressionrate | Double | Viewable impression rate | |
| Viewableclicks | Long | Viewable clicks | |
| ViewableCTR | Double | Viewable CTR | |
| Measuredimpressions | Long | Measured impressions | |
| Measuredimpressionrate | Double | Measured impression rate | |
| Videoviewthroughrate | Double | Video view through rate | |
| Videoviews | Long | Video views | |
| 10secvideoviews | Long | 10 sec video views | |
| 3secvideoviews | Long | 3 sec video views | |
| 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 | |
| Installs_SKAN_ | Long | Installs (SKAN) | |
| Installs_SKANviaclick_ | Long | Installs (SKAN via click) | |
| Installs_SKANview_through_ | Long | Installs (SKAN view-through) | |
| Costperinstall_SKAN_ | Double | Cost per install (SKAN) | |
| Costperinstall_SKANviaclick_ | Double | Cost per install (SKAN via click) | |
| Month | String | Dimension: Month | |
| Week_Mon_Sun_ | String | Week (Mon-Sun) | |
| Daily | String | Dimension: Daily | |
| OS | String | OS | |
| Device | String | Device | |
| Web_App | String | Web/App | |
| PrefectureID | String | Prefecture ID | |
| Prefectures | String | Prefectures | |
| CityID | String | City ID | |
| City | String | City | |
| WardID | String | Ward ID | |
| Ward | String | Ward | |
| Targetradius | String | Target radius | |
| Distancefromtargetlocation | String | Distance from target location | |
| Gender | String | Gender | |
| Age | String | Age | |
| Campaigngoals | String | Campaign goals | |
| Campaignsubtype | String | Campaign subtype | |
| Packagetype | String | Package type | |
| Campaigndeliverytype | String | Campaign delivery type | |
| Paidvideoviews_CPV_ | Long | Paid video views (CPV) | |
| Paidvideoviewrate_CPV_ | Double | Paid video view rate (CPV) | |
| 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 |
Pseudo-Columns
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. |