Export

After creating a template in Crealytics’ Search Platform, 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 Ads via the Google Ads Editor.

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

Step 1: Preview

In the template, access the “Preview” tab, and have a look at all generated content before exporting it. If you encounter a mistake, simply go back to the affected tab and make the necessary changes. When everything is in order, proceed with step 2.
Preview

Step 2: Export selection

To begin the export, either click “Go to export” in the tool bar, or the “Export” tab in the top navigation. Select the templates you want to export. Be sure that the template content is 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 deselect certain elements you don’t want to include in your export file. Click “Save this selection as default” if the same selection will be used in future exports.

Export sets

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

 Step 3: Export comparison

After the templates are generated, the comparison step allows you to see the differences compared to previous rounds of generation. If anything has changed or been added, the affected campaign(s) and ad group(s) will be highlighted in green. Crealytics’ Search Platform distinguishes the nature of these changes using 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 you to browse all the content again, in order to be completely sure that no mistakes have been made. Choose “Keep proposed changes” or “Reject proposed changes”.
Step 2 - Comparison

Step 4: Download file

After accepting the changes, the download is made available. You may choose between two options.

  • Select “Changes” to get a file containing the differences compared to the previous export. This file will only include the items that were changed. These kinds of exports 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 content removed from tables or templates. Furthermore, they may contain campaigns and ad groups set to “deleted”. However, they will not contain any “deleted” text ads.

Proceed by clicking “Download”. Your download will then start automatically.

Step 3 - Download

Step 5: Import the file to the Google Ads 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 “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 set ” 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, allowing you to change the column data format for all of them at once. Choose “Text” and proceed by clicking “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, always choose the full download. It contains all campaigns, ad groups, keywords, negative keywords etc.. After the full download has been imported to the Google Ads Editor and posted to Google Ads, it is no longer necessary to export every entity of the template(s). Thus, the “Changes” download is a faster option to export all changes being made in Crealytics’ Search Platform, whilst avoiding the download of an unnecessarily large file. This is because the “Changes” file contains only the data needed to ensure all changes are exported correctly and will be detected by the Google Ads Editor.
In case you encounter mistakes you made when creating content like text ads or keywords of previously downloaded output, you have two options.

Option 1: Crealytics’ Search Platform

The first option is to put the erroneous Crealytics’ Search Platform .CSV output file into the Ads Editor and clicking “Keep proposed changes”. Then correct the values in the Search Platform, perform the export process again, and choose the “Changes” option for your download. The new export file will include only the changed content. Load this new export file into the Ads Editor and again click “Keep proposed changes”. Now the Ads Editor contains the content as it should be. Proceed with uploading the content to Google Ads.

Option 2: Excel

Advanced users can instead open the erroneous .CSV file using Excel or any other appropriate software, and manually delete the incorrect content. After saving, it can be opened in Ads Editor and uploaded to Google Ads. The next step is to correct the associated content in Crealytics’ Search Platform and export again. This way you will have an export file containing only the corrected content, which you can also upload to Google via the Ads Editor.

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

In the window that pops up, you can choose between the changes or the full download.
Select file for download