I would like to ask you about PII elimination.
I am currently trying to create Analytics and Job to erase PII but without success.
When I look at Analytics History, Action is still Open, so I suspect that setting Default_Action_For_Analytics is not working.
By the way, PIIERASURESTATUS does not seem to be in a condition that can be set, so I removed it from the condition.
Here is the SQL query in Analytics:. (The user I want to erase appears in Preview.)
SELECT userKey, PIIERASURESTATUS, 'personallyIdentifiableInformationErasure' as Default_Action_For_Analytics FROM users WHERE (ENDDATE < NOW() - INTERVAL 180 DAY OR TERMDATE < NOW() - INTERVAL 180 DAY) AND STATUSKEY != 1
What is wrong with my procedure to perform PII cleanup?
Solved! Go to Solution.