I'm looking for some direction on how to handle a clay enrichment table that I have based on an import from a salesforce report of accounts.
The import runs daily and is set NOT to update existing rows because I don't want it burning credits when there aren't any real changes.
The salesforce report has a filter on it to exclude accounts that have had the enrichment fields completed unless a date stamp is older than x period of time
The clay table has a validation step in it to check to make sure that the company name and domain are aligned before proceeding with further enrichment & then I have a manual process for someone to review those mismatches and correct in salesforce
The clay table is set to autodedupe based on the 18digit SF account ID
Question:
What is the best way for me to get the corrected Accounts to be rerun through the enrichment process?
My assumption was that if I deleted the associated row in the clay table, the record would be imported again in the next import batch since it was still in the salesforce report, but the SFID was no longer in the table. However, that does not appear to be working. Other rows continue to be imported from the salesforce report, but not this Account that was previously in the table.
Are there also restrictions somewhere in the source that prevent "duplicates" from being imported? Any other thoughts?
