Operations

Data Health

What is missing, what is duplicated, and what the sheet would need to capture next.

Records checked
0
Field completeness
—
Duplicate groups
0

Missing fields

Every gap that blocks a metric somewhere in this app

Possible duplicates

Same phone number on more than one sheet row

No duplicates detected

Every phone number appears once.

Recommended additions to the Google Sheet

  • Time the enquiry arrived — unlocks real response-time reporting.
  • Salesperson handling each lead — unlocks per-person performance.
  • Lead status and next follow-up date — already written back by this app into columns K–N.
  • Budget spend per campaign row — unlocks cost per lead and per reservation.
  • Cost and booking outcome per influencer — unlocks influencer ROI.
  • Actual attendance per live night — unlocks artist ROI.