Sometimes it's useful to manipulate data residing in our marketing database. We may want to do this when performing:
- Data Cleaning (e.g. remove invalid characters)
- Formatting (e.g.ormat phone number, change text to proper case, merge first and last name)
- Adding Score Values Together
And in other cases as well. Recently we stumbled on a useful overview of the options available to us, via this excellent LinkedIn post
by Fab Capodicasa, and we learned of a free webhook-based service
that allows the application of Excel formulas on Marketo data. Pretty neat!