One of AdWords Editor's lesser known features is the ability to copy directly out of the data grid and paste into your spreadsheet program of choice. This way, you can pull the contents of a particular tab of Editor and modify the data to your heart's content. You can then post your changes directly back into Editor using the 'Make Multiple Changes' dialog box. The data will also automatically be in the correct format so there's no need to delete or move columns around. The instructions below are for Windows machines. Happy spreadsheeting!
- Compile the information you need in a tab (you can use Advanced Search to help)
- Hit Ctrl+A to highlight all of the information in the tab
- Hit Ctrl+C to copy all of the highlighted data
- Open the spreadsheet application of your choice
- Hit Ctrl+V to paste the data into your spreadsheet
- Make your changes
- Copy and paste back into the 'Make Multiple Changes' dialog on the relevant tab
- Post your changes
- Go do something with all the time you saved (coffee, walk, call your Mom, etc.)
