Skip to content

Querri for Customer Segmentation Know your best customers, so you can target better and grow faster

Your customers are spread across systems: orders in the store, accounts in the CRM, tickets in the help desk. Connect them or upload the exports, and Querri finds the groups that matter by revenue, behavior, region or clustering. Save the segments once and every report after that uses the same definitions.

See It in a Real Project

This walkthrough comes from the Renewals Below Target playbook. It joins Salesforce accounts with product usage, support and NPS data, then groups renewing customers into usage tiers. Segmenting your own customers follows the same steps.

Why It's So Hard to Know Which Customers Actually Matter

Most businesses are sitting on piles of customer data and still can't answer basic questions like:

"Who's loyal?"

"Who's likely to churn?"

"Which customers bring the most value?"

Each system holds one part of the customer. The store knows what they bought, the CRM knows who they are, and the help desk knows how often they complain.
Spreadsheets make it hard to compare patterns.
BI dashboards can't discover segments on their own.
And methods like clustering usually need a specialist.

So you guess instead of knowing, and miss chances to personalize marketing, improve service and grow your best relationships.

Customer data scattered across systems
Querri grouping customers into segments

How Querri Simplifies Segmentation

Connect your store, CRM and help desk, or upload the exports. Then just ask:

"What are the key customer segments in our data?"

"Group my customers by spending and order frequency."

"Which segments are growing fastest?"

Querri explores your data, cleans it up, matches the same customer across systems and groups your customers. That can be a simple breakout by region, store or plan, or a clustering model such as K-means. It can suggest how many segments make sense, label them by their traits and chart how each one is changing.

Every step is code you can open and read. Save the result as a view with one row per customer, and the segment is there for every dashboard, report and follow-up question.

What You Gain When You Finally Know Your Customers

One view of each customer across your systems

Clear visibility into who your customers are

Smarter targeting for marketing and sales

Segments defined once and reused in every report

No waiting for a data team

Segments that update as new orders arrive

How-To in Five Steps

1

Connect or upload your customer data

Connect Shopify, HubSpot, Salesforce, a database or a warehouse from 125+ connectors, or upload Excel and CSV files. Include fields like customer ID, revenue, order count, join date and location.

2

Add more context

Bring in a second source such as product preferences, support tickets or campaign responses. Querri helps you match them to the same customer.

3

Clean and join your data

Prompt: "Fix column names, remove duplicates, format dates, and fill missing values." Prompt: "Join customers and orders on Customer ID." Querri runs more than 180 data quality checks on each table as it arrives, so you can see what needs fixing before you ask.

4

Ask for customer segmentation

Prompt: "Find the best customer segments using revenue, recency, and frequency." Prompt: "Group customers by store and product preference." When your team agrees what a segment means, save the definition under Facts and Rules. Everyone who asks later gets the same groups.

5

Analyze, save and share

Prompt: "Show churn rate and revenue trend by segment." Prompt: "Describe what makes each segment different." Add the charts to a dashboard, share it with your team's workspace, or schedule the project so the segments refresh on their own.

Steps to build customer segments with Querri

Best Practices

Start simple, then go deeper

Segmenting by store or region is easy and useful. Then ask Querri to run clustering to find more nuanced groups.

Name your segments clearly

Whether Querri suggests names or you write them, clear labels like "VIPs", "At-Risk" or "Frequent Bargain Shoppers" make the segments easier to act on.

Write the definition down

Once you agree what "active customer" or "VIP" means, save it under Facts and Rules. Everyone who asks later gets the same segment, not a slightly different one.

Use at least 6 to 12 months of customer data

This captures recurring behavior, like holiday buyers and loyal repeat customers.

Track key fields: revenue, number of orders, join date and location

These give you recency, frequency and value, the standard inputs for segmentation.

Bar chart of renewing accounts grouped by usage tier

FAQs

I'm not sure what to segment by. Can Querri help?
Yes. Ask "What are some smart ways to segment my customers?" and Querri suggests options based on the data you have.
What if my data is messy or incomplete?
Querri checks every table as it arrives and helps you fix what it finds, such as inconsistent column names, duplicate customers and missing values.
Do I need to understand clustering algorithms?
No. Querri can run K-means or another method for you and explain what each segment means in plain language. The code is there to read if you want it.
Can I just segment by geography or store?
Yes. Not every segmentation needs a model. Slicing your customers by store, zip code or sales channel is often the most useful view.
Can I combine data from several systems?
Yes, and this is where segments get more useful. Join orders with campaign history or support tickets to compare engagement and satisfaction across segments. If you use two systems together, see the pages for Shopify and Klaviyo or Salesforce and HubSpot.
How do I use the segments once they're created?
Compare their performance, track them over time or download the list as CSV or Excel. You can also filter reports and marketing lists by segment.
Will it be easy to repeat this analysis later?
Yes. The analysis is saved as steps in a project. Run it again or schedule it, and the same steps replay on your latest data.
Can each account manager see only their own customers?
Yes. With row-level access, one shared dashboard shows each person only the customers they are allowed to see.
Frequently asked questions about customer segmentation

Ready to Build Smarter Segments?