🎉 Black Friday Sale: 40% OFF everything with code BF40 · ends 1 Dec  Shop now →

Public Relations (PR) Dashboard in Google Sheets

Google Sheets - instant download

Original price was: ₹1,899.00.Current price is: ₹999.00.
Details, requirements and demo below
Sale!

Public Relations (PR) Dashboard in Google Sheets

Original price was: ₹1,899.00.Current price is: ₹999.00.

  • 6 Google Sheets tabs: Overview, Media Coverage, Sentiment & Engagement, Regional Analysis, Search Sheet, and Data Sheet.
  • 4 KPI cards: Total Media Mentions, Total Reach, Total AVE Value, and Positive Sentiment %.
  • 16 PR charts: Analyze mentions, sentiment, reach, AVE, engagement, regions, channels, outlets, and tiers.
  • Interactive slicers: Filter campaign, channel, region, sentiment, tier, and date-based views quickly.
  • Media Coverage tab: Compare mentions by outlet, AVE by channel, coverage tier, and channel mix by month.
  • Sentiment & Engagement tab: Review sentiment trends, regional engagement, channel tone, and reach versus engagement.
  • Regional Analysis tab: Compare reach, AVE share, average reach, and mentions by region and channel.
  • Search Sheet: Look up one media mention by Record ID and review all selected record details.
  • Editable Data Sheet: Replace sample rows with your own PR coverage data in the same format.
Customize this template for your business (optional)

Handled by email: we contact you within 1 business day. One revision round included. What is included

- +
Have your own data? Build a dashboard from your Excel, CSV or Google Sheets file free in Dashboard Studio →
, ,

💡 Buy any 2 templates and save 20% automatically at checkout.

Included in All-Access Templates. Get this plus 7,000+ templates for ₹4,999.00 a year. Compare plans →
Pricing country
Prices follow your selected country; checkout uses your billing country.
Google Sheets Complete Course: Beginner to Advanced courseLaunch offer
🎓 NEXTGENTEMPLATES ACADEMY
Want to build Google Sheets like this yourself?
Google Sheets Complete Course: Beginner to Advanced

Formulas, lookups, QUERY, dynamic arrays, pivot tables, charts, live data and Apps Script, ending with an interactive sales dashboard. 74 lessons by PK with a practice file for every lesson.

Public Relations (PR) Dashboard in Google Sheets turns one structured PR data sheet into 6 working tabs: 4 KPI cards, 16 analysis charts, multiple slicers, a Record ID search sheet, and an editable data tab. Track Total Media Mentions, Total Reach, Total AVE Value, and Positive Sentiment % in minutes instead of rebuilding manual reports for every campaign review. More than 10,000 customers in 180+ countries use NextGenTemplates for spreadsheet and BI templates. Your purchase is backed by a 7-day file-match review if the delivered template does not match this description.

Key Features of Public Relations (PR) Dashboard in Google Sheets

  • 6 Google Sheets tabs: Overview, Media Coverage, Sentiment & Engagement, Regional Analysis, Search Sheet, and Data Sheet.
  • 4 executive cards: Total Media Mentions, Total Reach, Total AVE Value, and Positive Sentiment %.
  • 16 dashboard charts: Review mentions, sentiment, reach, AVE, outlet tier, engagement, region, channel, and month-level trends.
  • Interactive slicers: Filter the dashboard quickly by campaign, channel, outlet, region, sentiment, tier, or date-based fields.
  • Record lookup: Search by Record ID and view the selected media mention details without filtering the full data sheet.
  • Editable data format: Replace the sample data with your own PR records while keeping the same column structure.

What’s Inside the Public Relations (PR) Dashboard in Google Sheets

Overview Page

The Overview page gives PR managers a fast campaign health snapshot. The top cards summarize Total Media Mentions, Total Reach, Total AVE Value, and Positive Sentiment %, so teams can review visibility, potential media value, and brand tone in one view.

Media Mentions by Channel: Shows how mentions are distributed across channels such as online media, print, TV, radio, social, or podcasts. Use it to see which channels are creating the most coverage and where outreach may need support.

Mentions by Sentiment: Breaks mentions into positive, neutral, and negative categories. This helps communications teams understand whether coverage volume is also creating the right brand perception.

Reach by Region: Compares audience reach across regions. It is useful when campaign goals include regional visibility or market-specific PR performance.

Media Mentions by Month: Tracks mention volume over time. Use it to spot campaign peaks, quiet periods, and month-over-month movement after launches or announcements.

Public Relations PR Dashboard in Google Sheets overview page
Public Relations (PR) Dashboard in Google Sheets

Media Coverage

The Media Coverage tab focuses on outlet and channel performance. Mentions by Outlet shows which publications or media sources are creating the most coverage. AVE by Channel compares Advertising Value Equivalency across coverage channels so teams can understand value contribution.

