cutePR

PR report scope guide

Choose the report by the decision it needs to support.

A monthly PR report and a campaign report can contain some of the same coverage while producing different totals. That is expected when the scopes are explicit. The monthly view helps an operator manage a recurring period. The campaign view asks whether one bounded plan produced the evidence and learning needed for its next decision.

Choose the question before choosing the format. Then freeze the date rule, filters, evidence cutoff, and treatment of late discoveries. The method below works in a spreadsheet and does not require automatic monitoring, estimated reach, or a claim that coverage caused a business outcome.

By cutePR · Published

Download the Excel template

Free, no signup required. Choose the blank workbook or the fictional worked example. Read the workbook instructions before adapting it to your data.

PR coverage report template (blank) · XLSX (28 KB)PR coverage report template (fictional example) · XLSX (24 KB)

Start with the decision, not the calendar

Use a monthly report when someone needs a regular operating view: what entered the evidence register this period, which campaigns contributed, what is still missing, and what needs attention next month. Use a campaign report when the reader needs to judge a defined launch or initiative against its original objective, audience, activities, outputs, and measured results.

Some readers need both. An owner may review monthly workload and evidence gaps while a launch lead needs a final Solstice campaign record. Do not force both questions into one headline total. Create two named scopes from the same reconciled inventory and explain their overlap.

QuestionMonthly reportCampaign report
Primary decisionWhat needs operating attention next period?What should change in the next campaign?
BoundaryFixed calendar or accounting periodNamed campaign plus declared start and cutoff
Coverage includedAll qualifying items in the periodOnly items linked to the campaign
Activity contextWork handled during the monthActivities planned and executed for the campaign
Late evidenceHandled by a stated publication or discovery ruleIncluded if it fits campaign and cutoff, with discovery date visible
Typical endingPriorities, gaps, and next month's actionsLearning, decisions, owners, and follow-up date

Freeze four boundaries before calculating totals

Write a scope sentence at the top of the report. Name the period, controlling date, campaigns or markets, qualifying content, and evidence cutoff. For a monthly report, publication date is usually easier to audit than discovery date, provided late discoveries are recorded and amended consistently. For a campaign report, link each item to the campaign and choose an end date that matches the decision point.

Keep the evidence cutoff separate from publication date. A 30 September article discovered on 5 October can belong to the September publication period while being added after its first close. Decide whether to issue a labeled amendment or carry it in a late-discovery appendix. Moving it into October without explanation makes month-on-month totals impossible to reproduce.

BoundaryExample declarationRisk if omitted
PeriodPublications dated 1 to 31 OctoberItems drift between reports
CampaignSolstice records onlyAlways-on work enters the launch total
Evidence cutoffEvidence checked through 3 NovemberLater links silently rewrite the report
Qualifying ruleUnique items with required proofReposts and weak mentions inflate the headline
UnknownsAudience response and sales effect not measuredReaders infer outcomes from outputs

Keep the same evidence layers in either format

Changing the report scope should not change the meaning of the data. Keep activities, observed outputs, qualitative observations, estimates, measured outcomes, and unknowns in separate rows or sections. A sent product is activity. A verified article is an output. Message presence is a qualitative observation. Audience or business change belongs under outcomes only when another source supports it.

AMEC's Integrated Evaluation Framework starts with objectives and distinguishes outputs, out-takes, outcomes, and impact. Its taxonomy cautions against using a metric from one level as evidence for another. A monthly total can therefore describe observed publication volume, while the report still says that awareness, preference, or revenue effect was not measured.

  • State the objective and intended audience.
  • List activities without calling them coverage.
  • Derive output totals from unique evidence rows.
  • Explain qualitative categories and reviewer judgments.
  • Label every estimate with method, source, and limit.
  • Attach outcomes only from a separate measurement source.
  • Write unknown when the evidence does not answer the question.

See how matching totals can hide different coverage

The fictional Aster & Rue inventory contains nine unique candidates around the October close. Six have October publication dates: four Solstice items and two always-on items. Five of those six are evidence-ready; one Solstice mention still lacks sufficient proof. Two additional Solstice items were published in August and September, both evidence-ready. A final Solstice item was published on 2 November and remains outside both cutoffs.

The October monthly report contains six unique in-period items: five evidence-ready and one evidence gap. The Solstice campaign report, scoped from 25 August through 31 October, contains six campaign items: five evidence-ready and one evidence gap. Four October Solstice items sit in both reports. The August and September Solstice items appear only in the campaign report, while the two October always-on items appear only in the monthly report. The November item appears in neither.

All names, records, dates, and outcomes in this example are fictional.
Inventory groupRowsOctober monthlySolstice campaign
October Solstice444
October always-on220
August and September Solstice202
November Solstice100
Total candidate rows966
Evidence-ready rows7 within either scope55
Missing-proof rows1 within both scopes11

Design the last page for the reader's next action

A monthly report should end with a short queue: evidence to complete, follow-ups due, recurring topics, contacts to review, and decisions that must be made before the next close. Keep open tasks out of the coverage total. If a prior month changes, issue a dated correction rather than changing an old deck with no record.

A campaign report should end with decisions tied to its objective and evidence: keep, change, test, or stop. Name an owner and review date for each action. Avoid the empty conclusion that the campaign needs more coverage next time. Specify which audience, message, media context, evidence practice, or workflow should change, and state what remains unmeasured.

Build and freeze the report you actually chose

In a spreadsheet, filter the same evidence register twice, preserve the filter criteria beside each summary, and store the included IDs. Recalculate the totals, open a sample of proof, and save a dated final copy. The downloadable cutePR coverage report workbook can support this sequence without an account.

cutePR can scope manually entered records by period, campaign, market, product or pair, and audience, then freeze a report snapshot with web, Excel, and PDF output. Current exports use English labels. The product does not collect coverage automatically, schedule report delivery, provide shared client spaces, infer reach, or calculate causal ROI. Those limits should remain visible when deciding whether its current reporting workflow fits your process.

Sources & methodology

Ready to connect your PR files?

The founder helps you get started and handles the agreed initial migration. Your feedback helps shape what comes next.

Request access

Preferential pricing during the beta, then standard pricing announced in advance.