Has anyone successfully imported MSA data? We'd like to use this data in segmentation in order to pull prospect lists based on an MSA region.
We were told we could import the data into the Geographic Areas (TR_GEO_AREA) table, and that there's a process that runs on the backend to tie the constituent's address to the MSA region.
What we've found it that the process has each key programmed line by line to update each address based on the zip code. So it appears to us we would have to update the table, then rewrite the whole process. Has anyone already done this and would be willing to walk us through how you did it? Or if you've found a more efficient way to write the process instead of programming line by line?