Modified Data Columns are supported on Campaign Automator only upon request. If you need a new modified data column or you need to edit the existing ones, please write to firstname.lastname@example.org with your request.
On this page:
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 using existing information from 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 versatile and can help you do very complex data processing because they use C# code. They allow you to add additional information without editing the existing columns in your feed.
Based on your request, our team will create the columns and they will be added to the Modified Data Columns tab in the Campaign Automator.
To set up the modified columns, 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".