⚡ Get All Content for 20% Off ⚡

How to Clean Up Customer Data and Revive Your Company A three-hour database training session could transform your marketing team and boost your bottom line.

By Andrew Cohen

entrepreneur daily

Opinions expressed by Entrepreneur contributors are their own.

Shutterstock

In this competitive era of personalized marketing, a marketing team's ability to communicate with a company's existing customers is only as good as the customer data they are able to work with.

Designing marketing campaigns, segmenting audiences, forecasting the impact of potential new features and sending appropriately timed customer emails can only be done when the product and marketing teams have a constant stream of actionable and up-to-date information about the audience being reached. It is therefore depressing how many companies' marketing teams lack access to such information.

Related: 10 Questions to Ask When Collecting Customer Data

Where is your customer data?

Through my work at TechStars and as the business metrics instructor at General Assembly, I have spoken with a surprising number of great companies whose marketing teams regularly suffer from a dearth of the customer information that they really need. "We have the data buried in our database," the story often goes, "but we'll have to ask the [expensive] tech guys to get us that data."

Simply seeking the web versus mobile activity of a specific user cohort could mean asking a valuable software engineer to spend time writing a custom database query, because automatic data plugins and customer relationship management (CRM) tools don't always cut it.

Structured query language (SQL) just isn't that hard.

Fortunately, we were able to solve this problem at Brainscape by realizing that writing database queries is actually not very hard. It turned out that learning to write basic SQL code was something that even our non-technical marketing team could accomplish in as little as a three-hour workshop, led by our chief technology officer.

Related: 4 Things Non-Tech Leaders Do Better Than the Cyber-Obsessed

Brainscape's database training session helped us to develop a much more efficient user-communication machine. Each product and marketing team member is now empowered to explore our own hypotheses without needing to bother a valuable engineer. With a MySQL terminal and a little bit of brain power, we can answer questions like:

  • Which subjects are Brainscape users studying the most enthusiastically?
  • Which age groups are creating the most content?
  • In which step of the new-user onboarding funnel are we losing teachers?
  • Who are the most prolific sharers this month?
  • Are female users as active as male users, and if so, in which cases?
  • And the list goes on ....

Hold a database training session.

You can likely think of similar data points that you would want to know at your own company. Rather than asking your engineers to get you that information, I strongly recommend that your company hold a database training session, where an engineer trains each marketing team member about the structure of your customer database and about the syntax with which database queries can be written.

Of course, your company's marketing team may already have access to much of the data they need, either in the form of a regular monthly report or in a nice user-facing CRM interface like Salesforce or Customer.io. But at the end of the day, nothing is as flexible as learning how to write good old-fashioned SQL code.

Whatever language your database is built in, I can guarantee that having a star engineer train the marketing team on writing customer database queries is one of the best investments your company can make. It's a major step in becoming a more metrics-driven business.

Related: The Complete Guide to Building a Metrics-Driven Company

Andrew Cohen

Founder & CEO, Brainscape; Instructor, TechStars and General Assembly

Andrew Cohen is the founder of Brainscape, a web and mobile education platform that helps people study more efficiently. Brainscape originally grew out of a personal project that Cohen created to help him improve his Spanish, while working in Panama for the World Bank. It later inspired him to seek a master's degree in instructional technology from Columbia University and transform his pet project into a fundable startup that can help people study any subject. Brainscape has since raised several million dollars from top venture capitalists.

Want to be an Entrepreneur Leadership Network contributor? Apply now to join.

Side Hustle

The Remote Side Hustle a 43-Year-Old Musician Works on for 1 Hour a Day Earns Nearly $3,000 a Month: 'All From the Comfort of Home'

Sam Ziegler wanted to supplement his income as a professional drummer — then his tech skills and desire to help people came together.

Business News

Costco CFO Reveals Uncertain Fate of $1.50 Hot Dog and Soda Combo

CFO Richard Galanti reveals that the price will stay the same — but only "for a while."

Business News

The Most Unexpectedly Popular Side Hustle of the Decade Has Low Startup Costs and High Markups

A new report shows that vending machines are a popular investment — and the industry is set to grow up to $3 billion by 2031.

Marketing

Ever Wonder Why Certain Websites Rank Higher Than Yours? This SEO Expert Reveals The Secret to Dominating Search Results

It's often the smart use of SEO, now supercharged with AI, particularly in keyword optimization.

Business News

AI Is Impacting Jobs. Here Are the Gigs Affected the Most, According to an Analysis of 5 Million Upwork Postings

The researcher said in the report that freelance jobs were analyzed first because that market will likely see AI's immediate impact.

Leadership

Former Interrogator Shares 5 Behaviors Liars Exhibit and How to Handle Them

Five deceptive behaviors to look for and how to respond to those behaviors when you encounter them.