Home > Destinations > Data Studio (ex Looker Studio) > Pipedrive

Connect Pipedrive to Data Studio (ex Looker Studio)

Connect Pipedrive to Data Studio (ex Looker Studio) and and build automated dashboards without CSV exports, spreadsheets, or manual API setup.

Looker Studio
Power BI
Google Sheets
BigQuery
Snowflake

Used by the world's leading companies

Why do agencies use Catchr for Pipedrive reporting in Data Studio (Looker Studio)?

Catchr lets media buyers and agencies stop rebuilding Pipedrive reports by hand: the data lands in Data Studio ready to chart, for every ad account you manage.

No manual csv export
‍

Stop downloading files from Pipedrive every time a client report, spreadsheet, or dashboard needs fresh numbers.

Connected in minutes

Your first Pipedrive report can be live in a few minutes. Authorize your Pipedrive account, pick your ad accounts, and your data source is ready.

Built for agencies with many CRM accounts

Pull several CRM accounts into one data source, then filter by account to build a report per client or brand in the same Data Studio file.

Pipedrive to Looker Studio pricing

Choose your plan by the number of platforms and accounts you report on.

Starter

For freelancers and small teams.

$ 24 /mo

Billed monthly · cancel anytime

Platforms3
Accounts10
Start free trial

Growth

For agencies managing more clients.

$ 239 /mo

Billed monthly · cancel anytime

Platforms10
Accounts100
Start free trial

Scale

For teams reporting at scale.

$ 599 /mo

Billed monthly · cancel anytime

Platforms25
Accounts500
Start free trial

How to connect Pipedrive to Data Studio with Catchr?

To connect Pipedrive to Looker Studio (Data Studio), open the Catchr connector, authorize your Pipedrive account, select the ad accounts you want to report on, then create your report.

1. Open the Catchr Pipedrive connector in Looker Studio

Click the connector link to open it inside Looker Studio. You will be asked to authorize the connector before creating your data source.

2. Authorize Looker Studio (Data Studio) and Catchr

Choose the Google account you use for Looker Studio and authorize Catchr to create a secure Pipedrive data source.

3. Connect your Pipedrive account

Sign in with your Pipedrive account that has access to the accounts you want to report on. Make sure your user has the right Pipedrive permissions.

4. Select your Pipedrive accounts

Choose one or several CRM accounts, depending on the report you want to build.

5. Create your Data Studio report

Click Create report, then add charts, scorecards, tables, filters, and date controls using your Pipedrive metrics and dimensions.

6. Customize your dashboard

Use Person Open Deals Count, Person Won Deals Count, Person Lost Deals Count, Person Activities Count, Person Done Activities Count, Person Email Message Count, Lead Source Name, Lead Title, Lead Amount, Lead Currency, Deal Owner Name, Deal Organization Name, Deal Expected Close Date, Deal Lost Reason and many more.

Pipedrive metrics and dimensions available in Data Studio

Access 18 metrics and 118 dimensions from Pipedrive connectors including Person Open Deals Count, Person Won Deals Count, Person Lost Deals Count, Person Activities Count, Person Done Activities Count, Person Email Message Count, Lead Source Name, Lead Title, Lead Amount, Lead Currency, Deal Owner Name, Deal Organization Name, Deal Expected Close Date, Deal Lost Reason and more.

18

Available metrics

118

Available dimensions

Build better Pipedrive dashboards in Data Studio (ex Looker Studio)

Use Catchr to create dashboards that show what is working, what is wasting budget, and where performance is changing.

Client reporting for agencies

Create clean Looker Studio dashboards for each client with with Person Open Deals Count, Person Won Deals Count, Person Lost Deals Count, Person Activities Count, Person Done Activities Count, Person Email Message Count always up to date.

Budget pacing

Compare daily spend with the monthly budget of each campaign, so overspend shows up mid-month instead of on the invoice.

Review what drives results across

Compare to see where budget, traffic, or revenue is improving and where performance is dropping.

Compare with your other channels

Combine with your others marketing to understand performance across your full acquisition journey.

Keep an eye on Pipedrive performance

Track Pipedrive Person Open Deals Count, Person Won Deals Count, Person Lost Deals Count, Person Activities Count, Person Done Activities Count, Person Email Message Count in refreshable Data Studio dashboards so you can spot changes before they become reporting problems.

Customer testimonials

What our customers say about us.

85 %
Faster
Reporting time

After three years of use, Catchr has become essential for both our teams and our clients. So far, it has been our best solution for compiling and analyzing data from different advertising platforms. It’s easy to set up, and the customer service is responsive and excellent.

Valentin Keravel
CEO, Laio – Agency

With Catchr’s automated API, we can finally collect and centralize all advertising data, connect it with booking information, and calculate the real ROAS for our restaurant clients. It gives them full visibility, more autonomy, and the ability to optimize campaigns to maximize ROI.

Corentin Largeron
Freelance
30
hours saved

The solution is a real game changer, providing optimal time savings for our data reporting. The major strength of the solution is their highly responsive and professional support.

Corentin Largeron
CEO at The Browz – Agency

Pipedrive to Data Studio (ex Looker Studio): FAQ

Answers to common questions about connecting data to spreadsheets, dashboards, AI assistants, and reporting tools with Catchr.

How can I connect Pipedrive to Looker Studio?

Connect your Pipedrive account in Catchr and choose it in the Catchr Looker Studio connector. Create a deal table with deal ID, title, status, owner and value. Then add filters for the pipeline and reporting period so the dashboard follows the same scope as your sales team's Pipedrive view.

Can I track won, lost and open Pipedrive deals separately?

Yes. Use the deal status field to separate open opportunities from won and lost deals. Show deal count and value together: a team can win more deals while generating less value if the average deal size falls. Keep lost deals visible in a dedicated view to investigate the reasons behind them.

Which date should I use for a monthly sales report?

Use the won date for completed wins, the lost date for losses and the added date for newly created opportunities. Expected close date is useful for planning open pipeline. Catchr exposes these dates separately; choosing the wrong one can move a deal into a different reporting month.

Can I analyze why Pipedrive deals are lost?

Yes. Catchr includes the lost reason and lost time fields. Filter to lost deals and group by reason, using both deal count and value. Keep blank reasons visible so you can distinguish an actual pattern from incomplete CRM data.

How can I spot deals that need follow-up?

Use next activity date, last activity date and unfinished activity counts alongside deal status and owner. Build a view of open deals with overdue or missing next steps. An inactive deal is a prompt to investigate, not proof that the opportunity is lost.

What is the difference between deal value and weighted value?

Deal value is the full potential amount. Weighted value reflects the probability assigned to the opportunity. Catchr exposes both, so you can show potential pipeline and a probability-adjusted forecast separately. Neither measure should be presented as collected revenue while the deal remains open.

Can I compare Pipedrive sales with Google Ads campaigns?

Yes. Add Google Ads to compare acquisition spend with leads and won deals. Define campaign mappings and the sales period before blending. Daily spend and daily won revenue can move at different times because deals take time to close.

Still have a question?

Our team is always here to answer any questions you may have about our data connector.