Marketing data: sources, fields and reconciliation

Marketing data is the record of marketing spending, audience activity and the business outcomes you can connect to them. It becomes useful when campaign, account and opportunity identifiers link those records under agreed dates and definitions. A collection of exports is ready for analysis only when its inclusions, exclusions and unmatched amounts can be explained.

Inventory the files around a business question

Start with a specific request: which campaigns generated qualified accounts, and what recorded revenue is associated with those accounts? That determines the minimum fields. Collecting every available field adds review work without necessarily answering the question.

Use an inventory that distinguishes what each source can establish:

An attendance entry is not a qualified account. An opportunity amount is not recorded revenue. Keep these distinctions in the column names so a later summary cannot quietly substitute one for another.

For the question of evaluating data collected directly through your customer relationships, see first-party marketing data analysis. This page covers the inventory and readiness checks across the supplied files.

Agree identifiers and definitions before matching

Campaign names change; stable campaign IDs should carry the match. Use an approved crosswalk when an agency's campaign ID differs from the CRM's ID. The campaign owner should approve the crosswalk rather than asking a reporting analyst to infer equivalence from similar names.

Account identifiers need the same care. Decide whether the reporting unit is a legal entity, buying location or parent company. A parent and its subsidiaries cannot sometimes count as one account and sometimes as several merely because different exports use different labels.

Create a short definition sheet alongside your review process:

• The date field that places each record in the period.
• The currency and any approved conversion basis.
• The qualification rule and its responsible owner.
• The treatment of credits, cancellations and adjustments.
• The outcome assignment rule when several campaigns touched an account.

The marketing attribution guide explains alternative assignment rules. Data readiness means documenting and applying the selected rule; it does not mean choosing whichever rule produces the strongest campaign result.

Where staff enter campaign labels into an Excel reporting copy, controlled entries can help. Microsoft's data validation documentation describes restricting the types or values entered in cells. A permitted-value list can prevent new spelling variations, although it does not prove that the selected campaign is correct.

A worked reconciliation for a US supplier

Consider an illustrative US industrial supplier reviewing a completed campaign quarter. All amounts are USD. Finance supplies the credits that belong against the campaign service period; the analyst keeps their signs when building net spending.

The spending arithmetic is 18,000 - 1,000 = $17,000 for Search, 9,000 + 0 = $9,000 for Events and 6,000 - 500 = $5,500 for Partners. Together, 33,000 - 1,500 = $31,500. The campaign net amounts must also sum to that figure.

The account export starts with repeated records and unresolved IDs. Keep a count bridge rather than simply replacing the original file:

The count check is 60 - 4 - 2 = 54, matching 28 + 16 + 10. Here, each accepted account has one approved source campaign. Repeated engagement events remain valid in their own activity file; they are duplicates only if incorrectly used as repeated account qualifications.

Keep the original records before using a deletion tool. Microsoft warns that Excel's Remove Duplicates feature permanently deletes duplicate data and recommends preserving a copy. Covirage is not affiliated with Microsoft.

Measure coverage without hiding what is missing

The finance control total is wider than the matched campaign amount:

Revenue match coverage = Matched net revenue / In-scope finance net revenue

Coverage is 150,000 / 160,000 = 93.75%. The bridge is 150,000 + 10,000 = $160,000. Amounts are whole dollars; coverage is shown to two decimal places.

This proves reconciliation, not causal impact. It also does not establish whether the unassigned revenue would change a campaign ranking. Assign an owner to investigate that remainder before making a material spending decision.

Marketing operations owns campaign definitions and account crosswalks. Sales operations confirms qualification and opportunity records. Finance approves costs, net revenue and adjustment treatment. The analyst assembles the evidence and reports exceptions; the source owners resolve disputed meanings.

Once the checks pass, build the marketing dashboard. Use the separate customer acquisition cost guide when defining the broader acquisition cost pool rather than treating campaign spending alone as complete CAC.

Where it goes wrong

• Names used as identifiers. Similar company names can represent different entities. Use approved IDs and hold uncertain matches aside.
• Mixed row meanings. Contacts, event responses and accounts are different units. Count the unit the business question actually names.
• Credits lost during cleanup. Removing negative amounts overstates spending or revenue. Reconcile signed amounts to finance.
• Different financial periods. Invoice dates and service periods can differ. Apply the approved period rule consistently.
• Unmatched values omitted. A tidy matched table can conceal incomplete coverage. Publish the remainder beside the matched amount.

Check your marketing files in Covirage

Bring campaign spending, CRM outcomes and finance exports after their definitions and approved identifiers are settled. Covirage maps the columns; its tools compute and check the figures, and 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 self-service analytics for the supporting approach to working from business files.