Back to Home
Subscriber Onboarding
Subscriber Guide

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.

1

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.

2

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_Date falls 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.

3

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.

4

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."

5

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.

6

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. 1

    Open your file. It will be in your inbox, delivered Sunday night or Monday morning.

  2. 2

    Filter for Red rows. Click the dropdown on the Value_Tier column and select "Tier 1 — High" (or sort by that column).

  3. 3

    Check the Optimal Call Date. Only work leads where the call date is this week or past due.

  4. 4

    Read the Urgency Signal. For each lead, read your angle before you dial. Takes 20 seconds.

  5. 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