Skip to main content
All CollectionsManage Your ReportsProject reports
How can I see contract totals by client?
How can I see contract totals by client?

Here's how you can generate a report on clients using Custom Columns, Project List Download, and Google Sheets

Colin Connor avatar
Written by Colin Connor
Updated over 2 months ago

If you want to generate a report with sales numbers broken down by client or date...

First, set your Custom Columns. I'd suggest Client Name, Contract Total, and Logistics Start (so you can filter projects by date).

Next, filter your projects using the Project Filters to the left of your screen - you can use things such as Dates, a specific client or venue, and the sales lead for those projects.

Don't forget to Include Archived Projects if you're looking for events you've already finished!

With the downloaded list, open the document in Google Sheets (this is my preferred method!)

From here, let's create a Pivot table

First, add in the Rows of Client Name
Then, add the Value of Contract Total
After, filter the Client Name Row by the Sum of Contract total.

You'll see the sum of all projects for your clients, so you can quickly identify which of your clients have had the highest contracts.

Want to see this report broken down by month?

First ensure the Logistics Start column is operating as a Date.

First, select that column.

Next, select to format this column as a Date

Then, add the Logistics Start Date Column into the Pivot Table.

Getting an error?

No worries! This just means there are too many values at the moment for Google Sheets to handle.
Let's filter this down a little bit:
First, add a Filter to the Pivot Table

Filter by Logistics Start Date

Clear all the entries and just select one date from the list.

Now that you've got this one entry, right click on the date, click 'Create Pivot Date Group', then click 'Year - Month' (for example). This will narrow down the projects listed here by year and month.

Then, remove the filter from the pivot table.

Now you'll see a handy summary of contract values broken out month over month.

Pro tip: Click any of these values to see the projects that are being used to calculate these values.

Did this answer your question?