Skip to content

CRM and sales

Connect Pipedrive to DataxLand

The Pipedrive connector reads deals, stages, pipelines, activities and owners from your Pipedrive account. Si maps deals to the opportunity entity of the standard model, so you immediately get won amount, win rate, open pipeline value and average sales cycle by owner, on the same definitions as your dashboards and Si's answers.

Free plan with no time limit · No card required · Sample workspace ready in minutes

What you can do with Pipedrive

  • See each sales rep's win rate and average deal value by month.
  • Track open pipeline value by stage to forecast quarterly sales.
  • Compare wholesale sales from Pipedrive with retail revenue on marketplaces in one dashboard.
  • Ask Si why the sales cycle got longer than last quarter.

What data you get

Each stream lands as its own table in the workspace warehouse, as is; personal-data columns are hashed on load.

Stream (table)Contents
dealsDeals with value, status (open, won, lost), created date, close date, stage and owner.
stagesPipeline stages, to see which step each deal is at.
pipelinesThe list of pipelines, when you run several different sales processes.
activitiesCalls, meetings and tasks linked to deals.
organizationsCustomer companies; names and contact details are flagged for hashing when they are personal data.
personsContacts; emails and phone numbers are hashed on load.
usersPipedrive users, used as the owner dimension.

Connection details

Sign-in methodConnection details (API key, account), encrypted at rest
Sync modesFull (reloaded each run) · Incremental (new or changed rows only)
DeveloperAirbyte (certified), run inside DataxLand
LicenseELv2

Passwords and keys are encrypted at rest. Personal-data columns are hashed on load.

Metrics computed from this source

Real definitions from the analytics packs; dashboards and Si share them.

MetricDefinitionUnit
Won amountTotal value of won opportunities, by close date.Currency
Won opportunitiesNumber of opportunities won, by close date.Count
Win rateWon opportunities divided by all closed opportunities (won plus lost) in the period. Open opportunities are excluded.= Won opportunities / (Won opportunities + Lost opportunities)Ratio (%)
Open pipeline valueTotal value of opportunities created in the period that are still open (neither won nor lost).Currency
Average deal sizeWon amount divided by the number of won opportunities.= Won amount / Won opportunitiesCurrency
Average sales cycle (days)Average days from creation to win for opportunities won in the period.= won_cycle_days_total / Won opportunitiesNumber
New opportunitiesSales opportunities created in the period (by creation date), including open, won and lost ones.Count
Lost opportunitiesNumber of opportunities lost, by close date.Count

Connect Pipedrive in 4 steps

  1. 1

    Get an API token

    In Pipedrive, open your personal preferences, go to API and copy your personal token.

  2. 2

    Add the Pipedrive source

    In the workspace choose Add source, find Pipedrive in the connector library, choose API Token authentication and paste the token; it is encrypted when saved.

  3. 3

    Test and choose streams

    Click Test connection, then keep the deals, stages, pipelines and users streams; add activities if you want to measure activity.

  4. 4

    Review and build

    Si proposes a mapping from deals to sales opportunities; you fix anything highlighted in yellow, approve, then build the pipeline dashboard.

Limits and caveats

  • Requires the Starter plan or above; the Free plan takes Excel files only.
  • Pipedrive limits API calls according to your Pipedrive plan; a first load with several years of data can be slow.
  • Pipedrive has no sales targets; upload a targets table from Excel or Google Sheets to see attainment.
  • An Airbyte connector (ELv2 license) run inside DataxLand; you do not need an Airbyte account.

Frequently asked questions

Does DataxLand change data in Pipedrive?

No. The connector is read-only; data lands as is in the workspace's own warehouse.

How often does it refresh?

On the schedule you set and your plan allows, as often as hourly on the Starter plan. Deals and activities load incrementally by update time.

What if deals are in several currencies?

Values are loaded as Pipedrive returns them, with the currency code. DataxLand does not convert exchange rates; if your deals use several currencies, tell Si at the review step so only one currency is counted.

Dashboard templates that use this source

Ask Si about your Pipedrive data →All data sources →

Connect Pipedrive and get verified dashboards

Free plan with no time limit · No card required · Sample workspace ready in minutes