Map your contractor service area from completed jobs

Start with your own completed-job records. A service-area map can show where crews worked, what those jobs billed and what they cost. Use the worksheet to plan the next routing or marketing question, not as a benchmark for every contractor.

Decide what the map needs to answer

Choose one decision before exporting records: which routes need a closer look, where to test a local offer, or whether a long drive is supported by the work. A map of work locations does not define every place you serve. A high-revenue ZIP is not necessarily a high-profit ZIP.

Export a consistent job cohort

Select a recent period that reflects the work you want to plan for, such as your last completed season or a calendar quarter. Write its first and last dates on the sheet. Export a stable job ID, completion date, work-location ZIP code, invoiced amount, amount collected if tracked, direct job costs, callbacks and travel time when available. An open estimate or a cancelled request is not a completed job.

If you use the most recent 50 jobs as a first pass, label it an example cohort, not a required sample size. If those jobs cross seasonal periods, report the dates and split unlike work before comparing areas. Count missing ZIP codes and duplicate records before making a map. Do not silently remove a job merely because its address needs correction.

Build the worksheet before the map

Keep one row per eligible job and retain the original job ID so you can remove duplicates. Use the ZIP for the work location, not the office address or customer billing address. Keep customer names and full street addresses out of any shared analysis sheet unless the task requires them and you have permission to use them.

  • Job ID and completed date: define which jobs entered the analysis.
  • Work ZIP and service type: separate locations and unlike jobs.
  • Invoiced dollars: count billed work, not cash received.
  • Collected dollars: use reliable records only; mark missing collection coverage as unknown, not zero.
  • Direct job cost, travel and callbacks: record what you actually have, leaving unavailable fields blank.

For a spreadsheet pivot, put work ZIP in Rows and job ID in Values as a count. Add invoiced dollars as a sum for jobs with billed amounts. Keep collection totals separate: count jobs with reliable collection records and show collection coverage for that ZIP; if coverage cannot be established, mark it unknown rather than zero. Add direct costs only for completed jobs with both an invoiced amount and a complete direct-cost record. Check a few totals against the original export before trusting the pivot. An average billed amount is total invoiced dollars divided by jobs with an invoiced amount, not by all records when some amounts are missing.

Read each ZIP with its denominator

For each ZIP, display the eligible completed-job count and billed total with the count of jobs that have an invoiced amount. Show a collected total only for jobs with reliable collection records, alongside that count and its share of eligible jobs. If you cannot establish collection coverage, mark it unknown; missing collections are not zero collections. Show the number of jobs with both billed amounts and complete direct-cost records separately. You can divide a ZIP total by its comparable job count, but one large installation can dominate a small group. Show the date window and trade alongside every comparison. Revenue share is that ZIP’s invoiced amount divided by invoiced dollars from all eligible jobs with billed amounts in the same cohort.

For the subset of completed jobs with both an invoiced amount and a complete direct-cost record, billed dollars minus direct job costs gives gross profit in dollars before shared overhead. A gross margin percentage is that gross profit divided by billed dollars for the same cost-complete subset, when that denominator is above zero. Do not project this result onto jobs with missing costs. Include assigned travel and warranty callback costs once under your existing direct-cost method. Review unassigned amounts separately; do not subtract assigned costs again. Without complete paired records, label the ZIP review revenue-only rather than treating missing cost as zero. Billed profit is not collected cash.

Plot locations only if you need them

A ZIP-level table may be enough to choose the next question. If street-level routing matters, use an approved account and check access before uploading customer data. Google My Maps import guidance supports CSV, XLSX and Google Sheets with an address or coordinate column. On a computer, create a map, add a layer and import the file. It has a 2,000-row import limit. Check unmatched locations rather than treating plotted pins as a complete roster.[1]

Keep a map with customer addresses private. Google explains that a map can be shared by link or made public; verify the sharing setting before and after importing records.[2] If the decision only needs a geographic summary, map ZIP-level aggregates without customer names or addresses. A ZIP marker represents an area summary, not each customer property.

To color the map, My Maps allows styling by a data column.[3] Choose a field with a clear unit, such as total invoiced dollars for the selected period, and label the legend. Color is a visual aid; it does not establish profitability. Do not import a random ZIP boundary file without checking its source and geography.

Turn the worksheet into a bounded decision

Inspect ZIPs with meaningful job counts and comparable work. Compare travel, job costs, callbacks and the capacity of the crew that serves each place. A thin record may warrant more observation rather than an ad-budget change. If one project accounts for most of a ZIP’s billed dollars, show that concentration rather than treating it as routine demand.

Before shifting spend, compare your own inquiries, estimates, completed jobs and collected cash by the same ZIP and period. Advertising location settings describe where you target, not where jobs were completed. Keep current customer commitments and dispatch coverage intact while you test a change. Review results at a cadence that fits job volume and seasonal demand; quarterly is a planning option, not a guaranteed optimum.

A practical first review

  • Record the date window, eligible job count and excluded or incomplete records.
  • Check the pivot against the export and flag small ZIP groups.
  • Show collection coverage; compare billed dollars and direct costs only on completed jobs with complete paired records.
  • Choose one routing or marketing question to investigate; keep a dated copy before changing the next period.

If the records are incomplete, begin by fixing the fields used at job closeout. A polished map cannot replace missing cost or collection records. Keep the first version small enough that the dispatcher and office can explain what every number counts.

Questions contractors ask

How do I map completed jobs by ZIP code?

Export a defined set of completed jobs with a stable job ID, completion date, work-location ZIP code and invoiced amount. Add collected amounts and direct costs only where records are reliable. Group jobs by ZIP and show coverage for each optional field. Calculate gross profit only for completed jobs with both billed amounts and complete direct-cost records. Keep the period and exclusions on the sheet.

How many jobs should I include?

There is no universal minimum. Use a recent, defined period and report the number of eligible jobs and excluded records. Sparse ZIP groups can change sharply after one job, so do not use them alone to cut service or advertising.

Does the highest-revenue ZIP earn the most profit?

Not necessarily. Billed revenue is not cash collected or profit. For gross profit, subtract complete direct costs from billed amounts only for completed jobs with both records. Include assigned travel and callback costs once under your existing direct-cost method; review unassigned travel and callbacks separately. If you report a gross margin percentage, divide by billed dollars for those same jobs, provided that total is above zero. Gross profit is before shared overhead, and billed profit is not cash collected.

Can I put customer addresses in Google My Maps?

Google My Maps can import a spreadsheet containing addresses, but customer addresses are private business data. Get authorization before uploading them to an outside account. A ZIP-level summary or an approved private mapping tool may be safer for the decision you need to make.

How often should I review my service area?

Choose a review interval that matches your volume and seasonality. Save each period and the same inclusion rules so later comparisons mean the same thing. Revisit a decision when costs, staffing or travel patterns change.

Sources

Review your service-area evidence and lead path

KKS offers a free contractor audit for qualifying businesses: a website and competitor review with a 15-factor, 150-point scorecard, comparison with three local competitors, and a 90-day action plan. If we cannot find three defensible matches, we resolve the scope with you before accepting the audit. Qualified reports are delivered within two business days after KKS confirms the business, market and evidence scope. A large site or unclear identity can require a narrower scope or more time.

Request a free contractor audit

Get website and marketing help for your contracting business

KKS builds and manages contractor websites, handles local SEO, and researches your competitors to guide the work. Explore our managed website plans or start with a free audit comparing your business with three competitors.

View website and marketing plans Request my free competitor audit