LUMIERE MARKETING ROI DASHBOARD

URL after upload:
https://gwadar-one.com/lumiere/dashboard/

What works now:
- Responsive dashboard
- Date/source/campaign/search filters
- GHL lead counts
- GHL -> Oryx patient matching
- Marketing source/campaign attribution from GHL
- Oryx Referred By displayed as a validation signal
- Procedure/treatment production attribution
- Patient-level attribution explorer
- Campaign/source performance

Intentionally NOT calculated yet:
- Scheduled appointments / show / cancel / no-show
- Treatment presented vs accepted (until semantics are verified)
- Actual collections / cash revenue / lifetime collections
- Google Ads / Meta marketing spend
- CPL / CAC / ROAS / ROI
- CallRail call/tracking-number attribution

These are shown as Pending rather than estimated so the dashboard does not present unsupported financial metrics as facts.

PHP: written for PHP 7.x compatibility.
MySQL: compatible with MySQL 5.7 query syntax.
