All the historical Opportunities captured in Revsure with their associated attributes like $ Value, Close Date, Latest Stage etc. Includes all Open and Closed Opportunities.
Name | Label | Type | Description |
opportunity_id | Opportunity ID | STRING | Unique RevSure ID for the Opportunity |
sfdc_opportunity_id | Sfdc Opportunity ID | STRING | Unique SFDC Source ID for the Opportunity |
opportunity_name | Opportunity Name | STRING | Name 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_pipe_created_at | Opportunity Pipeline Created At | TIMESTAMP | Time at which the Opportunity first moved to the Pipeline stage (Qualified Pipeline) |
opportunity_close_date | Opportunity Close Date | DATE | Close Date assigned to the Opportunity |
opportunity_value | Opportunity Value | NUMERIC | Currency Value of the Opportunity |
funnel_lead_source | Funnel Lead Source | STRING | Lead Source assigned to the Opportunity as mapped in the source system |
opportunity_type | Opportunity Type | STRING | Type of the Opportunity |
num_activities | Number of Activities | INT64 | Number of activities the Opportunity is associated with. Activities include meetings, emails etc. |
num_campaign_touches | Number of Campaign Touches | INT64 | Number of campaign touches the Opportunity is associated with. |
duration_in_pipelinestage1 | Duration In Pipelinestage1 | INT64 | Days the Opportunity spent in pipeline stage 1 as per RevSure funnel config |
duration_in_pipelinestage2 | Duration In Pipelinestage2 | INT64 | Days the Opportunity spent in pipeline stage 2 as per RevSure funnel config |
duration_in_pipelinestage3 | Duration In Pipelinestage3 | INT64 | Days the Opportunity spent in pipeline stage 3 as per RevSure funnel config |
duration_in_pipelinestage4 | Duration In Pipelinestage4 | INT64 | Days the Opportunity spent in pipeline stage 4 as per RevSure funnel config |
opportunity_age | Opportunity Age | INT64 | Days since the Opportunity record was created in the source system |