ReportDisplayAdsModel_comparison
Returns Model_comparison 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 ReportDisplayAdsModel_comparison WHERE AccountId = '125466'
SELECT * FROM ReportDisplayAdsModel_comparison WHERE AccountId = '125466' AND ReportJobId = '123456'
SELECT * FROM ReportDisplayAdsModel_comparison WHERE AccountId = '125466' AND ReportDateRangeType = 'LAST_7_DAYS'
SELECT * FROM ReportDisplayAdsModel_comparison 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 | |
| CampaignID | Long | Campaign ID | |
| CampaignName | String | Campaign Name | |
| AdGroupID | Long | Ad Group ID | |
| AdGroupName | String | Ad Group Name | |
| Campaigngoals | String | Campaign goals | |
| Campaignsubtype | String | Campaign subtype | |
| Campaignbuyingtype | String | Campaign buying type | |
| Packagetype | String | Package type | |
| Cost | Double | Cost | |
| Basemodel | String | Base model | |
| Comparativemodel | String | Comparative model | |
| Creditsforconversions_incl_view_through_inthebasemodel | Double | Credits for conversions (incl. view-through) in the base model | |
| Creditsforconversions_incl_view_through_inthecomparativemodel | Double | Credits for conversions (incl. view-through) in the comparative model | |
| Changerateofcreditsforconversions_incl_view_through_ | Double | Change rate of credits for conversions (incl. view-through) | |
| Creditsforcost_conv_incl_view_through_inthebasemodel | Double | Credits for cost/conv. (incl. view-through) in the base model | |
| Creditsforcost_conv_incl_view_through_inthecomparativemodel | Double | Credits for cost/conv. (incl. view-through) in the comparative model | |
| Changerateofcreditsforcost_conv_incl_view_through_ | Double | Change rate of credits for cost/conv. (incl. view-through) | |
| Creditsforconv_value_incl_view_through_inthebasemodel | Double | Credits for conv. value (incl. view-through) in the base model | |
| Creditsforconv_value_incl_view_through_inthecomparativemodel | Double | Credits for conv. value (incl. view-through) in the comparative model | |
| Changerateofcreditsforconv_value_incl_view_through_ | Double | Change rate of credits for conv. value (incl. view-through) | |
| Creditsforconv_value_incl_view_through_costinthebasemodel | Double | Credits for conv. value (incl. view-through)/cost in the base model | |
| Creditsforconv_value_incl_view_through_costinthecomparativemodel | Double | Credits for conv. value (incl. view-through)/cost in the comparative model | |
| Changerateofcreditsforconv_value_incl_view_through_cost | Double | Change rate of credits for conv. value (incl. view-through)/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. |