Muck Rack Automated Client Coverage Reports
Every Monday, WebRun opens Muck Rack, pulls each client's coverage from the past seven days, totals the placements and reach in a Google Sheet, and drafts a client-ready recap email in Gmail leading with the top placements, left unsent for your account lead to review.
How do I automatically draft weekly client coverage reports?
Every Monday, WebRun pulls each client's coverage from the past week in Muck Rack, builds the placement totals in a Google Sheet, and drafts a client-ready recap email in Gmail leading with the top three placements. Every draft is left unsent, so your account lead reviews and sends the final report.
- Every client gets a coverage report drafted the same day, every week
- Placement totals and top hits are pulled straight from Muck Rack, not compiled by hand
- Account leads review a finished draft instead of building the report from scratch
Built for PR agencies · account managers · communications teams · client services teams
What does WebRun do on every run?
The exact actions WebRun takes, in order - in plain language, so you can adjust anything.
-
WebRun signs in and gets to work
Opens
muckrack.com/dashboardin a real browser with your saved login - no setup, no API keys. -
1
Muck Rack - compile the week's coverage
muckrack.com
WebRun opens Muck Rack to compile the week's coverage. - Open Muck Rack and pull each client's coverage from the past 7 days
- Capture outlet, headline, reach, and placement type for every hit
- Note total placements and top-tier outlet count for the week
Done when The full week's coverage is captured for every active client.
-
2
Google Sheets - build the report numbers
google.com
WebRun opens Google Sheets to build the report numbers. - Open the client reporting sheet
- Enter this week's placements with outlet, reach, and link
- Total placements, reach, and top-tier hits for the summary line
Done when The sheet shows this week's full placement list and totals.
-
3
Gmail - draft the client report
gmail.com
WebRun opens Gmail to draft the client report. - Draft a client-facing recap summarizing the week's placements and totals
- List the top three placements with links first
- Save the email as a draft and leave it unsent for the account lead to review and send
Done when Each client has an unsent, ready-to-send weekly report draft in Gmail.
How is each run configured?
Secure by default
Connect once, stays signed in
WebRun signs in once and keeps each session in a persistent environment, so every run picks up right where it left off.
Every action is checked against this policy before it runs.
Questions, answered
Will it email the report to the client automatically?
No, WebRun saves the report as an unsent Gmail draft. Your account lead reviews it and sends it, so no client ever receives a report WebRun sent on its own.
What does the report include?
Every placement from the past week with outlet, reach, and a link, plus a short summary of total placements and top-tier hits, pulled directly from Muck Rack.
Does it cover more than one client?
Yes, it runs the same process for every active client account and drafts a separate report for each one.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.