Hi Team,
I've few doubts related with CRM data upload to Audience Manager using FTP Process. Please refer below table (.csv) for my CRM data assumption
Customer ID | A | B | C |
123 | | Yes | |
456 | Yes | Yes | No |
789 | Yes | No | Yes |
Question #1: Consider my Customer ID 123 has only one CRM attribute (B=Yes) and doesn't have other two attributes in system (A, C). What should be the best practice for my csv file data
Should I have an entry>> 123 "A"="", "B"="Yes", "C"="" OR it should be just >> 123 "B"="Yes"
Question #2: I've an existing record uploaded in last .sync file with Customer Id - 456 "A"="Yes", "B"="Yes", "C"="No". In my next .sync file I update the record to - 456 "A"="No", "B"="", "C"= NULL
After successful file upload what will be the value for B and C?
Question #3: I've an existing record with Customer Id - 789 "A"="Yes", "B"="No", "C"="Yes" and this customer left the organization so I want to delete this record form AAM system
Do I need to update the record in next sync file like - 789 "A"=NULL, "B"=NULL, "C"=NULL?
The value which needs to be set will be NULL not "NULL", Please confirm which one is correct and if it is case sensitive?
Thanks in advance!!