Update weekly appointment counters per clinic for marketing
Update weekly appointment counters per clinic for marketing
New appointment rows arrive without counts, leaving regional marketing unsure of weekly volume. It updates a weekly clinic counter so campaign managers can see rollups same day.
Overview
Unaggregated appointment submissions make it hard for campaign managers to judge weekly demand. This flow bumps a per-clinic weekly counter on each new worksheet row so marketing ops sees rollups same day and can reallocate spend or outreach before week-end reporting.