Coverage by Tier separates top-tier, mid-tier, and lower-tier coverage for quality review. Channel Mix by Month shows how the media mix changes over time, helping PR teams evaluate whether outreach is becoming broader or too dependent on one channel.

Media Coverage page in Public Relations PR Dashboard in Google Sheets
Media Coverage

Sentiment & Engagement

The Sentiment & Engagement tab connects tone with audience response. Sentiment by Month reveals whether public perception is improving, staying flat, or turning negative during campaign periods. Engagement by Region helps compare where audiences are reacting most strongly.

Sentiment by Channel shows which channels carry the best or weakest tone. Reach and Engagement by Channel compares audience size with interaction, helping teams separate high-reach passive coverage from channels that also generate response.

Sentiment and Engagement page in Public Relations PR Dashboard in Google Sheets
Sentiment & Engagement

Regional Analysis

The Regional Analysis tab helps communications teams review market-level outcomes. Reach by Region highlights where coverage is generating the largest audience. AVE Share by Region shows which regions contribute the greatest share of estimated media value.

Average Reach by Region compares typical reach per mention across markets. Mentions by Region and Channel shows whether each region is driven by digital, print, TV, social, or other channels.

Regional Analysis page in Public Relations PR Dashboard in Google Sheets
Regional Analysis

Search Sheet Tab

The Search Sheet lets you look up a media mention by Record ID and review the selected record details, including date, campaign, channel, outlet, region, sentiment, tier, reach, impressions, AVE, engagement, and journalist. It is useful for quick record-level checks during reporting calls.

Search Sheet tab in Public Relations PR Dashboard in Google Sheets
Search Sheet tab

Data Sheet Tab

The Data Sheet is where you add or replace PR records in the same format as the sample data. Keep the headers and data structure consistent so the cards, charts, slicers, and search fields continue updating correctly.

Data Sheet tab in Public Relations PR Dashboard in Google Sheets
Data Sheet tab

Public Relations (PR) Dashboard in Google Sheets vs. Microsoft Excel Dashboard vs. Paid CRM/SaaS – Where This Fits

FeatureThis Google Sheets dashboardMicrosoft Excel dashboardPaid PR measurement SaaS
Cost$9.99 sale price, one-timeTemplate or custom workbook costRecurring monthly or annual fee
PlatformGoogle Sheets in browserExcel desktop or Microsoft 365Vendor-hosted web platform
Setup timeCopy sheet, replace sample data, use slicersOpen workbook and refresh or rebuildImplementation, onboarding, and setup
Real-time team collaborationBuilt into Google Drive sharingRequires OneDrive or SharePointUsually available by plan
Customizable fieldsEditable columns, charts, labels, and formulasEditable workbookLimited by vendor configuration
Share with linkYes, using Google Drive permissionsPossible through Microsoft cloudRole-based user accounts
Year-1 cost at 5 users$9.99 plus Google Workspace if applicableTemplate cost plus Microsoft licensingOften hundreds or thousands
PR reporting fitBest for exported PR coverage data and recurring reportsBest for offline spreadsheet workflowsBest for live monitoring and enterprise integrations

Who This Template Is For – and Who It’s Not For

This template is for PR agencies, corporate communications teams, media relations managers, marketing analysts, nonprofit communications teams, and consultants who need a shareable dashboard for media mentions, sentiment, reach, AVE, engagement, regions, outlets, tiers, and journalists.

It is not a live media monitoring system, journalist database, press release distribution platform, crisis alert tool, or social listening platform. Use it as a reporting layer after exporting or entering approved PR coverage data.

How to Use the Public Relations (PR) Dashboard in Google Sheets

  1. Open the PDF guide included with your purchase and use the Google Sheets copy link.
  2. Create your editable copy in Google Drive.
  3. Go to the Data Sheet and replace the sample records with your PR coverage data.
  4. Keep the same columns for date, campaign, channel, outlet, region, sentiment, tier, reach, impressions, AVE, engagement, and journalist.
  5. Use slicers on the dashboard pages to filter by campaign, channel, region, sentiment, tier, or date.
  6. Use the Search Sheet to look up a single media mention by Record ID.

Real-World Use Cases

Ana, PR agency account lead: uses the Overview and Media Coverage tabs before client calls to explain which channels, outlets, and months created the most coverage.

Marcus, corporate communications manager: reviews Sentiment & Engagement after a product launch to see whether high-reach coverage was positive, neutral, or negative.

Priya, regional marketing analyst: uses Regional Analysis to compare reach, AVE share, average reach, and channel mix across target markets.

Frequently Asked Questions

What does the Public Relations (PR) Dashboard in Google Sheets track?

