A Pipedrive Dashboard in Insights: Reports, Goals, Public Links and Plan Caps
The owner wants to know which lead source turns into won business, and the answer is somewhere in a Pipedrive account full of deals. Insights is where you build it: reports on deals, activities and revenue, gathered onto dashboards, with goals tracked against targets. Your plan sets how many reports each user can keep and whether you can have more than one dashboard.
New dashboard: open Insights, click +, choose Dashboard, give it a name and a section, and save.
Insights › + › DashboardReports onto it: drag one from the left panel, or open a report and click Add to dashboard.
Limits: a dashboard holds up to 25 reports, and only Premium and higher can create more than one dashboard.
What one lead source really returned
Insights reports the first line well. The rest sits in the ad platform and the accounting system, so the cost of a won deal never shows on the dashboard.
| Won deal value tagged paid search (What Insights shows) | $64,000 |
|---|---|
| Ad spend for the quarter (Lives in the ad platform) | − $9,600 |
| Discounts agreed after the deal closed (Lives on the invoices) | − $4,200 |
| Credit notes issued to those customers (Lives in accounting) | − $1,800 |
| Left after spend, discounts and credits | $48,400 |
Divide the spend by the number of won deals from that source and you have a cost per win to set beside the win rate. n-frames builds the scheduled pull that brings spend and invoice changes into one report with Pipedrive's source field, through the Pipedrive API.
A Pipedrive dashboard, from an empty board to a link you can send
- 1
Name the new board and file it
Insights › + › DashboardEnter a name, choose the section it belongs in, and click Save. The empty board opens on the right, with your saved reports listed on the left.
- 2
Add the reports
Drag reports from the side panel onto the board. Or, from inside a report, click Add to dashboard and pick the board. One report can sit on several dashboards, so build it once and reuse it.
Watch for: the 25-report limit per dashboard. A board for the owner and a board for the reps reads better than one crowded board anyway.
- 3
Filter it for the meeting
Period limits everything to a time range, and User narrows it to one person's data. Dashboard filters change what you see, not the reports underneath.
Watch for: a report the filter empties still shows on the board, and goals don't support the quick filter.
- 4
Share it
Share › Share as public linkClick Share at the top right to add teammates by name. Share as public link gives a view-only page to someone without a Pipedrive seat. Use + Add new link for a separate link per audience, so one can be revoked without touching the others.
Watch for: creating public links needs global admin rights or the matching permission on your user.
- 5
Take a copy out
A dashboard downloads as PDF or PNG. For the rows behind a report, open its table view and click Export, then pick XLSX or CSV.
The Insights report behind each question in the sales review
Questions people ask
Can I export Pipedrive reports to Excel?
Yes. Open the report's table view, click Export, choose XLSX or CSV and download. The file follows the chart's current filters, and the gear icon picks the columns. Exports stay in your generated exports list for 28 days. If someone is doing it every week, a scheduled pull through the API saves them the job.
Does Pipedrive have custom reporting?
It does. Insights builds reports from the fields Pipedrive holds, your own custom fields included, and you choose the grouping, filters and chart. What it can't do is report on numbers that never entered Pipedrive, such as ad spend or credit notes.
Can Pipedrive connect to a BI tool like Looker or Power BI?
Yes, through a connector app from the Pipedrive Marketplace or a feed built on the Pipedrive API. The second route is the one n-frames builds when the BI tool also needs data from accounting or the ad platforms, matched to each deal.
What is Pipedrive Insights?
It's the name Pipedrive gives its reporting area: reports, dashboards and goals built from the deals, activities and revenue in your account. You'll find it in the main menu, and the + button there creates each of the three.