We have using Cordiant Marketing Director for years. There has been quiet a number of people come and go, leaving a lot of orphan user/campaign below, and it is quite difficult to navigate through the campaign list now.
Please advise on the procedure/steps and SQL how that I can keep the CMS Slim.
1) How to delete old campaign? The campaign data has been deleted, and it is only left with the metadata of the campaign. These campaign may not be useful to us now.
2) How to delete user? The users may have left us many years ago, but his records still exists in the CMS. If he/she created an object in CMS, can we change the owner to of a dummy user?
3) We have created some new CDV for testing/investigation recently, how can we delete them so that the CMS can be kept slim?
For reducing schema size “Purge Scripts” can be used. When purge scripts are used, based on the inputs specified old campaigns/objects will be purged (communication data and dynamic data will be deleted) and all Purged objects will be moved to PURGED folders. At this stage only the structure of the objects will be retained and can be deleted manually if not required. Or the campaigns can be deleted case by case manually by using “Right Click --> Delete” option.
In CMD, there are no straight forward option for deleting Users and CDV’s. Please keep in touch with support for more details on how to “changing the ownership of the objects” and “”Deleting CDV data”.