How to Read Your
Shovel Radar Intelligence File
Start closing deals in 5 minutes.
Your file is pre-sorted. The money is at the top.
Every week, your Excel file arrives sorted by project value — highest dollar commercial permits first. You do not need to filter or sort anything. Open the file, look at the top rows, and start calling.
The Heat Map — Value Tier
Column: Value_Tier
This column colour-codes every lead by estimated project value. It tells you, at a glance, where the biggest contracts are sitting.
Red — Tier 1
Highest value. These are the jobs that pay for your whole quarter. Call these first, every single week.
Orange — Tier 2
High value. Strong second priority. Most weeks, Tier 2 alone is enough to fill your pipeline.
Yellow — Tier 3
Mid-range. Worth a call if Tiers 1 and 2 are exhausted, or if the location is ideal for you.
Rule of thumb: If your week is busy, only work Red rows. If you have time, move to Orange. Yellow is volume play.
Optimal Call Date
Column: Optimal_Call_Date
This is the exact week you should reach out — calculated from the permit issue date, permit type, and typical construction phase timelines for Calgary commercial builds.
-
Why it matters: Call too early and the GC hasn't mobilized yet. Call too late and they've already awarded the work. This column puts you in the window.
-
What to do: Each Monday morning, filter for rows where
Optimal_Call_Datefalls within the current week. Those are your calls for the week. -
Leads in the future: If the call date is 2–4 weeks out, add it to your CRM as a scheduled follow-up. Do not call early.
One-Click Scouting
Column: Address
Every address in your file is a live hyperlink. Click it and Google Maps satellite view opens instantly, pointed at the exact job site.
-
What to look for: Is there equipment on site yet? Is the lot cleared? Are there other trades already working? This tells you how far along the project is before you dial a single number.
-
Drive-by intel: If the site is in your quadrant, a 10-minute drive-by before a cold call turns it into a warm call. "I drove past your site on Macleod Trail this morning..." opens doors.
Tip: Hold Ctrl and click to open in a new browser tab without leaving Excel.
The Urgency Signal
Column: Outreach_Angle or Pitch_Angle
This is the most valuable column in the file. Our AI has read the permit details and written you a custom, one-paragraph cold call angle for each lead.
-
What it gives you: The specific reason this project needs your trade right now, written in plain English. Not a generic pitch — a project-specific angle tied to the permit description.
-
How to use it: Read it before you dial. Use it as your opening line. You are not reading from a script — you are using it to sound like you already know the project.
-
Example: "New commercial interior build on 17th Ave SW — electrical rough-in window opens in approximately 3 weeks based on permit issue date. Decision-maker is likely comparing quotes now."
GC Name
Column: Contractor_Name or GC_Name
If you are a subcontractor, this column is the holy grail. It tells you exactly which General Contractor pulled the permit and is running the site.
-
For subs: This is who you call. Not the building owner, not the property manager — the GC. They control sub trade hiring. Google the company name, find their project manager or estimator, and call that person directly.
-
For GCs: Use this column to identify which other GCs are active in your target quadrant. Knowing who your competitors are bidding against is its own form of intelligence.
-
Blank cells: Some permits list an owner-builder or developer rather than a GC. If this cell is blank, the Urgency Signal column will note it — look at the owner name instead.
The Gatekeeper Scripts Tab
Tab at the bottom of your Excel workbook: Gatekeeper Scripts
At the bottom of your Excel file, there is a separate tab called Gatekeeper Scripts. This is not lead data — this is a cheat sheet for getting past the front desk.
-
What's inside: Word-for-word scripts for the most common cold call scenarios — reaching the site super, getting to the estimator, leaving a voicemail that gets called back, and handling "we already have a supplier."
-
Print it out. Tape it beside your monitor. Every person on your team who makes calls should have a copy.
Don't skip this tab. The data gets you the number. The script gets you the meeting. Both matter.
Your Monday Morning Routine — 15 Minutes
-
1
Open your file. It will be in your inbox, delivered Sunday night or Monday morning.
-
2
Filter for Red rows. Click the dropdown on the
Value_Tiercolumn and select "Tier 1 — High" (or sort by that column). -
3
Check the Optimal Call Date. Only work leads where the call date is this week or past due.
-
4
Read the Urgency Signal. For each lead, read your angle before you dial. Takes 20 seconds.
-
5
Dial. Use the Gatekeeper Scripts tab if you hit a receptionist. Log the result in your CRM.
Need Help Reading the Data?
Reply directly to your delivery email or reach out anytime.
matthew@shovelradar.com