Pipedrive expertsA GLOBETECH SERVICE
Legal services

A law firm leaves Google Sheets behind and lifts its win rate by 28%

Client: Law firmIndustry: Legal servicesService: Pipedrive growth implementationWhen: October 2023

Short answerWe moved the firm's leads and deals out of Google Sheets into a Pipedrive pipeline designed around how it sells legal services, connected lead sources automatically and added BI dashboards. Win rate rose 28% and manual lead entry dropped to zero.

One spreadsheet per agentOne pipeline and live reports
28%Increase in win rate
0Hours of manual lead entry
100%Pipeline visibility for the owner

Results are as reported by the client.

The challenge

  • The whole sales pipeline ran on Google Sheets, and each agent kept their own.
  • Leads were lost, and staff copied data by hand from web forms, referrals, ad campaigns and phone calls.
  • Follow-ups were inconsistent.
  • The owner had no unified, real-time view of sales activity and no reporting to decide with.

What we built

  1. A pipeline built around legal salesStages match how the firm sells, with clear criteria for moving a deal forward.
  2. Lead sources connectedWebsite forms, ad campaigns and referral tracking feed Pipedrive automatically.
  3. Repetitive work automatedFollow-up reminders, stage updates and internal notifications run on their own.
  4. BI dashboardsConversion by agent, ROI by lead source, pipeline value, win and loss analysis and activity metrics.
  5. Data migrationExisting leads and deals were moved from the spreadsheets, cleaned and categorised.
  6. Role-based trainingAgents learned the process, and managers learned to use the reports for coaching.

Tools connected

  • Pipedrive
  • Pipedrive dashboards
  • Website forms
  • Google Sheets (migrated out)

In the client's words

We had good salespeople - but we had no idea what they were actually doing day to day.Law firm
The BI reports alone were worth the entire project.Law firm

Quick answers

What problem did Law firm have?

The whole sales pipeline ran on Google Sheets, and each agent kept their own. Leads were lost, and staff copied data by hand from web forms, referrals, ad campaigns and phone calls.

Which tools were used in this Pipedrive project?

This project used Pipedrive, Pipedrive dashboards, Website forms, Google Sheets (migrated out).

What results did Law firm see?

Win rate rose 28% after implementation. Lead data entry is fully automated, with zero manual hours. The owner sees the pipeline in real time and had visibility within the first month. The sales process ran consistently across all agents within 90 days.

Want something like this in your business?

Book a free 30 minute call and we will show you where to start.

Book a free strategy call

Book a free 30 minute strategy call

Loading the calendar...

Having trouble? Open the calendar in a new tab.