Partners Blog
What's new @ Google? Tips and tools for agencies
AdWords Editor tip: Copying into a spreadsheet
Wednesday, March 26, 2008
Posted by Bill Yancey, AdWords Agency Team
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.)
Labels
Account Manager
88
Account Planner
100
Ad Planner
21
AdWords Editor
23
Analytics
38
Case study
44
Coffee break with clients
5
Creative/Production
39
Display
42
DoubleClick
40
Google Display Network
47
Google Media Solutions Series
4
Holiday
16
Industry Resources
114
Local Marketing
9
Media Buyer
71
Media Planner
108
Mobile
42
Optimization
63
Quality Score
13
Search Specialist
133
Tools
94
Training
141
YouTube
51
Archive
March
( 2 )
December
( 4 )
November
( 1 )
October
( 3 )
September
( 2 )
August
( 2 )
July
( 4 )
June
( 4 )
May
( 3 )
March
( 2 )
February
( 1 )
January
( 2 )
December
( 1 )
October
( 1 )
August
( 1 )
July
( 1 )
June
( 3 )
May
( 3 )
April
( 2 )
March
( 2 )
February
( 3 )
December
( 1 )
November
( 2 )
October
( 2 )
September
( 1 )
July
( 1 )
June
( 4 )
May
( 1 )
April
( 1 )
February
( 1 )
December
( 2 )
November
( 4 )
September
( 1 )
August
( 2 )
July
( 3 )
June
( 5 )
May
( 6 )
April
( 5 )
March
( 7 )
February
( 5 )
January
( 1 )
December
( 8 )
November
( 4 )
October
( 8 )
September
( 3 )
August
( 8 )
July
( 6 )
June
( 5 )
May
( 8 )
April
( 8 )
March
( 7 )
February
( 4 )
January
( 2 )
December
( 5 )
November
( 3 )
October
( 4 )
September
( 3 )
August
( 5 )
July
( 2 )
June
( 6 )
May
( 11 )
April
( 3 )
March
( 8 )
February
( 4 )
January
( 6 )
December
( 6 )
November
( 5 )
October
( 9 )
September
( 10 )
August
( 8 )
July
( 4 )
June
( 10 )
May
( 6 )
April
( 9 )
March
( 7 )
February
( 4 )
January
( 3 )
December
( 4 )
November
( 9 )
October
( 6 )
September
( 3 )
August
( 7 )
July
( 6 )
June
( 17 )
May
( 9 )
April
( 11 )
March
( 17 )
February
( 12 )
January
( 8 )
December
( 8 )
November
( 12 )
October
( 16 )
September
( 18 )
August
( 16 )
July
( 10 )
June
( 10 )
May
( 7 )
April
( 9 )
March
( 10 )
February
( 11 )
January
( 5 )
December
( 11 )
November
( 11 )
October
( 19 )
September
( 14 )
August
( 14 )
July
( 18 )
June
( 15 )
May
( 13 )
April
( 12 )
March
( 11 )
February
( 7 )
January
( 8 )
December
( 8 )
November
( 5 )
October
( 8 )
September
( 8 )
August
( 8 )
July
( 9 )
June
( 12 )
May
( 10 )
April
( 9 )
March
( 5 )
Feed
