First, ensure you've got your columns set with the values you'd look to report on (Venue, Contract Total, etc) (Guide)
Next, set your dates and export your Project List (Guide)
Then, open the attached document in Google Sheets
Finally, follow the steps in the video above to quickly generate a Pivot Table to easily see your top performing Cities.
Here's how you can easily use your Project List and a quick Pivot Table to instantly know your most profitable cities, zip codes, etc
Written by Colin Connor
Updated over a week ago