X

Google AdWords Editor: Importing and Exporting Data

Google AdWords Editor lets you export AdWords account data in several different formats – as a CSV file, as an AdWords Editor archive file, as an AdWords Editor sharing file, and as an HTML file. File exporting options are available via the File link on the main menu at the top of the interface, or by right-clicking on an account, campaign, or ad group name.

The “Export for Archiving” and “Export for Sharing” options do essentially the same thing. They both export AdWords Editor data in a format that can be re-opened in AdWords Editor. For example, if you wanted to move your account and data settings from one instance of AdWords Editor to another, you could export the account data with the Export for Archiving option, save the file (a .aea file) to your computer, then move the file to another computer. On the new computer, you would use the File/Import Account Snapshot links to import the data into AdWords Editor. Imported data can be in either the .aea or .aes file format. The .aes files are created by using the “Export for Sharing” option to export your data, rather than “Export for Archiving”.

The other two export options, “Export to CSV” and “Export to HTML” are for exporting the data to look at in other programs. The CSV option creates tab-delimited text files which can be opened up in spreadsheet software such as Microsoft Excel. This is useful for analytical types that like having all the data displayed for them in one big file.

The HTML option creates a nicely-formatted HTML option that can be viewed in a web browser. This option is useful for creating a file that can be easily viewed by anyone. If you have clients or other interested parties who want to see the keywords and ads that comprise an ad group or campaign, you can create an HTML file and give them exactly the information they need. Work Media has used this option on numerous occasions to get client approval for the keywords and ads we are using before launching a campaign.

What exactly you can export depends on what is selected in the left-hand side of the screen. For instance, if the account name is selected, from the File menu you have options to export the entire account or export the current view (if exporting to CSV). If a campaign is selected, you have options to export the entire account or the currently selected campaign. If an ad group is selected, you have options to export the account, current campaign, or the current ad group.

Using AdWords Editor’s file exporting options, you have a lot of freedom to export all or part of your AdWords account in several different formats – either for data movement purposes or account viewing purposes.

If you would like help managing your Google AdWords account, contact Work Media at 888-299-4837 or email Info@WorkMedia.net.

admin: