Export

After creating a template with the Campaign Suite, the next step is to check it for mistakes. If there are none, export it. The export will create a file that can be imported into Google AdWords via the Google AdWords Editor.

Hint: It’s not possible to export templates, which “require review”. Those contain setup mistakes you will have to fix.

Step 1: Preview

In the template, go into the “Preview” tab and have a look at all generated content before exporting it. If you encounter a mistake, simply go back to the corresponding tab and apply changes. When everything is fine, proceed with step 2.
Preview

Step 2: Export selection

To begin the export, either click on “Go to export” in the tool bar or the “Export” tab in the top navigation. At first, select the templates, you want to export. Be sure that their contents are as you want it to be.
Step 1 - Select templates for export
Hint: If a template requires review a message will appear behind the entry when making the selection of templates for the export.

In the upper right corner of the page, the link “Export sets” enables you to de-select certain elements, you don’t want to have in your export file. Click “Save this selection as default” if the same selection shall be used in future exports.
Export sets

Finally, click the “Next” button in order to generate the selected templates.

 Step 3: Export comparison

After the templates were generated, the comparison step allows you to see the differences compared to last generations. If anything changed or has been added, the according campaign and ad group will be highlighted in green. The CS distinguishes among these changes using different icons:

  • pen icon Changed entities - changed entities
  • plus icon Added entities - added entities
  • minus icon Removed entities - deleted entities
  • alert icon Conflicting entities - conflicting entities

Furthermore, this step enables to browse all the contents again in order to be very sure that there are no mistakes. Choose to “Keep proposed changes” or “Reject proposed changes”.
Step 2 - Comparison

Step 4: Download file

After accepting the changes, the download is offered. You can choose among two options here. Either select “Changes” to get a file containing the differences compared to the last export. This file will only include the items that were really changed. These kind of export will generate only a subset of the complete templates, making the Editor upload procedure more efficient.

In some cases users will need to download the generated content of a whole template. This can be done by selecting the “Full Download” option. Please be aware that in comparison to the “Changes” files, these full export files don’t contain contents that were removed from tables or templates. Furthermore, they can contain campaigns and ad groups set to “deleted”, whereas they will not contain any “deleted” text ads.

Proceed by clicking the “Download” button. The download will then start automatically.

Step 3 - Download

Step 5: Import the file to the AdWords editor

After completing the previous steps, we can now upload the export file into the editor.

Step 1 – Start the wizard

Make sure that the exported file has been unpacked. Open an empty spreadsheet in Excel and go to the tab/menu “Data”. Select “Get External Data” > “From Text” and a small window will open. Here navigate to the folder where your CSV file is saved, select it and proceed by clicking “Open”. This opens the “Text Import Wizard”.

Step 2 – Set the original data type

In the first step of the wizard make sure that “Delimited” is set as “Original data type”, “Start import at row:” is set to 1 and then proceed by clicking “Next”.
Text import wizard - Step 1

Step 3 – Choose delimiter and text qualifier

Next up is the selection of the delimiter(s) and the text qualifier. Set the delimiter to “Tab” and choose ” as text qualifier. Proceed by clicking “Next”.
Text import wizard - Step 2

Step 4 – Change the column data type

In step 3 select the first column, then scroll all the way to the right, and select the last column while pressing SHIFT. This selects all columns and allows to change the column data format for all of them at once. Choose “Text” and proceed by clicking on “Finish”.
Text import wizard - Step 3

Step 5 – Choose the import location

The last step is to choose whether the imported file should be opened in the current worksheet or in a new one. Select your preferred choice and complete the wizard. The file will now be imported.
Text import wizard - Step 4

Advanced Hints

After generating and comparing the export, two download options are provided. The “Changes” and “Full” download are used for different purposes. When exporting a template for the first time from the Campaign Suite, always choose the full download. It contains all campaigns, ad groups, keywords, negative keywords etc. After the full download has been imported to the AdWords Editor and posted to AdWords, it is no longer necessary to export the every entity of the template(s). Thus the changes download is a faster option to export all changes being made in the Campaign Suite, but avoid to download a unnecessarily huge file. This is because the changes file only contains data, which is needed to make sure that all changes are exported correctly and will be detected by the AdWords Editor.
In case you encounter mistakes you made when creating contents like text ads or keywords of already downloaded Campaign Suite output, you have two options.

Option 1: Campaign Suite

The first option is to put the mistaken Campaign Suite CSV output file into AdWords Editor and click “Keep proposed changes”. Then correct the values in the Campaign Suite, perform the export process again, and choose the “Changes” option as download. The new export file will only contain the changed content. Load this new export file into the AdWords Editor and again click “Keep proposed changes”. Now, the AdWords Editor contains the content as it should be. Therefore, upload the contents to Google AdWords.

Option 2: Excel

Advanced users can instead open the mistaken CSV file using Excel or any other software and manually delete the false contents. After saving it, it can be opened in AdWords Editor and uploaded to Google AdWords. The next step is to correct the associated contents in the Campaign Suite and export again. This way you will have an export file containing only the corrected contents, which you can also upload to Google via the AdWords Editor. 

An exported file can be downloaded again without having to go through the whole export process again. Make sure that no changes have been made, which were not yet included in the previous generation. To download such file go to “Export” and click on “Recent downloads” in the lower left corner.
Recent downloads

In the window that pops up it is possible to choose between the changes or the full download.
Select file for download