“But we’re not Excel-people!”

In an email conversation with a blog subscriber, we discussed the challenges of pushing your team to adapt to a ‘digital first’ world:

The subscriber told me about how challenging it was to get colleagues who love letters to also love numbers. And, in my experience of working with many different types of organizations, this challenge is not uncommon.

Now, I love the power of the written word, too. But here’s the thing:

Technology, code, math — they’re all languages as well. In fact, they’re the Esperanto of our time; a unifying set of global languages that know no borders and defy slow-to-adapt politicians. The language of information technology is defining for our generation.

Thus, the time has come for communication professionals to step up and embrace the power of datadriven PR and marketing.

But where to start?

I suggest investing in a data warehouse.

Here’s why:

What’s a Data Warehouse?

‘Data warehouse’ is computing terminology, and it has nothing explicitly to do with public relations or marketing. Here’s how Wikipedia describes a data warehouse:

“In computing, a data warehouse (DW or DWH), also known as an enterprise data warehouse (EDW), is a system used for reporting and data analysis and is considered a core component of business intelligence. DWs are central repositories of integrated data from one or more disparate sources. They store current and historical data in one single place and are used for creating analytical reports for knowledge workers throughout the enterprise.”

In my words:

The data you collect as an organization goes into a huge “Excel-document” for future analysis.

However, not all data is created equal:

Example: You can’t combine your social media data with the data you collect on your website since these two data sets are structured differently. And this is why there are different types of programs tasked with restructuring all incoming data before storing it in your data warehouse.

Then, there are also different types of programs that will allow you to analyze and visualize your collected data. Otherwise, you’d just be sitting there, staring at lots of numbers in a massive spreadsheet.

So, that’s essentially what a data warehouse is.

But why is it necessary for public relations and marketing to have one?

Big Data for PR and Marketing

There are many advantages for communication professionals to collect and store all public relations and marketing data in one place:

Analysis. It’s more valuable to analyze various data sets together.

Time. Analyzing data via a single interface is more time-efficient.

Compliance. Regulations like GDPR will affect PR and marketing, too.

Then, which types of data sets could be relevant for communication professionals to access? A few examples:

  • Social media data
  • SEO/SEM data
  • Analytics data
  • Email data
  • Sales data
  • CRM data
  • Market research data
  • Budget data
  • Time report data

And the list goes on:

Is your business sensitive to weather fluctuations? The, maybe import some geographic data, too. The point here is that it’s always possible to increase the value of your combined data sets.

One strategy is, of course, to gather as much data as you can, but it’s the quality of your data that will determine the quality of your analysis.

As communication professionals, it’s not our job to set these data warehouses up. It’s not our job to make sure that they are secure and up and running. It’s not our job to manage the software that takes care of restructuring and analysis.

But it is our job to decide what public relations- and marketing data sets should go into the data warehouse — and how they should be analyzed.

The Future of PR and Marketing is Datadriven

I often hear this:

“It’s so difficult for us communications professionals to demonstrate ROI!”

“There’s so much data, but how do you make sense of it?”

“Our management doesn’t really understand the importance of ‘digital first’!”

Well, do you have a data warehouse up and running?

All future PR- and marketing-departments must learn to appreciate the value of a powerful data set. Otherwise, one of two things will happen:

Scenario #1: Your data gets lost — forever.
Scenario #2: Your data gets stored away in silos, never to be accessed again.

Example: Social Media Monitoring

What’s the point of social media monitoring?

Most organizations invest in some form of online monitoring tool. Some of these tools are quite on the expensive side, too. So why?

Most organizations are monitoring what’s being said about themselves and their competitors. Some use monitoring tools to be able to detect issues early, like tsunami buoys acting as early warning systems.

And that’s all well and good.

But that’s not the real power of analyzing social media data. The real power is social media intelligence.

(The term is used by Whispr Group, a social media intelligence firm in New York and Stockholm, where I was the COO and lead strategist between 2010-2013.)

Here’s the thing:

The real power of social media monitoring lies in the analysis of historical data. And to analyze historical data, you must store your data sets in an accessible way.

Imagine if you could analyze relevant data from years and years back. What otherwise hidden secrets and patterns would you find?

(Now, most social networks and monitoring tools have their own native insight dashboards, but these are often more or less useless for any type of serious analysis. These tools don’t know anything about your business strategy and all they can provide are generic reports that look the same for everyone.)

Evolution = Survival through Adaptation

For many communications professionals, ‘datadriven PR- and marketing’ is indeed a scary concept.

I get it — I truly do.

I used to be an avid hater of spreadsheets, too. To some extent, I still am.

But despite the fact that there are new channels, new tools, and new behaviors, what constitutes strategic communication haven’t changed at all. The basic tenets of communication are still the same; it’s still what you know and love.

Setting up a data warehouse is a one-time project, and then it mostly runs by itself. (And when it doesn’t, your new best friends over at the IT department will do their best to fix it for you.)

You get to do the fun part — diving into the data, creatively looking for answers, and coming up with next steps.

Data warehouse.
Write this down, please.

What’s your take on datadriven PR and marketing? Please share in the comment section.