Connect Pipedrive to Looker Studio
Directly connect Pipedrive to Looker Studio, in minutes, and in an easy-to-use format.
+
About the Pipedrive Looker Studio Connector
The Pipedrive Looker Studio Connector pulls Metrics and Dimensions for Pipedrive. The Insights are retrieved at the campaign level.
Once the user successfully logs into the connector he can then choose the metrics and dimensions he is interested to create a report on.
Prerequisites
To set up the connector, the user should have:
- An Pipedrive account (Visit our privacy policy and terms of use)
- Google account for Pipedrive to Looker Studio integration.
- A Windsor account. Start your free trial now.
How to connect Pipedrive to Looker Studio?
Do you plan to connect and visualize your Pipedrive in Looker Studio? Follow the Tutorial Below:
Select the fields on the right to later use in your data source. For example, you can include metrics such as Cost per Click, Cost per Action or Total Spend.
Go to “Select Destination” and choose Google Data Studio.
Once done, select “connect” and authorize access to your data source.
Connect Pipedrive to Looker Studio
Pipedrive metrics and dimensions available for streaming into Looker Studio
| name | type | description |
|---|---|---|
| Account ID | TEXT | The Pipedrive account identifier |
| Account Name | TEXT | The Pipedrive account name |
| Add Time | DATE | Time when the object was added. |
| Date | DATE | Time when the object was updated |
| Deal Is Active | BOOLEAN | Indicates whether the deal is active. |
| Deal Activities Count | NUMERIC | The count of activities associated with the deal |
| Deal Add Time | DATE | Time when the deal was added. |
| Deal Additional Data | OBJECT | Additional data related to the deal |
| Deal Close Time | DATE | The time when the deal was closed |
| Deal Currency | TEXT | The currency of the deal. |
| Deal Is Deleted | BOOLEAN | Indicates whether the deal is deleted. |
| Deal Done Activities Count | NUMERIC | The count of completed activities associated with the deal |
| Deal Email Messages Count | NUMERIC | The count of email messages associated with the deal |
| Deal Files Count | NUMERIC | The count of files associated with the deal |
| Deal First Won Time | DATE | The time when the deal was first won |
| Deal Followers Count | NUMERIC | The count of followers of the deal |
| Deal Formatted Value | TEXT | The formatted value of the deal |
| Deal Formatted Weighted Value | TEXT | The formatted weighted value of the deal |
| Deal Last Activity Date | DATE | Date of the last activity of the deal |
| Deal Last Activity ID | NUMERIC | The ID of the last activity of the deal |
| Deal Lost Reason | TEXT | The reason for losing the deal |
| Deal Lost Time | DATE | The time when the deal was lost |
| Deal Next Activity Date | DATE | Date of the next activity of the deal |
| Deal Next Activity Duration | TEXT | Duration of the next activity of the deal |
| Deal Next Activity ID | NUMERIC | The ID of the next activity of the deal |
| Deal Next Activity Note | TEXT | Note content of the next activity of the deal |
| Deal Next Activity Subject | TEXT | The subject of the next activity of the deal |
| Next Activity Time | DATE | Time of the next activity of the deal |
| Deal Next Activity Type | TEXT | The type of the next activity of the deal |
| Deal Notes Count | NUMERIC | The count of notes associated with the deal |
| Deal Organization Hidden | BOOLEAN | Indicates whether the organization is hidden |
| Deal Owner Name | TEXT | The name of the deal owner |
| Deal Participants Count | NUMERIC | The count of participants in the deal |
| Deal Person Hidden | BOOLEAN | Indicates whether the person is hidden |
| Deal Pipeline ID | NUMERIC | The ID of the pipeline of the deal |
| Deal Probability | PERCENT | The probability of the deal closing in percent. |
| Deal Products Counts | NUMERIC | The count of products associated with the deal |
| Deal Related Objects | OBJECT | Related objects associated with the deal |
| Deal Rotten Time | DATE | Time when the deal turned rotten |
| Deal Stage Change Time | DATE | Time when the deal stage changed. |
| Deal Status | TEXT | The status of the deal |
| Deal Title | TEXT | The deal title |
| Deal Undone Activities Count | NUMERIC | The count of incomplete activities associated with the deal |
| Deal Update Time | DATE | Time when the deal was updated. |
| Deal User ID | TEXT | The ID of the user associated with the deal |
| Deal Value | NUMERIC | The value of the deal. |
| Deal Visible To | TEXT | The visibility of the deal |
| Deal Weighted Value | NUMERIC | The weighted value of the deal |
| Deal Weighted Value Currency | TEXT | The currency of the weighted value of the deal |
| Deal Won Time | DATE | The time when the deal was won |
| Label IDs | OBJECT | The IDs of the lead labels which will be associated with the lead |
| Lead Add Time | DATE | Time when the lead was added. |
| Lead Company Email | TEXT | The lead company email |
| Lead Creator ID | TEXT | The ID of the creator of the lead |
| Lead Expected Close Date | DATE | The date of when the deal which will be created from the lead is expected to be closed. |
| Lead ID | TEXT | The ID of the lead. |
| Lead Is Archived | BOOLEAN | A flag indicating if the lead is archived or not. |
| Lead Next Activity ID | NUMERIC | The next activity ID of the lead. |
| Lead Owner ID | TEXT | The ID of the owner of the leadD |
| Lead Person ID | TEXT | The ID of a person which this lead will be linked to. If the person does not exist yet, it needs to be created first. This property is required unless organization_id is specified. |
| Lead Organization ID | NUMERIC | The ID of an organization which this lead will be linked to. If the organization does not exist yet, it needs to be created first. |
| Lead Source Name | TEXT | The source name of the lead (e.g. API) |
| Lead Title | TEXT | The name of the lead |
| Lead Update Time | DATE | Time when the lead was updated. |
| Lead Value Amount | NUMERIC | The amount of the deal which will be created from the lead |
| Lead Value Currency | TEXT | The currency of the deal which will be created from the lead |
| Lead Visible To | TEXT | Visible to |
| Lead Was Seen | BOOLEAN | A flag indicating whether the lead was seen by someone in the Pipedrive UI |
| Activity Flag | BOOLEAN | Flag whether the stage is active or not |
| Stage Add Time | DATE | Time when the stage was added. |
| Stage Deal Probability | PERCENT | The stage probability in percent |
| Stage ID | TEXT | The stage ID |
| Stage Name | TEXT | The stage name |
| Stage Order Number | NUMERIC | The stage order number |
| Stage Pipedrive Pipeline ID | NUMERIC | The pipeline ID |
| Stage Pipeline Deal Probability | BOOLEAN | The pipeline deal probability |
| Stage Pipeline Name | TEXT | The name of the pipeline |
| Stage Pipeline Rotten Days | NUMERIC | The number of days the deals not updated in this stage would become rotten. Applies only if the rotten_flag is set. |
| Stage Pipeline Rotten Flag | BOOLEAN | Whether deals in this stage can become rotten. |
| Stage Update Time | DATE | Time when the stage was updated. |
| Update Time | DATE | Time when the object was updated. |
| Today | DATE | Today's date |
Easily connect Pipedrive to Looker Studio
See the value and return on every marketing touchpoint
Providing 50+ marketing data streams, we make sure that all the data we integrate is fresh and accessible by marketers, whenever they want.
Spend less time on manual data loading and spreadsheets. Focus on delighting your customers.