For anyone involved in marketing. Whether analyzing data, cleaning up your contact list, or preparing materials for your next event, at all times there is at least one data document open on your computer. Today we focus on data management. Of all the operations that can be performed on this sprawling program, some are truly indispensable to our department: here are some of the options we use most often for cleaning data. Open a file Many platforms, including , , and , allow you to download an archive of data collected via or comma-separated values.
These text files can be easily opened in . Go Latest Mailing Database to the data section and click on the second icon from the left from text. In the window that opens, select the file to open and press the data button in the lower left corner. The Text Import Wizard window opens where you can choose the method for identifying fields, delimited by a specific symbol or fixed width. You can preview your transaction in the box below. Removing Duplicates When merging data lists, it may be necessary to manually import email contacts into your database, which may require an initial cleanup of duplicates.
In the operation is very basic: just go to the data window and select the remove duplicates icon. A dialog opens asking which columns to perform the operation on. Depending on your needs, you can compare the contents of a single column or multiple columns at once and get a list ready to be loaded into the database. And if you need to relate values of two tables, this function is for you. Just type the formula or to find a specific value in a row or column. Here's how it works: the value to find box; the range to find the value.