Pipedrive Looker Studio connector by Windsor.ai

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.

The user should have a Pipedrive API key in order to use this connector.

Pipedrive Looker Studio Templates

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;