Customer relationship management analytics compares account activity, opportunity outcomes, and recorded revenue. Work through a dated opportunity cohort and reconcile customer results to CRM and finance exports.
Customer relationship management analytics connects recorded account activity, opportunity conversion, and commercial outcomes. Start with customer and opportunity IDs, compare the same dated populations, and keep CRM opportunity value separate from finance's recorded revenue.
The useful question is not simply whether sales activity increased. It is which accounts received attention, what happened to their opportunities, and what commercial results appear in the records. Those comparisons support an account review without claiming that activity caused a sale.
A CRM organizes information about customers, prospects, and their interactions. Salesforce's CRM explanation describes customer and prospect records, sales opportunities, and service issues as information a CRM can hold. Your export determines which of those records you can actually analyze.
Keep the main measures distinct:
| Measure | Question answered | Source rows | Required boundary |
|---|---|---|---|
| Account activity coverage | Which eligible accounts had recorded completed activity? | Activities matched to an account list | Activity period and eligible accounts |
| Opportunity conversion | Which opportunities reached a defined outcome? | One row per opportunity | Entry cohort, stage rule, and observation cutoff |
| Open opportunity value | What recorded opportunity value is still unresolved? | Open opportunities at the cutoff | Snapshot date and currency |
| Recorded revenue | What revenue did finance record for these accounts? | Posted revenue entries, including credits | Finance reporting period and revenue basis |
The customer denominator guide explains why the account population must be defined before interpreting a coverage percentage. Include eligible accounts with no activity; otherwise the measure answers a different question.
A US business supplier reviews opportunities created during July 2026, observed through September 30, 2026. The example has one row per opportunity, in columns A:F of a worksheet named Opportunities. Won and Lost are final outcomes under the company's documented sales rules; Open means unresolved at the cutoff.
| Opportunity ID | Account ID | Created date | Outcome | Decision date | Opportunity value (USD) |
|---|---|---|---|---|---|
| Q01 | A01 | July 3, 2026 | Won | August 5, 2026 | 20,000 |
| Q02 | A01 | July 10, 2026 | Lost | September 3, 2026 | 10,000 |
| Q03 | A02 | July 5, 2026 | Won | September 10, 2026 | 15,000 |
| Q04 | A03 | July 12, 2026 | Lost | August 19, 2026 | 12,000 |
| Q05 | A04 | July 15, 2026 | Open | — | 8,000 |
| Q06 | A02 | July 20, 2026 | Open | — | 15,000 |
The dashes represent empty decision-date cells. In a real export, check that every final outcome has a valid date no later than the observation cutoff. Do not include an October win in this September snapshot.
Closed-opportunity win rate = Won opportunities / (Won opportunities + Lost opportunities)
Cohort win share to date = Won opportunities / All opportunities in the entry cohort
In Excel, calculate the first measure with:
=COUNTIFS(D2:D7,"Won")/(COUNTIFS(D2:D7,"Won")+COUNTIFS(D2:D7,"Lost"))
Microsoft documents COUNTIFS for counting records that meet specified criteria. The formula assumes the rows already meet the cohort and cutoff rules; it does not validate those rules itself.
| Calculation | Working | Result |
|---|---|---|
| Won opportunities | Q01 + Q03 | 2 |
| Lost opportunities | Q02 + Q04 | 2 |
| Closed opportunities | 2 won + 2 lost | 4 |
| Open opportunities | Q05 + Q06 | 2 |
| All cohort opportunities | 4 closed + 2 open | 6 |
| Closed-opportunity win rate | 2 / 4 | 50.0% |
| Cohort win share to date | 2 / 6 | 33.3% |
| Won opportunity value (USD) | 20,000 + 15,000 | 35,000 |
| Open opportunity value (USD) | 8,000 + 15,000 | 23,000 |
Percentages are rounded to one decimal place. Both win measures are valid, but they describe different denominators. The open opportunities have not become losses simply because they remain unresolved. For a sequence involving several dated stages, use customer journey analytics examples rather than treating a current stage field as complete event history.
Now add the company's five eligible accounts. The activity export supplies completed activity counts for July 1 through September 30 after duplicate activity IDs are removed. Finance supplies posted net revenue for those dates under its approved reporting policy.
The account worksheet uses columns A:F below. Finance revenue is an input from the separately reconciled account summary; opportunity counts and values come from the opportunity rows above.
| Account ID | Completed activities | Recorded revenue (USD) | Closed opportunities | Won opportunities | Won opportunity value (USD) |
|---|---|---|---|---|---|
| A01 | 6 | 18,000 | 2 | 1 | 20,000 |
| A02 | 3 | 9,000 | 1 | 1 | 15,000 |
| A03 | 2 | 0 | 1 | 0 | 0 |
| A04 | 1 | 0 | 0 | 0 | 0 |
| A05 | 0 | 2,500 | 0 | 0 | 0 |
| Total | 12 | 29,500 | 4 | 2 | 35,000 |
For example, calculate won count in E2 and won value in F2, then fill down:
=COUNTIFS(Opportunities!$B$2:$B$7,A2,Opportunities!$D$2:$D$7,"Won")
=SUMIFS(Opportunities!$F$2:$F$7,Opportunities!$B$2:$B$7,A2,Opportunities!$D$2:$D$7,"Won")
Microsoft's worksheet-sums guide explains conditional sums for grouped amounts. Covirage is not affiliated with Microsoft or Salesforce.
Activity coverage is four accounts with completed activity divided by five eligible accounts, or 80.0%. Activity volume reconciles as 6 + 3 + 2 + 1 + 0 = 12. The opportunity summary reconciles to four closed opportunities, two wins, and $35,000 won value.
Finance revenue reconciles as $18,000 plus $9,000 plus $2,500 equals $29,500. It is not a conversion percentage against won value: the revenue period can include earlier orders, partial fulfillment, and credits. A05's revenue with no recorded activity warrants a record review; it does not prove that the account needed no sales attention.
Sales operations owns identifiers, stage definitions, and activity completeness. Finance owns the revenue basis and its source reconciliation. Account managers explain the commercial circumstances behind the checked rows.
Ask why A03 has activity and a lost opportunity, whether A04's open opportunity needs follow-up, and whether A05's activity history is complete. Add verified customer segments from ledger records when account size or buying pattern changes the comparison. Service workload belongs in a separate customer care analytics review rather than being inferred from sales calls.
Bring a sample of your own account, activity, opportunity, and finance exports with stable IDs and clear reporting dates; Covirage maps the columns, and its tools compute and check the comparisons. The external AI model explains the results with every figure traced to its rows. Create a free Covirage account, then set up your business and bring your file.
See sales insights for the supporting commercial workflow.
Reporting presents recorded measures such as activity counts and opportunity stages. Analytics uses those measures to answer a business question, such as which accounts have activity but no completed sales. Both require agreed definitions and a way to check the underlying records.
Start with account activity coverage, closed-opportunity win rate, open opportunities, and recorded revenue by account. Define the eligible account list and reporting dates first. Add more measures only when they support a decision and the required fields are reliable.
It represents a recorded sales outcome under your CRM rules. Revenue comes from finance's reporting policy and may be recorded in a different period or amount. Payment collection is another event. Compare these measures separately unless you have the records needed to reconcile them.
Sales operations should own account matching, activity definitions, and opportunity-stage rules. Finance should approve the recorded revenue basis and reconciliation. Sales managers use the checked results to review accounts and decide what follow-up is appropriate.