What we do
Tools
Industries
Department
How we workLet's talk →
Home/Pipedrive/Pipedrive Dashboard With Cost per Lead Source
Pipedrive Insights

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.

In Insights

New dashboard: open Insights, click +, choose Dashboard, give it a name and a section, and save.

Insights + Dashboard

Reports 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.

Example quarter · one lead source
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. 1

    Name the new board and file it

    Insights + Dashboard

    Enter 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. 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. 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. 4

    Share it

    Share Share as public link

    Click 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. 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

The question Build this in Insights Watch for
Are we on pace this month? A goal on deals won, by count or value, for the team or one rep. Goals only track what's in Pipedrive, so a deal won but never invoiced still counts.
Where do deals stall? A deal conversion or duration report, grouped by stage. Filter to one pipeline if you run several, or stages from different pipelines blur together.
Who's doing the work? An activity report by user and activity type. Only logged activities count. Calls made from a phone that isn't synced won't show.
What will close next quarter? A revenue forecast report on expected close dates. Stale close dates pile deals into the current month. Clean them up before the meeting.
How many reports can each person keep? Lite 15, Growth 50, Premium 250, Ultimate 500, counted per user. Pipedrive doesn't delete anything over the limit, but no one can add more until some are removed or the plan changes.

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.

Let's talk

Tell us the one thing your team does manually that eats up time. We read every message and reply within a day.