Sometimes even the most experienced users will make a mistake or change their mind on using various campaign attributes. Unfortunately, we as users make this decision after designing and developing our campaign attributes. When we finally make our decision to cut certain attributes we will attempt to remove, delete or retire that attribute. Sometimes, we will upgrade our campaign application and decide that some attributes are not needed any longer. Recently, I was working with a new customer and they changed their mind on a campaign attribute, but we had already created it in our environment. Of course, we wanted to remove it.
Except............there is one problem...................
Campaign does not have a process in the GUI to remove campaign attributes.
The question is how would an administrator or user remove a campaign attribute. There is a process to do so, but as you may have guessed it is not through the GUI. In order to remove unwanted campaign attributes the administrator would need to modify four system tables in the database.
If you would like to remove a campaign attribute you could execute the following steps:
1 - Back up the following tables--
2 - Identify the target campaign attribute's ATTRIBUTEID in the UA_ATTRIUTEDEF table
3 - Note the ATTRIBUTEID value
4 - Delete records from the UA_CAMPATTRIBUTE table with the ATTRIBUTEID found in the Step 2.
5 - Delete records from the UA_OFFERATTRIBUTE table with the ATTRIBUTEID found in the step 2.
6 - Delete records from the UA_ENUMATTRVALUES table with the ATTRIBUTEID found in the step 2.
7 - Delete records from the UA_ATTRIBUTEDEF table with the ATTRIBUTEID found in the step 2.
Log into Campaign and navigate to Campaign Settings>>Custom Attribute Definitions and the attributes should not be in the list of attributes. If you mistakenly delete the incorrect ATTRIBUTEID you can restore the backup table.
Please keep in mind before making any changes to a production environment it is always wise to test them in a stage or development environment first. When you are satisfied with the changes then incorporate the changes into your production environment.