Reconcile recorded campaign interactions with offline invoices using supplied business identifiers and a defined window. Measure matched and unmatched sales, resolve exceptions and prove the totals against the invoice export.
Offline attribution links recorded marketing interactions to offline sales under a stated credit rule. Start with the identifiers already supplied in your CRM and invoice exports, apply the timing window, and reconcile matched plus unmatched revenue to the full sales cohort. A match is evidence for assigning credit, not proof that the interaction caused the sale.
An offline outcome can be a signed contract, an in-person sale or an invoice raised after a sales conversation. Pick the event that answers your business question and retain its date. A contract value, an invoice amount and a cash receipt describe different stages; they should not be combined into one revenue total.
Google Ads describes offline conversions as outcomes that occur away from the online interaction, including sales at an office or over the phone. The business reconciliation here starts from records your organization already has. It does not require treating an advertising-platform conversion count as the financial sales total.
For this example, the outcome is net invoiced merchandise sales from a defined invoice cohort. Each invoice has one unique invoice ID, and credit memos are linked to the invoice they reduce. Shipping and sales tax are outside the displayed amounts. The report states the date through which credit memos have been included.
Use an invoice export containing invoice ID, customer or account ID, invoice date, invoice amount, related credits and currency. Use a CRM export containing the recorded interaction ID, campaign, interaction date and supplied lead or account identifier. If the systems use different IDs, obtain the existing cross-reference between them.
An account-level match needs care. One account may contain several buying groups, opportunities or locations. Decide whether the supplied account connection is sufficient for this analysis. If the report requires an opportunity-level match and that reference is absent, an account match should remain an exception rather than being quietly accepted.
Write the rules before reviewing the totals:
For general credit allocation, use the marketing attribution models comparison. This article focuses on whether the offline sales cohort can be reconciled to the recorded evidence, including the part that cannot be assigned.
A fictional US equipment distributor reviews the following invoices. The interaction records and customer cross-reference are supplied by its sales operations team. Finance has summarized credit memos by original invoice before the matching review.
| Invoice | Matching outcome | Campaign credited | Invoice amount (USD) | Credits (USD) | Net sales (USD) |
|---|---|---|---|---|---|
| O201 | Supplied ID; interaction in window | Trade show | 12,000 | 0 | 12,000 |
| O202 | Supplied ID; interaction in window | Trade show | 8,000 | 1,000 | 7,000 |
| O203 | Supplied ID; interaction in window | Webinar | 6,000 | 0 | 6,000 |
| O204 | Missing cross-reference | Unmatched | 4,000 | 0 | 4,000 |
| O205 | Interaction outside window | Unmatched | 3,000 | 0 | 3,000 |
| O206 | Conflicting candidate records | Unresolved | 2,000 | 0 | 2,000 |
| Total | 35,000 | 1,000 | 34,000 |
Net sales equal invoice amount minus credits on every row. Trade-show credit is 12,000 + 7,000 = $19,000; webinar credit is $6,000. Assigned revenue is therefore 19,000 + 6,000 = $25,000.
The remaining amounts are 4,000 + 3,000 + 2,000 = $9,000. Keep the unresolved $2,000 distinct in the exceptions view even though it is included in the combined unassigned total. Do not choose whichever candidate produces the more attractive campaign result.
The reconciliation identity is:
Assigned net sales + Unassigned net sales = Total cohort net sales
Revenue match coverage = Assigned net sales / Total cohort net sales
For this cohort, 25,000 + 9,000 = $34,000. The independent invoice check is 35,000 - 1,000 = $34,000. These totals must agree with the corresponding invoice-register subtotal before anyone compares campaigns.
Revenue match coverage is 25,000 / 34,000 = 73.5%, rounded to one decimal place. Invoice-count coverage is 3 / 6 = 50.0%. Both percentages matter: the accepted matches cover a larger share of sales dollars than invoice count because the matched invoices carry larger amounts.
Report the denominator. A team that shows only $25,000 of credited sales hides the $9,000 it could not assign. A team that shows only the count percentage hides the value concentrated in the accepted matches. If net sales are zero or negative, show the dollar bridge and explain why a coverage percentage is not useful.
Suppose sales operations supplies the missing cross-reference for O204 and the recorded interaction meets every existing rule. That $4,000 can move from unassigned to assigned without changing any invoice.
| Reconciliation | Original review (USD) | After O204 is validated (USD) |
|---|---|---|
| Assigned net sales | 25,000 | 29,000 |
| Unassigned net sales | 9,000 | 5,000 |
| Total cohort net sales | 34,000 | 34,000 |
Revised revenue coverage is 29,000 / 34,000 = 85.3%. Invoice-count coverage is 4 / 6 = 66.7%. Percentages are rounded to one decimal place. The higher assigned amount reflects more complete evidence, not additional sales generated by the campaign.
Google's attribution documentation defines attribution around assigning credit. Keep that reporting meaning separate from cause attribution, which concerns causal explanations. Covirage is not affiliated with Google.
Sales operations owns the identifier cross-reference and unresolved CRM records. Marketing owns campaign labels and the proposed credit policy. Finance owns the invoice basis, credit adjustments and total reconciliation. Together they can decide whether the next step is better record capture, an exception review or a campaign economics assessment.
Keep timing analysis separate too. Sales velocity across two quarters examines how opportunities move into sales; offline match coverage asks which recorded sales have eligible campaign evidence.
Bring a sample of your own CRM interaction and invoice exports, including the supplied identifier cross-reference and the rules used for accepted matches. Covirage maps the columns, and its tools compute and check the supplied matched and unmatched figures; the external AI model explains the results with every figure traced to its rows. Create a free Covirage account in about a minute, then set up your business and bring your file.
See sales insights for the supporting business context.
A company matches a recorded trade-show interaction to a later invoice using a lead-to-customer reference already present in its exports. If the match meets the timing and credit rules, that invoice receives trade-show credit in the report.
Keep them in the sales reconciliation as unmatched. Show why they remain unmatched, such as a missing identifier, no eligible interaction or competing records. They remain real sales even though the available campaign evidence cannot support an assignment.
No. A valid match establishes a recorded relationship under a credit rule. Customers may have purchased without that interaction. A separate causal evaluation is needed to estimate incremental sales; higher match coverage alone does not establish marketing effectiveness.