Modified Data Columns are supported on Campaign Automator only upon request. If you are interested in using them, please write to email@example.com to request access and to add/edit Modified Data columns.
What are Modified Data Columns?
Modified Data 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 modified data column for that.
How are they created and used?
Modified Data columns are very versatile and can do very complex data processing because they use C# code. You can add a Modified Data 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 Modified Data 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 Modified Data Columns below that can be used with minor changes.
Copying Modified Data Columns
This option is available under the modified data columns section in the Campaign Automator template. This will allow you to copy single or multiple modified data columns across multiple accounts and with that eliminate the effort of having to create modified data 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 modified data 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 modified data column is available when you have at least one modified data column in your template. The system won't allow the addition of duplicate modified data columns. If that specific modified data 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 Modified Data Columns
Remove special characters - This will remove special characters from the words.
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 modified data column will have the value "Black and White Shoes".