What it is
Every lead on the team carries the source that actually brought it in. Every source has its own page: what it brought in, which agents hold its leads, and what it closed.
What broke
Sources were guessed. Leads came in as "Other" or with no source at all, and paid ads got credit for people who never clicked an ad. Facebook adds the same tracking tag to ordinary links, including the link in your bio, so organic visitors looked like ad clicks.
When the source is wrong, every decision about where to spend is a guess.
How we run it now
- Credit takes proof. A Google click id is proof of a Google ad. A Meta ad needs the ad's own tags. A Facebook tag alone isn't proof of anything.
- The keyword is the one we paid for, not what the person typed.
- A lead with no source gets fixed, not filed under Other.
- One page per source, so you can see whether a source is bad or just wasn't worked.
You can't fix your ad spend until you can trust where a lead came from.
Copy this
Write your source rules down.
| Source | Counts when | Doesn't count when |
|---|---|---|
| Google Ads | The visit carries a Google click id | Someone searched you by name and clicked organic |
| Meta Ads | The visit carries the ad's own tags | Only the Facebook click tag is present |
| Website organic | Search or direct visit, no ad proof | |
| Sphere / referral | Agent knows them or was referred | It came through the website |
| Open house / sign call | Came in at the property |
Then audit last month: how many leads are blank or "Other"? That number is how much of your spend you're guessing on.
What the sheet can't do
A sheet can't read the click. The platform ties each lead to the ad or page that actually brought them, automatically. That's in the beta.