Feed custom columns can only be created for templates with associated or inherited feeds, and are therefore not applicable in the context of responsive search ad (RSA) templates with ad group parents. For more information, see Set up responsive search ad templates.
To configure custom columns for a feed, you must be scoped to the sub-manager account in which you want to use the template functionality. When creating custom columns, you can reference all feed custom columns associated with the sub-manager account.
Custom columns are entered as formulas. There are drop-down menus from which you can select and enter columns and functions. Columns and functions that are valid at the current cursor position in the formula can also be selected from a menu that’s displayed when you right-click. For other building blocks in the formula, follow syntax rules.
Create custom columns in feeds
To create a custom column in a feed:
- Sign in to your Search Ads 360 experience.
- Navigate to a sub-manager account.
- From the page menu, click on the Templates drop-down.
- Click Feeds.
- Click the name of the hyperlinked feed that you want to edit.
- Click the Columns icon
above the feed’s columns table.
- In Custom Columns, click +Custom column.
- The owner selected by default is the current sub-manager.
- Enter the custom column Name and an optional Description.
- Select the required Data format: Number, Percent, Money, Text, True/False, or Date.
- Click in the dialog’s text area.
- To construct the formula in text mode, click Text then:
- Enter the formula using the rules described in Syntax.
- Click the
drop-down to select pre-formatted columns and functions.
- For feed columns, there is a separate submenu.
- Configure functions as described in Use functions in custom columns.
- To construct the formula in Visual mode, click Visual then:
- Enter the formula using the rules described in Syntax.
- Click the
- For feed columns, there is a separate submenu.
- Configure functions as described in Use functions in custom columns.
- Resolve underlined issues and red advisory messages.
- Click Save.
- View the new custom column alongside other columns in the feed table.
above the feed’s columns table.Feed custom column example
In this example, the "Flights" feed table contains the following columns of product data supplied by a new Search Ads 360 customer, Example Airways.
Example Airways operates two brands. Albatross Flights sells transatlantic tickets between the US and European destinations, while Golden Eagle Flights markets route tickets within Europe.
The example feed table only contains information for one route for each brand to ease understanding.
| Feed column name | Column description | Column value example 1 | Column value example 2 |
|---|---|---|---|
| "product_id" | Flight origin airport international air transport association (IATA) code –destination airport IATA code | CDignoredLHR | SEA-CDG |
| "brand" | The brand name for the flight | Golden Eagle Flights | Albatross Flights |
| "availability" | Flight ticket availability | Available | Not available |
| "seats_left" | Number of unsold seats on the flight | 11 | 0 |
| "origin_iata" | Flight origin airport’s IATA code | CDG | SEA |
| "origin_name" | Flight departure location | Paris | Seattle |
| "origin_country" | Flight origin country’s name | France | USA |
| "destination _iata" |
Flight destination airport´s IATA code | LHR | CDG |
| "destination_name" | Flight destination´s name | London | Paris |
| "destination_country" | Flight destination country’s name | UK | France |
| "price_usd" | The flight price in US dollars | 400 | 900 |
Feed custom column concatenation example
- The text function
concatmerges the"origin_country","destination_country"and"destination_name"columns. - Dashes are included between each column. They're static text, so they’re enclosed in quotation marks, “-”.
The final formula looks like the following:
concat(f:"origin_name", "-", f:"destination_country", "-", f:"destination_name")
Possible output values from this formula using the current feed data include:
Paris-UK-London
Seattle-France-Paris
Example
- Follow Create custom columns in feeds to Step 7.
- Name the custom column "Route", and enter the Description as “Flight origin to destination country”.
- In "Data format", select Text.
- Click in the dialog’s text area.
- Click the
- Click
and from the "Text" sub-menu, select concat.
concat("text1", "text2") - Remove all of
"text1". - Replace text1 by clicking +Custom column and selecting
f:"origin_name"from "Feed columns".
concat(f:"origin_name", "text2") - Remove all of
“text2”. - Replace text2 by clicking +Custom column and selecting
f:"destination_country"from "Feed columns".
concat(f:"origin_name", f:"destination_country") - Insert a comma after
f:"destination_country". - After the comma, click +Custom column to enter
f:"destination_name".
concat(f:"origin_name", f:"destination_country", f:"destination_name") - To add dashes between the feed columns, after the comma that follows the first three functions, add “-” followed by a comma.
concat(f:"origin_name", "-", f:"destination_country","-", f:"destination_name") - Click Done.