Rank and Rent Lead Tracker: Free Template and Commission Calculator

I’m Adi Attias. I’ve built three rank and rent sites: two pay and one never ranked. On the two that pay, every lead goes into this sheet the day it arrives, and the row stays open until the last commission payment is in. The tool above gives you that layout as a free download and works out the commission and due dates for any closed job.

What columns does a rank and rent lead tracker need?

Sixteen: eight that follow the lead and eight that follow the money. The download above has all of them in this order.

The due dates come from the commission clause in my rank and rent agreement template: 10% of the contract value, half within 7 days of the deposit and half within 7 days of the final payment. If your deal is different, change the days in the tool.

How do you use the tracker each week?

Thirty seconds per lead on the day it arrives, then one check-in a week and one look at the Overdue column a month.

Every lead, the same day

Add the row, do the real-lead check, forward it to the contractor and fill in column 7. Spam and out-of-area leads stay in the sheet marked as such, so your lead count stays honest.

Once a week, ask about open rows

Send one message listing the homeowners still at Contacted or Quoted: “Any update on Sarah M. (retaining wall) and the Hendersons (patio)?” A contractor can’t forget a lead you can name, which is why column 2 exists.

When a job closes, fill columns 9 to 13

The commission calculates itself. Put the deposit date into the tool above, copy the row and paste it in, then send the first invoice the day the contractor confirms the deposit.

At month end, filter by Overdue

Anything flagged gets a polite payment reminder. A late payment is often just a contractor who forgot, and a dated row makes the reminder easy to send.

How do you track phone calls from a rank and rent site?

Give the site a call tracking number that forwards to the contractor, then log each call as a row with “call” as the source. A form is easy to track because every submission lands in your inbox with a date and a name. A phone call goes straight to the contractor, so without a tracking number you only know about it if they tell you.

• Form-only site: no extra tool needed. The form email is the record.
• Site with a phone number: a call tracking service records every call to the number on the site, with the date, the caller’s number and the length of the call. CallRail’s cheapest plan, Lead Tracking, is $50 a month billed yearly, with 5 numbers and 250 minutes (checked October 2026).
• Count only real calls. Short calls, wrong numbers and sales calls are not leads. Agree in writing with the contractor what counts, for example a call from a homeowner asking about the service.

What should you track for each type of deal?

The lead columns stay the same, but the money columns change with how the contractor pays you. See the rank and rent pricing guide for how to choose a deal.

How do you prove a lead came from your site?

Keep the original form email or call record, and log it before you forward it. The row in your sheet, the dated forward to the contractor and the homeowner’s name are the paper trail. Two things make it stronger:

• A written agreement that says the contractor reports signed jobs from your leads within a set number of days.
• A contact form that emails you first. The rank and rent website template shows the form and thank-you pages to set up.

Spreadsheet, call tracking or rank and rent software?

Start with the spreadsheet. Add call tracking when the site shows a phone number, and paid software only when you run several sites.

Whatever you use, the job is the same: one record per lead, a status, and a dated payment for every closed job.

What does the Money Tracker in the kit add?

The same lead and payment layout, plus the messages that go with it. The Rank and Rent Starter Kit includes the Money Tracker (module 06) with both payment halves, due dates and overdue flags, the commission agreement, the invoice wording and the payment reminder messages. If you run more than one site, the Scale to 10 Sites System adds a portfolio tracker with monthly results, costs, renewals and a next step for every site. To find the contractor who will take the leads, see rank and rent without cold calling.