• About
  • Contact Us
Mate Plus
No Result
View All Result
Cart / ₦0.00

No products in the cart.

  • Public Relations
  • Measurement & Evaluation
  • Media Monitoring
  • Industry analysis
  • News & Events
  • Get Reports
Mate Plus
No Result
View All Result

7 Tips to Assure Clean Data for PR Evaluation

November 10, 2020
in Measurement & Evaluation
Reading Time: 2min read
0

50
SHARES
496
VIEWS
Share on FacebookShare on Twitter

While data from media monitoring and measurement allows public relations professionals to uncover valuable insights and demonstrate PR’s importance to their organization, inaccurate or corrupted data can lead to wildly incorrect conclusions.

Clean data is essential to obtain accurate and meaningful insights and recommendations. Corrupted, or “dirty data,” can cause dreadful results. A single clip with the really wrong data can lead to incorrect conclusions about an entire campaign. An entire presentation to a client or corporate management can be worthless due to invalid data.

Instead of using Lysol to clean your data, follow the recommendations of measurement experts on collecting, maintaining and measuring data:

Use Excel rather than Word. Excel enables you to divide data by category into rows and columns that can be cross-referenced and dissected with pivot tables, says freelance media analyst Steph Bridgman. List each new media item in a new row, and divide coverage up into categories. Organizing data into rows and files makes it easier to produce valid analytics about media coverage.

Use Boolean search terms. A fast-food chain once collected 4,000 extraneous references to underground transportation systems that had no relevance to the business, producing a ridiculously large reach figure, recalls PR measurement expert Katie Paine, CEO of Paine Publishing. Most all media monitoring services, including free tools such as Google Alerts, offer Boolean search queries that can eliminate extraneous results. Simply enter “not” before a word to exclude the word from results. You can write “and” between search terms to include both words in any order.

Eliminate duplicates. Take advantage of Excel’s Remove Duplicates option. Go to the Data tab and click “Remove Duplicates.” Select a column with a unique number, like “Clip ID,” or “Item ID.” If that doesn’t exist, use the unique URL of the article and click OK.

Periodically prune metrics. An organization might accumulate a glut of metrics over time as team members add their opinions. Some metrics may be obsolete, irrelevant and even dangerous. In addition, a vast supply of metrics becomes time-consuming to track, report and analyze. Once a year, or after a change in leadership, review the metrics. Eliminate useless figures; keep only those linked to business objectives. “It all comes down to one thing: Does the metric help you make decisions? When you see the metric, do you know what you need to do?” says Lars Lofgren, KISSmetrics marketing analyst.

Establish standard terminology. Different data providers and vendors might apply different definitions for the same metrics, causing confusion. Gather your team to agree on specific definitions for key terms, relying on industry benchmarks such as the Media Rating Council standards for social media or the Institute for Public Relations standards for PR, Paine advises. Then post the lexicon where everyone can access it.

Audit data. Audits check entries to ensure they are accurate and relevant. They’re especially important if you combine multiple sources. The most frequent error in combined data sets is misaligned dates. Make sure date formats are consistent.

Use an established media monitoring service. Doing so can be more effective overall, in addition to saving your organization time and money.

 

A version of this post first appeared on the Glean.info blog.

Previous Post

#EvaluatePR Takeaway- June Edition

Next Post

#EvaluatePR Takeaway- July Edition

Related Posts

P+ Measurement Services unveils “Get-Reports” for the Nigerian PR Industry
Measurement & Evaluation

P+ Measurement Services unveils “Get-Reports” for the Nigerian PR Industry

April 6, 2021
Advocating for Nigerian Media Monitoring and Measurement Association (NiMMA).
Measurement & Evaluation

Advocating for Nigerian Media Monitoring and Measurement Association (NiMMA).

March 22, 2021
Measurement & Evaluation

PR Must Become More Analytical, Says PR Measurement Expert

March 9, 2021
Measurement & Evaluation

Who should measure PR?

March 2, 2021
Measurement & Evaluation

Automated Sentiment Analysis Still Falling Short of Promise for PR Measurement

February 16, 2021
Measurement & Evaluation

Katie Paine’s 6 Steps to PR Measurement Success

February 16, 2021
Next Post

#EvaluatePR Takeaway- July Edition

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Get PR Performance Report

Recent Post

  • The Age of Crisis Demands a New Organization Chart, with Communications at its Head
  • P+ Measurement Services unveils “Get-Reports” for the Nigerian PR Industry
  • Four Things Your PR Agency Needs to Stop Saying
  • Communications expert set to share their experience at the 16th Edition of #EvaluatePR
  • Advocating for Nigerian Media Monitoring and Measurement Association (NiMMA).

Comments

  • Angela Jeffrey on 21 QUOTES: #FIBEP 2016 TAKE AWAY
  • Ralph Allison on P+ Measurement launches Nigeria’s first Broadcast Advert Analytics Audit Report
  • Philip Odiakose on P+ Measurement upgrades PR audit report services
  • Todd Murphy on P+ Measurement upgrades PR audit report services
  • P+ Measurement Services on “It is unprofessional for PR agencies to establish communication measurement agencies”

Categories

  • #EvaluatePR Tweet Chat Events
  • Advert Spend Analysis
  • COVID-19 Infographics in Nigeria
  • Industry analysis
  • Measurement & Evaluation
  • Media Intelligence Report
  • Media Monitoring
  • News & Events
  • Public Relations
  • Training
  • Uncategorized
Mate Plus

Copyright © 2019 P+ Measurement. All rights reserved.

Navigate Site

  • Home
  • Advertisement
  • Contact Us

Follow Us

No Result
View All Result
  • Public Relations
  • Measurement & Evaluation
  • Media Monitoring
  • Industry analysis
  • News & Events
  • Training
  • Get Reports
  • Cart

Copyright © 2019 P+ Measurement. All rights reserved.

Our customer support team is here to answer your questions. Ask us anything!
WeCreativez WhatsApp Support
Support 1
Support
Away
WeCreativez WhatsApp Support
Support 2
Support
Away
Hi, how can I help?