Pipedrive person fields
Pipedrive contacts are merged into your customer data platform (CDP) on the initial connection with Pipedrive.
Working with Pipedrive contacts
You can view or filter your Pipedrive contacts in your CDP on the People page.
Customize the field visibility and add Pipedrive fields by clicking the cog icon, then select or clear the fields you want to show or hide.
Apply filters using the Pipedrive person fields or activities to view the Pipedrive contacts in your people list who match the filter criteria. Learn more about Pipedrive activities under Pipedrive activities and attributes.
To filter people by the Pipedrive person fields:
- On the the People page, click Filter.
- Select Pipedrive person, then select the fields to wish to use as filter conditions.
- Click Done.
Learn more about creating filters under Working with filters.
Person fields added from Pipedrive
This table lists the Pipedrive person fields that are added to your Ortto account after integrating Ortto with Pipedrive.
Field | Type | Description |
|---|---|---|
Company ID | Text (string) | The ID of the company associated with the person. |
Company name | Text (string) | The name of the company associated with the person. |
User name | Text (string) | The name of the user associated with the person. |
Organization name | Text (string) | The name of the organization associated with the person. |
Owner name | Text (string) | The name of the owner associated with the person. |
Person name | Text (string) | The person’s name. |
The person’s email address. | ||
First name | Text (string) | The person’s first name. |
Last name | Text (string) | The person’s last name. |
Phone | Text (string) | The person’s phone number. |
Marketing status | Text (string) | Identifies the marketing permission the person has granted. Values can be: |
Created at | Time and date | The date the person was created as a record. In UTC, format YYYY-MM-DD HH:MM:SS. |
Updated at | Time and date | The date the person was last updated. In UTC, format YYYY-MM-DD HH:MM:SS. |
Open deals | Number | The amount of open deals associated with the person. |
Related open deals | Number | The amount of related open deals associated with the person. |
Closed deals | Number | The amount of closed deals associated with the person. |
Related closed deals | Number | The amount of related closed deals associated with the person. |
Participant open deals | Number | The amount of open deals where the person is a participant. |
Participant closed deals | Number | The amount of closed deals where the person is a participant. |
Email messages | Number | The amount of deal email messages the person is associated with. |
Activities | Number | The amount of activities the person is associated with. |
Done activities | Number | The amount of activities with a status of |
Undone activities | Number | The amount of activities with a status of |
Files | Number | The amount of files` the person is associated with. |
Notes | Number | The amount of notes the person is associated with. |
Followers | Number | The amount of followers the person has. |
Won deals | Number | The amount of won deals the person is associated with. |
Related won deals | Number | The amount of related won deals the person is associated with. |
Lost deals | Number | The amount of lost deals the person is associated with. |
Related lost deals | Number | The amount of related lost deals the person is associated with. |
Active flag | Boolean | A boolean value identifying whether or not the person is considered |
Next activity | Time and date | The date of the next (upcoming) activity the person is associated with. |
Last activity | Time and date | The date of the last (most recent) activity the person is associated with. |
Last incoming mail | Time and date | The date of the last (most recent) incoming mail message associated with the person. |
Last outgoing mail | Time and date | The date of the last (most recent) outgoing mail message associated with the person. |
Last stage | Text (string) | The name of the last (most recent) deal stage associated with the person. |
Last pipeline | Text (string) | The name of the last (most recent) pipeline associated with the person. |
Last deal | Text (string) | The name of the last (most recent) deal associated with the person. |
Last deal status | Text (string) | The name of the last (most recent) deal status associated with the person. |
Owner ID | Text (string) | The ID of the owner associated with the person. |
User ID | Text (string) | The ID of the user associated with the person. |
Organization ID | Text (string) | The ID of the organization associated with the person. |
Person ID | Text (string) | The person’s ID. |
Last stage ID | Text (string) | The name of the last (most recent) deal stage associated with the person. |
Last pipeline ID | Text (string) | The name of the last (most recent) pipeline associated with the person |
Last deal ID | Text (string) | The name of the last (most recent) deal associated with the person |
Next activity ID | Text (string) | The ID of the next (upcoming) activity associated with the person. |
Last activity ID | Text (string) | The ID of the last (most recent) activity associated with the person. |
Deal created first occurred | Time and date | The date for the first time a deal associated with the person was created. |
Deal created last occurred | Time and date | The date for the last time a deal associated with the person was created. |
Deal lost first occurred | Time and date | The date for the first time a deal with the status of |
Deal lost last occurred | Time and date | The date for the last time a deal with the status of |
Deal updated first occurred | Time and date | The date for the first time a deal associated with the person was updated. |
Deal updated last occurred | Time and date | The date for the last time a deal associated with the person was updated. |
Deal won first occurred | Time and date | The date for the frist time a deal with the status of |
Deal won last occurred | Time and date | The date for the last time a deal with the status of |
Label | Single-select | A label applied to the person. |
Person created first occurred | Time and date | The date for the first time the person was created. |
Person created last occurred | Time and date | The date for the last time the person was created. |
Person updated first occurred | Time and date | The date for the first time the person was updated. |
Person updated last occurred | Time and date | The date for the last time the person was updated. |