NPS AI Reporting Dashboard Demo

Production YoY

+3.7%

Cash YoY

+7.1%

Production MoM

-2.4%

Cash MoM

-9.6%

Production YTD

40,154

vs 38,738 LY (+1,416)

Cash YTD

$906,768

vs $846,411 LY (+$60,357)

Rolling Renewal Rate

64.9% vs 60.6% (+4.3 pts)

On expire volume down 13.9% — smaller pool, stronger conversion.

01 · Production

Production volume

Orders by channel — month vs prior-year month, and year-to-date.

DTP +20.3% YTDAGT -7.2% YTDREN -4.7% YTDTOT +3.7% YTD

May 2026 vs May 2025

YTD 2026 vs YTD 2025

02 · Cash

Cash performance

Dollars collected by channel — month vs prior-year month, and year-to-date.

DTP +29.9% YTDAGT +9.4% YTDREN -3.3% YTDTOT +7.1% YTD

May 2026 vs May 2025

YTD 2026 vs YTD 2025

03 · Renewals

Renewal performance

Rolling window: May/Jun–Sep/Oct 2024 vs May/Jun–Sep/Oct 2025. Smaller expire base, stronger conversion.

Rolling Renewal Rate

64.9%vs 60.6% LY

+4.3 pts

Expired (TY)

53,722

-13.9%

Renewed (TY)

34,876

Expired (LY)

62,403

Renewed (LY)

37,796

Renewal Rate by Source — This Year vs Last Year

Source	Expired TY	Renewed TY	Rate TY	Rate LY	Δ
Direct Mail	7,856	3,500	44.6%	44.2%	+0.3 pts
Online/Email	1,100	687	62.5%	62.1%	+0.4 pts
InsertStandout	2,227	1,783	80.1%	47.8%	+32.3 pts
Other DTP	3,555	2,217	62.4%	63.7%	-1.3 pts
Renewal of Renewals	8,775	4,703	53.6%	56.7%	-3.1 pts
Agent	30,209	21,986	72.8%	72.6%	+0.2 pts

Multi-year Renewal Rate by Channel (2022 – 2026)

Multi-year renewal rates by channel. 2026 is early/not yet fully reliable; 2027 partial.

04 · Inserts

Insert volume & revenue

Volume declining sharply but renewal conversion strengthening (higher-value, more targeted channel).

2020

69.8%

pay-up

2021

105.2%

pay-up

2022

62.0%

pay-up

2023

61.6%

pay-up

2024

67.2%

pay-up

2025

59.4%

pay-up

2026

48.5%

pay-up

05 · Direct Mail

Direct mail campaigns

Reliable but slowly slipping. New campaign drops early July 2026. *autorenewals removed from starred rows.

Mail Date	Total Mailed	Gross Orders	Net Orders	Pay-up %	Paid Revenue
2024-01-18	501,248	9,332	8,887	95.2%	$159,052
2024-06-14	429,430	9,062	8,551	94.4%	$159,507
2024-10-07	411,201	7,084	6,633	93.6%	$138,045
2025-01-27	405,510	7,421	6,988	94.2%	$149,153
2025-06-30*	390,575	6,281	5,922	94.3%	$123,486
2025-10-07	375,010	5,780	5,473	94.7%	$116,003
2026-01-30	390,193	6,016	5,650	93.9%	$113,461
2026-06-30Scheduled	373,660	—	—	—	—

Ask the data

ARC Reporting Assistant

Ask anything about Archaeology's May 2026 performance — production, cash, renewals, inserts, or direct mail.

Generator

Monthly Narrative

One-click executive narrative in the analyst's voice, generated from this month's data.

Click Generate Monthly Narrative to produce the May 2026 write-up in the executive style and structure used by NPS analysts.

Generator

Create Report Prompt

Copy a ready-to-paste prompt with this month's key data, formatted for a board-ready report.

You are a senior media-marketing analyst producing the May 2026 board report for Archaeology magazine on behalf of NPS Media Group.

Use only the data below. Do not invent numbers.

== HEADLINE KPIs ==
Production YoY: +3.7% | Cash YoY: +7.1%
Production MoM: -2.4% | Cash MoM: -9.6%
Production YTD: 40,154 (prior year 38,738)
Cash YTD: $906,768 (prior year $846,411)
Rolling Renewal Rate: 64.9% vs 60.6% (+4.3 pts)

== PRODUCTION YTD by channel (orders) ==
AGT: 5,485 vs LY 5,912 (-7.2%)
DTP: 16,277 vs LY 13,534 (20.3%)
REN: 18,392 vs LY 19,292 (-4.7%)
TOT: 40,154 vs LY 38,738 (3.7%)

== CASH YTD by channel ($) ==
AGT: $63,162 vs LY $57,760 (9.4%)
DTP: $316,392 vs LY $243,618 (29.9%)
REN: $527,214 vs LY $545,033 (-3.3%)
TOT: $906,768 vs LY $846,411 (7.1%)

== RENEWALS by source (rate TY vs LY) ==
Direct Mail: 44.6% vs 44.2%
Online/Email: 62.5% vs 62.1%
Insert: 80.1% vs 47.8%
Other DTP: 62.4% vs 63.7%
Renewal of Renewals: 53.6% vs 56.7%
Agent: 72.8% vs 72.6%
Overall expire volume down 13.9% — smaller pool, higher conversion.

== STRATEGIC THEMES ==
1. DTP source dominance: now the primary driver of both production and cash growth.
2. Renewal compression: smaller expire base materially impacting totals despite better conversion.
3. Cash still outpacing production, but the growth gap is narrowing.
4. Channel divergence increasing: DTP accelerating while agents and renewals lag.
5. Shift to value optimization: inserts and direct mail evolving toward efficiency and higher LTV per order.
6. LTV expansion critical: multi-year offers and auto-renewal essential to offset shrinking renewal scale.

== STYLE REFERENCE ==
Match the executive, takeaway-driven voice of the May 2026 narrative:
"Year-over-year performance remains positive, though growth has moderated further. Direct-to-publisher (DTP) continues to be the primary growth driver, while both agents and renewals are now showing year-over-year softness in production. Cash performance remains solid and continues to outpace production, although the rate of growth has slowed. Month-over-month shows only modest declines in production but a sharper drop in cash, driven primarily by lower renewal cash."

== OUTPUT INSTRUCTIONS ==
Format the output as a board-ready PDF report. Include: cover page (title, month, client, prepared by), executive summary (3–5 bullets), KPI dashboard page, channel-by-channel breakdown (Production, Cash, Renewals, Inserts, Direct Mail), strategic themes, and a recommendations page. Use clean typography, generous whitespace, and consistent section headers. Output as ready-to-render HTML/CSS for PDF, or structured markdown with clear page breaks.

Appendix

Source Reports

Underlying PDFs and the source spreadsheet. The dashboard above is built from the May 2026 data context.

Production

Cash

Cash Variance

Renewals

Direct Mail

Inserts

Insert Card Analysis

Reference