Special URL Tables

Most websites rely on dynamic URLs. However, in certain cases it is easiest to implement some pages with static URLs. Special URL tables are needed if dynamic keyword final URLs are used in most cases, and static keyword final URLs are only used for some special websites.

Step 1: Set up the Special URL table

To create a Special URL table click on “New table” in the “Campaign Management” tab and select “SpecialURL” from the drop down. This is required to assign the table accordingly in a template.

A Special URL table must contain one column for the URL. Additionally, more columns need to be added in order to tell the Campaign Suite for which table combination to use the special URL.

Imagine having a “Brand” and a “Category” table, which are combined in a “Brand + Category” template. To make it simple, we want to implement one special URL for “adidas shoes”. The URL is “example.com/adidas_winter_shoe_sale”. In the “Brand” table, there are hundreds of entries. One of them is “adidas”. In the “Category” table there are also many entries. One of them is “shoes”. For the URL table this means, that it needs one column for the brand and one column for the category. The URL table should look like this:


Attention: The columns “brand” and “category” must be of type “list”, and they are only allowed to contain one single list entry. Alternatively, proceed with step 2 before creating and filling the columns.

Step 2: Relate the columns

The next step is to set up relations between the column “brand” in the URL table and the column “name” (or similar) in the “Brand” table. The same applies to the category.

relation modal 2

Make sure to use “include” as the default relation type.

Note: Please note that it is not necessary to activate these relations in the template. They will not appear under “Apply Relations” but they will be active nevertheless. Please never select a Special URL table in that same “Relations” dialogue under “Create items only if referenced in: “.

Step 3: Add special URL table to template

You may add a Special URL table while creating a new template (Button: “New template”) or after the template has already been created. The latter option is available under “Settings” > “Assign tables” in the template details page.

Static URL tables2

A click on the Special URL table will assign it to the template. The Special URL table will always be displayed in the upper right corner within “Assign Tables”. Proceed by clicking “Save Changes”. This makes the contents of the Special URL table available in the template.

Step 4: Keyword final URL

The last step is to set up a template variable that will create the keyword final URL. In the template click “Variables” in the menu bar. This leads you to a pop-up window, where you can create a new template variable for your keyword final URL. In the value field, create the keyword final URL with the table column from the Special URL table. In the fallback fields, proceed with the usual deep linking approach. This way, whenever a special URL exists, it will be used. However, if there is no special URL for the desired combination, the template variable will jump to its next fallback and construct the deep link in the usual way.

Static URL variable

After saving the template variable, go into the tab “Keywords” and put it into the field “Keyword final URL”. This may either be done by typing the name of the variable into the Keyword final URL field or by selecting “Template Variables” in the dropdown and dragging the column name from the colorful selector into the field.

Advanced Hints

In the example from the Step-by-Step Guide above, the URL table had one column for each of the assigned tables to the template (i.e. one column for “brand” and one for “category” where the template was a “Brand + Category” template). If we had however only created one column “brand” but no category column in the URL table, the result would have been that we use the same special URL for all “adidas” categories. This might make sense if “adidas” is only related to “shoes” in the brand or category table. But if the seller also has adidas footballs, this would lead to the mistake that the ad for adidas footballs leads to the landing page for adidas winter shoe sale.
Using one Special URL table for multiple templates can save a lot of time. Imagine that a Special URL table has already been set up for the template “Brand + Category”. There is also a template “Brand + Category + Color”, which should use special URLs. To assign special URLs to both “Adidas” + “Shoes” and “Adidas” + “Shoes” + “blue” a single row in the table is sufficient. Just add a column for each template (in this example two) and enter the according special URL. This should look similar to this:

Note: Make sure to use the correct URL column in the according template.