All the open leads in the system in various stages as per the funnel configuration defined in RevSure. Contains key lead level attributes like Job Title, Lead Source, Account name etc. List of attributes included in the dataset is configurable.
Name | Label | Type | Description |
LeadID | Lead ID | STRING | Unique Revsure ID of the Lead |
OpportunityID | Opportunity ID | STRING | Unique Revsure ID of the Opportunity |
AccountID | Account ID | STRING | Unique Revsure ID of the Account |
AccountName | Account Name | STRING | Name of the Account |
OpportunitySourceId | Opportunity Source ID | STRING | Unique Source ID of the Opportunity |
LeadSourceId | Lead Source ID | STRING | Unique Source ID of the Lead |
LeadSourcesystem | Lead Source System | STRING | Source system for the Lead record |
OpportunitySourcesystem | Opportunity Source System | STRING | Source system for the Opportunity record |
PersonName | Person Name | STRING | Name of the Lead |
OpportunityValue | Opportunity Value | NUMERIC | Currency Value of the Opportunity |
OpportunityCloseDate | Opportunity Close Date | DATE | Close Date assigned to the Opportunity |
FunnelActivityTimestamp | Funnel Activity Timestamp | TIMESTAMP | Time when the latest status change happened on the Lead |
FunnelActivityDate | Funnel Activity Date | DATETIME | Date when the latest status change happened on the Lead |
CreatedStageTimestamp | Created Stage Timestamp | TIMESTAMP | Time when the Lead entered the current RevSure funnel stage |
StageCreatedDate | Stage Created Date | DATETIME | Date when the Lead entered the current RevSure funnel stage |
PipelineConversionProbabilityQ0 | Pipeline Conversion Probability Q0 | FLOAT64 | Probability of the Lead to convert to Pipeline in Q+0 quarter |
PipelineConversionProbabilityQ1 | Pipeline Conversion Probability Q1 | FLOAT64 | Probability of the Lead to convert to Pipeline in Q+1 quarter |
PipelineConversionProbabilityQ2 | Pipeline Conversion Probability Q2 | FLOAT64 | Probability of the Lead to convert to Pipeline in Q+2 quarter |
PipelineConversionProbabilityQ3 | Pipeline Conversion Probability Q3 | FLOAT64 | Probability of the Lead to convert to Pipeline in Q+3 quarter |
ProjectedPipelineValueQ0 | Projected Pipeline Value Q0 | FLOAT64 | Projected Pipeline Currency Value of the Lead in Q+0 quarter |
ProjectedPipelineValueQ1 | Projected Pipeline Value Q1 | FLOAT64 | Projected Pipeline Currency Value of the Lead in Q+1 quarter |
ProjectedPipelineValueQ2 | Projected Pipeline Value Q2 | FLOAT64 | Projected Pipeline Currency Value of the Lead in Q+2 quarter |
ProjectedPipelineValueQ3 | Projected Pipeline Value Q3 | FLOAT64 | Projected Pipeline Currency Value of the Lead in Q+3 quarter |
BookingConversionProbabilityQ0 | Booking Conversion Probability Q0 | FLOAT64 | Probability of the Lead to convert to Closed Won in Q+0 quarter |
BookingConversionProbabilityQ1 | Booking Conversion Probability Q1 | FLOAT64 | Probability of the Lead to convert to Closed Won in Q+1 quarter |
BookingConversionProbabilityQ2 | Booking Conversion Probability Q2 | FLOAT64 | Probability of the Lead to convert to Closed Won in Q+2 quarter |
BookingConversionProbabilityQ3 | Booking Conversion Probability Q3 | FLOAT64 | Probability of the Lead to convert to Closed Won in Q+3 quarter |
ProjectedBookingValueQ0 | Projected Booking Value Q0 | FLOAT64 | Projected Closed Won Currency Value of the Lead in Q+0 quarter |
ProjectedBookingValueQ1 | Projected Booking Value Q1 | FLOAT64 | Projected Closed Won Currency Value of the Lead in Q+1 quarter |
ProjectedBookingValueQ2 | Projected Booking Value Q2 | FLOAT64 | Projected Closed Won Currency Value of the Lead in Q+2 quarter |
ProjectedBookingValueQ3 | Projected Booking Value Q3 | FLOAT64 | Projected Closed Won Currency Value of the Lead in Q+3 quarter |
StageID | Stage ID | STRING | RevSure funnel stage ID. E.g: stage1, stage2 etc |
StageName | Stage Name | STRING | RevSure funnel stage name. E.g: Lead, MQL etc |
OpportunityType | Opportunity Type | STRING | Type of the latest Opportunity the lead is associated with. |
CompanySizeBucket | Company Size Bucket | STRING | Lead's Company Size Bucket |
FunnelLeadSource | Funnel Lead Source | STRING | Lead Source of the Lead as mapped from the source |
AccountIndustry | Account Industry | STRING | Industry of the Account the Lead is associated with. |