It tracks media mentions, reach, AVE value, positive sentiment percentage, channel mix, outlet performance, coverage tier, engagement, region, month, journalist, and record-level media mention details.

Can I replace the sample data with my own PR data?

Yes. Add your records to the Data Sheet in the same format so the dashboard cards, charts, slicers, and Search Sheet continue working correctly.

Does this dashboard connect live to media monitoring tools?

No. It is built for Google Sheets data entry or exported PR coverage data, not live API monitoring from media platforms.

Can multiple team members use it?

Yes. Because it runs in Google Sheets, you can share the copied file with approved team members using Google Drive permissions.

Is this a subscription?

No. This is a one-time template purchase from NextGenTemplates. Google Workspace costs, if any, are separate.

About the Author

Built by PK – Microsoft Certified Professional with 15+ years of Excel, Google Sheets, and Power BI experience. Founder of NextGenTemplates, reaching 300K+ subscribers across YouTube channels. Every template is hand-built and tested before release.

Explore Related Templates

You may also like the Public Relations KPI Dashboard in Google Sheets, Channel Performance Analytics Dashboard in Google Sheets, Content Marketing KPI Dashboard in Google Sheets, and Marketing and Social Media Analytics Kit. Browse more Google Sheets templates and Google Sheets dashboard templates.

Watch the step-by-step video Demo:

Download the Public Relations (PR) Dashboard in Google Sheets to turn media mentions, reach, AVE, sentiment, outlets, channels, regions, and engagement into a focused reporting dashboard.

Last updated: July 6, 2026.

Compatibility and Requirements

  • Works in Google Sheets. You need a free Google account and a web browser.
  • The dashboard pages use slicers to filter by campaign, channel, outlet, region, sentiment or tier. Google explains how charts work in Add and edit a chart or graph.

Frequently asked questions

How do I get my own copy?
After purchase you get a link to the Google Sheet. Open it while signed in to your Google account and use File > Make a copy - the copy in your Google Drive is fully yours and editable.
Do I need a paid Google account? Will it expire?
No. A free Google account is enough, and your copy lives in your own Google Drive - it never expires and there is nothing to renew.
Does it work on Mac, phone or tablet?
Yes - in any browser on Windows, Mac or Chromebook, and in the Google Sheets mobile app for viewing and quick entries.
Can I share it with my team?
Yes. Share your copy with colleagues using Google's normal sharing, with view or edit rights as you choose.
Can I change the design and formulas?
Yes, your copy is fully editable - colours, labels, logo, formulas and charts. If a range is protected, use Data > Protect sheets and ranges to remove it in your copy.
Are there macros or add-ons?
No macros or add-ons - it uses normal Google Sheets formulas and charts.
Is it a one-time payment or a subscription?
One-time payment. No subscription, no per-user fees and nothing to renew - the file is yours to keep.
How do I get the file after payment?
Instantly. The download link appears on screen after checkout, is emailed to you, and stays under My Account > Downloads on our website. If the email does not arrive within a few minutes, check your spam or promotions folder.
Is a user manual included?
Most of our newer products include a PDF user manual in the download. If yours does not have one, message us with your order number and we will send it.
Do I get free updates?
Bug fixes are always free - if something does not work as described, we fix it and send you the corrected file. New versions with new features are not included in the price, unless this product's description says otherwise.
Can you customise it for me?
Yes. Small changes to this template (your columns, categories, logo, colours, minor layout) cost the template price plus $40-80 (Rs 3,000-6,000 + GST), quoted once you send your list. A fully custom build is usually $100-200 (Rs 8,000-18,000 + GST) with two revision rounds. Email your requirements to [email protected] or message us on WhatsApp.
Can I use it for my business or my clients?
Yes, for your own personal or internal business use, for as long as you like. Reselling or redistributing the template is not allowed.
What is your refund policy?
Because these are digital downloads, they are non-refundable once delivered - except when the product does not match its description (report it within 48 hours of purchase) or there is a technical problem our team cannot fix within 72 hours. Email [email protected] with your order number.
How do I get help?
Email [email protected] (Mon-Fri, 10 AM-7 PM IST) or message us on WhatsApp +91 80770 90260 (chat only, no calls). Please include your order number.

Still have a question? Click Need help? at the bottom-left to ask our assistant, or message us on WhatsApp.

Application

Google Sheets

Template Type

Dashboard

Price

Paid

Business or Department

Marketing

Reviews

There are no reviews yet.

Only logged in customers who have purchased this product may leave a review.

You may also like…

Public Relations (PR) Dashboard in Google SheetsPublic Relations (PR) Dashboard in Google Sheets
Original price was: ₹1,899.00.Current price is: ₹999.00.
- +
Have your own data? Build a dashboard from your Excel, CSV or Google Sheets file free in Dashboard Studio →
Scroll to Top