Apply Microsoft Advertising remarketing lists using bulksheets

You can use bulksheets to do the following:

Create positive and negative (exclude) remarketing targets
Set or change remarketing target bid adjustments
Remove remarketing targets from campaigns or ad groups. The Remarketing lists will still be available in Search Ads 360 because the bulksheet removes only the target and not the remarketing list.
Set or change the remarketing setting in campaigns or ad groups

Use a bulksheet to create campaign-level remarketing targets

Download an editable bulksheet that contains the Microsoft Advertising campaigns that you want to update.
1. Navigate to a Microsoft Advertising client account.
2. Click the Campaigns tab.
3. Optionally use a filter to display only the campaigns that you want.
4. Select the campaigns from the displayed list and click Apply.
5. Click the download icon , which appears above the reporting table and makes the following selections in the download panel. Note that some options are selected by default.
  - Scope: Current selection in table or Current scope
  - Columns: Editable columns (for re-upload)
  - Include types:
    - Campaigns
    - Campaign remarketing lists
    - Negative campaign remarketing lists
    - Negative ad group remarketing lists (optional)
      - You might want to select Negative ad group remarketing lists if you want to exclude the remarketing list members from some targeting.
  - Filters: Include rows with no impressions
6. Click Download.
In the downloaded bulksheet, enter information in the applicable columns in the campaign remarketing list and campaign rows to specify remarketing target settings.
Upload the bulksheet.

Bulksheet columns for creating and editing campaign remarketing targets

Column name	Description
Row type	Enter `campaign` in this column if you're going to also change the campaign remarketing list targeting setting. Enter `campaign remarketing list` to create or change a campaign remarketing list. Enter `negative campaign remarketing list` to create or change a negative remarketing list.
Action	In a `campaign` row enter: `edit` to change a campaign's settings For information about how to create campaigns using a bulksheet, see the Upload campaigns article. In a `campaign remarketing list` row, enter: `edit` to change a remarketing list's settings `create` to apply a remarketing list to a campaign (create a campaign remarketing target) `deactivate` to remove a remarketing list from a campaign (remove a campaign remarketing target) In a `negative campaign remarketing list` row, enter: `edit` to remove a remarketing list `create` to apply remarketing list to a campaign `deactivate` to remove a remarketing list from a campaign You can't use a bulksheet to add remarketing lists to an account.
Campaign	In a `campaign remarketing list` row, enter the name of the campaign that you're applying the remarketing list to. In a `negative campaign remarketing list` row, enter the name of the campaign that you're applying the remarketing list to. In `campaign` rows, the campaign name is already listed in the Campaign column.
Remarketing list	In a `campaign remarketing list` row, enter the name of a Microsoft Advertising remarketing list. In a `negative campaign remarketing list` row, enter the name of a Microsoft Advertising remarketing list. In a `campaign` row, the Remarketing list column should be blank.
Remarketing list bid adjustment %	In a campaign remarketing list row, enter a percent. You can increase bids by up to 900%. You can decrease bids by 90%. For example, enter -90% If you plan to use a conversion goal or Search Ads 360 bid strategy to set the remarketing target bid adjustment, set the bid adjustments to 0%. A conversion goal or bid strategy can be applied at the campaign level.
Campaign remarketing list targeting	In a `campaign` row, enter `Bid only` or `Target and Bid`. `Bid only` is the default setting.
Conversion goal name	Optional. In a campaign row, enter the name of an existing conversion goal to apply a conversion goal to the campaign and use the goal to set remarketing target bid adjustments. This column should be blank if you apply a Search Ads 360 bid strategy to the campaign.

Bulksheet columns for creating and editing ad group-level remarketing targets

Column name	Description
Row type	In an ad group row, enter the ad group if you're going to also change the Ad group remarketing list targeting setting. In an ad group remarketing list row, enter `ad group remarketing list`. In a negative ad group remarketing list row, enter `negative ad group remarketing list`.
Action	In an ad group row enter: `edit` to change a ad group's settings Learn how to Upload an ad to a specific client account. In an `ad group remarketing list row`, enter: `edit` to change a remarketing list's settings `create` to apply a remarketing list to an ad group `deactivate` to remove a remarketing list from an ad group (remove an ad group remarketing target) In a `negative ad group remarketing list` row, enter: `edit` to remove a remarketing list `create` to apply a negative remarketing list to an ad group `deactivate` to remove a remarketing list from an ad group (remove an excluded remarketing target) You can't use a bulksheet to add remarketing lists to an account.
Ad group	In an `ad group remarketing list` row, enter the name of the ad group that you're applying the remarketing list to. In a `negative ad group remarketing list` row, enter the name of the ad group that you're applying the remarketing list to. In `ad group` rows, the ad group name is already listed in the ad group column.
Campaign
Remarketing list	In an `ad group remarketing list` row, enter the name of a Microsoft Advertising remarketing list. In a `negative ad group remarketing list` row, enter the name of a Microsoft Advertising remarketing list. In an ad group row, the Remarketing list column should be blank.
Remarketing list bid adjustment %	In an `ad group remarketing list` row, enter a percent. You can increase bids by up to 900%. You can decrease bids by 90%. For example, enter -90% If you plan to use a conversion goal or Search Ads 360 bid strategy to set ad group remarketing target bid adjustments, set the bid adjustments to 0%. A bid strategy can be applied at the campaign level.
Ad group remarketing list targeting	Optional. An Ad group inherits the setting from its campaign. If you want to override the campaign setting, in an `ad group` row, enter `Bid only` or `Target and Bid`. `Bid only` is the default setting for campaigns and ad groups.
Conversion goal name	Optional. In a campaign row, enter the name of an existing conversion goal to apply a conversion goal to the campaign and use the goal to set ad group-level remarketing target bid adjustments. This column should be blank if you apply a Search Ads 360 bid strategy to the campaign.
Remarketing target bid adjustment setting	Optional. Applicable only if you apply a conversion goal to the campaign.

Was this helpful?

How can we improve it?

Apply Microsoft Advertising remarketing lists using bulksheets

Use a bulksheet to create campaign-level remarketing targets

Bulksheet columns for creating and editing campaign remarketing targets

Bulksheet columns for creating and editing ad group-level remarketing targets

Was this helpful?

Need more help?

Try these next steps: