Validate incoming file rows and load valid records into a database table.
Check incoming activity files and report rejected rows.
Get fresh website activity in your analysis table, with an import tally and a report of rows that need fixing.
Keep duplicate identifiers out of the tracking table.
Keep your tracking table focused on valid form responses, with an email explaining what was added or what needs fixing.