ProductNegativeKeywordConflictReport
Use this report to discover which keywords and negative keywords are in conflict, and whether the conflict is at the campaign or ad group level. Use this list to figure out which negative keywords to delete.
Columns
| Name | Type | Select requirement | Metric | Aggregate | Description |
| AccountName | String | True | The account name. | ||
| AccountNumber | String | The Bing Ads assigned number of an account. | |||
| AccountId | Long | The Bing Ads assigned identifier of an account. | |||
| AccountStatus | String | The account status. | |||
| CampaignName | String | The campaign name. | |||
| CampaignId | Long | The Bing Ads assigned identifier of a campaign. | |||
| CampaignStatus | String | The campaign status. | |||
| AdGroupName | String | The ad group name. | |||
| AdGroupId | Long | The Bing Ads assigned identifier of an ad group. | |||
| AdGroupStatus | String | The ad group status. | |||
| ConflictLevel | String | The entity level where the keyword and negative keyword conflict occurs. The possible values are AdGroup and Campaign. | |||
| NegativeKeywordListId | Long | The Bing Ads assigned identifier of a negative keyword list. | |||
| NegativeKeyword | String | True | The negative keyword text. | ||
| NegativeKeywordId | Long | The Bing Ads assigned identifier of a negative keyword. | |||
| NegativeKeywordMatchType | String | The type of match to compare the negative keyword and the user's search term. The possible values for a negative keyword are Exact and Phrase. | |||
| Title | String | The type of match to compare the negative keyword and the user's search term. The possible values for a negative keyword are Exact and Phrase. | |||
| MerchantProductId | String | True | The report will include a column that contains the unique identifier provided by a merchant for each product offer. | ||
| AdGroupCriterionId | Long | The Bing Ads assigned identifier of an ad group criterion, or product group in the context of a Bing Shopping campaign. | |||
| ProductGroup | String | True | The forward slash ('/') delimited list of product conditions, reported as Operand= |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| DatePreset | String | The time period to use for the report. You can specify a custom date range or select a predefined date range, for example, Today or ThisWeek.
使用できる値は次のとおりです。Today, Yesterday, LastSevenDays, ThisWeek, LastWeek, Last14Days, Last30Days, LastFourWeeks, ThisMonth, LastMonth, LastThreeMonths, LastSixMonths, ThisYear, LastYear, ThisWeekStartingMonday, LastWeekStartingMonday, LastFourWeeksStartingMonday |
| EndDate | String | The end date of the custom date range. The end date cannot be later than today's date. |
| StartDate | String | The start date of the custom date range. The start date must be earlier than or the same as the end date. |