Introduction

Datasources and destinations

Fields listing for Pipedrive

Pipeline Id
Id of a pipeline.
Field IDpipelines.id
TypeNUMBER
Data Typedimension
Pipeline Name
Name of a pipeline.
Field IDpipelines.name
TypeTEXT
Data Typedimension
Pipeline Url Title
Url title of a pipeline.
Field IDpipelines.url_title
TypeTEXT
Data Typedimension
Pipeline Order Number
Order number of a pipeline.
Field IDpipelines.order_nr
TypeNUMBER
Data Typedimension
Pipeline Is Active
Return true if the pipeline is active.
Field IDpipelines.active
TypeBOOLEAN
Data Typedimension
Pipeline Deal Probability
Deal probability of a pipeline.
Field IDpipelines.deal_probability
TypeBOOLEAN
Data Typedimension
Pipeline Added At
Datetime the pipeline added.
Field IDpipelines.add_time
TypeNUMBER
Data Typedimension
Pipeline Update At
Datetime the pipeline last updated.
Field IDpipelines.update_time
TypeNUMBER
Data Typedimension
Pipeline is Selected
Return true if the pipeline is selected.
Field IDpipelines.selected
TypeNUMBER
Data Typedimension
Lead Id
Id of a lead.
Field IDleads.id
TypeNUMBER
Data Typedimension
Lead Title
Title of the lead.
Field IDleads.title
TypeTEXT
Data Typedimension
Lead Owner Id
Owner Id of the lead.
Field IDleads.owner_id
TypeNUMBER
Data Typedimension
Lead Creator Id
Creator id of the lead.
Field IDleads.creator_id
TypeNUMBER
Data Typedimension
Lead Person Id
Person id of the lead.
Field IDleads.person_id
TypeNUMBER
Data Typedimension
Lead Organization Id
Organization id of the lead.
Field IDleads.organization_id
TypeNUMBER
Data Typedimension
Lead Source Name
Source name of the lead.
Field IDleads.source_name
TypeTEXT
Data Typedimension
Lead Is Archived
Return true if the lead is archived.
Field IDleads.is_archived
TypeBOOLEAN
Data Typedimension
Lead Was Seen
Return true if the lead was seen.
Field IDleads.was_seen
TypeBOOLEAN
Data Typedimension
Lead Amount
The amount of the lead.
Field IDleads.value.amount
TypeNUMBER
Data Typedimension
Lead Currency
The currency of the amount lead.
Field IDleads.value.currency
TypeTEXT
Data Typedimension
Lead Expected Close Date
The expected close date of the lead.
Field IDleads.expected_close_date
TypeYEAR_MONTH_DAY
Data Typedimension
Lead Next Activity Id
The next activity id of the lead.
Field IDleads.next_activity_id
TypeNUMBER
Data Typedimension
Lead Added At
The add time of the lead.
Field IDleads.add_time
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Lead Updated At
The update time of the lead.
Field IDleads.update_time
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Lead Visible To
The visibility of the lead.
Field IDleads.visible_to
TypeTEXT
Data Typedimension
Lead CC Email
The cc mail of the lead.
Field IDleads.cc_email
TypeTEXT
Data Typedimension
Person ID
The person ID
Field IDpersons.id
TypeTEXT
Data Typedimension
Person Company ID
The person company ID
Field IDpersons.company_id
TypeTEXT
Data Typedimension
Person Name
The person name
Field IDpersons.name
TypeTEXT
Data Typedimension
Person First Name
The person first name
Field IDpersons.first_name
TypeTEXT
Data Typedimension
Person Last Name
The person Last name
Field IDpersons.last_name
TypeTEXT
Data Typedimension
Person Open Deals Count
The person open deals count
Field IDpersons.open_deals_count
TypeNUMBER
Data Typemetric
Person Related Open Deals Count
The person related open deals count
Field IDpersons.related_open_deals_count
TypeNUMBER
Data Typemetric
Person Closed Deals Count
The person closed deals count
Field IDpersons.closed_deals_count
TypeNUMBER
Data Typemetric
Person Related Closed Deals Count
The person related closed deals count
Field IDpersons.related_closed_deals_count
TypeNUMBER
Data Typemetric
Person Participant Open Deals Count
The person participant open deals count
Field IDpersons.participant_open_deals_count
TypeNUMBER
Data Typemetric
Person Participant Closed Deals Count
The person participant closed deals count
Field IDpersons.participant_closed_deals_count
TypeNUMBER
Data Typemetric
Person Email Message Count
The person email message count
Field IDpersons.email_messages_count
TypeNUMBER
Data Typemetric
Person Activities Count
The person activities count
Field IDpersons.activities_count
TypeNUMBER
Data Typemetric
Person Done Activities Count
The person done activities count
Field IDpersons.done_activities_count
TypeNUMBER
Data Typemetric
Person Undone Activities Count
The person Undone Activities count
Field IDpersons.undone_activities_count
TypeNUMBER
Data Typemetric
Person Files Count
The person Files count
Field IDpersons.files_count
TypeNUMBER
Data Typemetric
Person Notes Count
The person Notes count
Field IDpersons.notes_count
TypeNUMBER
Data Typemetric
Person Followers Count
The person Followers count
Field IDpersons.followers_count
TypeNUMBER
Data Typemetric
Person Won Deals Count
The person Won Deals count
Field IDpersons.won_deals_count
TypeNUMBER
Data Typemetric
Person Related Won Deals Count
The person Related Won Deals count
Field IDpersons.related_won_deals_count
TypeNUMBER
Data Typemetric
Person Lost Deals Count
The person Lost Deals count
Field IDpersons.lost_deals_count
TypeNUMBER
Data Typemetric
Person Related Lost Deals Count
The person Related Lost Deals count
Field IDpersons.related_lost_deals_count
TypeNUMBER
Data Typemetric
Person Active Flat
The person Active Flat
Field IDpersons.active_flag
TypeBOOLEAN
Data Typemetric
Person Primary Email
The person Primary Email
Field IDpersons.primary_email
TypeNUMBER
Data Typedimension
Person CC Email
The person CC Email
Field IDpersons.cc_email
TypeNUMBER
Data Typedimension
Person Marketing Status
The person Marketing Status
Field IDpersons.marketing_status
TypeNUMBER
Data Typedimension
Person Update Time
The person Update Time
Field IDpersons.update_time
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Person Add Time
The person Add Time
Field IDpersons.add_time
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Person Last Activity Time
The person Last Activity Time
Field IDpersons.last_activity_date
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Person Last Outgoing Time
The person Last Outgoing Time
Field IDpersons.last_outgoing_mail_time
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Person Last Incoming Mail Time
The person Last Incoming Mail Time
Field IDpersons.last_incoming_mail_time
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Deal Id
Id of a deal.
Field IDdeals.id
TypeNUMBER
Data Typedimension
Deal Organization Id
Organization id of a deal.
Field IDdeals.org_id
TypeNUMBER
Data Typedimension
Deal Title
Title of a deal.
Field IDdeals.title
TypeTEXT
Data Typedimension
Deal Value
Value of a deal.
Field IDdeals.value
TypeNUMBER
Data Typedimension
Deal Currency
Currency of a deal.
Field IDdeals.currency
TypeTEXT
Data Typedimension
Deal Added At
Added date of a deal.
Field IDdeals.add_time
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Deal updated At
Updated date of a deal.
Field IDdeals.update_time
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Deal Stage Change At
Change date of the stage deal.
Field IDdeals.stage_change_time
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Deal Is Active
Return true if the deal is active.
Field IDdeals.active
TypeBOOLEAN
Data Typedimension
Deal Is Deleted
Return true if the deal is deleted.
Field IDdeals.deleted
TypeBOOLEAN
Data Typedimension
Deal Status
Status of the Deal.
Field IDdeals.status
TypeTEXT
Data Typedimension
Deal Probability
Probability of the Deal.
Field IDdeals.probability
TypePERCENT
Data Typedimension
Deal Next Activity Date
Next activity date of the Deal.
Field IDdeals.next_activity_date
TypeYEAR_MONTH_DAY
Data Typedimension
Deal Next Activity Time
Next activity date of the Deal.
Field IDdeals.next_activity_time
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Deal Last Activity Date
Last activity date of the Deal.
Field IDdeals.last_activity_date
TypeYEAR_MONTH_DAY
Data Typedimension
Deal Lost Reason
Reason you lost the Deal.
Field IDdeals.lost_reason
TypeTEXT
Data Typedimension
Deal Visible To
Deal Visibility.
Field IDdeals.visible_to
TypeTEXT
Data Typedimension
Deal Close Time
Time when close Deal.
Field IDdeals.close_time
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Deal Won Time
Time when Deal won.
Field IDdeals.won_time
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Deal First Won Time
Time when Deal first won.
Field IDdeals.first_won_time
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Deal Lost Time
Time when Deal lost.
Field IDdeals.lost_time
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Deal Products Count
Product count associated with Deal.
Field IDdeals.products_count
TypeNUMBER
Data Typedimension
Deal Files Count
Files count associated with Deal.
Field IDdeals.files_count
TypeNUMBER
Data Typedimension
Deal Notes Count
Notes count associated with Deal.
Field IDdeals.notes_count
TypeNUMBER
Data Typedimension
Deal Follower Count
Follower count associated with Deal.
Field IDdeals.followers_count
TypeNUMBER
Data Typedimension
Deal Email Messages Count
Email Messages count associated with Deal.
Field IDdeals.email_messages_count
TypeNUMBER
Data Typedimension
Deal Activities Count
Activities count associated with Deal.
Field IDdeals.activities_count
TypeNUMBER
Data Typedimension
Deal Done Activities Count
Done activities count associated with Deal.
Field IDdeals.done_activities_count
TypeNUMBER
Data Typedimension
Deal Undone Activities Count
Undone activities count associated with Deal.
Field IDdeals.undone_activities_count
TypeNUMBER
Data Typedimension
Deal Participants Count
Participants count associated with Deal.
Field IDdeals.participants_count
TypeNUMBER
Data Typedimension
Deal Expected Close Date
Expected close date of the Deal.
Field IDdeals.expected_close_date
TypeYEAR_MONTH_DAY
Data Typedimension
Deal Last Incoming Mail Time
Last incoming mail time of Deal.
Field IDdeals.last_incoming_mail_time
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Deal Last Outgoing Mail Time
Last outgoing mail time of Deal.
Field IDdeals.last_outgoing_mail_time
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Deal Label
Label of Deal.
Field IDdeals.label
TypeTEXT
Data Typedimension
Deal Stage order Number
Stage order number of Deal.
Field IDdeals.stage_order_nr
TypeNUMBER
Data Typedimension
Deal Person Name
Person name of Deal.
Field IDdeals.person_name
TypeTEXT
Data Typedimension
Deal Organization Name
Organization name of Deal.
Field IDdeals.org_name
TypeTEXT
Data Typedimension
Deal Next Activity Subject
Next activity subject of Deal.
Field IDdeals.next_activity_subject
TypeTEXT
Data Typedimension
Deal Next Type Subject
Next activity type of Deal.
Field IDdeals.next_activity_type
TypeTEXT
Data Typedimension
Deal Next Activity Duration
Next activity duration of Deal.
Field IDdeals.next_activity_duration
TypeDURATION
Data Typedimension
Deal Next Activity Note
Next activity note of Deal.
Field IDdeals.next_activity_note
TypeTEXT
Data Typedimension
Deal Formatted Value
Formatted value of Deal.
Field IDdeals.formatted_value
TypeTEXT
Data Typedimension
Deal Weighted Value
Weighted value of Deal.
Field IDdeals.weighted_value
TypeNUMBER
Data Typedimension
Deal Formatted Weighted Value
Formated and weighted value of Deal.
Field IDdeals.formatted_weighted_value
TypeNUMBER
Data Typedimension
Deal Weighted Value Currency
Weighted value currency of Deal.
Field IDdeals.weighted_value_currency
TypeNUMBER
Data Typedimension
Deal Rotten Time
Time when deal rotten.
Field IDdeals.rotten_time
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Deal Owner Name
Owner name of the deal.
Field IDdeals.owner_name
TypeTEXT
Data Typedimension
Deal CC Email
CC email of the deal.
Field IDdeals.cc_email
TypeTEXT
Data Typedimension
Deal Organization is Hidden
Return true if related organization is hidden.
Field IDdeals.org_hidden
TypeBOOLEAN
Data Typedimension
Deal Person is Hidden
Return true if related person is hidden.
Field IDdeals.person_hidden
TypeBOOLEAN
Data Typedimension
Stage Id
The Stage Id.
Field IDstages.id
TypeNUMBER
Data Typedimension
Stage Order Number
The Stage order number.
Field IDstages.order_nr
TypeNUMBER
Data Typedimension
Stage Name
The Stage name.
Field IDstages.name
TypeTEXT
Data Typedimension
Stage Active Flag
The Stage active flag.
Field IDstages.active_flag
TypeBOOLEAN
Data Typedimension
Stage Deal Probability
The Stage deal probability.
Field IDstages.deal_probability
TypeNUMBER
Data Typedimension
Stage Rotten Flag
The Stage rotten flag.
Field IDstages.rotten_flag
TypeBOOLEAN
Data Typedimension
Stage Rotting Days
The Stage rotting days.
Field IDstages.rotten_days
TypeNUMBER
Data Typedimension
Stage Add Time
The Stage add time.
Field IDstages.add_time
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Stage Update Time
The Stage update time.
Field IDstages.update_time
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Stage Pipeline Deal Probability
The Stage Pipeline Probability.
Field IDstages.pipeline_deal_probability
TypeBOOLEAN
Data Typedimension
Extracted Date
The date where the extraction take times.
Field ID_catchr_date_extract
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Platform Name
Return the platform name
Field ID_catchr_platform_name
TypeTEXT
Data Typedimension