Calculate video marketing ROI from matched financial outcomes and complete campaign costs. Allocate reusable production costs across campaigns, reconcile the allocation and keep viewing activity separate from contribution.
Video marketing ROI compares contribution attributed to video with the production, distribution and media costs needed to earn it. Start with matched financial outcomes and an explicit cost boundary. When one production serves several campaigns, allocate that cost across uses and prove that the full amount is included once.
Views, watch time and clicks help a team understand delivery. For example, YouTube's impressions guidance describes how thumbnail impressions lead to views and watch time. Those measures describe audience activity; the financial return still needs revenue and cost records.
For this guide, use a return on the marketing investment convention:
Attributed video marketing ROI = (contribution before video costs - video costs) / video costs
Contribution before video costs = attributed net revenue - product and variable delivery costs
Video costs = allocated production + distribution + paid media
Google's ROI guidance illustrates a broader cost denominator that includes production and advertising. State which convention you use. The marketing ROI versus ROAS guide explains the general difference between a revenue multiple and a contribution-based return.
This calculation is before excluded corporate costs and taxes. It is also attribution-based: an observed sale assigned to video is not proof that video caused an additional sale.
Start with the production invoice register and internal production cost worksheet. Give each finished asset an ID, including versions derived from the original work. Record editing, licensing and captioning costs in the approved scope; a separately invoiced edit should not disappear inside a reference to the original asset.
Add a campaign register linking those asset IDs to distribution dates, media costs and other campaign expenses. Define distribution clearly. In the example below, it includes campaign setup and delivery services, while media is paid placement. No cost sits in both categories.
Match campaign IDs to orders, invoices or CRM outcomes under the approved attribution rule. Deduct refunds and discounts, exclude sales tax, and retain product and delivery costs for the matched sales. The marketing attribution guide owns how credit is shared across touches; this worksheet applies the approved allocations rather than creating a new rule.
Compare outcomes after a consistent observation window. If a financial match is unavailable, show the audience measures and cost as an incomplete financial assessment. Do not assign a made-up dollar value to every view.
A fictional US supplier spends $18,000 producing one video used in a launch campaign, retargeting campaign and sales follow-up campaign. Finance approves allocation weights of 50%, 30% and 20% for management reporting. The weights reflect planned use and are fixed for this comparison; they do not represent measured causal credit.
Keep the original production cost in cell M1. Put these inputs in A:F, with weights stored as percentages:
| Campaign | Attributed net revenue (USD) | Product and delivery cost (USD) | Production weight | Paid media (USD) | Distribution (USD) |
|---|---|---|---|---|---|
| Launch | 80,000 | 40,000 | 50% | 10,000 | 3,000 |
| Retargeting | 50,000 | 30,000 | 30% | 6,000 | 1,600 |
| Sales follow-up | 30,000 | 18,000 | 20% | 0 | 1,400 |
| Total | 160,000 | 88,000 | 100% | 16,000 | 6,000 |
In Excel or Google Sheets, calculate allocated production in G, contribution before video in H, total video cost in I, contribution after video in J and ROI in K. Fill row 2 down through row 4:
G2 = $M$1*D2
H2 = B2-C2
I2 = SUM(E2:G2)
J2 = H2-I2
K2 = IF(I2=0,"",J2/I2)
| Campaign | Production allocated (USD) | Contribution before video (USD) | Video cost (USD) | Contribution after video (USD) | ROI |
|---|---|---|---|---|---|
| Launch | 9,000 | 40,000 | 22,000 | 18,000 | 81.8% |
| Retargeting | 5,400 | 20,000 | 13,000 | 7,000 | 53.8% |
| Sales follow-up | 3,600 | 12,000 | 5,000 | 7,000 | 140.0% |
| Total | 18,000 | 72,000 | 40,000 | 32,000 | 80.0% |
ROI percentages are rounded to one decimal place using unrounded dollar calculations. The sales follow-up result includes production and distribution even though its paid media cost is zero. It is not a free use of the asset.
These checks must return zero:
=SUM(D2:D4)-1
=SUM(G2:G4)-$M$1
=SUM(B2:B4)-SUM(C2:C4)-SUM(I2:I4)-SUM(J2:J4)
The program has $160,000 revenue less $88,000 product and delivery costs, leaving $72,000 before video. Production of $18,000, media of $16,000 and distribution of $6,000 total $40,000. Subtracting that cost leaves $32,000, and dividing by $40,000 gives 80.0%.
Calculate total ROI as =SUM(J2:J4)/SUM(I2:I4). Tie production to the asset cost register, media to the campaign export and revenue to finance. The allocation supports a management comparison; it does not change the expense timing or cash payment recorded by finance.
Keep customer acquisition cost alongside the return when the budget goal is new customers. For actions after the reconciliation, see improving marketing ROI.
Bring your production register, campaign costs and matched revenue file to Covirage. 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 customer profitability for the contribution behind attributed revenue. Covirage is not affiliated with Microsoft, Google or YouTube.
Views measure audience activity, rather than profit. To calculate a financial return, connect the campaign to an agreed business outcome and its contribution, then compare that contribution with video costs. Keep views as a separate delivery measure when no defensible financial match exists.
Record the original production cost once, then allocate it across uses under an approved management-reporting rule. Confirm that the allocation weights total one and the allocated dollars equal the original cost. Keep the underlying finance expense and cash payment visible separately.
Include it when the agreed cost scope calls for fully costed production. Use documented hours and an approved labor rate, and avoid adding labor already included in an agency or production invoice. Apply the same boundary when comparing video with other campaign formats.
No. Attribution assigns observed outcomes under a credit rule. It does not establish how much revenue would have occurred without the video. Describe the result as attribution-based unless separate evidence supports an estimate of incremental contribution.