Plan, execute, measure and optimize customer experiences

Flagging data in SAS Marketing Automation tool

Reply
New User
Posts: 1

Flagging data in SAS Marketing Automation tool

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?

 

 

SAS Employee
Posts: 70

Re: Flagging data in SAS Marketing Automation tool

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.

Ask a Question
Discussion stats
  • 1 reply
  • 429 views
  • 0 likes
  • 2 in conversation