Skip to main content
All CollectionsCampaign Automator
Modified Data Columns in Campaign Automator
Modified Data Columns in Campaign Automator

Here are examples of some Modified Data columns you can use in the Campaign Automator

Geetanjali Tyagi avatar
Written by Geetanjali Tyagi
Updated yesterday

On this page:


What are Modified Data Columns?

Modified Data columns allow you to pre-process data from your data feed, creating new virtual columns that can be used anywhere across the template. These columns are generated using existing feed data. For example, if you want to use the 'Brand' column in an ad template but need to capitalize the first letter, you can create a Modified Data Column for that.

Another use case is shortening product titles from your source feed to fit the ads' heading length limits, preventing errors. 

How are they created and used?

You can apply the following modifications to your column text directly within the tool:

  • Case Change: Convert text in the column to lower case, upper case, sentence case, or title case.

  • Remove Whitespace: Eliminate all whitespace from the column.

  • Find and Replace: Find and replace specific text within the column.

  • Trim: Remove whitespace or specified characters from the beginning or end of the text in the column.

  • Shorten Text: Limit the text in the column to a specified length.

For advanced changes not listed here, contact support@optmyzr.com. Our team can help create custom Modified Data Columns, which will be added to the Modified Data Columns tab in Campaign Automator.

Depending on the request's complexity, a one-time setup fee (in addition to your Campaign Automator subscription) may apply.

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.

Did this answer your question?