AI for media business analysis: revenue and account trends

AI for media business analysis starts with comparing recognized advertising and subscription revenue by account, offering and month. Reconcile the export to finance totals, calculate the movements, and ask the external AI model to explain the computed evidence. A useful review identifies where revenue changed and which account owner should investigate.

Define the revenue before comparing it

Use revenue recorded for the period under your finance team's accounting policy. Keep bookings, invoices and cash collections in separately labeled fields. They answer different questions, especially when advertisers pay after delivery or subscribers pay in advance.

The New York Times Company's annual report separates advertising and subscription revenue and explains that subscription payments are typically due upfront while revenue is recognized over the subscription period. That distinction matters when choosing your export: a bank receipt is not automatically that month's revenue.

This workflow concerns a media company's commercial results. For an advertiser choosing between channels, use media mix analysis. Keep that separate from reviewing what the publisher earned.

Prepare the account and offering rows

Consider a fictional US publisher comparing July and August 2026. Its Revenue worksheet has headers in A1:E1 and the following records in rows 2 through 9. Dates are actual spreadsheet dates, displayed in US format. Each record is a period-level subtotal for one account and offering, after credits and adjustments.

SUB01 and SUB02 represent business customer accounts, rather than counts of individual subscribers. Document that distinction beside the report. A customer can buy multiple offerings, so preserve the offering column rather than merging every purchase into an unexplained customer total.

For a transaction-level export, retain the original revenue entry ID as well. Use stable account IDs across months and map spelling changes before grouping. The broader customer revenue analysis method covers the account view beyond this media review.

Calculate monthly movements in Excel

Create a Review worksheet with the summary table below starting at A1. Put account IDs in A, offerings in B, July revenue in C and August revenue in D. Enter this formula in C2:

=SUMIFS(Revenue!$E$2:$E$9,Revenue!$C$2:$C$9,$A2,Revenue!$D$2:$D$9,$B2,Revenue!$A$2:$A$9,DATE(2026,7,1))

In D2, use the August date:

=SUMIFS(Revenue!$E$2:$E$9,Revenue!$C$2:$C$9,$A2,Revenue!$D$2:$D$9,$B2,Revenue!$A$2:$A$9,DATE(2026,8,1))

Microsoft documents SUMIFS as adding values that meet multiple criteria. Here, all three criteria must match: account, offering and period. These formulas assume the period dates shown above; daily posting dates would require start-inclusive and end-exclusive date criteria instead.

Enter the dollar movement in E2 and growth in F2, then fill C2:F2 through row 5:

=D2-C2
=IF(C2=0,"N/A",E2/C2)

Sum C2:C5, D2:D5 and E2:E5 in row 6. F6 is =E6/C6, not the average of account percentages. Percentages are rounded to one decimal place; dollar amounts here are exact.

Prove the movement before explaining it

The account bridge must close:

Revenue movement = 12,000 - 8,000 + 6,000 + 2,000 = 12,000 USD.

Then regroup the same rows by revenue type:

Advertising contributes $4,000 and subscriptions $8,000 of the $12,000 increase. Both the account view and the revenue-type view must reconcile to the same July and August ledger totals. Keep any unmapped revenue visible until finance resolves it.

Those checks prove the size and location of the movement. They do not establish its cause. Ask the advertising owner whether Audio reflects campaign timing, delivery credits or lower demand. Ask the subscription owner whether Business reflects customer additions, price changes or contract adjustments. Record the supporting file before presenting an explanation as established fact.

Use the account review to assign action

Start with the negative Audio movement and the large Display increase. Check whether the movements persist in comparable periods before changing sales targets or capacity. A favorable company total can conceal an offering that needs attention.

An account review also supports customer concentration checks, but growth and dependency are separate questions. A growing advertiser may deserve an account plan even when subscription revenue is rising faster. Keep named owners and evidence requests alongside the review rather than treating a written explanation as the final decision.

Where it goes wrong

• Mixing revenue with billings. Advance subscription invoices can create a spike without changing recognized revenue for the month.
• Counting agency and advertiser twice. Choose the contractual customer for financial totals; retain the other relationship as a separate classification.
• Calling every missing account lost. A missing period may reflect a seasonal campaign, an account remapping or an incomplete extract. Check status before assigning a commercial label.
• Treating bundles as separate full-value sales. Use finance's allocated offering amounts so the parts add back to the recorded revenue.
• Inferring causes from movements. A revenue export establishes changes, while contract, pricing and delivery records establish explanations. The AI analytics overview explains the distinction between computation and interpretation.

Covirage is not affiliated with Microsoft.

Review your media revenue file in Covirage

Upload your reconciled advertising and subscription revenue file; Covirage maps the columns, and its tools compute and check account, offering and period comparisons. The external AI model explains those results with every figure traced to its rows. Create a free Covirage account, which takes about a minute, then set up your business and bring a sample of your own data.

See revenue driver analysis for the supporting business workflow.