Specify Google Ads location targets via bulksheet

In Google Ads campaigns, you can specify location targets and adjust bids by geographic locations. Google Ads ad groups always inherit these targets. That is, you can't specify location targets in a Google Ads group. 

Specify Google Ads campaign location targets in a bulksheet

1. Download the list of Google Ads geo codes: XLSX / CSV.
2. Navigate to a Google Ads account. 
   We recommend that you set at least one location target using the Search Ads 360 user interface before you download a bulksheet to add location targets.
3. Click the Campaigns tab.
4. Do either of the following to select the campaigns that you want to update:
   • Select the check boxes of the campaigns.
   • Filter the list to include only the campaigns that you want.
5. Download a report.
   1. Click the download icon , which appears above the reporting table.
   2. On the Download report tab, do the following:
      • Report name. Enter a report name or use the default name.
      • Scope. Use the default selection which is either Current selection in table or Current scope.
      • Format. Click the arrow and select a file format. Excel 2007 (.xlsx) is selected by default. 
      • Columns. Don't change the default option which is Editable columns (for re-upload).
      •  Include types:
        •  Clear the Campaigns check box. 
          If you include campaigns and ad groups in the bulksheet, it will include location columns for Country, Region, Metro, and City.  In the Country column you could see, US | CA;-90% in a campaign that targets the United States, and decreases bids by 90% to target Canada. 

          While you can specify location targets and bid adjustments, in the columns of a campaign row, we recommend using location target rows instead because you can enter all location types in the Location column.
        • Select the Campaign location targets check box.
   3. Optional. Select other options.
   4. Click Download.
6. In the bulksheet, specify location target settings in the appropriate columns: 
   1. Add a location target row for each location target  or edit existing location target rows.
      For example, to target Indiana and Denmark with a campaign named, Campcar, you'd enter US-IN in one location target row, and enter DK in a different location target row.
   2. Optional. In the Location bid adjustment % column, enter a percent to adjust the default bid.

7. Upload the bulksheet back into Search Ads 360.

Bulksheet columns for campaign location targets

Specify Google Ads negative location targets using a bulksheet

1. Navigate to a Google Ads account or campaign.
2. Click the Targets ▼ tab, and then click Location targets.
3. Click the Excluded tab.
4. Download a report.
   1. Click the download icon , which appears above the reporting table.
   2. On the Download report tab, do the following:
      • Report name. Enter a report name or use the default name.
      • Scope. Use the default selection which is either Current selection in table or Current scope.
      • Format. Click the arrow and select a file format. Excel 2007 (.xlsx) is selected by default. 
      • Columns. Don't change the default option which is Editable columns (for re-upload).
      •  Include types:
        • The Negative campaign location targets check box is selected for you.
   3. Optional. Select other options.
   4. Click Download.
5. In the bulksheet, specify negative location target settings in the appropriate columns: 
   1. Add a negative location target row for each location target that you want to exclude.
      For example, to exclude Indiana and Denmark from a campaign named, Campcar, you'd enter US-IN in one negative location target row, and enter DK in a different negative location target row.
6. Upload the bulksheet back into Search Ads 360.