The problem
PR coverage reports are a recurring headache for agencies that include media relations in their service offering. At the end of each month, the PR team has typically collected a list of coverage links: press mentions, feature articles, podcast appearances, online news pieces, and social media pickups. The raw list exists, but turning it into a polished client report that communicates the value and impact of that coverage is a different task entirely.
A proper PR coverage report does not just list links. It categorises coverage by publication tier, summarises the key messages that landed in each piece, calculates reach and audience size, notes the sentiment and framing of each mention, and ties it all together with a narrative commentary that tells the story of the month's PR performance. Done well, it helps the client understand not just what coverage they received, but why it matters and what it means for their brand positioning.
The problem is that producing this report manually is slow. Reading or skimming each piece of coverage, writing a one-line summary, categorising it, calculating cumulative reach, and then writing the narrative commentary can take three to four hours for a client with moderate coverage volumes. For agencies managing five to ten PR clients with monthly reporting requirements, this is a significant and recurring cost. It is also work that varies in quality depending on who writes it and how much time they have on the day.
The system
Step 1: Standardise your coverage tracking spreadsheet
Set up a coverage tracking template that your PR team updates throughout the month as coverage lands. The columns should include: Date, Publication name, Publication tier (Tier 1 / Tier 2 / Tier 3 / Trade / Online), Article title, URL, Estimated monthly readership (from media kit or Similarweb), Key messages covered (brief notes), Sentiment (Positive / Neutral / Negative), and Type (Feature / Mention / Interview / Podcast / Social).
This is a one-time template setup. The PR team adds rows as coverage comes in, which takes 2 to 3 minutes per piece and is far less daunting than trying to summarise everything at month end.
Step 2: Fetch and summarise individual articles (Perplexity or Claude)
For any coverage pieces where the team did not have time to write notes during the month, use Perplexity or Claude to quickly summarise the article. For Perplexity, simply paste the URL and ask:
"Summarise this article in 2 to 3 sentences. Note: which company is mentioned and how, what key messages about them are included, and whether the coverage is positive, neutral, or negative."
For Claude, paste the article text directly if the URL is paywalled. This step takes 1 to 2 minutes per article and fills any gaps in your coverage notes before the report is generated.
Step 3: Generate the coverage analysis (Claude)
Once the spreadsheet is complete, paste the coverage data into Claude with a reporting prompt:
"Here is a month of PR coverage data for [client name]. Each row includes the publication, tier, readership, key messages covered, and sentiment. Analyse this data and produce the following: 1) A coverage summary table showing: total number of pieces, breakdown by tier, total estimated reach, and breakdown by sentiment. 2) A highlight section listing the three most significant pieces of coverage and why they matter. 3) A section on key messages — which messages landed most frequently across coverage, and any that did not land as expected. 4) A section on publication tier performance — what level of media did we achieve this month and how does it compare to what the client was hoping for? Here is the data: [paste spreadsheet rows]."
This analysis typically takes Claude 30 to 60 seconds to produce and gives you the factual backbone of the report.
Step 4: Write the narrative commentary (Claude)
With the analysis in hand, write the narrative — the part that actually tells the client the story of the month:
"Using the following PR coverage analysis for [client name] in [month], write a professional narrative commentary for a monthly PR report. The commentary should: open with a summary of the month's headline achievement, explain what drove the coverage (which story angles or news hooks worked), note any areas where coverage fell short of expectations and why, identify the most significant piece of coverage and its strategic value, and close with a brief note on focus and priorities for next month. Tone: confident, clear, and direct. Length: 300 to 400 words. UK English."
Step 5: Assemble and send (Notion AI)
Copy the analysis tables and narrative commentary into your report template. Use Notion AI to write a one-paragraph executive summary at the top that synthesises everything into the three most important things the client needs to know:
"Write a three-sentence executive summary of this PR report for a client who has 30 seconds to read it. What were the three most important things that happened in this month's PR coverage? Be specific and concrete. UK English."
Export as a PDF or send as a Notion page link, depending on your client's preference.
The results
Before this workflow, a monthly PR coverage report for a moderately active client took three to four hours: reading coverage, writing summaries, calculating reach, writing the narrative. For an agency with five PR clients, that is 15 to 20 hours of monthly reporting overhead.
With this system, each report takes 45 to 75 minutes: 20 to 30 minutes to clean and complete the coverage spreadsheet, 10 to 15 minutes of AI analysis and commentary generation, and 15 to 20 minutes of review and assembly. Monthly overhead drops from 15 to 20 hours to 4 to 6 hours — a saving of approximately 10 to 14 hours per month, with no reduction in report quality and typically an improvement in the depth and consistency of the narrative commentary.