Flagging data in SAS Marketing Automation tool

Andy3 — Thu, 23 Jun 2016 23:03:35 GMT

I am trying to flag my list in SAS MA using an external list of postal codes to tell me what area the record is in. How do I flag this customer using the external list?

Re: Flagging data in SAS Marketing Automation tool

shill — Fri, 24 Jun 2016 20:58:53 GMT

The only way to add new data (for use in other places, like split nodes, exports, etc.) is by adding it to the information map.

If you just need to get a list of "customers who are in area XYZ", you could write a simple stored process that reads in the external file into a dataset and uploads it to the database for temporary use, then creates a new list of outgoing customer ID's (&outTable) by joining the incoming list of customer IDs (&inTable) with the customer table and with the temporary table from above and a where clause like "where area=XYZ" and you'll have a list you can to continue building your campaign.

topic Flagging data in SAS Marketing Automation tool in SAS Customer Intelligence

Flagging data in SAS Marketing Automation tool

Re: Flagging data in SAS Marketing Automation tool