Search
Clear search
Close search
Google apps
Main menu

Welcome to the help center for DoubleClick Search, a platform for managing search marketing campaigns.  While the help center is available to the public, access to the DoubleClick Search product is available only to subscribing customers who are signed in. To subscribe or find out more, contact our sales team.

Use bulksheets to create manual campaigns

Use a bulksheet to apply DS bid strategies and specify adaptive settings

Apply DS bid strategies to AdWords and Bing Ads campaigns and turn on adaptive features

To speed up campaign management when you want to apply DS bid strategies to AdWords or Bing Ads campaigns and turn on adaptive features in many campaigns, you can use a bulksheet to make changes to the campaigns instead of using the DS user interface. 

You can't use a bulksheet to create or edit bid strategies. Bulksheets are great for applying bid strategies and turning on the adaptive feature in supported campaign types.

The overall process for turning on the adaptive feature in AdWords and Bing Ads campaigns is as follows:

  1. Download an editable bulksheet that contains the AdWords and Bing Ads campaigns that you want to update.

  2. In the downloaded bulksheet, edit the applicable columns in the campaign rows to specify adaptive settings. 
  3. Upload the bulksheet.

     

Download an editable bulksheet

  1. Navigate to an advertiser.

  2. Click the Campaigns tab.

  3. Optional. Add the following columns to the report to verify if a DS bid strategy or other item is managing bidding or other options in a campaign.

    • Bid strategy.  Displays (manual bidding) or the name of the DS bid strategy that is applied to the campaign.

    • Conversion goal name. Displays the name of a conversion goal if one is applied to a campaign or dashes (---) if a conversion goal isn't applied to a campaign. You'll need to remove the conversion goal to apply a bid strategy to a campaign.

    • Engine bid strategy type. Displays Manual CPC or the AdWords bid strategy type, for example Target CPA, if one is applied to the campaign. Manual CPC indicates that the AdWords bid strategy is set to manual bidding. To avoid conflicts, you may want to remove the AdWords bid strategy to apply a DS bid strategy to a campaign.

    • Campaign type. Displays the type of campaign.  Use this column to help you specify applicable settings for the type of campaign.  For example, don't set the adaptive product groups setting in a manual campaign. 

  4. Optionally use a filter to display only the campaigns that you want to include in a DS bid strategy or check the boxes of the AdWords and Bing Ads campaigns that you want to update. 

  5. Click the download icon Download icon, which appears above the reporting table and make the following selections in the download panel:
    • Scope: Current selection in table or Current scope
    • Columns: Editable columns (for re-upload)
    • Include types:
      • Campaigns
      • Campaign location targets. (AdWords campaigns only) If you're going to turn on the adaptive location targets feature, you should also select the Campaign location targets check box to verify that the campaign includes a least one high-level location target that can be subdivided. Each location target is listed in a separate row in the bulksheet.
    • Filters: Include rows with no impressions
  6. Click Download.

DS generates the report and either downloads the file to your browser's download directory or sends an email, depending on the delivery option you selected.

If you selected to download a report and the report is very large, it may take a while for DS to generate the report. You can still use DS while the report is generating. A status bar indicates the progress of the report generation. When it's complete, a Download link appears in the status bar. Click the link to download the report.

Apply a DS bid strategy and specify adaptive settings using a bulksheet

In the downloaded bulksheet, edit the applicable columns to apply a DS bid strategy, if one isn't already applied, and turn on adaptive settings. 

  1. To apply DS bid strategies to campaigns in a bulksheet, note the names of your DS bid strategies in the DS user interface:

    1. Navigate to an advertiser.

    2. In the left navigation panel of an advertiser, click Bid strategies.
      The names of bid strategies are displayed in the Bid strategy column.

  2. In the downloaded bulksheet, in a campaign row, enter the name of a DS bid strategy in the Advertiser bid strategy column.
  3. Turn on the adaptive settings:
    • In any of the following columns, enter on if the setting is relevant for the type of campaign.
      • Adaptive setting: Product groups (for shopping campaigns only)
      • Adaptive setting: Remarketing targets
      • Adaptive setting: Location targets (for manual and shopping campaigns)
  4. Optional:  In the Adaptive notifications column,  enter one or more email addresses, separated by a vertical bar ( | ). Specifying an email address turns on adaptive notifications. Each time DS changes a product group or location target, a message is sent to the email addresses.
  5. Upload the bulksheet.

     

Adaptive column settings

Column name  Description
Row Type Enter campaign. Specifies the type of item that you're creating or editing.
Action

Enter edit to edit a campaign's settings.

Enter create to create a new manual campaign and apply a DS bid strategy. 

You can't use a bulksheet to create shopping campaigns.
Campaign Enter the name of a campaign.
Campaign type

Specifies the campaign type. You can apply a DS bid strategy to all types of campaigns.

Use the column for information only, to ensure that you specify the relevant adaptive setting for the campaign type. For example, don't turn on the adaptive product group setting in a manual campaign. If you specify an incorrect setting, an error will occur when you upload the bulksheet.

Conversion goal name

This column should be blank for the campaigns that are managed by a bid strategy.

If the column displays the name of a conversion goal and you want to replace the conversion goal with a bid strategy, enter remove_content to remove the conversion goal.  

You are required to also remove any conversion-goal-related settings if specified. For example, if the conversion goal is being used to set location target or mobile bid adjustments, you should specify remove_content in those columns too.

The location target, mobile bid, and remarketing target bid adjustment settings for a DS bid strategy can only be set in the DS user interface.

Advertiser bid strategy

Specifies the name of a DS bid strategy that is applied to a campaign.

If this column contains the text, (manual), a DS bid strategy isn't setting keyword or product group bids in the campaign.

Engine bid strategy name (AdWords only)  The Engine bid strategy column should be blank or set to (manual).
Adaptive setting: Product groups

Specify on to turn on the adaptive product group setting in AdWords or Bing Ads shopping campaigns.

Specify off to turn off the adaptive product group setting.

This column should be blank for manual and mobile app install campaigns.

If you're using a bulksheet to remove a DS bid strategy from a campaign and this setting is on, you're also required to replace on with remove_content to remove this setting. If you don't turn off the adaptive setting when you remove a DS bid strategy,  an error will occur when you upload the bulksheet.

Adaptive setting: Location targets

Specify on to turn on the adaptive location target setting in AdWords campaigns.

Specify off to turn off the adaptive location target setting.

If you're using a bulksheet to remove a DS bid strategy from a campaign and this setting is on, you're also required to replace on with remove_content to remove this setting. If you don't turn off the adaptive setting when you remove the DS bid strategy, an error will occur when you upload the bulksheet.

Adaptive notifications

Enter the email addresses of people who will be notified when DS subdivides or removes location targets or product groups. Separate each email address with a vertical bar ( | ).

If the row is blank, notifications are turned off.

Mobile bid adjustment setting

Applicable only for conversion goals.

Location target bid adjustment setting

Applicable only for conversion goals. 

Remarketing target bid adjustment setting

Applicable only for conversion goals.

Was this article helpful?
How can we improve it?