This page defines the data included in each file when downloading data from the Value Metrics reports.
File downloads are limited to 25,000 records. These reports rarely approach those limits, but if required, the file will be prioritized to include the highest Buying Stages first.
The downloaded files typically contain data for each individual Opportunity, and a single Account may have multiple Opportunities open at a time.
For example, the sections for “Activities by Source for Accounts with Opportunities” and “Campaigns Influencing Opportunities” show a metric focused on the number of unique accounts represented in that month’s data, but because the downloaded file shows opportunity-level data, you may see more rows in the file compared to the number of accounts shown in the platform. However if you count the total number of unique 6sense ID values in the file, you will see that this matches the number of accounts shown.
Similarly, there may appear to be extra rows included in the file because you may have multiple CRM Accounts that correspond to the same 6sense ID – the platform typically counts accounts on the basis of the 6sense ID, so it’s important to keep in mind that the downloaded file may contain more data due to duplicate CRM Accounts, and/or due to multiple Opportunities per CRM Account.
Accounts Worked by Sales After 6sense Predicted
Account Name: 6sense’s normalized company name.
Account Website: 6sense’s normalized company website.
Account Country: The country associated with the account.
CRM Account ID: The Salesforce Account ID corresponding to the opportunity’s Account.
6sense ID: 6sense’s ID corresponding to a unique company. If you have multiple Salesforce Accounts with the same 6sense ID, that means 6sense has identified those Accounts to represent the same company + country pair.
Opp Name: The name of the Opportunity as denoted in Salesforce.
Opp ID: The Salesforce Opportunity ID.
Opp Type: The type of the Opportunity as denoted in Salesforce.
Opp Stage: As of the beginning of the current month, the Stage of the Opportunity as denoted in Salesforce.
Opp Open Date: The date that the Opportunity was created, as denoted in Salesforce.
Opp Amount: As of the beginning of the current month, the size of the Opportunity as denoted in Salesforce.
Max Buying Stage: The maximum buying stage in the duration between 90 days prior to the Opportunity Open Date and the First Worked Date.
Days to Open after Max Buying Stage Prediction: The number of days it took to create the Opportunity after the account hit the Max Buying Stage.
First Worked Date: The first date that any sales task or outreach activity associated with this account was tracked in Salesforce.
Closed: As of the beginning of the current month, whether the Opportunity has been closed.
Won: As of the beginning of the current month, whether the Opportunity has been won.
Close Date: The Close Date of the Opportunity as denoted in Salesforce.
Relevant Opportunity: Whether the Opportunity is relevant to your predictive models, as determined during data onboarding for your organization. Please reach out to your Customer Success Manager for any questions on which opportunities are considered as relevant.
Accounts with No Created Opportunities
Account Name: 6sense’s normalized company name.
Account Website: 6sense’s normalized company website.
Account Country: The country associated with the account.
CRM Account ID: The Salesforce Account ID corresponding to the opportunity’s Account.
6sense ID: 6sense’s ID corresponding to a unique company. If you have multiple Salesforce Accounts with the same 6sense ID, that means 6sense has identified those Accounts to represent the same company + country pair.
Max Buying Stage: The highest Buying Stage for the account within the selected month.
First Date of Max Buying Stage: The first date that the account reached the Max Buying Stage in the selected month.
Activities by Source for Accounts with Opportunities
Account Name: 6sense’s normalized company name.
Account Website: 6sense’s normalized company website.
Account Country: The country associated with the account.
CRM Account ID: The Salesforce Account ID corresponding to the opportunity’s Account
Opp Name: The name of the Opportunity as denoted in Salesforce.
Opp ID: The Salesforce Opportunity ID.
Opp Type: The type of the Opportunity as denoted in Salesforce.
Opp Phase: Used to determine whether the following activities occurred before or after the Opportunity was created. Possible values are Pre-Pipeline and Post-Pipeline. Note that if you see the same Opportunity listed twice in this file, it is because the activities associated with that Account have been split into these Pre-Pipeline and Post-Pipeline phases, as visualized in the platform.
Anonymous Research Activities: Whether the Account performed any anonymous keyword research activities as identified by 6sense.
Anonymous Web Engagements: Whether the Account visited your website as identified by 6sense.
Known Web Engagements: Whether a known user associated with the Account visited your website, as typically tracked by your Marketing Automation Platform.
Marketing Reach Activities: Whether the Account was reached by any of your marketing activities, as tracked within your Marketing Automation Platform.
Marketing Engagement Activities: Whether the Account engaged with any of your marketing activities, as tracked within your Marketing Automation Platform.
Sales Reach Activities: Whether the Account was reached by any of your sales activities, as tracked within Salesforce.
Sales Engagement Activities: Whether the Account engaged with any of your sales activities, as tracked within Salesforce.
External Display Impressions: Whether the Account registered an impression for any external media campaigns.
External Display Engagements: Whether the Account registered a clickthrough or viewthrough on any external media campaigns.
6sense Display Impressions: Whether the Account registered an impression for any 6sense campaigns.
6sense Display Engagements: Whether the Account had a clickthrough or viewthrough on any 6sense campaigns.
Campaigns Influencing Opportunities
Note: All of the accounts shown in this download were reached by 6sense Campaigns in the corresponding month.
Existing Opp Status: As of the beginning of the selected month, whether the Account had an Open Opp or not. Possible values of No Open Opp and Existing Open Opp.
Account Name: 6sense’s normalized company name.
Account Website: 6sense’s normalized company website.
Account Country: The country associated with the account.
CRM Account ID: The Salesforce Account ID corresponding to the opportunity’s Account
6sense ID: 6sense’s ID corresponding to a unique company. If you have multiple Salesforce Accounts with the same 6sense ID, that means 6sense has identified those Accounts to represent the same company + country pair.
Opp Name: The name of the Opportunity as denoted in Salesforce.
Opp ID: The Salesforce Opportunity ID.
Opp Type: The type of the Opportunity as denoted in Salesforce.
Opp Stage: As of the beginning of the current month, the Stage of the Opportunity as denoted in Salesforce.
Engaged: Whether the Account had a clickthrough or viewthrough on any 6sense campaigns that month.
Increased Engagement: Whether the Account showed an increase in engagement after engaging with any 6sense campaign that month.
Closed: As of the beginning of the current month, whether the Opportunity has been closed.
Won: As of the beginning of the current month, whether the Opportunity has been won.
Pipeline: As of the beginning of the current month, the Opportunity amount as denoted in Salesforce.
Close Date: The Close Date of the Opportunity as denoted in Salesforce.
Website Match Rates
Note: These metrics only consider webpages which have been configured to be tracked by 6sense’s analytics, based on installation of the web tag. The downloaded file will only contain data shown in the application, corresponding to the previous 13 months.
Month: The month used to aggregate the metrics below. Note that the downloaded file will contain data for the months shown in the visualization (representing the past year).
Total Pageviews: The number of times your webpages have been loaded.
Matched Pageviews: The number of your pageviews 6sense was able to identify as coming from a known company in 6sense’s database.
Pageview Match Rate: Matched Pageviews / Total Pageviews.
Distinct Visitors: The number of unique people who visited your website, regardless of the number of sessions or pageviews they contributed.
Matched Visitors: The number of Distinct Visitors that 6sense was able to identify as coming from a known company in 6sense’s database.
Visitor Match Rate: Matched Visitors / Distinct Visitors.
Accounts Identified: The number of unique companies that 6sense identified across your Matched Visitors.
Relevant Opportunities Definition
The help icon next to “Exclude Irrelevant Opportunities” option displays the business-specific relevant opportunity definition based on the setup for company-specific models, and a downloadable sample of opportunity data to help understand this definition. The sample sheet contains the latest 20 records from the company’s data to provide additional details for clarity.
Product: 6sense’s normalized company’s product name.
Account Name: 6sense’s normalized company name.
Account Website: 6sense’s normalized company website.
Account Country: The country associated with the account.
CRM Account ID: The Salesforce Account ID corresponding to the opportunity’s Account.
6sense ID: 6sense’s ID corresponding to a unique company. If you have multiple Salesforce Accounts with the same 6sense ID, that means 6sense has identified those Accounts to represent the same company + country pair.
Opp Name: The name of the Opportunity as denoted in Salesforce.
Opp ID: The Salesforce Opportunity ID.
Opp Type: The type of the Opportunity as denoted in Salesforce.
Opp Stage: As of the beginning of the current month, the Stage of the Opportunity as denoted in Salesforce.
Opp Open Date: The date that the Opportunity was created, as denoted in Salesforce.
Opp Amount: As of the beginning of the current month, the size of the Opportunity as denoted in Salesforce.
Max Buying Stage: The maximum buying stage in the duration between 90 days prior to the Opportunity Open Date and the First Worked Date.
Days to open after Max Buying Stage Prediction: The number of days it took to create the Opportunity after the account hit the Max Buying Stage.
First Worked Date: The first date that any sales task or outreach activity associated with this account was tracked in Salesforce.
Closed: As of the beginning of the current month, whether the Opportunity has been closed.
Won: As of the beginning of the current month, whether the Opportunity has been won.
Close Date: The Close Date of the Opportunity as denoted in Salesforce.
Relevant Opportunity: Whether the Opportunity is relevant to your predictive models, as determined during data onboarding for your organization.