Margin Watch

Margin monitoring, updated most weekdays · Pacing by Campaign (Line Item Level) · insights.viamedia.ai

Building history

Implied margin trend

Each point is the margin implied by the gap between two consecutive pulls (both cumulative from Jan 1, 2026) — not a single calendar day. The dashed line is the latest YTD-to-date margin for reference.

YTD-to-date — where the margin risk already concentrates

Read from the latest Jan 1–to-date export. These are the spots worth watching first.

Brand breakdown (YTD)

Top 25 brands by gross revenue, plus everything else rolled into "Other."

Channel breakdown (YTD)

Platform breakdown (YTD)

How this stays current

  1. Most weekdays, on insights.viamedia.ai → Pacing by Campaign (Line Item Level), export that table's data as .xlsx — leave the Date filter as-is (Jan 1, 2026 through today). No need to fight the date picker.
  2. Drop the file in the Margin Watch conversation in Claude.
  3. Claude subtracts it from the previous pull to work out the implied margin for just the days in between, appends that snapshot, and republishes this dashboard — same link, refreshed content.
  4. Gaps don't need to be exactly one day — a Friday-to-Monday gap works the same as a one-day gap, just labeled by its date range. Once 2+ gap-periods exist, period-over-period and trailing-average alerts turn on automatically. Thresholds: flag a drop of 3+ points vs. the prior period, or 5+ points below the trailing 5-period average.

Full comparison

The Power BI Numbers above, set alongside every manually-sourced margin number — managed service, monthly reporting, budgets and contracted targets — once they're added.