Pipedrive Looker Studio connector by Windsor.ai

+

About the Connector
The connector pulls metrics and dimensions from Pipedrive. The insights are retrieved at stage and lead level.
Once user successfully logs into the connector its possible to choose the metrics and dimensions to create a report on.
Prerequisites
The user should have a Pipedrive API key in order to use this connector.
Our privacy policy and terms of use.
Available Metrics and Dimensions
Name | Type | Description | Object Type |
---|---|---|---|
Activity Flag | BOOLEAN | The activity flag | stages; |
Add Time | DATE | Time when the lead was added. | leads; stages; |
Company Email | TEXT | The company email | leads; |
Creator ID | NUMERIC | The Creator ID | leads; |
Deal Probability | NUMERIC | The deal probability | stages; |
Expected Close Date | DATE | The expected close date. | leads; |
Is Archived | BOOLEAN | The lead is archived or not. | leads; |
Label IDs | OBJECT | The label IDs | leads; |
Lead ID | TEXT | The Lead ID | leads; |
Lead Title | TEXT | The Lead title | leads; |
Next Activity ID | NUMERIC | The next activity ID | leads; |
Order Number | NUMERIC | The order number | stages; |
Pipedrive Lead Owner ID | NUMERIC | The Owner ID | leads; |
Person ID | NUMERIC | The person ID | leads; |
Organization ID | NUMERIC | The organization ID | leads; |
Pipedrive Pipeline ID | NUMERIC | The pipeline ID | stages; |
Pipeline Deal Probability | BOOLEAN | The pipeline deal probability | stages; |
Pipeline Name | TEXT | The pipeline name | stages; |
Rotten Days | NUMERIC | The rotten days | stages; |
Rotten Flag | BOOLEAN | The rotten flag | stages; |
Source Name | TEXT | The source name | leads; |
Stage ID | NUMERIC | The stage ID | stages; |
Stage Name | TEXT | The stage name | stages; |
Update Time | DATE | Time when the lead was updated. | leads; stages; |
Value Amount | NUMERIC | The value's amount | leads; |
Value Currency | TEXT | The value's currency | leads; |
Visible To | TEXT | Visible to | leads; |
Was Seen | BOOLEAN | The lead was seen or not. | leads; |