Fill Data into New Table

Watch the video to learn how to fill data into a new table within the Campaign Suite!

After setting up a new table, an empty row already awaits first entries. At this point it is essential to understand the meaning of every column and column set. The most important columns are described briefly. These column names have developed to be our best-practice from years of experience in the creation of text ads. However, apart from “name” and “status” the usage of these columns is optional.

“name” is the term allocated to the corresponding table entry. It will be used in the ad text.
“status” indicates whether this table entry is activated, paused or deleted. Within the Campaign Suite you can literally remove a row or set the status to removed. The latter will just exclude a row from the export, but make it available for later reactivation.
“alias” contains all keywords that should trigger this entry. These should also include shortcuts, variant spelling, or extensions.
“shortname” is the term that should be used in the corresponding ad alternatively to the “name” column if the “name” entry is too long for an ad in general.
“alternative” is the term that should be displayed if the user wants to show something different from the “name” column in the ad text.
“negatives” are keywords that enable advertisers to hinder ads from appearing when specific terms are a part of a user’s search query.
“url_parameter_cleartype” is the most commonly used column for the keyword final URL. Depending on the structure of the store’s website the advertiser would enter corresponding parameters.

Table Actions

To add a column into the table, two ways are possible. Click on the “+” button to the right of the column name row. Alternatively, click on “Settings” and choose “Columns/Settings”. Both ways will open the “Edit Settings” dialog box, but the first will automatically create a custom column. At the bottom of the dialog box is the option to add a column. One can also remove a column using delete buttons next to each existing column name.

Add a column

Edit the settings for tables

In order to delete one or more rows, mark the row by clicking in the id or name column of the according row and click the button “delete rows”. To mark more than one row, select multiple by clicking on each row in the id or name column. Using the shift key makes it easy to select a range of rows with just two clicks.
Delete one or multiple rows
When the column type “list” is selected (the column “alias” has this type selected per default), you can add multiple entries to one field. By pressing SHIFT + ENTER the cursor jumps to a new row. To finish editing the field press ENTER to jump to the field below. When exporting the table, applications like Excel will also have multiple lines for the entries of a list field. To jump to the next row within a cell in Excel press ALT + ENTER.
As soon as a table has reached a certain size, the hide function gets very helpful. There are two ways to hide a column. The easiest is to click on the column header and in the popup on “Hide column”. Alternatively, click on “Settings” and “Hide columns”.
Hide certain columns

It is also possible to import a text file into the table. This is helpful if the data already exists, which must end up in the Campaign Suite table. Click “Import Table”, upload a file, which either has the extension .csv or .txt and follow the instructions. Both can easily be created from an existing Excel file. Just use the option “Save as” and select “CSV” or “Text” as file type.

This feature works in the same manner as the feed import. Click “Import Feed” to import a feed. The article about Feeds explains it in far more detail. Learn more

Inside a table all data can also be deleted by clicking the “Empty table” button.
Delete all data
Note: Please note that the binding between name and id values will stay. If you want to get rid of that, please contact us.
In order to remove the whole table, go to “Settings” and then click “Remove table”. This will totally remove the table from the Campaign Suite, if you never exported anything before. However, if you already did an export, the Campaign Suite remembers the prefix of your table. If you create a new table with the same prefix, the old table will be reactivated. This has the consequence that the connection between IDs and name values will be remembered as before.

Imagine to enter “nike” as a brand into the name column. If this is the first entry it gets the ID 1. Now, if you add more rows, remove the first row and add a new row entering “nike” again, the new entry “nike” will have the ID 1 again. The Campaign Suite remembers the combination of names and IDs. This information is also present in reactivated tables.

To work more efficiently with tables, each column can be sorted in alphabetical and reverse alphabetical order. Simply click on the column header to activate the sorting of choice. The Campaign Suite will then save the sorting individually for each user.
If more than one column has set to be sorted, the order in which the sorting has been activated will determine, which sorting will be prioritised.
Sorting Tables
Example: In this example the ‘alternative’ column is sorted alphabetical and the ‘alias’ column is sorted reverse alphabetical. Thus the sorting of the ‘alias’ column only changes the order for entries having identical entries in the ‘alternative’ column.
By using filters, only relevant content will be displayed. Click into the search bar of a column, type a word or number, which should be filtered for, and press ENTER to apply the filter. A small yellow token in the search bar shows for which term the table is filtered. It will then only contain entries, which apply to the word or number in the token. Filters can also be set in multiple columns at once.
Table Filters
Example: It is also possible to filter for two or more words and numbers at once within one column. If a column entry matches either of the set filters, it will be displayed.

Special Filters can be used to filter the table for ‘empty’ entries within a column. which has more than a certain number of characters. Numerical columns (of type decimal/whole number) have the special filters “Greater than”, “Less than”, and “Between # and #”, while the non-numerical columns can be filtered for entries, which have more than a certain number of characters (“Greater than # chars”). Select all of these filters from the drop-down, which unfolds, when clicking on the search bar of a column.

Tables in the Campaign Suite offer a backup functionality. Before certain table actions a backup will be created to allow to restore the previous state of the table. These table actions are:

  • Structure changed (e.g. column added/removed, relations added/removed)
  • Dynamic rule (a dynamic rule has been applied)
  • Restore operation (only if there have been changes since the last backup)
  • Table import
  • Feed import
  • Empty table
  • Table deleted (will only be available if the table is being reactivated)

Additionally there will be an automatic backup of changes like adding a new row, changing entries etc. every 3 days (if changes were applied). The last possiblity is to do a manual backup.

Step 1: Create a backup or access previous backups

To do a manual backup of the table or access previous backups click on “Backup” in the far right of the tool bar. Click “Backup now” to make a “Manual backup”, which will appear in the list of backups shortly after.
Access the backup options

Step 2: Select a backup to restore

The Campaign Suite will make a backup of the table before every of the changes mentioned above. To restore the state before such changes, simply select the backup from the list
Select a backup to restore

Step 3: Choose to restore with or without relations

The only thing to do left, is to choose whether to restore the backup with or without the relations set previously. The information in the pop-up helps to decide if the relations are still required or not. Finalize the backup by choosing either option.
Restore with or without relations

Optional step: Undo the restoring

Tthe Campaign Suite also creates a backup before restoring one. If a backup has been restored by mistake or the restoration does not lead to the expected result, the state before the restore operation can be reached by selecting “Restore operation” from the drop-down.