Converts rankings (100-0) into decile (1-10).
CASS Certify a File
Allows a Customer Postal Address to be updated into a format from the USPS that is acceptable for barcoding and eligible for discounted postage.
Concatenates address fields (Street Number; Street Direct; Street Name; Street Suffix; Street Suffix Direct) into one Address Field. The output will be the a single field called “Address1”.
Returns the number of records in a file.
Identify and remove duplicated records in a file. Choose the fields to dedupe by (ie: address fields, customer ID) and output a new file with unique records.
A special format that certain DSPs use to upload the audiences into their platform. The format concatenates IP_BEGIN and IP_END with a space, dash, and space in between them and renames the column as just "IP".
Match Code Append
Create and a append a match code based on Person Level or Household Level fields.
NCOA Certify a File
Periodically check and update your CRM database, responders or customer postal file against the National Change of Address Service to see who has moved and update with the new address. Records submitted for NCOA go through the Semcasting Marketing Appliance for processing. NCOA records are current to the week of submission. CRM customer and prospect records should go through NCOA annually to maintain accuracy and deliverability.
Sample any size file by nth record. Looks at the overall sample size and selects, selects every nth record. Example: out of 100 records, every 10th is taken into the overall sample.
Used to add a phone number to a name/address
Postal File Formating
Used to output an 11 digit code to send to aquire names and addresses from a data provider.
Reverse Phone Append*
Used to add a name/address to a phone number.
Sample any size file randomly. In the “sample size” enter the number of records you want sampled. Note: Do not include (,) when specifying the number of records. (ie: enter 25000 and not 25,000.
Allows you to sort the file by different fields that are listed. Select the order of the fields in which you would like the file sorted by.
Splits 1 file into multiple files. In the ‘Number of Files’ tab, enter how many files you would like the original file to be split into. The file will export file into the number of files you have chosen in equal parts.
Suppress a file from another file. Upload the master file that you are keeping Upload the suppression file . Choose the fields that will be used to to suppress with. The suppression file does not need to have the same layout as the master file, but does need to contain the choosen suppression fields.
Create counts based on rank/percentile and decile. The file exports as a CSV file.
Create a file based on specific quantites per zipcode and deciles. Enter the number of records you would like per zip code and decile using this format: (zip,qty,low,high). Low and high represents the deciles. Use a comma (,) to separate each field. Two outputs will be provided - list of records in a TXT format and a summary report providing the number of countsrequested and received.