KPI Tree

Salesforce Metric

Sales

Activity Based Analysis = Won Opportunities Linked to Activities / Total Activities Logged in Period x 100

Activity Based Analysis measures the relationship between logged sales activities in Salesforce, such as calls, emails, tasks and meetings, and the outcomes they drive across opportunities and accounts. In Salesforce these activities live on the Task and Event objects tied to leads, contacts, opportunities and accounts, which lets you connect effort to pipeline movement and closed revenue. It shifts reporting from raw activity counts towards understanding which activity patterns correlate with conversion and won deals.

Full guide: definition, formula, and benchmarks

Activity Based Analysis

Activity Based Analysis measures the relationship between logged sales activities in Salesforce, such as calls, emails, tasks and meetings, and the outcomes they drive across opportunities and accounts. In Salesforce these activities live on the Task and Event objects tied to leads, contacts, opportunities and accounts, which lets you connect effort to pipeline movement and closed revenue. It shifts reporting from raw activity counts towards understanding which activity patterns correlate with conversion and won deals.

How to calculate activity based analysis

Activity Based Analysis = Won Opportunities Linked to Activities / Total Activities Logged in Period x 100

Why activity based analysis matters for Salesforce users

Salesforce makes it easy to count activities but hard to see which of them actually move deals forward. Activity Based Analysis closes that gap by tying logged calls, emails and meetings to opportunity stage changes and closed outcomes, so leaders can tell productive effort apart from busywork.

For a sales team, this reveals the cadence and mix of touches that precede a win, helps coach reps who are active but not converting, and exposes accounts that have gone quiet before they slip. It turns the activity feed into a forecasting and coaching signal rather than a vanity number.

Understand and act on activity based analysis with KPI Tree

Sync your Salesforce Task, Event, Opportunity and Account data into your warehouse and compute Activity Based Analysis in KPI Tree, joining activities to the opportunities and accounts they are logged against. Place it in a metric tree alongside activity volume per rep and contact conversion rate so you can see how raw effort flows through to conversion and revenue.

Assign RACI ownership in KPI Tree, with sales operations accountable for the definition and frontline managers responsible for acting on it, then set a weekly review cadence aligned to your pipeline reviews so the analysis informs coaching and forecasting in real time.

Get started with your Salesforce data

Data Warehouse
SnowflakeBigQueryDatabricksRedshift

Connect your existing warehouse where Salesforce data already lands.

Professional Services
FivetranSnowflakedbt

Our professional services team can build you turn-key AI foundations in a matter of weeks. Data warehouse on Snowflake/BigQuery, ELT with Fivetran, all modelled in dbt with a semantic layer.

Related Salesforce metrics

Activity Volume per Rep

CRM

Metric Definition

Activity Volume per Rep = Total Logged Activities / Number of Active Reps

Activity volume per rep measures the total number of logged activities (calls, emails, meetings, tasks) per sales representative in Salesforce over a defined period. It quantifies the effort each rep invests in customer-facing and pipeline-building activities and serves as a baseline for evaluating activity efficiency.

View metric

Contact Conversion Rate

CRM

Metric Definition

Contact Conversion Rate = (Contacts with Opportunities / Total Qualified Contacts) x 100

Contact conversion rate measures the percentage of contacts in Salesforce that become associated with an opportunity. It evaluates the effectiveness of lead qualification, nurturing, and sales development at converting the contact database into active pipeline.

View metric

Account Health Score

CRM

Metric Definition

Account health score is a composite metric that evaluates the overall strength of a customer relationship using Salesforce data. It combines activity recency, opportunity pipeline status, support ticket trends, product adoption signals, and engagement frequency to produce a single score indicating whether an account is thriving, stable, or at risk.

View metric

Customer Acquisition Cost

CRM

Metric Definition

Customer Acquisition Cost = Total Sales & Marketing Spend / Number of New Customers Won

Customer acquisition cost (CAC) measures the total sales and marketing investment required to win a new customer. Using Salesforce opportunity data, campaign costs, and activity records, CAC quantifies acquisition efficiency and determines the breakeven point for each new customer relationship.

View metric

Explore activity based analysis across integrations

Empower your team to understand and act on Salesforce data

Map what drives your metrics, measure progress at any grain, prove what works statistically, and deliver personalised action plans to every team member.

Experience That Matters

Built by a team that's been in your shoes

Our team brings deep experience from leading Data, Growth and People teams at some of the fastest growing scaleups in Europe through to IPO and beyond. We've faced the same challenges you're facing now.

Checkout.com
Planet
UK Government
Travelex
BT
Sainsbury's
Goldman Sachs
Dojo
Redpin
Farfetch
Just Eat for Business