Connect Pipedrive to Looker Studio

Directly connect Pipedrive to Looker Studio, in minutes, and in an easy-to-use format.

Pipedrive
+
Looker Studio

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:

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.

select fields on the right

Go to “Select Destination” and choose Google Data Studio.

Once done, select “connect” and authorize access to your data source.

pipedrive looker studio integration

Connect Pipedrive to Looker Studio

Pipedrive metrics and dimensions available for streaming into Looker Studio

nametypedescription
Account IDTEXTThe Pipedrive account identifier
Account NameTEXTThe Pipedrive account name
Add TimeDATETime when the object was added.
DateDATETime when the object was updated
Deal Is ActiveBOOLEANIndicates whether the deal is active.
Deal Activities CountNUMERICThe count of activities associated with the deal
Deal Add TimeDATETime when the deal was added.
Deal Additional DataOBJECTAdditional data related to the deal
Deal Close TimeDATEThe time when the deal was closed
Deal Currency TEXTThe currency of the deal.
Deal Is DeletedBOOLEANIndicates whether the deal is deleted.
Deal Done Activities CountNUMERICThe count of completed activities associated with the deal
Deal Email Messages CountNUMERICThe count of email messages associated with the deal
Deal Files CountNUMERICThe count of files associated with the deal
Deal First Won TimeDATEThe time when the deal was first won
Deal Followers CountNUMERICThe count of followers of the deal
Deal Formatted ValueTEXTThe formatted value of the deal
Deal Formatted Weighted ValueTEXTThe formatted weighted value of the deal
Deal Last Activity DateDATEDate of the last activity of the deal
Deal Last Activity IDNUMERICThe ID of the last activity of the deal
Deal Lost ReasonTEXTThe reason for losing the deal
Deal Lost TimeDATEThe time when the deal was lost
Deal Next Activity DateDATEDate of the next activity of the deal
Deal Next Activity DurationTEXTDuration of the next activity of the deal
Deal Next Activity IDNUMERICThe ID of the next activity of the deal
Deal Next Activity NoteTEXTNote content of the next activity of the deal
Deal Next Activity SubjectTEXTThe subject of the next activity of the deal
Next Activity TimeDATETime of the next activity of the deal
Deal Next Activity TypeTEXTThe type of the next activity of the deal
Deal Notes CountNUMERICThe count of notes associated with the deal
Deal Organization HiddenBOOLEANIndicates whether the organization is hidden
Deal Owner NameTEXTThe name of the deal owner
Deal Participants CountNUMERICThe count of participants in the deal
Deal Person HiddenBOOLEANIndicates whether the person is hidden
Deal Pipeline IDNUMERICThe ID of the pipeline of the deal
Deal ProbabilityPERCENTThe probability of the deal closing in percent.
Deal Products CountsNUMERICThe count of products associated with the deal
OBJECTRelated objects associated with the deal
Deal Rotten TimeDATETime when the deal turned rotten
Deal Stage Change TimeDATETime when the deal stage changed.
Deal StatusTEXTThe status of the deal
Deal TitleTEXTThe deal title
Deal Undone Activities CountNUMERICThe count of incomplete activities associated with the deal
Deal Update TimeDATETime when the deal was updated.
Deal User IDTEXTThe ID of the user associated with the deal
Deal ValueNUMERICThe value of the deal.
Deal Visible ToTEXTThe visibility of the deal
Deal Weighted ValueNUMERICThe weighted value of the deal
Deal Weighted Value CurrencyTEXTThe currency of the weighted value of the deal
Deal Won TimeDATEThe time when the deal was won
Label IDsOBJECTThe IDs of the lead labels which will be associated with the lead
Lead Add TimeDATETime when the lead was added.
Lead Company EmailTEXTThe lead company email
Lead Creator IDTEXTThe ID of the creator of the lead
Lead Expected Close DateDATEThe date of when the deal which will be created from the lead is expected to be closed.
Lead IDTEXTThe ID of the lead.
Lead Is ArchivedBOOLEANA flag indicating if the lead is archived or not.
Lead Next Activity IDNUMERICThe next activity ID of the lead.
Lead Owner IDTEXTThe ID of the owner of the leadD
Lead Person IDTEXTThe 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 IDNUMERICThe 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 NameTEXTThe source name of the lead (e.g. API)
Lead TitleTEXTThe name of the lead
Lead Update TimeDATETime when the lead was updated.
Lead Value AmountNUMERICThe amount of the deal which will be created from the lead
Lead Value CurrencyTEXTThe currency of the deal which will be created from the lead
Lead Visible ToTEXTVisible to
Lead Was SeenBOOLEANA flag indicating whether the lead was seen by someone in the Pipedrive UI
Activity FlagBOOLEANFlag whether the stage is active or not
Stage Add TimeDATETime when the stage was added.
Stage Deal ProbabilityPERCENTThe stage probability in percent
Stage IDTEXTThe stage ID
Stage NameTEXTThe stage name
Stage Order NumberNUMERICThe stage order number
Stage Pipedrive Pipeline IDNUMERICThe pipeline ID
Stage Pipeline Deal ProbabilityBOOLEANThe pipeline deal probability
Stage Pipeline NameTEXTThe name of the pipeline
Stage Pipeline Rotten DaysNUMERICThe number of days the deals not updated in this stage would become rotten. Applies only if the rotten_flag is set.
Stage Pipeline Rotten FlagBOOLEANWhether deals in this stage can become rotten.
Stage Update TimeDATETime when the stage was updated.
Update TimeDATETime when the object was updated.
TodayDATEToday's date

Easily connect Pipedrive to Looker Studio

See the value and return on every marketing touchpoint

data warehouse

Providing 50+ marketing data streams, we make sure that all the data we integrate is fresh and accessible by marketers, whenever they want.

insights

Spend less time on manual data loading and spreadsheets. Focus on delighting your customers.

Build your Pipedrive and Looker Studio Integrations