Currently, it is impossible to prevent user to import incorrect (values that are not in a pick list, or values that will be blocked by CRM sync, or simply values that do not make sense, business-wise) values in Marketo. As result, users sometimes make big mistakes and create havoc in the database.
We recently had a use case where someone imported 25000 leads with nonsense values in the "salutation field". Then the data management smart campaigns triggered and removed this incorrect values, only to replace these by NULL. The result is that the initial values of these 25000 records were lost. We had to use a complex set of "data value changed" filters to rebuild them...
So this idea is that, in the field management section of the admin, together with the "List Import Alias", we should be able to set the "List Import acceptable values". An even better solution would be a comprehensive management of enum fields (see ), but if at least we could limit what is done on import, that would be a good start.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.