An Agency Report That Connects Marketing Spend to Accepted Opportunities

A client asks what the agency's campaign produced. The report shows visits, clicks and form submissions. The client asks again: which of those became opportunities the sales team was willing to work?

You need a report that can follow the relationship beyond the form without claiming ownership of every deal. Define the group, reconcile the handoff and show the costs attached to the decision.

A useful agency report makes the numbers traceable. The client should be able to see what was counted, what was excluded and what still needs time or evidence.

Define the group before choosing the headline

Start with a cohort: a group of contacts included under a written rule. For example, use new contacts first acquired through the agreed campaign paths during June.

State the acquisition dates, source rule, duplicate handling and outcome window. Decide whether existing customers, internal tests and repeat submissions belong in the group.

Keep a monthly activity report separate from this cohort report. Opportunities created in July may relate to contacts acquired in May or June. Combining them with July's spend without explanation can create a ratio that describes no consistent journey.

The OSPRY approach for agencies is a useful place to frame the client conversation. Agree on the evidence the client needs to assess your work before designing the presentation.

Agree on what sales accepts

Write an acceptance rule the client can apply to actual records. It should explain what makes a contact suitable for sales review and what makes an opportunity a potential deal worth managing.

Those may be separate stages. A contact can fit the target business and still need a conversation before anyone knows whether a real project exists.

Ask sales to record a reason when it rejects a contact. Wrong market, duplicate, existing relationship and unclear need are different outcomes. A single rejected total hides the changes marketing and operations could make.

Assign the client an owner for acceptance decisions and the agency an owner for campaign evidence. Neither side should quietly change the definition after seeing the result.

Reconcile a complete example

Here is a hypothetical report prepared on July 31. All figures are invented to illustrate the method.

The acquisition cohort covers June 1 through June 30. Each contact is evaluated over its first 30 days, so a late-June contact receives the same outcome window as an early-June contact.

The campaign generated 120 form submissions. Review found 20 repeat submissions, five internal tests and 15 submissions from existing contacts. That leaves 80 new distinct contacts in the agreed cohort.

Sales accepted 50 of those contacts for further work. Thirty completed a qualified conversation. Twelve distinct opportunities were accepted into the pipeline within the defined window.

Record the 30 contacts sales did not accept and why. Also explain the 20 accepted contacts without a completed qualified conversation by the cutoff. Some may be waiting, some may have declined and some may need an operational correction. Do not assume every pause is a lost deal.

Show the selected spend completely

For the hypothetical June campaign, paid media cost $6,000. Agency management cost $2,000 and campaign creative cost $1,000. The selected acquisition spend is therefore $9,000.

State that scope clearly. Media-only cost and total selected cost answer different questions. If software, internal labor or other costs are excluded, name those exclusions rather than calling the total fully loaded.

Using the agreed cohort:

• Media cost per new distinct contact is $6,000 divided by 80, or $75.
• Selected cost per new distinct contact is $9,000 divided by 80, or $112.50.
• Selected cost per sales-accepted contact is $9,000 divided by 50, or $180.
• Selected cost per accepted opportunity is $9,000 divided by 12, or $750.

These are example calculations, not targets for another business. Their usefulness comes from consistent definitions and a traceable group of records.

Keep pipeline, signed business and cash distinct

Suppose three of the example's opportunities became signed contracts within the same observation window. Their combined contract value is $18,000, and $9,000 has been collected by the relevant cutoff.

Those are three different facts: signed contracts, their value and cash received. None is a substitute for the cost of delivering the work.

You can report selected acquisition cost per signed contract as $9,000 divided by three, or $3,000. Do not call the difference between contract value and acquisition spend profit. Fulfillment costs, contract terms and other expenses still matter.

Likewise, the remaining opportunity value is not money the client has received. Keep any forecast in its own section and explain the assumptions behind it. A pipeline number should not quietly become realized revenue in the headline.

Show the attribution rule and its limits

Pick a rule for assigning campaign credit and describe it in language the client can understand. A first-known-source view and a last-recorded-touch view may credit different activities in the same journey.

Preserve the underlying touches where your systems support them. Do not erase a referral, direct return or sales conversation because the report needs one source column.

Count unique opportunities before presenting channel totals. If several channels each claim the same deal under different models, adding those credited totals can exceed the distinct deals the business actually has.

Attribution describes credit under a method. This report does not establish how many opportunities would have existed without the campaign. A stronger causal claim would need an appropriate evaluation designed to answer that question.

Make the handoff inspectable

For a few appropriate sample records, trace the path from campaign entry to form, contact, owner, acceptance decision and opportunity. Preserve the relevant dates and status changes.

Review the connections between website and sales systems with those records in front of you. Confirm that a successful submission arrived with the context sales needed and that the acceptance result can be returned to the reporting process.

Keep the test small enough to inspect carefully. A green integration status is useful, but it does not explain whether the right owner received a particular enquiry.

Respect contact preferences and the collection choices surrounding each record. Consent belongs in the reporting workflow because the evidence available to the report depends on how information was collected and handled.

Label maturity instead of hiding it

At the July 31 review, separate completed outcomes from work still developing. Keep each contact's observation window consistent for the cohort calculation.

If you also show the latest status after that window, label it as a separate view. A contact that signs on day 45 should not silently alter a metric presented as first-30-day performance.

Record the report version and cutoff. Explain whether later corrections restate the original group, add a new observation or repair a duplicate. That makes month-to-month discussion less dependent on screenshots that cannot be reconciled.

End with decisions both sides can own

Choose an action from the actual gap. Poor fit may call for a narrower campaign promise. Missing source context may call for a handoff correction. Accepted contacts waiting without an owner may call for a client operating change.

Name the responsible person and the evidence the next review will use. Avoid turning every weak stage into a request for more advertising spend.

Connecting a website visit to a useful next action gives the agency report a practical purpose. Bring the agreed cohort, cost scope, acceptance decisions and attribution limits to the next client review. The strongest headline is one both sides can trace to the same records.