Organic marketing analytics connects unpaid acquisition with recorded commercial outcomes. This guide works through matched traffic and lead cohorts, opportunities, customer revenue, spreadsheet formulas, and reconciliation checks.
Organic marketing analytics connects unpaid acquisition with the leads, opportunities, and customer revenue recorded after it. Compare sources over consistent cohort windows, because a larger traffic count does not by itself establish stronger commercial performance.
The practical output is a source table that a marketing manager and sales operations lead can reconcile together. It should show the denominator behind each rate, the observation window, and which revenue rows belong to which customer.
Begin with the source classifications already present in your traffic and CRM exports. Google Analytics' default channel definitions distinguish Organic Search and Organic Social as traffic arriving through non-ad links in search results and social sites. Referral is a separate channel; review referral records before including them in an unpaid acquisition comparison.
For the example below, the business includes organic search, organic social, and referrals it has confirmed are unpaid. It excludes paid placements and compensated referrals. Keep unknown sources visible during reconciliation rather than quietly assigning them to organic.
Choose one source rule for leads. Here, each lead retains the source of its first qualifying inquiry. Sessions in the traffic export use the session channel, not a first-user channel. Only calculate a session-to-lead rate when the inquiry records can be mapped to the corresponding sessions and source definitions.
The rule provides a consistent accounting view of recorded outcomes. It does not allocate causal credit across every contact. For sales progression across a broader set of campaigns, see CRM marketing analytics.
Use a traffic export summarized by source and period, a CRM export with unique lead and opportunity IDs, and an invoice register with customer IDs and credit amounts. Keep the original IDs when assigning sources or grouping records.
Resolve duplicate leads before counting opportunities. Link opportunities through an agreed lead-to-account mapping, and allocate each customer's revenue to only one acquisition cohort in this report. A customer with several contacts must not have its entire invoice history repeated for each contact.
The fictional US supplier below reviews April 2026 inquiries. Every lead receives a 90-day outcome window starting at its own creation date, with an export cutoff of July 31, 2026. Count opportunities created and customers first won within that window; include invoices issued within it and their identified credits through the cutoff. These are net invoiced sales, not cash collections or a claim about accounting revenue recognition.
This cohort boundary differs from a calendar-month sales report. The latter includes older customers acquired in other periods. Explain the difference when reconciling totals instead of forcing unlike reports to match.
The supplier's checked exports produce the following summary. Columns A through H hold source, sessions, leads, opportunities, customers, invoice value, credits, and net invoiced revenue. All counted opportunities belong to the displayed leads, and each lead contributes at most one to the opportunity count.
| Source | Sessions | Leads | Opportunities | Customers | Invoices (USD) | Credits (USD) | Net revenue (USD) |
|---|---|---|---|---|---|---|---|
| Organic search | 3,000 | 90 | 18 | 6 | 72,000 | 3,000 | 69,000 |
| Organic social | 2,000 | 80 | 8 | 2 | 18,000 | 2,000 | 16,000 |
| Unpaid referrals | 1,000 | 50 | 15 | 5 | 60,000 | 1,000 | 59,000 |
| Total | 6,000 | 220 | 41 | 13 | 150,000 | 6,000 | 144,000 |
In Google Sheets, calculate H2 from F2 and G2, then fill through row 4:
=F2-G2
The commercial comparisons follow directly. Percentages are rounded to two decimal places, and revenue per lead to the nearest cent. Calculations use unrounded underlying amounts.
| Source | Leads / sessions | Opportunities / leads | Customers / leads | Net revenue / lead (USD) |
|---|---|---|---|---|
| Organic search | 3.00% | 20.00% | 6.67% | 766.67 |
| Organic social | 4.00% | 10.00% | 2.50% | 200.00 |
| Unpaid referrals | 5.00% | 30.00% | 10.00% | 1,180.00 |
| Total | 3.67% | 18.64% | 5.91% | 654.55 |
Use these formulas against the summary row, formatting the first three results as percentages:
=IF(B2=0,"",C2/B2)
=IF(C2=0,"",D2/C2)
=IF(C2=0,"",E2/C2)
=IF(C2=0,"",H2/C2)
Search produces 90 leads from 3,000 sessions, or 3.00%. Its net revenue is 72,000 - 3,000 = $69,000, giving 69,000 / 90 = $766.67 per lead. Social has the stronger inquiry rate but lower recorded revenue per lead. That identifies a question about audience fit, qualification, or sales handling; it does not prove any one explanation.
On a separate Leads tab, keep one checked row per lead: A is lead ID, B is cohort source, C is creation date, and H is the assigned net invoiced revenue within the stated window. After the matching and date checks, this Google Sheets formula sums the revenue for the source in summary cell A2:
=SUMIFS(Leads!$H$2:$H$221,Leads!$B$2:$B$221,A2,Leads!$C$2:$C$221,">="&DATE(2026,4,1),Leads!$C$2:$C$221,"<"&DATE(2026,5,1))
Google Sheets documents SUMIFS as summing a range subject to multiple criteria. The formula assumes each assigned revenue amount has already passed the customer, timing, and duplication checks; summation cannot repair an incorrect match.
The proof is explicit: 90 + 80 + 50 = 220 leads, 18 + 8 + 15 = 41 opportunities, and 6 + 2 + 5 = 13 customers. Revenue ties both ways: 69,000 + 16,000 + 59,000 = $144,000, matching 150,000 - 6,000. Every included invoice and credit must appear once in that bridge.
Total conversion is 220 / 6,000 = 3.67%, not the simple average of the three source rates, which is 4.00%. Ratios use summed numerators and denominators. Customer acquisition cost adds the separate cost question; marketing ROI versus ROAS covers return calculations once the expense boundary is agreed.
For the wider business-to-business measurement context, see B2B marketing analytics. Covirage is not affiliated with Google.
Bring your source summary, matched CRM export, and invoice and credit rows with an agreed cohort window. Covirage maps the columns, and its tools compute and check the source comparisons; the external AI model explains the results with every figure traced to its rows. Create a free Covirage account and bring a sample of your own data.
See Covirage for sales insights for the supporting business context.
Unpaid acquisition means there is no media charge for that particular placement or click. Content production, staff time, agencies, and measurement can still cost money. An outcome report should not call revenue profit or treat an unpaid channel as having no operating cost.
Choose a window that fits your company's buying cycle and the decision being made. Compare cohorts with the same observation period. If newer cohorts have not completed that period, label their outcomes incomplete rather than treating missing future sales as zero performance.
It shows recorded outcomes under the source rule you chose. It does not establish what customers would have done without the activity. Branded demand, prior paid exposure, account relationships, and other contacts can contribute to the same eventual sale.