How to Clean Up Customer Data and Revive Your Company

Grow Your Business, Not Your Inbox

Stay informed and join our daily newsletter now!
Will be used in accordance with our Privacy Policy
How to Clean Up Customer Data and Revive Your Company
Image credit: Shutterstock
Guest Writer
Founder & CEO, Brainscape; Instructor, TechStars and General Assembly
3 min read
Opinions expressed by Entrepreneur contributors are their own.

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 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

More from Entrepreneur

Get heaping discounts to books you love delivered straight to your inbox. We’ll feature a different book each week and share exclusive deals you won’t find anywhere else.
Jumpstart Your Business. Entrepreneur Insider is your all-access pass to the skills, experts, and network you need to get your business off the ground—or take it to the next level.
Starting, buying, or growing your small business shouldn’t be hard. Guidant Financial works to make financing easy for current and aspiring small business owners by providing custom funding solutions, financing education, and more.

Latest on Entrepreneur

Entrepreneur Media, Inc. values your privacy. In order to understand how people use our site generally, and to create more valuable experiences for you, we may collect data about your use of this site (both directly and through our partners). By continuing to use this site, you are agreeing to the use of that data. For more information on our data policies, please visit our Privacy Policy.