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