Backfill Email Data

Create placeholder email submission records for assessments completed before email tracking was implemented

Data Status
Total Assessments
146
Email Submissions
140
Missing Records
6

6 assessments without email data

These are assessments completed before email tracking was implemented. Running the backfill will create placeholder records marking these as "no email captured" so analytics accurately reflect the true submission rate.

What This Does
  • Creates EmailSubmission records for all assessments that don't have one
  • Marks these as "no email captured" (subscribed: false)
  • Allows analytics to accurately calculate email submission and subscription rates
  • Safe to run multiple times - only creates missing records