You can create new databases by merging two existing databases and queries. When merging databases, Acoustic Campaign preserves the original databases and creates a new database that contains the merged data.
Database merging is a two-task process: selecting a database and selecting the priority data and format.
Important: Only fields with the same name and data type can be combined, and other field data may not be included.
- Your original databases are not changed by the merge and remain in the table of databases.
- Database data is the content in the database. In step 2, you select one database to take precedence in case of duplicate entries. For example, the database that has the most recent data or content takes precedence so that old data does not overwrite new data.
- Database format refers to the fields you have in the database such as email address, phone number, and segmenting. Select the database that has the format (field names) that you want to use. The field names in the other database, and the information in those fields, will be lost.
- To avoid losing field names and data, return to the summary for the database that you want to have priority and create the field in that database. Important: Use the identical name spelling, including case, or the fields will not merge. Remember that you can't edit field names or field types after they are saved in a database.
- Select the databases that you want to merge in View Databases.
- Select the data and format to take priority in View Databases.
- Select the option for the database that contains the data you want to take priority in the merged database in the Which database's data do you want to take precedence? section.
- Click Continue to review the merge database job details and then click Submit. The new merged database display in the table of databases; the original databases are undisturbed.