cutePR

Free PR coverage-report template

A PR report that separates results, estimates, and unknowns.

A stakeholder report should make every number explainable. This template starts with the campaign objective and reporting period, lists the coverage and evidence behind the summary, separates qualitative observations from estimates, and ends with decisions. It does not turn an advertising-rate multiplier into proof of business value.

The blank workbook is ready for your own reporting process. The filled workbook follows the fictional Aster & Rue Solstice launch used throughout these guides. Every organization, contact, URL, product, amount, and outcome is synthetic. The example demonstrates traceability, not customer performance or an industry benchmark.

By cutePR · Updated

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)

Build the report in an order a reviewer can audit

Begin with the communication objective, intended audience, period, markets, and campaign scope. Then inventory each observed item before calculating totals. Give every row a stable coverage ID, date, source, contact, campaign, product, type, primary URL, evidence reference, and notes. Add qualitative assessment and estimates only after the item can be identified.

The summary should be derived from those rows. If it says five proven items, a reviewer should be able to find five rows that meet the stated proof rule. If it quotes EMV, the workbook should name the formula, inputs, source, rule version, and exclusions. Decisions and next actions come last, so the report remains a working instrument rather than a decorative archive.

WorksheetQuestion answered
Scope and objectivesWhat was the campaign trying to change, for whom, and during which period?
Coverage inventoryWhat was observed and how can each item be verified?
Evidence registerWhere is the URL, screenshot, PDF, clipping, stored file, archive, or note?
Measures and limitsWhich figures are observed, estimated, unavailable, or drawn from another source?
Stakeholder summaryWhat patterns, gaps, and decisions should the reader take away?

Keep four kinds of statement apart

An observed fact is something the team can verify, such as a publication date or a product visible in a clipping. A qualitative assessment applies a disclosed rubric to relevance, message delivery, prominence, or sentiment. An estimate uses a model, such as EMV, and depends on its formula. An outcome comes from a separate measurement source, such as a survey, attributed referral data, or another agreed business record.

AMEC's framework distinguishes outputs from what audiences take out, subsequent outcomes, and organizational impact. Its Barcelona Principles reject AVE. The template therefore provides no AVE field or hidden ad-rate multiplier. EMV is available only as a labeled estimate with methodology. A report can be complete even when a field says not measured; it is less credible when it fills that gap with invented precision.

Statement typeSynthetic exampleRequired context
ObservedArticle dated 18 September includes the Mistral jacketURL or evidence and observation date
QualitativeCore rainwear message is prominentRubric, reviewer, and rationale
EstimatedEMV entered as a manual estimateFormula, inputs, source, version, and limitations
OutcomeReferral visits from a tagged articleSeparate analytics source and attribution caveat
UnknownAudience response not measuredExplicitly leave unavailable

Trace the fictional Solstice example

The worked report includes a fictional Northline Journal article linked to J-014 and the Mistral jacket, a fictional creator post with a screenshot reference, one mention that lacks durable proof, one delivered product send with no observed content, and one unrelated item excluded from the period. The summary counts only rows inside the stated campaign and dates.

The article and creator post are outputs. Their relevance and product presence receive explained qualitative notes. The example includes one manual EMV value solely to show the assumptions field; it is not added to a causal ROI line. The delivered product send appears in the seeding section, not the coverage total. No sales, awareness change, or audience response is claimed because the fictional campaign has no such source.

The worked example contains no real contacts, customers, publications, or performance results.
Synthetic recordReport treatmentReason
J-014 article with URLIncluded as proven coverageMatches period, campaign, product, and proof rule
C-011 post with screenshotIncluded with evidence type disclosedObserved content is linked to the correct send
Mention without durable proofIncluded in missing-proof queue or excluded by stated ruleThe report must explain its choice
C-008 delivered sendSeeding activity onlyNo content has been observed
Old unrelated articleExcludedOutside campaign and period

Review the workbook before it leaves the team

Recalculate summary totals from the inventory, open a sample of evidence links, and confirm that the reporting period and exclusions are visible. Check that product sends without coverage have not entered the coverage count. Read every estimate beside its assumptions. Remove or redact personal and confidential details before sharing the file outside the private workspace.

The downloadable workbook is a public resource and does not require beta enrollment. cutePR can freeze the same kind of campaign evidence into a web, Excel, or PDF report, but the current product relies on manual coverage and English-default exports. It offers no automatic monitoring, client portal, scheduled delivery, shared seats, or causal ROI calculation. Joining the paid beta adds personal setup and an agreed migration at a preferential beta price; no public amount is decided.

  • Reconcile every summary count with included rows.
  • Open evidence and disclose missing-proof rules.
  • Separate seeding activity from observed coverage.
  • Label qualitative judgment, estimates, outcomes, and unknowns.
  • Record the final review date and keep the shared version frozen.

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.