Create and remove negative dynamic ad targets using bulksheets

To exclude pages on your site from being advertised by a dynamic search ad, create a negative dynamic ad target either at the campaign level or a specific ad group level. Learn more about creating negative dynamic targets.

Note that you can't use bulksheets to edit negative dynamic ad targets. Instead, you'll need to remove the target you want to change and create a new one.

1. Download a bulksheet that contains existing negative targets (even if you haven't created any  targets, follow these steps to download a bulksheet that contains the columns and IDs you'll need to create targets):
   1. Navigate to a Google Ads engine account, campaign, or ad group.
   2. Click the Targets ▼ tab,  click Dynamic ad targets, and then click Excluded. 
      If you don't see Dynamic ad targets, the current scope is not set up for dynamic search ads.
   3. Click the download icon , which appears above the reporting table and make the following selections in the download panel:
      • Scope: Current selection in table
      • Columns: Editable columns (for re-upload)
      • Include types: Negative campaign dynamic ad targets and Negative ad group dynamic ad targets
      • Filters: Include rows with no impressions
   4. Click Download to start generating a bulksheet.
      When Search Ads 360 finishes generating the bulksheet, a Download now link appears above the reporting table.
   5. Click Download now.
      Your browser downloads the bulksheet to its download directory.
2. To create a new negative target, add a new row to the bulksheet.
   You can copy an existing row and edit the data in the columns.
3. Enter or edit information in the bulksheet columns described below.
4. Upload the bulksheet. 

Bulksheet columns for creating or removing negative dynamic ad targets

Row type: 

Enter Negative campaign dynamic ad target or Negative ad group dynamic ad target.

Action: 

Enter one of the following:

• create to create a new negative target.
• pause to pause an existing negative target
• remove to remove an existing negative target

Account, Campaign, Ad group: 

Enter the names of the engine account and campaign that you want to contain the negative target. If you're creating a negative target in a specific ad group, you'll also need to specify the ad group ID.

Dynamic search ad target:

Sets criteria for excluding pages under the site domain. If you're editing an existing target, leave the column empty to keep the current setting.

You can specify up to three criteria in a logical AND statement. The target will only exclude pages that match all criteria.

Here's the syntax:
AND(criteria, criteria, criteria)
Even if you specify only one criterion, you still need the AND statement:
AND(criteria)

For example: 
AND(CATEGORY = "shoes/outdoor/sneakers", PAGE_CONTENT CONTAINS "mens", PAGE_TITLE CONTAINS "casual")

Here are the types of criteria you can specify:

• CATEGORY = "mycategory":  Google automatically assigns predefined categories to the pages on your site based on the content of the pages. To see the categories that Google has assigned to your site, use the Search Ads 360 UI. Learn more about CATEGORY criteria. 

  If you're targeting second or third-level categories, separate each level by a slash:
  CATEGORY = "top-category/second-level-category/third-level-category"

• URL CONTAINS "string":  Excludes pages with URLs that contain the string you specify.

  The match is not case sensitive, nor does it support wildcards.

  For example, if you specify
  URL CONTAINS "red",
  the negative target will exclude pages with these URLs:
  https://www.example.com/shoes/red
  https://www.example.com/elves/TIRED/abc

• PAGE_TITLE CONTAINS "string": Excludes pages with titles that contain the string you specify. This is the title that's specified in the pages <title> HTML element. Some browsers display the page's title in bar at the top of the browser window.

  The match is not case sensitive, nor does it support wildcards.

• PAGE_CONTENT CONTAINS "string": Excludes pages that contain the string you specify. Specifically, the string needs to be within the page's <body> HTML element.

  The match is not case sensitive, nor does it support wildcards.

• CUSTOM_LABEL = "string": Excludes pages from page feeds with a specified label. Separate each label with a comma.