Create your own reports with Google Data Studio

Tom Bell posted in product March 6, 2019

We’ve got some great news for our customers on the Teams plan - now you can create your own sales opportunity reports in Google Data Studio - Google’s own business intelligence and data visualization platform.

On the Teams plan, you can already access detailed sales reports on your team’s activity, sales performance, pipeline and more. But we know that every business is unique and so there are some reports you’ll want to create yourself. Now you can.

All your sales opportunity data can now be connected to Google Data Studio in a few simple steps. We’ve even added additional data points that we don’t usually report on in Capsule, so you get even more insight from your data. Examples include the number of days it takes to close a deal and the number of days an opportunity has spent at one stage.

The great thing about Google Data Studio is that you can combine multiple data sources to create a dashboard, which gives you a fantastic overview of your business performance.

If you’re not familiar with Google Data Studio there are templates that help you get started and lots of good support videos too. We put together the template featured below quite quickly to show you what your customised sales opportunity data could look like. Plus, we’ve put together our own guide to create your first chart in Google Data Studio.

Head over to our support portal to read the guide on how to connect your data. If you have any questions or simply want to share your feedback let us know.

Read more about product

Know why you’re losing sales opportunities

Everyone loses a sale now and again but how often do you learn from it? It’s important to understand where it all went wrong, even more so if it’s down to the person selling.

Keep your sales pipeline moving with Stale Opportunities

Sometimes you don’t lose a sale, it just goes stale. What’s important is to be aware of these stale opportunities and put plans in place to reinvigorate them or close the opportunity.

Connect Capsule with different web services using Zapier

Find out about automating workflows between Capsule and different web services using our Zapier integration.