Search
Clear search
Close search
Google apps
Main menu

Create a manual campaign

Tips for using the keyword editor

By default, the keyword editor contains the basic columns typically needed to create keywords (positive or negative). The editor contains a few data-entry features similar to standard spreadsheets:

  • Add optional columns
  • Copy/paste rows
  • Copy a cell to multiple rows
  • Copy/paste from and to an external spreadsheet, such as Excel or Google Sheets

Add and remove optional columns

If you want add more information while creating the keywords--for example, specify labels, URL template, or bid strategy--click + Columns just above the table and change the columns that are displayed. The list displays all optional columns that are valid for the editor in the current scope.
Click "Select columns" to add optional columns.

A check appears next to the name of each optional column that's already been added.

To remove an optional column, click + Columns and unselect the column.

Copy/paste rows

To copy a row:

  1. Click the row number.
  2. Type Ctrl+C (or whatever key combination your operating system uses to copy to the clipboard).

Click a row number to select the row. Then use standard copy/paste keyboard shortcuts.

To paste the row:

  1. Click a row number.
  2. Type Ctrl+V (or whatever key combination your operating system uses to paste from the clipboard).

Copy a cell to multiple rows

If you've entered a value in a cell that you want other rows to use:

  1. Click in the cell.
    A blue square appears in the lower right corner.
    Click in the lower right corner of a cell.
  2. Drag the blue square down the column.
    Drag the mouse down the column and release.
  3. When you release the mouse, the cell's content will copy into the selected cells.

Copy/paste rows from and to an external spreadsheet

Copy from the editor

To copy rows:

  1. Hold the Shift key and click one or more row numbers .
  2. Type Ctrl+C (or whatever key combination your operating system uses to copy to the clipboard).

Click a row number to select the row. Then use standard copy/paste keyboard shortcuts.

To paste the row:

  1. Open a spreadsheet in an external application, such as Microsoft Excel or Google Sheets.
  2. Click a row number.
  3. Type Ctrl+V (or whatever key combination your operating system uses to paste from the clipboard).

Copy from an external application

To copy a row:

  1. Open a spreadsheet in an external application, such as Microsoft Excel or Google Sheets.
  2. Make sure the columns in the application match the order of the columns in the DS keyword editor.
  3. Select the range of cells you want to copy.
    For example, if you're copying 10 keywords:
    1. Hold the Shift key
    2. Click cell A:2
    3. Then click cell D:11
      Note: Since the number of columns in the selected range needs to match the number of columns currently visible in the DS keyword editor, it's recommended that you select the specific range of cells instead of entire rows.
  4. Type Ctrl+C (or whatever key combination your operating system uses to copy to the clipboard).

     

To paste the row in DS:

  1. View the keyword editor in the search terms report.
    Make sure the columns in the editor match the order of the columns in the external application. DS does not validate the data you paste until you save the new keywords.
  2. Click a row number.
  3. Type Ctrl+V (or whatever key combination your operating system uses to paste from the clipboard).
Was this article helpful?
Subscribe to DoubleClick News

Stay up-to-date on the latest product news, case studies and communications from DoubleClick.