The dashboard marketing uses to see where pipeline came from. I took over a colleague's first version, audited it, and rewrote nearly all of it.
What it did
A 5-route linker ties every opportunity to a source person. Unlinked opps went from 49 of 105 to 1 of 104.
An attribution tab splits each opp's value evenly across its people's lead sources; it matched the analysis sheet on 1,847 rows across 154 opps with 0 differences.
Inbound SLA tracking and monthly pipeline cohorts against the 6-month average and plan.
Daily Salesforce sync through n8n that checks counts before writing; every merge to main passes self-checks before it deploys.