Pipeline details for the last 8 quarters based on the open pipeline at the end of each quarter.
Name | Label | Type | Description |
opportunity_id | Opportunity ID | STRING | Unique Revsure ID of the Opportunity |
opportunity_name | Opportunity Name | STRING | Name of the Opportunity |
opportunity_value | Opportunity Value | NUMERIC | Currency Value of the Opportunity |
opportunity_stage | Opportunity Stage | STRING | Funnel Stage of the Opportunity |
opportunity_type | Opportunity Type | STRING | Type of the Opportunity |
opportunity_src_created_at | Opportunity Source Created At | TIMESTAMP | Time at which the Opportunity record was created in the source system |
opportunity_close_date | Opportunity Close Date | DATE | Close Date assigned to the Opportunity |
activity_stage_grp | Activity Stage Group | STRING | RevSure Funnel Stage ID. E.g: Stage1, Stage2 etc |
opportunity_close_date_quarter_year | Opportunity Close Date Quarter Year | STRING | Financial Quarter of OpportunityCloseDate. |
num_campaigns | Number of Campaigns | INT64 | Number of activities the Opportunity is associated with. Activities include meetings, emails etc. |
num_activities | Number of Activities | INT64 | Number of campaign touches the Opportunity is associated with. |
opportunity_age | Opportunity Age | FLOAT64 | Days since the Opportunity record was created in the source system |
duration_in_pipelinestage1 | Duration In Pipeline Stage1 | INT64 | Days the Opportunity spent in pipeline stage 1 as per RevSure funnel config |
duration_in_pipelinestage2 | Duration In Pipeline Stage2 | INT64 | Days the Opportunity spent in pipeline stage 2 as per RevSure funnel config |
duration_in_pipelinestage3 | Duration In Pipeline Stage3 | INT64 | Days the Opportunity spent in pipeline stage 3 as per RevSure funnel config |
duration_in_pipelinestage4 | Duration In Pipeline Stage4 | INT64 | Days the Opportunity spent in pipeline stage 4 as per RevSure funnel config |
funnel_lead_source | Funnel Lead Source | STRING | Lead Source of the Opportunity |
booking_prob_q0 | Booking Prob Q0 | FLOAT64 | Probability of the Opportunity to convert to Closed Won in Q+0 quarter |
booking_prob_q1 | Booking Prob Q1 | FLOAT64 | Probability of the Opportunity to convert to Closed Won in Q+1 quarter |
booking_prob_q2 | Booking Prob Q2 | FLOAT64 | Probability of the Opportunity to convert to Closed Won in Q+2 quarter |
booking_prob_q3 | Booking Prob Q3 | FLOAT64 | Probability of the Opportunity to convert to Closed Won in Q+3 quarter |
conversion_overall | Conversion Overall | FLOAT64 | Overall Probability of the Opportunity to convert to Closed Won any time |
closed_won_opp_id | Closed Won Opp ID | STRING | RevSure Opportunity Id if the Opportunity is in the Closed Won stage, otherwise Null |