Derived Dimensions Descriptions

Prev Next

Introduction

Derived dimensions are those that 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 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

For opportunities: Time taken by the primary contact since inception ('src_created_at') to move into the stage

Opportunity and Lead

Lead Velocity Till Stage First Creation

Time taken by the lead since inception ('src_created_at') to move into the 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

For opportunities: Time taken by the primary contact since inception ('src_created_at') to move into the 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 lead in its most recent stage

Lead

Opportunity Duration

Time taken by the opportunity in its most recent stage

Opportunity

Account Duration

Time taken by 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

For opportunities: Time taken by the primary contact 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

For opportunities: Time taken by the primary contact 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 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 the last activity performed by a contact associated with the account

Account, Opportunity, and Lead

Last Contact Activity’s Contact Name

Name of the 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 the last GTM activity performed by marketing/sales on the account

Account, Opportunity, and Lead

Last GTM Activity’s Owner Name

Name of the marketing/sales person who 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 the first activity performed by a contact associated with the account

Account, Opportunity, and Lead

First Contact Activity’s Contact Name

Name of the contact who 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 the first GTM activity performed by marketing/sales on the account

Account, Opportunity, and Lead

First GTM Contact Activity’s Contact Name

Name of the 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 the 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 that are not marked as customers or leaked.

Account

Number Of Open Opportunities

Count of active opportunities associated with the account. These are the opportunities that 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. Otherwise, it is 'False'.

Account

Account With Open Opportunity

This is 'True' if the account has at least one open opportunity. Otherwise, it is 'False'.

Account

Account With Activities

This is 'True' if the account has at least one activity across all its leads. Otherwise, it is 'False'.

Account

Account With Closed Won Opportunity

This is 'True' if an account has a closed won opportunity associated with it. Otherwise, it is 'False'.

Account

Entrypoint

The first stage of the funnel, 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. Otherwise, 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. Otherwise, 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. Otherwise, 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 visited webpage type by an entity

Lead, Visitor, Account

Pages Visited List

The list of all visited webpages 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’. Otherwise, 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 spending 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 associated 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

Account 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 is 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 is associated with the campaign_member

Campaign_Member

Account ENR COUNTRY

Account info enriched with the country data

Account

Account ENR PHONE

Account 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

Account data enriched with industry info

Account

Account ENR ESTIMATED NUM EMPLOYEES

Enriched data for the 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 the postal code

Account

Account Duration In Revsure Funnel Stage

Time spent by an account in the current stage of the 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 the 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 retail 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 a 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 visitors

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. Otherwise, it is 'False'.

Lead, Opportunity, Account

Account ENR STREET ADDRESS

Enriched street address

Account

Account Number Of Contacts Bucket

A 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 engagements 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 campaign that was an 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 is 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 that 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. Otherwise, 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 Crunchbase 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. Otherwise, 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 spent (in days) by an account in the current state in the RevSure funnel

Account

Account With Closedwon Opportunity

This is 'True' if an account has a closed won opportunity associated with it. Otherwise, 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

Latest value of the opportunity

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'. Otherwise, it is 'false'.

Account

Account Number Of Open Leads

Number of open leads for the account

Account

Funnel Country

Country associated with the 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 the lead/opportunity/account entered a stage

Revsure_default

Lead First Campaign Touch Type

This is the type of campaign that was a lead’s 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’. Otherwise, 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 the 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

The 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. Otherwise, it is 'False'.

Account

Lead Last Campaign Touch Type

The type of the campaign that 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 the 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. Otherwise, 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’. Otherwise, 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

A bucket based on the number of activities associated with a lead. E.g., 1-5, 5-10, 10+, etc.

Revsure_default

Opportunity Annual Recurring Revenue ISO Code

ISO Code for the annual recurring revenue 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 is when 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. Otherwise, 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 the RevSure funnel

Lead

Lead Meta Touched

If a lead has engaged with any Meta (Facebook) campaign in its journey, then this value is ‘true’. Otherwise, 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 the 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 the 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 the 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 the RevSure funnel

Opportunity

Revsure Account Original Source Detail

Details for the source for an account in the 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 the 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 the 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 the person

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 the 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 the 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

A 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. Otherwise, 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 source for a lead in the RevSure funnel

Revsure_default

Latest Opportunity Close Date Quarter

The latest value of the 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 the 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. Otherwise, it is 'False'.

Lead

Revsure Funnel Previous Status

The previous stage that 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 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 funnel is when 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 the 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'. Otherwise, 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 the 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

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 the 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 the 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 system associated 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'. Otherwise, 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. Otherwise, it is 'False'.

Lead

Revsure Lead Latest Source

The 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. Otherwise, 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 the campaign has been manually updated

Campaign

Campaign Original Actual Cost

Original cost/spend of the campaign

Campaign

Campaign_member Is Email Campaign

Whether a campaign member is part of an email campaign

Campaign

Campaign_member Email Clicked

Whether the 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

The 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 the email has been delivered to the campaign member's 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 is 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 is 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 its journey so far

Account

Cm Activity Sub Type

Indicates the subtype 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 the first interaction happened with the campaign

Campaign

Campaign_member Email Opened

Whether the email sent was opened

Campaign