Skip to main content

ZenPilot Blog » Latest Articles

Table of Contents
Table of Contents

How to Set Up Sales Reporting at Your Agency

Gray MacKenzie
Gray MacKenzie is a true operations nerd who has spent the past decade helping hundreds of agencies build more productive, profitable, and healthy teams by solving the core issues plaguing their project management.

To chat with Gray and have ZenPilot lead your team through the last project management implementation you'll ever need, schedule a quick call here.

This is a unique episode of Inbound Sales Journey.

In this episode, we explain how we have set up sales reporting for both GuavaBox and ZenPilot.

Tracking the Right Numbers

The first and most important part of setting up your sales reporting is figuring out which data points you want to report on. We have set up a Google Sheet with formulas to help choose which numbers to track. 

We decided on the following:

  • Number of Leads
  • Percentage of Leads That Turn to Demos
  • Close Rate
  • New MRR
  • Number of Sales of Each Service.

We then took that data and turned it into a nice Google spread sheet. Below is a screenshot of what that looks like.

Screen Shot 2016-11-30 at 1.10.41 PM.png

If you have not created a forecasting worksheet hopefully the above image will help give you some ideas.

If you want a useable copy of that worksheet, let us know and we can get you a copy. That should give you a good start towards tracking your sales progress. 

An Automated Solution

The collection and displaying of data is continuing to become more and more automated. But I can’t help but feeling like the sales reporting side is lagging behind a bit. 

We use the HubSpot CRM to track all of our deal information and prospect data. But as of the time of writing this post one key automated piece of data is missing. Deal velocity.

Being able to have up-to-date real time data about how quickly a prospect goes from a connect call to signing a contract for any of our services or products would be awesome. We want to evaluate our funnels and sales process using up-to-date data that we don’t have to spend hours calculating on our own.

If there are any great sales tools out there that you like please feel free to share them below.

How to Connect with Ryan and Gray

Twitter:

@ryanrherman

@sgraymackenzie

Explore Topics

About ZenPilot

Our proven framework helps agencies streamline their operations in ClickUp and build healthy teams, boost profits, and double productivity. Get our proven framework →
New call-to-action

Related Articles

Subscribe to First Class Operations

And get instant access to the ClickUp for Agencies Guide. Join 8,000+ agencies that stay ahead of the curve on agency news, resources, tools, and insights with our newsletter.
FREE ClickUp Training Course
ClickUp for Agencies Playbook

Get Access to Our Complete Playbook to Streamlining Your Operations in ClickUp