Validate incoming file rows and load valid records into a database table.
Import clean website activity for reporting.
Get fresh website activity in your analysis table, with an import tally and a report of rows that need fixing.
Use checked search figures and trace rows excluded from reports.
Your reporting table gets checked page and query figures, with import counts and rejection reasons ready to review.