Below are the descriptions of the various dimensions of the opportunity entity. These dimensions are available in all three BI widgets of the Marketing Performance module, as listed below:
BI - Bar Chart
BI - Trend Chart
BI - Cross Table
Opportunity Entity Dimensions
Please note that:
The quarters are based on the calendar config.
‘Funnel' refers to the RevSure funnel
Dimension/Metric | Definition |
Opportunity Sources | The CRM/source system for the opportunity |
Opportunity Close Date Quarter Year | The quarter and year in which the opportunity is marked closed. It is in the format of QQ-YYYY. |
Company Size Bucket | Account’s company-size bucket |
Opportunity Num Activities Bucket | A bucket based on the number of activities associated to an opportunity. E.g., 1-5, 5-10, 10+, etc. |
Revsure Lead Original Source | This is the first channel that has touched a lead/opp |
Lead LinkedIn Touched | If a lead has engaged with any LinkedIn campaign in its journey, then this value is ‘true’. Else, it is ‘false’. |
Revsure Funnel Previous Status | The previous stage that the lead belonged to in the RevSure funnel |
Lead Last Gtm Activity Name | Name of the last GTM activity associated with a lead |
Revsure Funnel Entered Stage | The stage at which the lead entered the Revsure funnel |
Lead With Open Opportunity | This is 'True' if the lead is associated with an open opportunity. Else, it is 'False'. |
Lead Created Date Quarter Year | The quarter and year in which the lead is created. It is in the format of QQ-YYYY. |
First Activity | The first activity associated with the lead |
Lead Last Gtm Contact Activity Name | Name of the last GTM contact activity associated with a lead |
Account Last Activity Name | Name of the latest activity across all leads associated with an account |
Opportunity Last Touch Campaign Type | The type of the newest campaign that an opportunity touched |
Lead Last Contact Activity Name | Name of the newest contact activity associated with a lead |
Pipeline Conversion Probability Overall Bucket | The bucket name is based on the pipeline conversion probability (High/Medium/Low) |
Lead With No Engagements Within Last 30 Days | This is 'True' if the lead had no engagements in the last 30 days. Else, it is 'False'. |
Lead Num Activities Bucket | A bucket based on the number of activities associated with a lead. E.g., 1-5, 5-10, 10+, etc. |
Opportunity Status | Status of the opportunity from the source system |
Lead First Gtm Contact Activity Contact Name | The name of a lead's first GTM activity |
Opportunity Opportunity Source | The channel that generated the opportunity |
Opportunity Value Iso Raw | Value associated with an opportunity |
Last Activity | The latest activity associated with an opportunity |
Lead Unique Campaign Sequence | This contains a list of all unique campaigns in the order of their first touch |
Account First Gtm Contact Activity Name | Name of the first GTM contact activity associated with an opportunity |
Latest Opportunity Close Date Quarter | The latest value of the close date quarter associated with an opportunity. It is in the format of QQ. The quarters are based on the calendar config. |
Lead With No Engagements Within Last 7 Days | This is 'True' if the lead had no engagements in the last 7 days. Else, it is 'False'. |
Opportunity First Activity | The name of the first activity associated with an opportunity |
Opportunity Close Date Quarter | The quarter for the close date of an opportunity |
Region | Account's region |
Funnel Entrypoint | The stage where the lead entered the funnel |
Lead First Activity Contact Name | Name of the contact associated with the first activity of a lead |
Lead With Engagements | This is 'True' if the lead has any engagement(s) associated with it. Else, it is 'False'. |
Latest Opportunity Stage | The latest stage of an opportunity |
Created Stage Quarter Year | As a lead progresses through the various stages of the RevSure funnel, the quarter and year when a lead enters any stage for the first time are stored in this data dimension. It is in the format of QQ-YYYY. The quarters are based on the calendar config. |
Opportunity Num Campaigns Bucket | A bucket based on the number of campaigns touched by an opportunity. E.g., 1-5, 5-10, 10+, etc. |
Lead Started As Visitor | This is 'True' if the lead started as a visitor before becoming a lead in the funnel. Else, it is 'False'. |
Revsure Funnel Entered Status | Status of a lead from the source system when it entered the RevSure funnel for the first time. |
Lead Meta Touched | If a lead has engaged with any Meta (Facebook) campaign in its journey, then this value is ‘true’. Else, it is ‘false’. |
Opportunity Type | Type of the opportunity mapped to the CRM |
Lead First Gtm Contact Activity Name | Name of the first GTM contact activity associated with a lead |
Booking Conversion Probability Overall Bucket | The bucket name is based on the booking conversion probability (High/Medium/Low) |
Lead First Activity Name | The name of the first activity associated with a lead |
Lead First Gtm Activity Name | The name of the first GTM activity associated with a lead |
Lead Last Activity Contact Name | Name of the contact associated with the latest activity of a lead |
Account Last Gtm Contact Activity Contact Name | Name of the contact for the latest GTM contact activity across all leads associated with an account |
Account First Activity Contact Name | Name of the contact who performed the first activity across all leads associated with an account |
Account Last Gtm Contact Activity Owner Name | Name of the activity owner, across all leads associated with an account, who performed the latest GTM contact activity |
Revsure Funnel Entered Stage Id | Unique ID of the stage where the lead first entered the RevSure funnel |
Opportunity CURRENCY | Currency for the opportunity value |
Lead Last Activity Name | Name of the latest activity associated with a lead |
Revsure Lead Latest Source | The latest channel from which the lead was generated |
Lead Last Touch Channel | The channel associated with a lead's last touch (for a campaign) |
Account First Gtm Contact Activity Contact Name | The name of a lead, across all leads of an account, who performed the first GTM contact activity |
Lead Google Touched | If a lead has engaged with any Google campaign in its journey, then this value is ‘true’. Else, it is ‘false’. |
Opportunity Last Touch Campaign Source System | Name of the source system based on the opportunity's last touch campaign |
Metric Entity Type | Type of the entity in the RevSure data model (Lead/Opportunity/Account/Internal user) |
Lead With Closedwon Opportunity | This is 'True' if the lead had a closed won opportunity associated with it. Else, it is 'False'. |
Opportunity Number Of Contacts Bucket | A bucket based on the number of contacts associated with an opportunity. E.g., 1-5, 5-10, 10+, etc. |
Opportunity Entrypoint | The first stage of the funnel is where an opportunity enters |
Lead First Contact Activity Name | The name of the first contact activity associated with a lead |
Lead With Opportunity | If a lead is associated with an opportunity, then this value is 'true'. Else, it is 'false'. |
Opportunity Entrypoint Stage | The first stage of the funnel is where an opportunity enters |
Account Last Activity Contact Name | Contact name of the lead who performed the last/latest activity among all the leads associated with an account |
Lead First Campaign Touch Type | This is the type of campaign that was a lead’s first campaign touch in its journey |
Opportunity Channel | The first stage of the funnel is where an opportunity enters |
Current Status | The current status of an opportunity from the CRM |
Lead Last Gtm Contact Activity Contact Name | Name of the contact for the latest GTM contact activity of a lead |
Lead With Activities | If a lead has at least 1 activity associated with it, then this value is 'true'. Else, it is 'false'. |
Revsure Account Latest Source | The campaign type that generated the latest lead, among all leads, is associated with an account |
Account Current Activity Stage Group | The RevSure stage group for the latest activity across all leads of an account |
Lead Unique Campaign Sequence Till Stage | List of unique campaign touches in a lead’s journey till it entered the current stage |
Lead Num Campaigns Bucket | Buckets for leads based on the number of campaigns they have touched |
Opportunity Last Activity | The latest activity associated with an opportunity |
Forecast Category | Forecast category of the opportunity in the source system |
Pipeline Creation Quarter Year | It is the quarter and year when the pipeline was first created. It is in the format QQ-YYYY. |
Lead First Touch Channel | The channel associated with a lead's first campaign touch |
Funnel Entrypoint Stage | The first stage of the funnel, in which a lead enters |
Lead Entrypoint | The first stage of the funnel, in which a lead enters |
Opportunity Fiscal Period | Fiscal period associated with an opportunity in the CRM |
Lead Digital Paid Touched | The paid campaigns (LinkedIn, Meta, Google Ads) touched by a lead |
Opportunity Primary Contact Id | Unique ID of the primary contact associated with an opportunity |
Account Last Gtm Contact Activity Name | Activity name of the last activity performed by any of the leads associated with an account |
Account Unique Campaign Sequence Till Stage | List of unique campaign touches in an account's journey till it entered the current stage |
Account First Activity Name | Name of the first activity across all leads of an account |
Lead Last Campaign Touch Type | The type of the campaign that was the last touchpoint for a lead |
Opportunity Created Date Quarter | The quarter in which the opportunity is created. It is in the format of QQ. |
Visitor First UTM Content | The first content that a visitor was exposed to |
Opportunity Created Date Quarter Year | The quarter and year in which the lead is created. It is in the format of QQ-YYYY. |
Latest Opportunity Close Date Quarter Year | The latest value of the close date (quarter and year) associated with an opportunity. It is in the format of QQ-YYYY. |
Funnel Lead Source | It is the channel that generated a lead in the funnel |
Opportunity First Touch Campaign Type | The type of the first campaign that an opportunity touched |
Lead Entrypoint Stage | The state from the source system that was recorded when a lead entered the funnel |
Lead Last Gtm Contact Activity Owner Name | Name of the contact/owner who performed the latest GTM contact for a lead |
Previous Stage Label | The name/label of the stage from which a lead moved to the current stage |
Opportunity First Touch Campaign Source System | Name of the source system based on an opportunity's first touch campaign |
Account Unique Campaign Sequence | List of the campaigns directly engaged with an account or engaged with any of the contacts associated with the account |
Opportunity Stage | The stage of opportunity in the CRM |