A Marketers in Demand company

3 Tactics for Reading Customer Data

Jacob Brain

Author

With mountains of customer data to analyze, you may feel the need to have “big blue” in your back corner to crunch the data to get any valuable information or insights. Reading customer data can reveal many interesting things, yet you don’t need a super computer or a team of nerds from MIT to get value from your data. Here are some tactics using a simple spreadsheet program that can provide big insights into your customer data.

Group by X

Sometimes the biggest insight is a matter of perspective. And a good way to change perspective is to change the way your order or group your customer data. You might be looking clearly at profit and margin of your customers. But what if you grouped them by frequency first, then looked at profit? What if your grouped them by product category? Any column in your customer data can be used as a grouping column and may provide insights. Sometimes, seemingly insignificant data points actually have a bigger influence than you might expect.

Creating Cohorts by Scoring

You might have a lot of variation in your customer data, which could make creating cohorts within your data a bit tough. A good solution to this is to score relevant data points, and create your cohorts from those scores. It simplifies the reading process and allows you some flexibility to explore the data.

Look at the Outliers

Taking averages of your data makes great board room and presentation material. But what about those outliers? Why is this one customer spending so much with you and this one, so little? What do they have in common, or not? If you had 10,000 customers, you could take the top ten and the bottom ten and gain a lot of insight around their behaviors alone. The polarity of their profiles should provide obvious data points and actionable insights. Combine this tactic with the group by tactic, and you can really start to chop up the data in new ways to glean insights.

You might also like...

If you’re looking to scale revenues for your SaaS business, chances are you’re getting serious about investing in marketing.  Marketing plays a crucial role in determining the success or failure of a product. The market is competitive and unless…
Do you know how much profit is bleeding out of your company? Use our retention calculator to find out how a real retention campaign can change your bottom line….
Salespeople believe that election years are harder when it comes to making sales. But is it true, or just an old myth to justify the slow season?…
Scroll to Top