Derived Columns are supported on Campaign Automator only upon request. If you are interested in using them, please write to support@optmyzr.com to request access and to add/edit derived columns.

What are Derived Columns?

Derived columns are a way to pre-process data from your data feed that can then be used in the keyword and templates. They are created as new virtual columns based on your data feed. For example, if you want to use the 'Brand' column in the ad template but need to capitalize the first alphabet, you can add a derived column for that. 

How are they created and used?

Derived columns are very versatile and can do very complex data processing because they use C# code. You can add a Derived Column on the external source tab in the Campaign Automator. It creates a new column that can be used just like other columns in the feed. This does not edit the existing columns in your feed.

After clicking on 'Add Derived Column', you can give it a name and write the C# code in the box under the name. 

If you don't have access to a developer, you can ask our team to set them up for you as part of the setup process on the paid subscription plans for Campaign Automator. We've listed some common use cases for Derived Columns below that can be used with minor changes.

Copying Derived Columns

This option is available under the derived columns section in the Campaign Automator template. This will allow you to copy single or multiple derived columns across multiple accounts and with that eliminate the effort of having to create derived columns repeatedly for a single purpose.

You will have the option to choose from "Same Source Templates" which will use the same source file as the template you're copying the derived column from, as well as "All Templates", irrespective of the source.

Note: If no other templates are using the same source file this option won't be available.

The option to copy a derived column is available when you have at least one derived column in your template. The system won't allow the addition of duplicate derived columns. If that specific derived column already exists in the template (and everything is exactly similar for name and code), on copying it'll show 'No changes made', hence avoiding duplicates.

Examples of Derived Columns

  1. Remove special characters - This will remove special characters from the words.

  2. Truncate columns to have fewer words - This will remove extra words from a column field. For example, if the value in the product title column is "Black and White Shoes For Sale Today", the derived column will have the value "Black and White Shoes".

Did this answer your question?