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 |
|---|---|
| deals | Deals with value, status (open, won, lost), created date, close date, stage and owner. |
| stages | Pipeline stages, to see which step each deal is at. |
| pipelines | The list of pipelines, when you run several different sales processes. |
| activities | Calls, meetings and tasks linked to deals. |
| organizations | Customer companies; names and contact details are flagged for hashing when they are personal data. |
| persons | Contacts; emails and phone numbers are hashed on load. |
| users | Pipedrive users, used as the owner dimension. |
Connection details
| Sign-in method | Connection details (API key, account), encrypted at rest |
|---|---|
| Sync modes | Full (reloaded each run) · Incremental (new or changed rows only) |
| Developer | Airbyte (certified), run inside DataxLand |
| License | ELv2 |
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.
| Metric | Definition | Unit |
|---|---|---|
| Won amount | Total value of won opportunities, by close date. | Currency |
| Won opportunities | Number of opportunities won, by close date. | Count |
| Win rate | Won 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 value | Total value of opportunities created in the period that are still open (neither won nor lost). | Currency |
| Average deal size | Won amount divided by the number of won opportunities.= Won amount / Won opportunities | Currency |
| Average sales cycle (days) | Average days from creation to win for opportunities won in the period.= won_cycle_days_total / Won opportunities | Number |
| New opportunities | Sales opportunities created in the period (by creation date), including open, won and lost ones. | Count |
| Lost opportunities | Number of opportunities lost, by close date. | Count |
Connect Pipedrive in 4 steps
- 1
Get an API token
In Pipedrive, open your personal preferences, go to API and copy your personal token.
- 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
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
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
Connect Pipedrive and get verified dashboards
Free plan with no time limit · No card required · Sample workspace ready in minutes