Introduction
Derived dimensions are those which are based on the standard data dimensions in RevSure’s data model. These are computed in the metrics layer and are stored in the metric store.
List of Derived Dimensions
Dimension Name | Description | RevSure Entity |
Account Existing Customer Account | It indicated if there has been at least one associated opportunity, which is in 'Closed Won' status | Account |
Last Touch Ts | The latest touch campaign date across all the leads associated with the account | Account, Opportunity, Visitor, and Lead |
First Touch Ts | The very first touch campaign date across all the leads associated with the account | Account, Opportunity, Visitor, and Lead |
Number Of Unique Campaign Touches | Total number of unique campaigns that have been touched | Account, Opportunity, Visitor and Lead |
Number Of Campaign Touches | Total number of campaigns that have been touched | Account, Opportunity, Visitor and Lead |
Account Number Of Activities | The total number of activity IDs count across all the leads associated with the account | Account |
Account Last Activity Ts | The latest activity date across all the leads associated with the account | Account |
Account First Activity Ts | The very first activity date across all the leads associated with the account | Account |
Lead Velocity Till Stage | Time taken by the lead since inception ('src_created_at') to move into the stage | Lead |
Opportunity Velocity Till Stage | Time taken by the opportunity ('src_created_at') since inception to move into the stage | Opportunity |
Funnel Velocity Till Stage (Primary Contact) | For leads: Time taken by the lead since inception ('src_created_at') to move into the stage | Opportunity and Lead |
Lead Velocity Till Stage First Creation | Time taken by the the lead since inception ('src_created_at') to move into stage for the first time | Lead |
Opportunity Velocity Till Stage First Creation | Time taken by the opportunity ('src_created_at') since inception to move into a stage for the first time | Opportunity |
Funnel Velocity Till Stage First Creation | For leads: Time taken by the lead since inception ('src_created_at') to move into a stage for the first time | Opportunity and Lead |
Lead Age | Time spent by the lead in the funnel since inception ('src_created_at') | Lead |
Opportunity Age | Time spent by the opportunity in the funnel since inception ('src_created_at') | Opportunity |
Account Age | Time spent by the account in the funnel since inception ('src_created_at') | Account |
Lead Duration | Time taken by the the lead in its most recent stage | Lead |
Opportunity Duration | Time taken by the the opportunity in its most recent stage | Opportunity |
Account Duration | Time taken by the the account in its most recent stage | Account |
Opportunity Velocity Till State | Time taken by the opportunity ('src_created_at') since inception to move into the state | Opportunity |
Account Velocity Till State | For leads: Time taken by the lead since inception ('src_created_at') to move into the state | Account |
Funnel Velocity Till State | For leads: Time taken by the lead since inception ('src_created_at') to move into the state | Opportunity and Lead |
Lead Unique Campaign Sequence | This contains a list of all unique campaigns in the order of their first touch | Lead |
Account With No Engagement | Account with no engagement (Y/N) | Account |
Account With No Activity Within Last X Days | Account with no funnel activity ts within a given date range (Y/N) | Account |
No Of Contact Activities Till Stage | Number of activities performed by open contacts in the account till the current stage | Account, Opportunity and Lead |
No Of GTM Activities Till Stage | Number of activities performed by marketing/sales teams on the account till the current stage | Account, Opportunity and Lead |
Last Contact Activity | Name of last activity performed by a contact associated with the account | Account, Opportunity and Lead |
Last Contact Activity’s Contact Name | Name of contact that performed the last activity associated with the account | Account, Opportunity and Lead |
Last Contact Activity Time | Time of last activity performed by a contact associated with the account | Account, Opportunity and Lead |
Last GTM Activity | Name of last GTM activity performed by marketing/sales on the account | Account, Opportunity and Lead |
Last GTM Activity’s Owner Name | Name of marketing/sales person that performed the last GTM activity on the account | Account, Opportunity and Lead |
Last GTM Activity Time | Time of last GTM activity performed by marketing/sales on the account | Account, Opportunity and Lead |
First Contact Activity | Name of first activity performed by a contact associated with the account | Account, Opportunity and Lead |
First Contact Activity’s Contact Name | Name of contact that performed the first activity associated with the account | Account, Opportunity and Lead |
First Contact Activity Time | Time of first activity performed by a contact associated with the account | Account, Opportunity and Lead |
First GTM Activity | Name of first GTM activity performed by marketing/sales on the account | Account, Opportunity and Lead |
First GTM Contact Activity’s Contact Name | Name of marketing/sales person who performed the first GTM activity on the account | Account, Opportunity and Lead |
First GTM Activity Time | Time of first GTM activity performed by marketing/sales on the account | Account, Opportunity and Lead |
No. Of Campaign Touches Till Stage | Count of campaign touches with the account till the current stage. E.g., if a campaign touched an account twice, it’d be counted as 2. | Account, Opportunity and Lead |
No. Of Unique Campaigns Touched Till Stage | Count of unique campaigns that have touched the account till the current stage. E.g., if a campaign touched an account twice, it’d be counted as 1. | Account, Opportunity and Lead |
Unique Campaigns Touched Till Stage | The sequence of unique campaigns that touched the account till current stage | Account, Opportunity and Lead |
First Touch Campaign | Name of the first touch campaign | Account, Opportunity, Visitor and Lead |
Last Touch Campaign | Name of the last touch campaign | Account, Opportunity, Visitor and Lead |
First Touch Channel | The channel associated with the first campaign touch | Account, Opportunity, Visitor and Lead |
Last Touch Channel | The channel associated with the last campaign touch | Account, Opportunity, Visitor and Lead |
Status | Account’s current funnel status or state | Account, Opportunity and Lead |
Previous Status | Account’s previous funnel status or state | Account, Opportunity and Lead |
Previous Stage | Account’s previous funnel stage | Account, Opportunity and Lead |
Stage | Account’s current funnel stage | Account, Opportunity and Lead |
Created Date | Account’s created date. It is configurable. | Account, Opportunity and Lead |
Region | Account’s region | Account, Opportunity and Lead |
Country | Account’s country | Account, Opportunity and Lead |
Company Size Bucket | Account’s company-size bucket | Account, Opportunity and Lead |
Company Size | Account’s company size | Account, Opportunity and Lead |
Industry | Account’s industry | Account, Opportunity and Lead |
Booking Conversion Probability Q0 | Account’s booking conversion propensity for the current quarter | Account, Opportunity and Lead |
Booking Conversion Probability Q1 | Account’s booking conversion propensity for the next quarter | Account, Opportunity and Lead |
Booking Conversion Probability Q2 | Account’s booking conversion propensity for the current quarter + 2 | Account, Opportunity and Lead |
Booking Conversion Probability Q3 | Account’s booking conversion propensity for the current quarter + 3 | Account, Opportunity and Lead |
Pipeline Conversion Probability Q0 | Account’s pipeline conversion propensity for the current quarter | Account, Opportunity and Lead |
Pipeline Conversion Probability Q1 | Account’s pipeline conversion propensity for the next quarter | Account, Opportunity and Lead |
Pipeline Conversion Probability Q2 | Account’s pipeline conversion propensity for the current quarter + 2 | Account, Opportunity and Lead |
Pipeline Conversion Probability Q3 | Account’s pipeline conversion propensity for the current quarter + 3 | Account, Opportunity and Lead |
Number Of Open Leads | Count of active leads/contacts associated with the account. These are the leads/contacts which are not marked as customers or leaked. | Account |
Number Of Open Opportunities | Count of active opportunities associated with the account. These are the opportunities which are not marked as customer or leaked. | Account |
Number Of Leads | Count of all leads/contacts associated with the account | Account |
Number Of Opportunities | Count of all opportunities associated with the account | Account |
RevSure Original Source | This is the first channel that has touched a lead/opp | Lead, Opportunity |
RevSure Original Source Detail | This is the first campaign name that has touched a lead/opp | Lead, Opportunity |
Campaign Combination List | List of all the campaign names that touched a lead/opp | Lead, Opportunity, Account |
Campaign Type Combination List | List of all the campaign types that touched a lead/opp | Lead, Opportunity, Account |
Campaign Channel Combination List | List of all the campaign channels that touched a lead/opp | Lead, Opportunity |
Lead Digital Paid Touched | If a lead has engaged with any digital campaign (LinkedIn/Meta/Google) in its journey, then this value is ‘true’, else it is ‘false’. | Lead |
Lead LinkedIn Touched | If a lead has engaged with any LinkedIn campaign in its journey, then this value is ‘true’, else it is ‘false’. | Lead |
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’. | Lead |
Lead Google Touched | If a lead has engaged with any Google campaign in its journey, then this value is ‘true’, else it is ‘false’. | Lead |
Account Digital Paid Touched | If an account has engaged with any digital campaign (LinkedIn/Meta/Google) in its journey, then this value is ‘true’, else it is ‘false’. Even if one of the leads/contacts associated with the account is Digital Paid Touched, the Account will be considered ‘True’ | Account |
Account LinkedIn Touched | If an account has engaged with any LinkedIn campaign in its journey, then this value is ‘true’, else it is ‘false’. Even if one of the leads/contacts associated with the account is LinkedIn Touched, the Account will be considered ‘True’ | Account |
Account Meta Touched | If an account has engaged with any Meta (Facebook) campaign in its journey, then this value is ‘true’, else it is ‘false’. Even if one of the leads/contacts associated with the account is Meta Touched, the Account will be considered ‘True’ | Account |
Account Google Touched | If an account has engaged with any Google campaign in its journey, then this value is ‘true’, else it is ‘false’. Even if one of the leads/contacts associated with the account is Google Touched, the Account will be considered ‘True’ | Account |
Opportunity Digital Paid Touched | If an Opportunity has engaged with any digital campaign (LinkedIn/Meta/Google) in its journey, then this value is ‘true’, else it is ‘false’. Even if one of the leads/contacts associated with the Opportunity is Digital Paid Touched, the Opportunity will be considered ‘True’ | Opportunity |
Opportunity LinkedIn Touched | If an Opportunity has engaged with any LinkedIn campaign in its journey, then this value is ‘true’, else it is ‘false’. Even if one of the leads/contacts associated with the Opportunity is LinkedIn Touched, the Opportunity will be considered ‘True’ | Opportunity |
Opportunity Meta Touched | If an Opportunity has engaged with any Meta (Facebook) campaign in its journey, then this value is ‘true’, else it is ‘false’. Even if one of the leads/contacts associated with the Opportunity is Meta Touched, the Opportunity will be considered ‘True’ | Opportunity |
Opportunity Google Touched | If an Opportunity has engaged with any Google campaign in its journey, then this value is ‘true’, else it is ‘false’. Even if one of the leads/contacts associated with the Opportunity is Google Touched, the Opportunity will be considered ‘True’ | Opportunity |
Account With Open Opportunity | This is 'True' if the account has at least one open opportunity. Else, it is 'False'. | Account |
Account With Open Opportunity | This is 'True' if the account has at least one open opportunity. Else, it is 'False'. | Account |
Account With Activities | This is 'True' if the account has at least one activity across all its leads. Else, it is 'False'. | Account |
Account With Closedwon Opportunity | This is 'True' if an account has a closed won opportunity associated with it. Else, it is 'False'. | Account |
Entrypoint | The first stage of the funner in which a lead/opportunity enters | Lead and Opportunity |
Entrypoint Stage | The first stage of the funnel in which a lead/ opportunity enters | Lead and Opportunity |
Created Date Quarter Year | The quarter and year in which the lead/opportunity is created. It is in the format of QQ-YYYY. | Lead and Opportunity |
Traffic Type | Traffic type associated with the activity like Paid, Organic, and Mixed | Activity |
Campaign Member Email Sent | If the associated activity type is in ('Send Email' (Marketo) or ‘Marketing Email Sent’ (Hubspot)), this flag is set to True. Else, it is False. | Campaign Member |
Campaign Member Email Delivered | If the associated activity type is in ('Email Delivered' (Marketo) or ‘Marketing Email Delivered’ (Hubspot)), this flag is set to True. Else, it is False. | Campaign Member |
Campaign Member Email Opened | If the associated activity type is in ('Open Email' (Marketo) or ‘Marketing Email Open’ (Hubspot)), this flag is set to True. Else, it is False. | Campaign Member |
First Visited URL | The first visited webpage URL by an entity | Lead, Visitor, Account |
First Visited Page | The first visited webpage by an entity | Lead, Visitor, Account |
First Visited Page Type | The inferred type of the first visited webpage by an entity | Lead, Visitor, Account |
First Visited Page Type Intent | The inferred intent of the first webpage type visited by an entity | Lead, Visitor, Account |
First Visited Timestamp | The timestamp of the first webpage visit associated with an entity | Lead, Visitor, Account |
Last Visited URL | The last visited webpage URL by an entity | Lead, Visitor, Account |
Last Visited Page | The last visited webpage by an entity | Lead, Visitor, Account |
Last Visited Page Type | The inferred type of the last visited webpage by an entity | Lead, Visitor, Account |
Last Visited Page Type Intent | The inferred intent of the last visited webpage type by an entity | Lead, Visitor, Account |
Last Visited Timestamp | The timestamp of the last webpage visit associated with an entity | Lead, Visitor, Account |
Most Visited URL | The most visited webpage URL by an entity | Lead, Visitor, Account |
Most Visited Page | The most visited webpage by an entity | Lead, Visitor, Account |
Most Visited Page Type | The inferred type of the most visited webpage by an entity | Lead, Visitor, Account |
Most Visited Page Type Intent | The inferred intent of the most webpage type visited by an entity | Lead, Visitor, Account |
Pages Visited List | The list of all visited webpage by an entity | Lead, Visitor |
Page Types Visited List | The list of all visited webpage types by an entity | Lead, Visitor, Account |
Page Types Intent Visited List | The list of all visited webpage type intents by an entity | Lead, Visitor, Account |
UTM Sources List | A list of all UTM source tags linked to the entity | Lead, Visitor |
UTM Campaigns List | A list of all UTM campaign tags linked to the entity | Lead, Visitor |
UTM Contents List | A list of all UTM content tags linked to the entity | Lead, Visitor |
UTM Mediums List | A list of all UTM medium tags linked to the entity | Lead, Visitor |
UTM Terms List | A list of all UTM term tags linked to the entity | Lead, Visitor |
Latest GCLID | The most recent Google Click ID associated with the entity | Lead |
Latest GCLID Timestamp | The timestamp of the most recent Google Click ID interaction associated with the entity | Lead |
GCLIDs List | The list of all Google Click IDs associated with the entity | Lead |
FBCLIDs List | The list of all Facebook Click IDs linked to the entity | Lead |
LI_FAT_IDs List | The list of all LinkedIn FAT IDs linked to the entity | Lead |
GCLID Count | The total number of Google Click IDs recorded for the entity | Visitor |
FBCLID Count | The total number of Facebook Click IDs recorded for the entity | Visitor |
LI_FAT_ID Count | The total number of LinkedIn FAT IDs recorded for the entity | Visitor |
Page Visited URL List | The list of all visited webpage URLs by the entity | Visitor, Account |
Activity Ad Id | Ad Id of the activity | Activity |
Activity Campaign Name | Campaign name associated with the activity | Activity |
Activity Account ID | Account ID for the activity | Activity |
Activity Account Name | Account Name associated with the activity | Activity |
Activity Engaged | If the activity was engaged with, then this is 'True’. Else it is ‘False’. | Activity |
Activity Form Id | Form Id of the Activity | Activity |
Activity Name | Name of the activity | Activity |
Activity Opportunity Id | Opportunity ID associated with the activity | Activity |
Activity Outreach Sequence Name | Outreach sequence name associated with the activity | Activity |
Activity Session Id | Session Id for the activity | Activity |
Activity Salesloft Cadence Name | Name of the Cadence from Salesloft | Activity |
Activity Source System | Source system name for the activity | |
Activity Traffic Type | Traffic type associated with the activity | |
Ad Ad Group Budget ISO Code | ISO code for the ad group budget | Ad |
Ad Ad Group Budget Raw | Raw budget value for the ad group | Ad |
Ad Ad Group Budget Iso Raw | Raw ISO value of the budget for the ad group | Ad |
Ad Source System | Source system name for the ad | Ad |
Ad Total Cost Iso Raw | Raw ISO value of the total cost for an ad | Ad |
Ad Total Cost ISO Code | ISO code for the total cost of the ad | Ad |
Ad Total Cost Raw | Raw value of the total cost associated with an ad | Ad |
Campaign Actual Cost Raw | Raw value of the actual cost for a campaign | Campaign |
Campaign Budgeted Cost Iso Raw | Raw ISO value of the budgeted cost for a campaign | Campaign |
Campaign Channel | Channel for a campaign | Campaign |
Campaign_member Visitor Id | Visitor ID associated with campaign_member | Campaign |
Campaign Daily Budget Iso Raw | Daily spend budget of the campaign | Campaign |
Campaign Impressions | Total number of impressions generated by a campaign | Campaign |
Campaign_member UTM Content | UTM content associated with the campaign_member | Campaign_Member |
Account Age In Revsure Funnel | Time spent by an account since it first entered the Revsure funnel | Account |
Campaign Parent Campaign Name | Name of the immediate parent of a campaign | Campaign |
Campaign Owner Team | Name of the team that owns the campaign | Campaign |
Campaign Form List | List of forms associated with a campaign | Campaign |
Campaign Member Activity Id | Activity ID associated with a campaign member | Campaign |
Campaign Parent Campaign Properties | Properties asscoiated with the parent campaign | Campaign |
Campaign_member UTM Medium | UTM medium associated with the campaign_member | Campaign |
Campaign_member Account Id | Account ID of the account associated with the campaign member | Campaign |
Campaign Owner Name | Name of the owner of the campaign | Campaign |
Account ENR CURRENT TECHNOLOGIES | Account enriched with data about current technologies | Account |
Account ENR ANNUAL REVENUE | Enriched data for the annual revenue of an account | Account |
Campaign Referrer | Referrer of the campaign | Campaign |
Campaign Top Parent Campaign Name | Name of the top parent of a campaign | Campaign |
Campaign Teams | Teams associated with the campaign | Campaign |
Account ENR FACEBOOK URL | Account info enriched with its Facebook (Meta) URL | Account |
Campaign Owner Username | Username for the owner of the campaign | Campaign |
Account ENR DOMAIN | Acccount data enriched with domain info | Account |
Campaign Parent Campaign Id | ID of the parent campaign of a campaign | Campaign |
Account Email | The email ID associated with an account | Account |
Member Lead Id | Lead ID associated with a campaign member | Revsure_default |
Campaign_member Lead Id | Lead ID of the campaign member | Campaign_Member |
Account ENR ANNUAL REVENUE PRINTED | Enriched annual revenue | Account |
Campaign Revsure Channel | The RevSure channel mapped to a campaign | Campaign |
Campaign Targeting Criteria | Criteria for the target audience of the campaign | Campaign |
Account ENR DEPARTMENTAL HEAD COUNT | Enriched departmental headcount of an account | Account |
Account Annual Revenue Iso Raw | Raw ISO value of an account's annual revenue | Account |
Campaign Member Association Type | Type of association for a campaign_member (e.g. lead, account, opportunity_all_contacts, etc.) | Campaign_Member |
Account ENR LATEST FUNDING STAGE | Account details enriched with the latest funding stage of the org | Account |
Account ENR LINKEDIN UID | Enriched LinkedIn UID | Account |
Account ENR LOGO URL | Account info enriched with the URL to the logo | Account |
Campaign_member UTM Campaign | UTM campaign name associated with the campaign_member | Campaign_Member |
Account ENR Employee Range | Account enriched with 6sense data for a range based on the number of employees | Account |
Account Country | Country to which the account belongs | Account |
Campaign_member UTM Term | UTM tem associated with the campaign_member | Campaign_Member |
Account ENR COUNTRY | Account info enriched with the country data | Account |
Account ENR PHONE | Acccount data enriched with phone contact info | Account |
Campaign Owner Email Internal | Email ID of the campaign owner | Campaign |
Account Digital Paid Touched | The paid campaigns (LinkedIn, Meta, Google Ads) touched by any lead of an account | Account |
Account ENR LINKEDIN URL | Account enriched with LinkedIn URL | Account |
Account ENR INDUSTRY | Acccount data enriched with industry info | Account |
Account ENR ESTIMATED NUM EMPLOYEES | Enriched data for number of employees at an account's organization | Account |
Account Age In Source | Time spent by an account since its inception in the source system | Account |
Campaign Owner Email | Email ID of the owner of a campaign | Campaign |
Account ENR BLOG URL | Enriched blog URL | Campaign |
Campaign_member Campaign Id | Campaign ID of the campaign associated with the campaign member | Campaign |
Account ENR POSTAL CODE | Account data enriched with postal code | Account |
Account Duration In Revsure Funnel Stage | Time spent by an account in the current stage of RevSure funnel | Account |
Campaign Internal User Id | Internal user ID associated with the campaign | Campaign |
Account ENR OWNED BY ORGANIZATION ID | Enriched data for the ID of the organization that owns the account | Account |
Account Annual Revenue Raw | Raw value of an account's annual revenue | Account |
Account ENR CITY | Account details enriched with the city info | Account |
Account ENR NUM SUBORGANIZATION | Enriched data for number of suborganizations for the account | Account |
Account ENR NAME | Account info enriched with name | Account |
Account ENR FOUNDED YEAR | Enriched data for the founding year of the account | Account |
Campaign_member UTM Source | UTM source associated with the campaign_member | Campaign_Member |
Account ENR RETAIL LOCATION COUNT | Enriched data for the count of the retial locations for the account | Account |
Account ENR ALEXA RANKING | Enriched data for the Alexa ranking of the website | Account |
Account ENR PUBLICLY TRADED SYMBOL | Account information enriched with publicly traded symbol | Account |
Campaign Segment | Segment to which the campaign belongs | Account |
Account ENR RAW ADDRESS | Account info enriched with its address | Account |
Account ENR STATE | Enriched state name to which an account belongs | Account |
Account ENR KEYWORDS | Account info enriched with keywords | Account |
Account ENR PUBLICLY TRADED EXCHANGE | Account information enriched with info about publicly traded exchange | Account |
Campaign Member Entity Id | Entity ID for the campaign member | Campaign_Member |
Account G2 Pricing Pageviews | G2 enriched data for the pricing pageviews of an account | Account |
Account ENR TOTAL FUNDING PRINTED | Enriched total funding | Account |
Account ENR TECHNOLOGY NAMES | Account enriched with data with technology names | Account |
Account ENR TWITTER URL | Account info enriched with its Twitter URL | Account |
Account Internal User Id | The internal user ID associated with an account | Account |
Campaign Daily Budget Raw | Raw value of the daily budget for a campaign | Campaign |
Campaign Daily Budget Raw | Raw value of the daily budget for a campaign | Campaign |
Account G2 Total Pageviews | G2 enriched data for the total number of pageviews | Account |
Record Type | Type of campaign | Revsure_default |
Account Last Contact Activity Name | Name of the latest contact activity associated with an account | Account |
Account G2 Visitor Count | G2 enriched data for the count of the visitiors | Account |
Created Stage Name | Name of the stage in which a lead/opportunity/account was created | Revsure_default |
Meta Touched | This is 'True' if the account has touched a Meta campaign. Else, it is 'False'. | Lead,Opportunity,Account |
LinkedIn Touched | This is 'True' if the account has touched a LinkedIn campaign. Else, it is 'False'. | Lead,Opportunity,Account |
Account ENR STREET ADDRESS | Enriched street address | Account |
Account Number Of Contacts Bucket | Bucket based on the number of contacts associated with an account. E.g., 1-5, 5-10, 10+, etc. | Account |
Account ENR TOTAL FUNDING | Enriched data for the total funding the account has received | Account |
Account Number Of Engagements | Number of engagments for the account | Account |
Account Number Of Contacts | Number of contacts associated with the account | Account |
Funnel Lifecycle Status | Status associated with the lead/opportunity | Account |
Account ENR 6 Sense NAME | 6sense enriched data for the name of the account | Account |
Account First Gtm Activity Name | The name of the first GTM activity associated with an account | Account |
Account First Campaign Touch Type | This is the type of the campaign which was a account-first campaign touch in its journey | Account |
Account Outreach Buyer Intent Score | Outreach's buyer intent score for an account | Account |
Account G2 Buying Stage | G2 buying stage associated with the account | Account |
Account First Contact Activity Description | Description of the first contact activity of the account | Account |
Account Last Campaign Touch Type | The type of the campaign which was the last touchpoint for an account (across all leads) | Account |
Account Last Gtm Activity Contact Name | Name of the contact who performed the last GTM activity associated with the account | Account |
Account With Engagements | This is 'True' if an account has at least one engagement across all its leads. Else, it is 'False'. | Account |
Source System | The source system(s) for the lead/opportunity/accounts data | Lead,Opportunity,Account |
Last Contact Activity Description | Description of the latest contact activity associated with the lead/account | Lead,Account |
Account IPs | IPs associated with an account | Account |
Account G2 Sponsored Content Pageviews | G2 enriched data for the pageviews of sponsored content | Account |
Account Existing Customer | If the account is an existing customer, then this value is 'Y'. Else, it is 'N'. | Account |
Account ENR SHORT DESCRIPTION | Enriched short description | Account |
Account Last Gtm Activity Name | Name of the last GTM activity associated with an account | Account |
Account ENR SEO DESCRIPTION | Enriched SEO description | Account |
Funnel State | Current funnel state of the lead/account from the source systems | Lead,Account |
Account Last 6 Sense Enriched Ts | Timestamp for the latest enrichment by 6sense | Account |
Account G2 Competitor Pageviews | G2 enriched data for the number of pageviews of the account's competitors | Account |
Account Owner Name | Name of the person who is marked as the owner of the account | Account |
Account G2 Category Pageviews | G2 enriched data for the category pageviews | Account |
Account G2 Comparison Pageviews | G2 enriched data for the comparison pageviews | Account |
Number Of Campaign Touches | Total number of touches for this lead/account across all the leads associated with the account | Lead,Account |
Created State Name | Name of the state in which a lead/opportunity/account was created | Revsure_default |
Member Type | Type of the campaign_member | Campaign_member |
Account Number Of Opportunities | Number of open opportunities for the account | Account |
Account Annual Revenue Bucket | Bucket based on the annual revenue of the account | Account |
Account Last Gtm Activity Owner Name | Name of the owner of the last GTM activity associated with the account | Account |
Account Status | Status of the account from the source system | Account |
Account First Contact Activity Name | The name of the first contact activity associated with an account | Account |
Funnel Entrypoint | The stage where the lead/opp entered the funnel | Revsure_default |
Internal User Name | Name of the Owner | Revsure_default |
Funnel Velocity Till Revsure Funnel Stage | Average time taken by a lead/opportunity/account since inception to move into the current RevSure funnel stage | Revsure_default |
Account Number Of Days Since Last Activity Day | Number of days since the last activity associated with an account | Account |
Account Last Contact Activity Contact Name | Name of the latest contact activity associated with the account | Account |
Account G2 Product Profile Pageviews | G2 enriched data for the pageviews of the product profile page | Account |
Account ENR WEBSITE URL | Account's info enriched with website URL | Account |
Lead First Touch Channel | The channel associated with a lead's first campaign touch | Lead |
Account Id | Unique ID for the account | Account |
Account G2 Intent Score | G2 enriched data for intent score | Account |
Account ENR CRUNCHBASE URL | Enriched Cruchbase URL | Account |
Account With No Engagements Within Last 7 Days | This is 'True' if the account (across leads) had no engagements in the last 7 days. Else, it is 'False'. | Account |
Account Velocity Till Stage First Creation | Time since the creation to the time when it enters RevSure for the first time | Account |
Activity Stage Group | Name of the stage group associated with the activity | Account |
Latest Opportunity Stage | The latest stage of an opportunity | Opportunity |
Lead Age In Revsure Funnel | Time spent by a lead since it first entered the RevSure funnel | Lead |
Account State Duration In Revsure Funnel | Time spend (in days) by an account in the current state in RevSure funnel | Account |
Account With Closedwon Opportunity | This is 'True' if an account has a closed won opportunity associated with it. Else, it is 'False'. | Account |
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. | Revsure_default |
Funnel Status | Current funnel status | Revsure_default |
Created Stage Name Label | Name (label) of the stage in which a lead/opportunity/account was created | Revsure_default |
Account Region | Account’s region | Account |
Lead Age In Source | Time spent by a lead since its inception in the source system | Lead |
Latest Opportunity Value | The most current/real-time value of the opportunity. Reflects any edits made to the deal amount over time. | Revsure_default |
Opportunity Created Value | The value of the opportunity at the moment it was first created in the CRM. A fixed historical snapshot that never changes. | Revsure_default |
Opportunity Pipeline Value | The value of the opportunity at the time it first entered a qualified pipeline stage. May differ from Created Value if the deal was created at an early stage and grew in value before entering pipeline. | Revsure_default |
Account Stage | Current stage of an account in the funnel | Account |
Company Size Bucket | Account’s company-size bucket | Revsure_default |
Account Unique Campaigns Touched | Number of unique campaigns that touched the account | Account |
Account G2 Direct Pageviews | G2 enriched data for the direct pageviews | Account |
Account Google Touched | If the account has at least one touch with a Google campaign, then this value is 'true'. Else, it is 'false'. | Account |
Account Number Of Open Leads | Number of open leads for the account | Account |
Funnel Country | Country associated with lead/account | Revsure_default |
Account First Touch Channel | The channel associated with an account's first campaign touch (across all leads) | Account |
Latest Min Stage Ts | Timestamp when lead/opportunity/account entered a stage | Revsure_default |
Lead First Campaign Touch Type | This is the type of the campaign which was a leads first campaign touch in its journey | Revsure_default |
Lead Google Touched | If a lead has engaged with any Google campaign in its journey, then this value is ‘true’. Else, it is ‘false’. | Lead |
Account Velocity Till Revsure Funnel State | Time taken by the account since inception to move into the current RevSure funnel state | Account |
Account Parent Account Id | ID of an account's parent account | Account |
Account First Contact Activity Contact Name | The name of the contact for the first contact activity associated with a lead | Account |
Lead First Gtm Activity Name | The name of the first GTM activity associated with a lead | Revsure_default |
Lead Last Activity | Name of last activity performed by a lead | Revsure_default |
Lead First Touch Campaign Source System | The source system associated with a lead's first touch (for a campaign) | Lead |
Opportunity Age In Revsure Funnel | Time spent by an opportunity since it first entered the RevSure funnel | Opportunity |
Lead Internal User Id | Internal user ID of the lead | Lead |
Account Velocity Till Revsure Funnel Stage | Time taken by the account since inception to move into the current RevSure funnel stage | Account |
Current Stage | Name of the current stage of the lead/opportunity/account | Revsure_default |
Lead Recent UTM Term | Latest UTM term parameter associated with a lead | Lead |
Lead First Touch Campaign Type | The type of the first campaign that a lead touched | Lead |
Lead Last Gtm Activity Contact Name | Contact name who performed the latest GTM activity associated with a lead | Revsure_default |
Lead Activity List Str | List of activities | Revsure_default |
Entity Id | Unique ID for the entity | Revsure_default |
Lead Number Of Contact Activities Till Stage Overall | Total number of contact activities till the current stage of the lead | Revsure_default |
Account With Open Opportunity | This is 'True' if the account has at least one open opportunity. Else, it is 'False'. | Account |
Lead Last Campaign Touch Type | The type of the campaign which was the last touchpoint for a lead | Revsure_default |
Account First Gtm Activity Contact Name | Name of the contact who performed the first GTM activity associated with the account | Account |
Account Number Of Open Opportunity | Number of open opportunities associated with an account | Account |
Funnel Lead Source | It is the channel that generated a lead in the funnel | Revsure_default |
Account Last Touch Channel | The channel associated with an account's last touch (for a campaign) across all its leads | Account |
Account Owner Username | Username of the account owner | Account |
Opportunity Product Ids | List of product IDs associated with the opportunity | Opportunity |
Lead Activity Combination List | List of all the activities associated with a lead | Revsure_default |
Opportunity First Touch Campaign Source System | Name of the source system based on an opportunity's first touch campaign | Opportunity |
Lead Number Of Gtm Activities Till Stage | Number of GTM activities associated with the lead till current stage | Revsure_default |
Lead Transition | Timestamp of when a lead transitioned to an opportunity | Lead |
Account With Activities | This is 'True' if the account has at least one activity across all its leads. Else, it is 'False'. | Account |
Lead Num Activities Till Stage | Number of activities till the current stage for a lead | Revsure_default |
Opportunity Age In Source | Time spent by an opportunity since its inception in the source system | Opportunity |
Lead Linkedin Touched | If a lead has engaged with any LinkedIn campaign in its journey, then this value is ‘true’. Else, it is ‘false’. | Lead |
Internal_user Manager Id | ID of the manager of the Owner | Internal_user |
Lead First Contact Activity Name | The name of the first contact activity associated with a lead | Revsure_default |
Lead Last Gtm Activity Name | Name of the last GTM activity associated with a lead | Revsure_default |
Lead Activity List | List of activities associated with the lead | Revsure_default |
Lead Funnel State | Current funnel state of the lead | Lead |
Opportunity Annual Contract Value ISO Code | ISO Code for the annual contract value for the opportunity | Opportunity |
Lead First Gtm Activity Contact Name | Contact name who performed the latest GTM activity associated with a lead | Revsure_default |
Lead Created Date Quarter Year | The quarter and year in which the lead is created. It is in the format of QQ-YYYY. | Lead |
Lead Created By Id | ID of the user who created the lead in the system | Lead |
Lead First URL | The first webpage visit associated with a lead (all time) | Lead |
Lead Ad IDs | Ad IDs associated with the lead | Lead |
Lead Number Of Activities | Total number of activities by a lead | Revsure_default |
Lead Number Of Unique Campaign Touches | Number of unique campaigns touched by a lead | Revsure_default |
Lead Unique Campaigns Touched Till Stage | Number of unique campaigns touched by the lead till the current stage | Revsure_default |
Lead Last Touch Campaign Source System | Name of the source system based on the lead's last touch campaign | Lead |
Lead Num Activities Bucket | Bucket based on the number of activities associated to a lead. E.g., 1-5, 5-10, 10+, etc. | Revsure_default |
Opportunity Annual Recurring Revenue ISO Code | ISO Code for the annual recurring revennue for the opportunity | Opportunity |
Opportunity Last Touch Campaign Source System | Name of the source system based on the opportunity's last touch campaign | Opportunity |
Lead Last URL | The latest URL associated with a lead | Lead |
Opportunity Velocity Till Revsure Funnel State | Time spent (in days) by the opportunity to reach the current RevSure funnel state | Opportunity |
Lead Number Of Campaign Touches | Total number of campaign touches for a lead | Revsure_default |
Opportunity Entrypoint Stage | The first stage of the funnel in which an opportunity enters | Opportunity |
Funnel Velocity Till Revsure Funnel State | Time spent (in days) in the RevSure funnel to reach the current funnel state | Revsure_default |
Opportunity Activity List | List of activities associated with the opportunity | Opportunity |
Lead First Contact Activity Description | Description for the first contact activity associated with a lead | Revsure_default |
Lead_status Source System | Name of the source system for lead status | Lead_status |
Internal_user Source System | Name of the source system associated with the Owner | Internal_user |
Opportunity Num Campaigns | Number of campaigns that the opportunity touched | Opportunity |
Lead Entrypoint Stage | The state from the source system that was recorded when a lead entered the funnel | Lead |
Lead Recent UTM Medium | Recent UTM medium associated with the lead | Lead |
Person ENR 6 Sense Last Name | 6sense enriched data for the last name of the person | Person |
Lead Sales Region | The sales region in which the lead was generated | Lead |
Lead Recent UTM Campaign | Most recent UTM campaign associated with the lead | Lead |
Lead Number Of Unique Campaigns Touched Till Stage | Number of unique campaigns touched by a lead till the current stage | Revsure_default |
Lead With Engagements | This is 'True' if the lead has any engagement(s) associated with it. Else, it is 'False'. | Lead |
Lead Velocity Till Revsure Funnel Stage | Time taken by the lead since inception to move into the current RevSure funnel stage | Lead |
Opportunity Close Date Quarter | The quarter for the close date of an opportunity | Opportunity |
Lead State Duration In Revsure Funnel | Time spent by a lead in the current state of RevSure funnel | Lead |
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’. | Lead |
Opportunity Activity List Str | List of activities associated with the opportunity | Opportunity |
Lead Duration In Revsure Funnel Stage | Time spent by a lead in the current stage of RevSure funnel | Lead |
Opportunity Annual Recurring Revenue Iso Raw | Raw ISO value of the annual recurring revenue for the opportunity | Opportunity |
Opportunity Number Of Contacts | Number of contacts associated with the opportunity | Opportunity |
Lead Last Touch Campaign Type | The type of the latest campaign that a lead touched | Lead |
Lead Entrypoint | The first stage of the funnel in which a lead enters | Lead |
Lead Num Campaigns Bucket | Buckets for leads based on number of campaigns they have touched | Revsure_default |
Opportunity Type Custom | Type of the opportunity (custom) | Opportunity |
Person ENR LINKEDIN URL | Enriched data for the LinkedIn profile URL of the person | Person |
Opportunity Total Contract Value Raw | Raw value of the total contract value for the opportunity | Opportunity |
Person Age | Age of the person | Person |
Opportunity Monthly Recurring Revenue Raw | Raw value of the monthly recurring revenue associated with the opportunity | Opportunity |
Lead Grade | Grade of a lead from the source system | Lead |
Revsure Lead Original Source | This is the first channel that has touched a lead/opp | Revsure_default |
Lead First Contact Activity Contact Name | Contact name for the first contact activity associated with the lead | Revsure_default |
Lead Number Of Days Since Last Activity Day | Number of days spent since the last activity associated with a lead | Revsure_default |
Lead Number Of Contact Activities Till Stage | Number of contact activities till the current stage associated with the lead | Revsure_default |
Opportunity Last Activity | The latest activity associated with an opportunity | 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. | Opportunity |
Opportunity Value ISO Code | ISO code of the value of the opportunity | Opportunity |
Person ENR 6 Sense Email | 6sense enriched data for the email ID of the person | Person |
Opportunity Num Campaign Activities Till Stage | Number of campaign activities associated with the opportunity till current stage | Opportunity |
Lead Digital Paid Touched | The paid campaigns (LinkedIn, Meta, Google Ads) touched by a lead | Lead |
Lead Unique Campaigns Touched | Number of unique campaigns touched by a lead | Revsure_default |
Person ENR LAST NAME | Enriched data for the last name of the person | Person |
Lead Account Id | Account ID associated with the lead | Lead |
Lead Recent UTM Content | Latest UTM content parameter associated with a lead | Lead |
Lead Last Contact Activity Description | Description for the last contact activity associated with a lead | Revsure_default |
Lead Num Activities | Number of activities associated with a lead/opportunity/account | Revsure_default |
Internal_user Parent Role | Parent role of the Owner in the organization | Internal_user |
Opportunity Last Touch Campaign | Name of the latest campaign that touched the opportunity | Opportunity |
Lead Campaign Ids | Campaign IDs that touched a lead | Lead |
Opportunity Product Name List | Product name list associated with the opportunity | Opportunity |
Lead Source System | The source system associated with a lead | Lead |
Lead Number Of Engagements | Number of engagements associated with the lead | Lead |
Person Address 2 | Line 2 of the address of the person | Person |
Account Owner Email | Email of the account owner | Account |
Lead Num Campaign Activities Till Stage | Number of campaign activities till the current stage associated with the lead | Revsure_default |
Opportunity Person Id | Person ID associated with the opportunity | Opportunity |
Opportunity Monthly Recurring Revenue | Monthly recurring revenue associated with the opportunity | Opportunity |
Opportunity Created By Id | ID of the person/user who created the opportunity | Opportunity |
Lead Number Of Opportunities | Number of opportunities associated with a lead | Lead |
Lead Last Touch Channel | The channel associated with a lead's last campaign touch | Lead |
Opportunity Campaign Id | Primary campaign associated with the opportunity in the source system | Opportunity |
Opportunity Number Of Contacts Bucket | Bucket based on the number of contacts associated with an opportunity. E.g., 1-5, 5-10, 10+, etc. | Opportunity |
Person Last 6 Sense Enriched Ts | Timestamp for the latest update using 6sense enriched data for a person | Person |
Opportunity Num Campaigns Bucket | Bucket based on the number of campaigns touched by an opportunity. E.g., 1-5, 5-10, 10+, etc. | Opportunity |
Lead Num Campaigns | Total number of campaigns touched by a lead/opportunity/account | Revsure_default |
Person ENR APOLLO ORGANIZATION ID | Enriched data from Apollo for the organization ID of the person | Person |
Person Region | Region (address) for the person | Person |
Opportunity Annual Recurring Revenue Raw | Raw value of the annual recurring revenue for the opportunity | Opportunity |
Opportunity Duration In Revsure Funnel Stage | Time spent by an opportunity in the current stage of RevSure funnel | Opportunity |
Revsure Account Original Source Detail | Details for the original source for an account in RevSure funnel | Opportunity |
Opportunity Lead Id | Lead ID associated with an opportunity | Opportunity |
Person ENR 6 Sense Linkedin Url | 6sense enriched data for the LinkedIn profile URL of the person | Person |
Opportunity First Touch Campaign | Name of the first campaign that touched the opportunity | Opportunity |
Person Account Id | Account ID associated with the person | Person |
Person ENR 6 Sense Full Name | 6sense enriched data for the full name of the person | Person |
Lead Recent UTM Source | The most recent UTM source for a lead | Lead |
Lead Last Gtm Activity Owner Name | Name of the owner who performed the latest GTM activity associated with a lead | Revsure_default |
Revsure Lead Latest Source Detail | Details of the latest source for a lead in RevSure funnel | Revsure_default |
Opportunity Account Id | Account ID associated with the opportunity | Opportunity |
Opportunity Value Iso Raw | Value associated with an opportunity | Opportunity |
Opportunity Annual Recurring Revenue | Annual recurring revenue for an opportunity | Opportunity |
Opportunity Annual Contract Value Raw | Raw value of the annual contract value for the opportunity | Opportunity |
Opportunity State Duration In Revsure Funnel | Time spent by an opportunity in the current state of RevSure funnel | Opportunity |
Opportunity Internal User Id | Internal user ID associated with the opportunity | Opportunity |
Opportunity Annual Contract Value | Annual contract value associated with the opportunity | Opportunity |
Opportunity_stage Id | Unique ID of the opportunity stage | Opportunity_stage |
Revsure Funnel Stage | Current stage in the RevSure funnel | Revsure_default |
Person ENR GITHUB URL | Enriched data with the GitHub URL of the person | Person |
Account G2 Activity Level | The G2 activity level associated with an account | Account |
Lead Conversion Tracking Id | Unique ID to track the lead conversions mapped to the source system | Lead |
Person Source Updated At | Timestamp of when the latest update for a person was made in the source system (e.g. HubSpot, Salesforce, etc.) | Person |
Person ENR COUNTRY | Enriched data for the country of the person | Person |
Prev Lead Status | Name of the previous lead status | Revsure_default |
Opportunity Product Code List | Product code list associated with the opportunity | Opportunity |
Person LinkedIn URL | LinkedIn profile URL for theperson | Person |
Opportunity First Activity | The name of the first activity associated with an opportunity | Opportunity |
Opportunity Total Contract Value | Total contract value associated with the opportunity | Opportunity |
Opportunity Num Activities Till Stage | Number of activities associated with the opportunity till current stage | Opportunity |
Person ENR EMAIL | Enriched data for the email ID of the person | Person |
Opportunity Product Family List | List of the product family associated with an opportunity | Opportunity |
Opportunity Last Touch Campaign Type | The type of the latest campaign that an opportunity touched | Opportunity |
Latest Opportunity Close Date Quarter Year | The latest value of close date (quarter and year) associated with an opportunity. It is in the format of QQ-YYYY. | Revsure_default |
Person Source System | Name of the source system for the data about the person | Person |
Person Country Code - 3 Letter | 3-letter country code based on the address of the person | Person |
Visitor Source Updated At | Timestamp when the visitor data was last updated in the source system | Visitor |
Opportunity First Touch Campaign Type | The type of the first campaign that an opportunity touched | Opportunity |
Visitor First UTM Term | First UTM term parameter associated with the visitor | Visitor |
Lead Last Contact Activity Name | Name of the latest contact activity associated with a lead | Revsure_default |
Revsure Funnel Status | Current status in the RevSure funnel by the lead/opportunity/account | Revsure_default |
Revsure Funnel Previous Stage | Previous stage in the RevSure funnel | Revsure_default |
Person ENR 6 Sense Email Confidence | 6sense enriched data for the confidence score of the email ID for a person | Person |
Pipeline Creation Quarter Year | It is the quarter and year when the pipeline was first created. It is in the format QQ-YYYY. | Revsure_default |
Opportunity Num Activities Bucket | Bucket based on the number of activities associated to an opportunity. E.g., 1-5, 5-10, 10+, etc. | Opportunity |
Opportunity Source System | The CRM/source system for the opportunity | Opportunity |
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'. | Lead |
Visitor Account Id | Account ID associated with the visitor | Visitor |
Opportunity Total Contract Value Iso Raw | Raw ISO value of the total contract value for the opportunity | Opportunity |
Person ENR 6 Sense Division | 6sense enriched data for the division that the person belongs to | Person |
Person ENR APOLLO ID | Enriched data with the Apollo ID of the person | Person |
Revsure Lead Original Source Detail | Details for the original source for a lead in RevSure funnel | Revsure_default |
Latest Opportunity Close Date Quarter | The latest value of close date quarter associated with an opportunity. It is in the format of QQ. | Revsure_default |
Opportunity Created Date Quarter | The quarter in which the opportunity is created. It is in the format of QQ. | Opportunity |
Metric Entity Type | Type of the entity in RevSure data model (Lead/Opportunity/Account/Internal user) | Revsure_default |
Visitor First Channel | First channel associated with the visitor | Visitor |
Opportunity Annual Contract Value Iso Raw | Raw ISO value of the annual contract value of the opportunity | Opportunity |
Opportunity Primary Contact Id | Unique ID of the primary contact associated with an opportunity | Opportunity |
Lead With Closedwon Opportunity | This is 'True' if the lead had a closed won opportunity associated with it. Else, it is 'False'. | Lead |
Revsure Funnel Previous Status | The previous stage the lead belonged to in the RevSure funnel | Revsure_default |
Person ENR TWITTER URL | Enriched data with the Twitter URL of the person | Person |
Recent State Name | Name of the most recent state name | Revsure_default |
Person ENR 6 Sense Country | 6sense enriched data for the country of the person | Person |
Person ENR 6 Sense Postal Code | 6sense enriched data for the postal code (address) of the person | Person |
Opportunity CURRENCY | Currency for the opportunity value | Opportunity |
Person ENR 6 Sense Title | 6sense enriched data for the title of the person | Person |
Visitor Duration | Time spent by the visitor on the website | Visitor |
Opportunity Created Date Quarter Year | The quarter and year in which the lead is created. It is in the format of QQ-YYYY. | Opportunity |
Person ENR 6 Sense Education | 6sense enriched data for the highest education level of the person | Person |
Opportunity Num Activities | Number of activities for the opportunity | Opportunity |
Lead_status Id | Unique ID of the lead status | Lead_status |
Visitor First UTM Campaign | First UTM campaign parameter associated with the visitor | Visitor |
Revsure Funnel Entered Stage Id | Unique ID of the stage where the lead first entered the RevSure funnel | Revsure_default |
Visitor First UTM Source | First UTM Source parameter associated with the visitor | Visitor |
Person ENR 6 Sense Id | 6sense enriched data for the ID of the person | Person |
Visitor First Device Type | Type of the first device associated with the visitor | Visitor |
Opportunity Entrypoint | The first stage of the funner in which an opportunity enters | Opportunity |
Src Lead Id | Lead ID from the source system | Revsure_default |
Recent Stage Name | Name of the most recent stage in the RevSure funnel | Revsure_default |
Revsure Funnel Entered Status | Status of a lead from the source system when it entered RevSure funnel for the first time. | Revsure_default |
Person ENR PHONE NUMBER | Enriched data for the phone number of the person | Person |
Person ENR 6 Sense Title Level | 6sense enriched data for the level of the title of the person (e.g. manager, executive, etc.) | Person |
Person ENR 6 Sense Phone | 6sense enriched data for the phone number of the person | Person |
Person ENR 6 Sense State | 6sense enriched data for the state (address) of the person | Person |
Person ENR FIRST NAME | Enriched data for the first name of the person | Person |
Visitor Last Activity Name | Name of the last activity associated with a visitor | Visitor |
Opportunity Velocity Till Revsure Funnel Stage | Time spent (in days) by the opportunity to reach the current RevSure funnel stage | Opportunity |
Revsure Account Original Source | Original source associated with the account in the RevSure funnel | Revsure_default |
Visitor First Device | First device associated with the visitor | Visitor |
Lead With Opportunity | If a lead is associated with an opportunity then this value is 'true'. Else, it is 'false'. | Lead |
Person ENR STATE | Enriched data for the state (address) of the person | Person |
Person ENR 6 Sense City | 6sense enriched data for the city of the person | Person |
Opportunity Value Raw | Raw value for the value of the opportunity | Opportunity |
Visitor Id | Unique ID of the visitor from source system | Visitor |
Visitor First Referring Domain | First referrer domain associated with the visitor | Visitor |
Person ENR PHOTO URL | Enriched data with the URL to a photo of the person | Person |
Visitor First Activity Type | Type of the first activity associated with the visitor | Visitor |
Visitor Is Bot | To identify and filter bot/crawler traffic from visitor activity | Visitor |
Rs Opportunity Age | Time spent since the inception of the opportunity | Revsure_default |
Visitor First OS | First operating system detected for the visitor | Visitor |
Revsure Account Latest Source Detail | Details of the latest source for an account in RevSure funnel | Revsure_default |
Person ENR CITY | Enriched data with the city (address) of the person | Person |
Person ENR 6 Sense First Name | 6sense enriched data for the first name of the person | Person |
Visitor First Referring URL | First referring URL associated with the visitor | Visitor |
Funnel Entrypoint Stage | The channel associated with a lead's first campaign touch | Revsure_default |
Visitor Person Id | Person IS associated with the visitor | Visitor |
Person ENR HEADLINE | Enriched data for headline associated with the person | Person |
Visitor Source Created At | Timestamp when the visitor was created in the source system | Visitor |
Previous State | Name of the previous state | Revsure_default |
Visitor Source System | Source systemassociated with the visitor | Visitor |
Visitor Age | Age of the visitor | Visitor |
Person ENR 6 Sense Scores | 6sense enriched data for the scores related to a person | Person |
Visitor First UTM Medium | First UTM Medium parameter associated with the visitor | Visitor |
Person ENR 6 Sense Level | 6sense enriched data for the level of the person (in the org) | Person |
Person ENR 6 Sense Title Function | 6sense enriched data for the title function of the person | Person |
Opportunity Monthly Recurring Revenue Iso Raw | Raw ISO value of the monthly recurring revenue for the opportunity | Opportunity |
Lead With Activities | If a lead has at least 1 activity associated with it, then this value is 'true'. Else, it is 'false'. | Revsure_default |
Person ENR NAME | Enriched data for the name of the person | Person |
Visitor First Browser | First browser associated with the visitor | Visitor |
Revsure Account Latest Source | The campaign type that generated the latest lead associated with an account | Revsure_default |
Person Name | Name of the person | Person |
Opportunity Total Contract Value ISO Code | ISO code for the total contract value of the opportunity | Opportunity |
Lead Person Id | Person ID of the lead | Lead |
Person Source Created At | Timestamp when the person was created in the source system (e.g. Salesforce, hubsport, etc.) | Person |
Person Country Code - 2 Letter | 2-letter country code based on the address of the person | Person |
Visitor First Activity Name | Name of the first activity associated with a visitor | Visitor |
Visitor Last Activity Type | Type of the latest activity by the visitor | Visitor |
Revsure Funnel Entered Stage | The stage at which the lead entered the Revsure funnel | Revsure_default |
Visitor First User Agent | First user agent associated with the visitor | Visitor |
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'. | Lead |
Revsure Lead Latest Source | Latest channel from where the lead was generated | Revsure_default |
Lead Number Of Campaign Touches Till Stage | Number of campaigns touched by the lead till the current stage | Revsure_default |
Visitor Lead Id | Lead ID associated with the visitor | Visitor |
Person ENR 6 Sense Twitter Url | 6sense enriched data for the URL of the Twitter profile of the person | Person |
Revsure Funnel Previous Stage Id | ID of the previous stage in the RevSure funnel | Revsure_default |
Person ENR 6 Sense Function | 6sense enriched data for the function of the person (e.g. analyst, VP, etc.) | Person |
Visitor First Activity Timestamp | Timestamp of the first activity by the visitor | Visitor |
Visitor Last Activity Timestamp | Timestamp of the latest activity by a visitor | Visitor |
Visitor First Utm Content | The first content that a visitor was exposed to | Visitor |
Lead With Open Opportunity | This is 'True' if the lead is associated with an open opportunity. Else, it is 'False'. | Lead |
Person ENR FACEBOOK URL | Enriched data with the Facebook URL of the person | Person |
Person ENR 6 Sense Facebook Url | 6sense enriched data for the Facebook profile URL of the person | Person |
Lead First Touch Campaign Id | Campaign ID of the first touch campaign for a lead | Lead |
Lead Last Contact Activity Contact Name | Name of the contact for the latest contact activity associated with the lead | Revsure_default |
Person ENR 6 Sense Skills | 6sense enriched data for the skills associated with the person | Person |
Account Tags | Tags for an account | Account |
Opportunity_stage Source System | Name of the source system for the opportunity stage | Opportunity_stage |
Opportunity Monthly Recurring Revenue ISO Code | ISO code for the monthly recurring revenue associated with the opportunity | Opportunity |
Activity Marketo BL Param | Marketo URL tracking parameter | Activity |
Activity Marketo BT Param | Marketo URL tracking parameter | Activity |
Activity Marketo BF Param | Marketo URL tracking parameter | Activity |
Activity Page Type Intent | Buyer intent of the page visited | Activity |
Activity Page Type | Type of the page visited | Activity |
Activity Session Duration | Session duration of the page visited | Activity |
Activity UTM Content | UTM content parameter associated with the activity | Activity |
Activity UTM Medium | UTM medium parameter associated with the activity | Activity |
Activity UTM Source | UTM source parameter associated with the activity | Activity |
Activity UTM Campaign | UTM campaign parameter associated with the activity | Activity |
Activity UTM Term | UTM term parameter associated with the activity | Activity |
Campaign Budget Cost ISO Code | ISO code of the currency of your campaign budget | Campaign |
Campaign Actual Cost ISO Code | ISO code of the currency of your campaign`s actual cost | Campaign |
Campaign End Date Quarter Year | Quarter and Year of the campaign`s end date | Campaign |
Campaign First Engagement Date Quarter Year | Quarter and Year of the campaign`s first engagement | Campaign |
Campaign Last Engagement Date Quarter Year | Quarter and Year of the campaign`s last engagement | Campaign |
Campaign Is Manual Update | Whether campaign has been manually updated | Campaign |
Campaign Original Actual Cost | Original cost/spend of the campaign | Campaign |
Campaign_member Is Email Campaign | Whether campaign member is part of an email campaign | Campaign |
Campaign_member Email Clicked | Whether campaign member has clicked on the email sent | Campaign |
Account Engagement Minutes (3 mo.) | Average number of minutes spent by contacts of an account engaging in any activity over a period of 3months | Account |
Campaign_member Source System | Source system in which the campaign member was created | Campaign_member |
Account Address Line 2 | Second address line of the account/company | Account |
Campaign_member Email Delivered | Tells you whether email has been delivered to the campaign member inbox | Campaign_member |
Engagement Utm Content | Measures engagement segmented by the utm content tag | Revsure_default |
Campaign Source System | Source system in which the campaign was created | Campaign |
Cm Activity Status | The current state of a campaign activity | Revsure_default |
Engagement Source Detail | The specific channel or sub-source (e.g., organic search, paid social, partner referral) through which a user interaction originated. | Revsure_default |
Account Annual Revenue ISO Code | The three-letter ISO currency code (e.g., USD, EUR) in which the account’s reported annual revenue is denominated. | Account |
Page Type | The category of the webpage involved in the engagement | |
Account RevSure De-Anonymized | Is the Account deanonymised by Revsure | Account |
Engagement Utm Source | The value of the utm_source URL parameter used to track the primary marketing channel for this engagement | Revsure_default |
Campaign Start Date Quarter Year | Start date quarter and year of the campaign | Campaign |
Campaign Ad Geo Country | The country targeted by the campaign’s ad creatives, usually based on the user’s IP or chosen audience region. | Campaign |
Campaign Manual Modified At | The date and time when a user manually edited the campaign settings | Campaign |
Engagement Utm Campaign | The value of the utm_campaign URL parameter used to associate this interaction with a particular marketing campaign. | Revsure_default |
Engagement Timestamp | The timestamp of the engagement | Revsure_default |
Engagement Type | Category of the engagement to which it belongs | Revsure_default |
Account ENR LATEST FUNDING ROUND DATE | Shows the exact day when the company most recently raised money. | Account |
Account Bing Touched | Whether this account was touched by Bing during it`s journey so far | Account |
Cm Activity Sub Type | Indicates the sub-type of the campaign activity | Revsure_default |
Account ENR ANGEL LIST URL | Account`s AngelList URl link | Account |
Account Campaign Combination List | Contains an array of all campaigns the account touched | Account |
Engagement Description | Description of the engagement/URL of the visited webpage | Revsure_default |
Campaign First Engagement Date | Date when first interaction happened with the campaign | Campaign |
Campaign_member Email Opened | Whether the email sent was opened | Campaign |
Account Had Pipeline | Indicates whether the account has had an opportunity reach the pipeline stage. | Account |
Account with Open Pipeline | Indicates whether the account’s latest opportunity is currently in an open pipeline stage. | Account |
Account with Closed Won or Lost Opps | Indicates whether the account has had any opportunity reach a Closed Won or Closed Lost stage. | Account |
Account with Lost Opps | Indicates whether the account has had any opportunity reach a Closed Lost stage. | Account |
Opportunity Record Type Name | Indicates the Salesforce Record Type associated with the opportunity. | Opportunity |
Visitor Topic of Interest | Displays topics a visitor is interested in, automatically identified based on their website page browsing activity. Displays topics a visitor is interested in, automatically identified based on their website page browsing activity. | Visitor, Lead |
What is Revsure_default?
Revsure_default is a dimension source type that indicates a dimension is natively created and managed by RevSure, rather than being sourced directly from your connected systems (such as Salesforce, HubSpot, or other integrations).
Key Characteristics
When you see Revsure_default as the entity or source type for a dimension, it means:
The dimension is derived or computed by RevSure
It represents enriched or transformed data that RevSure generates to provide additional insights
It is part of RevSure's core analytics framework, available across all customer instances
Usage in Reports and Dashboards
You can use Revsure_default dimensions just like any other dimension in your:
Custom reports and dashboards
Segmentation and filtering
Attribution models
Pipeline analysis
These dimensions are designed to complement your source data and provide deeper insights.