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.

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).

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.
   
2. Drag the blue square down the column.
   
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).

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 Search Ads 360 keyword editor.
3. Select the range of cells you want to copy. Limit the selection to 100 rows or less.
   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 Search Ads 360 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 Search Ads 360:

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. Search Ads 360 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).

If you want to copy and paste more than 100 rows, repeat these steps for each 100 rows.