Pipedrive in Google Data Studio
Deals from every pipeline, leads, products and calls from Pipedrive — every night in Google Data Studio. Pipeline and team reports next to your ads, Google Analytics and spreadsheets.
No card required. Cancel any time.
What Pipedrive data you get
Not raw API output — ready tables: client names already joined onto deals, currencies converted, dates in your time zone.
Your CRM custom fields come along too, with proper types: numbers as numbers, dates as dates.
- Clients
-
People with organisation, owner and creation date.
- Deals and orders
-
Pipeline, stage, outcome, lost reason, value — in both currencies.
- Leads
-
Pipeline, stage, source and UTM tags.
- Products and services
-
Code, price, cost.
- Users
-
For reports broken down by owner.
- Order lines
-
What exactly was sold, how many and for how much.
- Calls
-
Outcome, duration, owner.
What is specific to Pipedrive
- Deals from all pipelines, archived ones included: stage, lost reason, close date
- People and organisations — names already joined onto deals
- Deal products: what sold, how many and for how much
- Leads, archived ones included
- Currency and time zone picked up from your Pipedrive account automatically
- Deal and person custom fields, plus call logs
Reports you can build
- Win rate and lost reasons by pipeline
- Sales cycle length
- Expected close forecast for open deals
- Team activity: calls and deals by owner
How to connect Pipedrive
-
1/3
Every Pipedrive user has their own API token: Settings → Personal preferences → API.
-
2/3
Use the token of a user who can see all the deals you need (usually an admin).
-
3/3
The first sync loads your full history; after that data refreshes every night.
Pipedrive questions
Pipedrive has reports already. Why Data Studio?
Data Studio lets you combine Pipedrive with ads, Google Analytics and spreadsheets in one report and share it with anyone.
Deals in several currencies?
Every amount comes in its original currency and in your reporting currency at the official rate of the deal day.
Are archived deals included?
Yes — archived deals and leads come along with the active ones.
Other CRMs