flexiblefullpage - default
interstitial1 - interstitial
Currently Reading

Pro's Pick: Track KPIs in Real-time with Data-Sharing Platform

billboard -
Products — Home Improvement

Pro's Pick: Track KPIs in Real-time with Data-Sharing Platform

This Pro’s Pick helps you run your home improvement business by the numbers

April 24, 2023
Contractors can use Airtable for data-sharing and real-time KPI tracking.

USA Insulation of Toledo Owner David PottsDavid Potts


USA Insulation of Toledo, Kalamazoo, and SE Michigan

Toledo, Ohio


Airtable allows us to really carve up our data to manage our business by the numbers. It’s a database that looks like an Excel spreadsheet. We’re using it in three primary areas.

The first way is to better track sales information and the performance of every single salesperson when it comes to the leads they’re assigned. I can quickly access their close rate and how long it takes them to close those sales on average. We can import our sales into Airtable each morning from our CRM and every salesperson has a unique link assigned to them where they can go to view how they’re performing.

The second use is to assess the cost of goods sold. Once our install teams complete a job they fill out a form in Airtable that looks just like a Google form. They enter information including hours of labor on the job, the materials they used, and the quantity of those materials. This allows me to see how my installation crews are performing against each other in terms of the average cost of goods sold.

The third way we’re using Airtable is to identify our profitability by product and by the installation crew. Being able to see this data means we can make adjustments to our pricing models quickly to ensure that we’re not losing money on jobs. And we can identify which crews are performing the best and why. The why is critical and where Airtable really helps us.

We are able to use this data to not only help us run our business more efficiently and profitably but also to help guide our employee performance reviews by letting people know exactly how they’re doing–by the numbers.

Add new comment

Plain text

  • No HTML tags allowed.
  • Web page addresses and email addresses turn into links automatically.
  • Lines and paragraphs break automatically.
leaderboard2 - default

Related Stories

Homeowner Trends When Selecting Manufactured Stone

On this episode of Rock Stars of Remodeling, ProVia Product Manager of Stone & Roofing Chance Shalosky joins host Drew Barto to reveal design and color trends that contractors should consider when selling manufactured stone in 2024

Pro's Pick: Route Planning App for Sales and Project Managers

Outback Deck saves time and cuts down on fuel costs with this app that plans the most efficient routes for its field supervisors

Pro’s Picks: A Plumbing Tool That Cuts Install Time

This Pro’s Pick helps ensure that a one-day bath business completes its jobs in, well, one day

Shingle Color of the Year 2024 Announced by Owens Corning

The roofing manufacturer says the color evokes timelessness

Top Siding and Window Colors for 2024

A recent survey identifies the top siding and window color choices for American homeowners

Top Traits Contractors Should Demand from Product Partners

On this episode of Rock Stars of Remodeling, ProVia Director of Sales, Northeast, Randy Albaugh joins host Drew Barto to discuss what contractors should be looking for in product partners or manufacturers


Contractors Embrace Province™ Slate

From California to Minnesota to Florida, contractors are embracing Province™ Slate. Launched a year ago by DaVinci® Roofscapes, the composite single-…

4 Colorful Takeaways from Roofing Contractors

Why residential roofing contractors are more mindful of color when it comes to shingle selection


Why Homeowners and Pros Prefer Stone Veneer to Stone

With the depth of selection in Westlake Royal Building Products, builders and homeowners have an almost-endless range of design possibilities to explore. Ben Drury, Product Development Manager for their exterior product brands, explains why Versetta Stone is so effective in so many different applications. 

Lowe’s to Open Next-Day Delivery Fulfillment Center for Pros

Lowe's makes its next move into the pro market.

boombox2 -
halfpage2 -
native1 -

More in Category

native2 -
halfpage1 -
leaderboard1 -