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.
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.
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.
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
- plus icon - added entities
- minus icon - deleted entities
- alert icon - conflicting entities
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 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
Step 3 – Choose delimiter and text qualifier
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”.
Step 5 – Choose the import location
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.