Compare automated workflows using entrants, opportunities, won customers and recorded revenue. Build an account-level report from campaign and CRM exports, then reconcile its counts and costs before changing a workflow.
Marketing automation analytics compares workflow entrants with the opportunities, customers and revenue recorded after enrollment. Start with the workflow export, match it to CRM accounts and use a fixed follow-up window. Count people or accounts consistently, rather than treating every automated message as another chance to win the same customer.
Choose a question a marketing manager can act on: does the pricing follow-up workflow bring more qualified opportunities per entrant than the educational workflow? That is narrower and more useful than asking which workflow has the most activity.
Marketing analytics and automation work together when the reporting definitions survive a workflow change. Record the entry condition, intended audience, workflow version and owner before comparing results. A new entry rule can change audience intent even when the messages stay the same.
Keep the business question separate from building or sending the automation. For earlier funnel definitions, see B2B marketing analytics. For the distinct question of investment returns, use marketing automation ROI.
For this example, the reporting unit is a company account. A US business services company has an account ID on its campaign and CRM exports. It assigns each eligible new account to its first qualifying workflow; subsequent enrollments remain in an overlap worksheet rather than creating more acquisition rows.
Prepare a worksheet with these columns:
| Column | Field | Preparation rule |
|---|---|---|
| A | Account ID | One unique account per row |
| B | Assigned workflow | First qualifying workflow under the written rule |
| C | Enrollment date | Date the account first became eligible |
| D | Opportunity flag | One if an eligible opportunity appeared within the window |
| E | Won flag | One if an eligible new-customer contract won within the window |
| F | Recognized revenue (USD) | Revenue recorded for that account within the window |
Use zero flags only for a confirmed absence of the event, not a missing CRM match. Keep unmatched records in an exception worksheet. Revenue comes from finance-approved records; an opportunity amount or signed contract value is not automatically recognized revenue.
Take June 2026 entrants and measure each account's first 45 days after enrollment. Extract after the latest entrant has completed that window. Do not allow early June entrants to contribute more days of revenue simply because they entered earlier.
Build the opportunity flag, won flag and revenue amount using those account-specific observation dates before summarizing. The source exports need event dates and revenue dates to support that boundary. If only current CRM status is available, label the report as a status snapshot; it cannot faithfully reconstruct when each event happened.
Marketing operations owns enrollment and assignment. Sales operations checks opportunity and account matching. Finance approves recognized revenue and the workflow cost schedule. This division gives each exception a clear owner.
The prepared account worksheet produces the following illustrative summary. The direct workflow costs include allocated platform and content costs under a documented allocation rule, with shared costs allocated once. They exclude sales salaries and corporate overhead.
| Workflow | Entrants | Opportunities | Won customers | Recognized revenue (USD) | Direct workflow cost (USD) |
|---|---|---|---|---|---|
| Pricing follow-up | 600 | 90 | 18 | 54,000 | 9,000 |
| Education sequence | 900 | 72 | 18 | 36,000 | 6,000 |
| Total | 1,500 | 162 | 36 | 90,000 | 15,000 |
In the account worksheet, put the desired workflow name in H2. Count entrants, opportunities and wins:
=COUNTIFS(B2:B5000,H2,A2:A5000,"<>")
=COUNTIFS(B2:B5000,H2,D2:D5000,1)
=COUNTIFS(B2:B5000,H2,E2:E5000,1)
Microsoft documents COUNTIFS as counting rows that satisfy all specified criteria. The account rows must already be deduplicated and restricted to the selected cohort; the function does not establish unique business membership for you.
Sum recognized revenue for that workflow:
=SUMIFS(F2:F5000,B2:B5000,H2)
Microsoft's SUMIFS documentation explains the conditional sum used here. Keep the cost schedule separate from account revenue so shared invoices do not repeat across account rows.
In the summary table, with workflow in A and the remaining columns in B:F, derive the comparison measures:
=C2/B2
=D2/B2
=E2/B2
=F2/D2
These give opportunity conversion, customer conversion, revenue per entrant and direct workflow cost per won customer, respectively. Display percentages and per-unit dollars to two decimal places; retain unrounded values in the worksheet.
| Workflow | Opportunity conversion | Customer conversion | Revenue per entrant (USD) | Cost per won customer (USD) |
|---|---|---|---|---|
| Pricing follow-up | 15.00% | 3.00% | 90.00 | 500.00 |
| Education sequence | 8.00% | 2.00% | 40.00 | 333.33 |
| Total | 10.80% | 2.40% | 60.00 | 416.67 |
The total customer conversion is 36 divided by 1,500, or 2.40%. Total revenue per entrant is $90,000 divided by 1,500, or $60.00. Do not average the workflow rates because the audience counts differ.
Pricing follow-up has higher recorded conversion and revenue per entrant. Education has lower direct workflow cost per won customer. Both statements can be true because the audience, revenue profile and assigned costs differ.
Before allocating more budget, ask whether pricing entrants were already closer to buying. Marketing automation and analytics can reveal this selection difference; a source comparison alone cannot measure how many sales the automation caused.
Check that the account rows reproduce all 1,500 entrants and 36 wins. Reconcile the $90,000 revenue to the eligible finance rows and $15,000 cost to the allocation schedule. If enrollment overlaps are reported separately, label those counts as nonadditive.
The cost per win above covers only the stated workflow costs. Use the separate customer acquisition cost guide for a broader acquisition expense calculation. The marketing ROI versus ROAS guide covers the margin test before calling an outcome profitable.
Covirage is not affiliated with Microsoft.
Bring a sample of your own workflow, CRM and finance exports; 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, which takes about a minute, then set up your business and bring your files.
See sales insights for the business context.
Measure unique entrants, opportunities, won customers and recorded revenue under a consistent follow-up window. Delivery and engagement can diagnose a workflow, but they do not replace commercial outcomes. Document the costs included so readers can distinguish a workflow comparison from a full profitability calculation.
Show the audience counts alongside opportunity conversion, customer conversion and revenue per entrant. Calculate the total rate from total outcomes divided by total eligible entrants. Before ranking workflows, check whether audience intent, eligibility and the amount of follow-up time are comparable.
Yes, but overlapping membership can make summed workflow revenue misleading. For an additive acquisition report, assign each account to one workflow under a documented rule. Keep additional workflow participation in a separate view, and avoid presenting its repeated revenue as additional company revenue.
No. A workflow aimed at pricing inquiries may start with more motivated buyers than an educational sequence. The comparison describes recorded outcomes for those audiences. To estimate incremental impact, use a suitable randomized comparison or another evaluation that addresses selection and competing influences.