Case Study - ABCO Pools
I met Nick and Andrew from ABCO Pools when they came out to replace the pool liner at a house we were renting. Nick had successfully run the family business for more than 30 years, and now it was time for Andrew, his son, to take the helm. Andrew was excited about the opportunity, but he also knew there were challenges ahead and was looking for help modernizing the business.
The Problem
Andrew knew the business needed updates from a technology standpoint. They were still using handwritten contracts, and they didn’t have a company website.
What Wasn’t Working
The biggest time drain was the contract process. They were spending so much time handwriting contracts that they couldn’t get to all of their sales calls. On top of that, they had hundreds of old contracts that needed to be kept for reference when clients needed repairs, liner replacements, or other future work.
How I Helped
The first thing I looked at was how they could better store and access their contracts and customer information. There are several Customer Relationship Management (CRM) tools available, but I wanted to use something that wouldn’t lock them into storing everything inside one platform. I wanted a solution that could grow with them and keep them flexible long term.
At the time, I narrowed it down to Zoho and Copper. I ultimately chose Copper because it gave Andrew a single place to manage his customers while integrating directly with his Gmail and Google Workspace tools. Copper automatically tracks client communication through Gmail, so Andrew could email clients normally without having to re-enter notes or manually update records. Every email conversation would automatically be connected to the client inside Copper, making future follow-up much easier.
Another big advantage was the ability to store contracts directly in Google Drive while linking those files inside Copper. This solved the issue of long-term file storage while still making everything easy to access from within the customer record.
I also built a new website for them that helped showcase their experience, installation work, and available pool liner patterns. They already had strong Yelp reviews, so we highlighted those throughout the site to help build trust and credibility with new customers.
The Results
Using Google Drive and Copper, I loaded all of their client information and contracts into the new system so they could begin using it during customer visits. I even scanned and uploaded their older contracts, which meant everything was finally stored in one place and accessible from anywhere.
Andrew’s productivity improved significantly because he spent less time searching for information and more time focusing on customers and sales.
Their new website also launched successfully and has continued generating traffic. We’re currently making additional updates focused on improving visibility in AI-powered search results.
Lessons Learned
A CRM system can dramatically improve customer organization and follow-up.
Copper is a cost-effective CRM solution, especially for businesses already using Gmail and Google Workspace.
Your website should support your sales process — it’s more than just an online brochure.
Keeping contracts and customer records digitally organized saves time and improves customer service.
The Challenge
Find a CRM tool to manage all of their customer data
Move over 2000 customer records into a new system
Move over 4000 customer contracts and design files into something that would be system agnostic
Minimize data entry
Research Details
I spent some time looking into several solutions and technologies to see what would work for their situation. My review included the following tools:
The major hurdle was how to link the customer data with the contracts and design. Most CRMs will manage customer data very well, but once you look into how they can store contracts and images, it becomes a larger issue. Most of them will let you write a contract in their system, however that assumes you have no historic data.
I spent time with Microsoft Dynamics, trying to program their input forms to suit ABCO Pools needs, but Microsoft Dynamics does not allow the attachments of files when creating a new customer record. I’m not a programming expert in Dynamics, and perhaps there are folks out there that have figured this out, but my research into the tool said uploading files was a no-go. It seemed it was an issue with security vs technology. I also still wanted to create a solution that Andrew could manage himself, and not be MS Certified.
Google Sheets would work for capturing customer data, but it wouldn’t be a CRM solution, so I kept looking for the right fit for this particular client.
Salesforce was off the list quickly because of the monthly cost.
I had used Copper with a former client and found it easier to navigate. One key benefit to Copper is that it integrates with Google very well. I realized if we stored the Contracts and Designs in Google Drive, and then link them from Copper, if would give us a great solution for this client.
Solution Details
The solution would include the use of Google Drive, Copper, Zapier and Excel.
With all the tools identified, it was time to figure out how to bring everything together. The first step was to migrate the customer data into Copper and Google Drive.
We started with a full export of all the data out of a couple of their current data systems. We managed to get all the customer data into Google Sheets and the Contracts and Designs into PDFs, alphabetically by last name. Not a great way to start but at least we had all the data.
In the pool business, while the customers are always important, the real customer is the ADDRESS – it’s better to link the contracts and repairs to the home, not the people. The people may leave…but the pool doesn’t go with them.
Copper has two main categories to store customer data, Companies and People. We decided it would be best to use “Home” for Company and “People” for People. That way all the contracts and designs are linked to the home, and the people could come and go.
Using Google Drive to host all of the contracts would give us the longevity we were looking for. With a folder for each Home we would just need to move the Contracts/Designs files into the appropriate folder. The one obstacle was we couldn’t create more than one folder at a time within Google. Bummer… Enter, Zapier.
Zapier is a tool that will let you automate a lot of tasks, and help get this work done quickly. Plus, Zapier can create Multiple Google Folders on the fly. I created a Zap that would automatically create a Home in Copper and also a folder in Google Drive.
Next up, customer data. We needed to Import the customers (People) into Copper after the Homes were there, this way Copper would link the customer to the home during the import process, the common denominator was the address. For this, I used the traditional Import process in Copper, and since I had the customer data in Excel, I was able to format the data to match the Copper import template.
At this point, we have all the Home and Customer data in Copper, and we have folders for each Home in Google. Now comes the manual part, the only way we could get all of the Contracts and Designs into the Home folders was to drag/drop the files. This will just be one of those things that will take time but the results will be worth it. Once the files are there we can go into the Home in Copper and select the Files section, from there we can link the files directly from Google Drive.
Conclusion
As you can tell, it wasn’t an easy task but the outcome was exactly what we were looking for. ABCO Pools is happy all that their customer data is Copper and easily accessed from a Desktop, Tablet or Phone, including the Contracts and Designs. In the end we loaded over 2000 customers into Copper, which means they can now start looking at Marketing to all of them.
Next up for ABCO Pools, we plan to integrate PandaDoc into Copper so they can create a digital Contract. We also plan on a full website redesign. But we need to jump into the pool first and go for a swim.
