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