Date Filter Dimensions - Leads, Opportunities, and Accounts

Prev Next

Below are the descriptions of the various dimensions of the date filter for leads, opportunities, and account entities. These dimensions are available in all three BI widgets of the Marketing Performance module, as listed below:

  • BI - Bar Chart

  • BI - Trend Chart

  • BI - Cross Table

Date Filter Dimensions

Please note that:

  1. ‘Funnel' refers to the RevSure funnel

Dimension/Metric

Definition

Lead Last Gtm Activity Ts

Timestamp of a lead's latest GTM activity

Lead Last Touch Ts

Timestamp of a lead's last touch

Created Stage Timestamp

Timestamp when a lead/opp was created in the funnel stage

Revsure Funnel Entered Date

Date when the lead/opp entered the Revsure funnel for the first time

Account First Activity Ts

Timestamp of the first activity across all leads of an account

Account Last Gtm Contact Activity Time

Time of the latest GTM contact activity across all leads/ops of an account

Revsure Funnel Stage Entered Date

Date when the lead/opp entered the Revsure funnel stage for the first time

Created State Timestamp

Timestamp when a lead/opp was created in the particular state in the source system

Lead Ingested At

Timestamp when a lead was ingested into the RevSure data platform

Account First Gtm Activity Ts

Timestamp for an account's first GTM activity

Account Last Gtm Activity Ts

Timestamp for an account's latest GTM activity

Recent Stage Timestamp

Timestamp for a lead/opp's latest stage

Lead Last Contact Activity Time

Time associated with a lead's latest contact activity

Funnel Transition Ts

Timestamp for a lead/opp's funnel transition

Lead Original Src Created At

Timestamp associated with a lead when it was first created in the source system

Lead First Gtm Activity Time

Time for a lead's first GTM activity

Lead First Contact Activity Time

Time for a lead's first contact activity

Recent State Timestamp

Timestamp for a lead's recent state in the source system

Lead MQL Date Most Recent

Most recent date when a lead entered the MQL stage

Lead Last Gtm Contact Activity Time

Time of the latest GTM contact activity associated with a lead

Last Touch Campaign Engagement Ts

Timestamp of the latest campaign engagement associated with a lead/opportunity

Last Activity Ts

Timestamp of the latest activity associated with a lead/opportunity

Revsure Funnel Status Entered Date

Date when a lead/opportunity was entered its latest status

Lead First Gtm Activity Ts

Timestamp of a lead's first GTM activity

Lead Last Gtm Activity Time

Timestamp of a lead's latest GTM activity

Lead First Gtm Contact Activity Time

Time of the first GTM contact activity associated with a lead

Account Last Activity Ts

Timestamp of the latest activity associated with an account across all leads

Duration

Time spent by a lead in the current stage

Account First Gtm Contact Activity Time

Time of the first GTM contact activity of an account across all leads

Latest Opportunity Close Date

The latest date associated with an opportunity when it closes

First Activity Ts

Timestamp of a lead/opportunity's first activity

Lead Created At

Timestamp when a lead was first created in the source system

Lead First Touch Ts

Timestamp of a lead's first engagement with a campaign

Lead Source Updated At

Timestamp when the lead was updated in the source system

First Touch Campaign Engagement Ts

Timestamp for the first engagement with a campaign