↑↓ selectEnter openEsc close

    1. Elbuz

    How to find a customer in your database and pick the ones you need

    7 min readUpdated

    Elbuz finds a customer among thousands of records by part of a name, phone or email, and picks ready-made groups in one click: debtors, dormant buyers, unassigned records.

    When you need this:

    • A customer calls — number search and the AI summary show who it is and what they bought.
    • Buyers stopped ordering — the “Dormant customers” tile lists only them.
    • A manager needs only their customers — the “Mine” view opens them in one click.
    • A sales head checks the team — analytics shows stages, workload and each manager's 30-day follow-ups.

    Where to start: type part of a name or number into the search box in “Contacts”.

    What the contact list can do

    The list opens just as fast with ten records as with fifteen thousand: the browser receives only the visible rows, and the rest load as you scroll. You can narrow it in three independent ways, and they combine with each other.

    • Search box — a record by name, contact person, phone or email.
    • Stats tiles — ready-made selections: “Has debt”, “Dormant customers”, “Without owner” and others.
    • Filters and views — a more complex selection, saved under a name for yourself or for the team.
    • Three presentations — the same records as a table, a stage board or cards.
    • AI summary — who the customer is and what to do next, without opening the card.
    • Analytics — customer stages, sources, top by turnover and manager activity.

    How to find a customer by name or phone

    The box is in the window header. Its placeholder names the first search fields, and you see the full list by hovering over the box. The set of fields is defined by the “Use for search index” checkbox in the grid settings window, so it differs from account to account.

    The demo database has ten such fields: Name, Name #2, Contact person, Phone, Phone #2, Email, Email #2, Website link, TIN, OKPO. The third phone and the third email are not in this set.

    Search runs on the server and checks all ten fields with “or”: a match in at least one of them shows the record. The / key puts the cursor in the search box, and Esc clears it.

    Search compares text literally and does not normalize phone numbers. Phone numbers are usually stored with spaces — +380 50 302 60 35; in the demo database almost every filled-in number looks like this.

    There, the query 0503026035 finds nothing, while 302 60 35 finds the right record. Search for a phone number by a fragment written the way it's stored in your records — for example, the last four to six digits.

    Ctrl+K search also matches phone numbers literally. The duplicate check on entry works differently: it does normalize the number (see duplicate warning). These are two different mechanisms, and their results don't have to match.

    How to pick customers with debt, dormant customers and records without a manager

    Apart from them, on the left is the scope panel “Views”: roles at the top, record type below, then “Trash” with a count of deleted records. The “?” in its header expands a short guide, “How this window works”. The panel collapses with a double arrow, its width is dragged with the mouse, and your browser remembers both.

    Contacts window: indicator tiles on top and the segments panel on the left
    1Total tile
    2Dormant customers tile
    3Roles list
    4Record type heading
    5Trash
    1. Total — the only tile that does not filter the list.
    2. Dormant customers — contacts with no activity for a long time.
    3. Roles list — filters contacts by role, with counts.
    4. Record type — organizations, private persons, contact persons.
    5. Trash — deleted contacts at the very bottom of the panel.

    Above the list there are up to ten tiles. All of them except “Total” are ready-made selections: clicking a tile leaves only those records in the list, and clicking it again removes the selection. The tooltip on such a tile says “Show only these records”.

    A tile whose number equals “Total” is hidden: it selects nothing and tells you nothing. This is usually how “No next step” disappears while nobody plans follow-ups. The tile of an active selection stays in place even if its number has caught up with the total, so you can see the list is narrowed.

    Stats bar tiles
    TileWho it counts
    Totalall records in the current scope; the only tile that doesn't select
    Minewhere you are the responsible manager
    New this monthadded in the last month
    Has debtthose with unpaid documents
    Without ownerno manager assigned
    No next stepno future contact with the customer is planned
    Next step overdue ( overdue)the planned date has passed, and there's no result mark
    Dormant customersthose whose customer stage is “Dormant”: they have bought before, but the gap is longer than your business format threshold
    Idle leadsstage “Lead”, the record was added more than 3 days ago, and it has no deals
    No contactsboth phone and email are empty

    The numbers are counted for the current scope — the selected role and record type — but without the tile's own condition. So clicking “Dormant customers” won't reset the numbers on the other tiles.

    “Dormant customers” includes only past buyers. The threshold depends on your business format: online store or pickup point — 90 days without a purchase, wholesale — 120, services — two usual intervals between the customer's payments, but at least 45 days. Someone who never bought is a lead, not dormant: see the “Idle leads” tile.

    How to build a complex selection and save it

    The filter panel is hidden: the “Filters” link above the list opens it, with the number of active filters next to it. The default set has twenty rules, thirteen of them shown in the panel, and five visible right away — the rest are under “More”. The set is personal: what you turn off or rename doesn't change for colleagues.

    Filters in the default set
    FilterWhat it selectsIn the panel
    Customer stagea list of customer stages: Lead, Customer, Regular…yes
    Account managera list of employeesyes
    Contact groupa list of rolesyes
    Type (legal/private)legal entity or private personyes
    Sourcethe channel the contact came fromyes
    Without emailempty email fieldyes
    Without phoneempty phone fieldyes
    Industrya list of industriesyes
    Without managerno responsible manager assignedyes
    Added this monthadded within 30 daysyes
    VIP customersVIP segment: a “regular” buyer whose total spend is at least twice the store averageyes
    Regular customers“Regular” segment: 3+ purchases (2+ in services), the gap is no longer than the format thresholdyes
    Dormant customers“Dormant” segment: the gap is longer than the format threshold, but less than a yearyes
    Citya list of citiesonly in the filters window
    Organizationsrecord type “organization”only in the filters window
    Private personsrecord type “private person”only in the filters window
    My companiesyour own legal entitiesonly in the filters window
    New customersone purchase, the gap is no longer than the format thresholdonly in the filters window
    Repeat customerstwo purchases, the gap is no longer than the format threshold (in services, two payments already mean “Regular customers”)only in the filters window
    Lost customersthe last purchase was more than a year agoonly in the filters window
    Filter button panel above the contacts grid
    1Filters link
    2Views link
    3More (8)
    4Filter settings
    1. Filters — shows or hides the filter button panel.
    2. Views — saved views of the list.
    3. More — the filter buttons that do not fit in the row, with their count.
    4. Filter settings — choose which filters appear on the panel.

    Segment filters use the same threshold as stages: 90 days for stores, 120 for wholesale, the payment interval for services. The “Dormant customers” filter selects by buyer segment, the tile of the same name by stage. Numbers differ only when records without a stage — suppliers and competitors — have purchases: the filter sees them, the tile doesn't.

    Next to “Filters” is the “Views” link. A view remembers the scope, the pressed tile, active filters, sorting and presentation under one name. Three views are built in: “Mine”, “Dormant customers” and “Without owner”. Save your own with “Save current view”; the “Available to the whole team” toggle shares it, and then only its creator can delete it.

    How to see customers as a stage board

    The switch in the window header: “Table”, “Stages”, “Cards”. The scope, filters and search are shared by all three — only the way the same records are shown changes.

    Table — a regular grid where you edit right in the cell.

    Stages — a board where the columns are customer stages and the cards are contacts. Columns are only the enabled stages of your business format: for an online store, “Lead”, “Customer”, “Regular”, “Dormant”, “Lost”, “Not a fit”; for wholesale and services, “Qualified” also sits between “Lead” and “Customer”.

    The first column is “No stage” — it holds suppliers, competitors and records that don't have a stage yet. Each column loads no more than 40 cards, and whatever doesn't fit is marked separately.

    Columns the system calculates are marked with a lock: “Customer”, “Regular”, “Dormant”, “Lost”. You can't drag a card into such a column or out of it: the board just won't let go of it, and the tooltip on the lock explains: “This stage is calculated from purchases — cards can't be moved here”.

    A card moves freely only between manual stages: lead, qualified, not a fit. Clicking a card shows the record in the panel on the right, and double-clicking opens the card. The card line under the name doesn't show the “Customer” role, so as not to repeat the stage name: the source appears instead — chat, email, import.

    The “Stages” view: columns No stage, Lead, Customer and Regular with locks
    1“No stage” column
    2Manual stage “Lead”
    3Lock on “Customer”
    4Lock on “Regular”
    1. Suppliers, competitors and records without a stage.
    2. A lead card can be dragged to another manual stage.
    3. The app calculates this column from purchases; cards can’t be moved into it.
    4. Repeat purchases; the app moves cards here itself.

    Cards — tiles with a photo, role and city; on the right of each tile there are contact icons: call, send an email, Telegram. Tiles load in batches of 60 as you scroll.

    Which columns to show and what the preview panel shows

    The grid has over 150 columns, and thirteen are shown out of the box: “Select”, the edit button, “Name”, “Customer segment”, “Phone”, “Customer stage”, “Responsible manager”, “Company”, “Contact person”, “Active”, “Turnover”, “Discount, %” and “Date added”. Turn on the rest via the menu → “Set up grid”. The layout is saved for you personally.

    Two columns apply only to buyers. “Customer segment” is a badge — “New”, “Repeat”, “Regular”, “VIP”, “Dormant” or “Lost” — with one to five rating stars next to it. “Customer rating” is the stars alone; they combine three scores: how recent the last purchase was, the number of orders, and spend relative to your store's average buyer.

    The program calculates both columns hourly from purchases — what counts as a purchase is set by your business format; you can't edit them in the grid. Anyone who has never bought has them empty. What AI does with this profile is in “Customer profile”.

    The “Name” column is composite: a photo or colored letter, the name, and below it, dot-separated, the role, record type icon, organization, city and the owner's initial. Left of the photo is a completeness dot with the tooltip “Card completeness: N%”. So “Contact group”, “City”, “Email” and “Photo” are hidden by default: they would duplicate this cell.

    The “Preview” panel on the right shows the selected record without opening the card: contacts, money, recent documents, deals, price lists, tasks, correspondence, contact persons, the next follow-up, recent events and a note field. A section with no data isn't drawn at all.

    Preview panel for an organization record, scrolled to its bottom
    1Preview panel header
    2Deals section
    3Price lists section
    4Open card button
    1. Preview panel header — shows the panel for the row selected in the grid.
    2. Deals section — start a new deal for this contact.
    3. Price lists section — the supplier's price lists with date and item count.
    4. Open card button — opens the full contact card.

    You decide what goes into the “Record data” block of this panel — with the “Show on panel” checkbox in the same column settings window. While nothing is ticked, the panel says so: “Tick the fields you need with “Show on panel” in the column settings.”

    Some panel sections are restricted by rights to other windows: without access to price lists there's no “Price lists” section, without access to email — no “Correspondence”, without access to the deals window there's no “New deal” button. This is deliberate: a button that leads to an access-denied message is worse than no button.

    How to recall who a customer is in seconds: AI summary

    Under the name and contact buttons in the panel is the “AI summary” block — three or four lines: who the customer is, what they bought and for how much, what the last contact was about, what to do next. Its job: when a customer calls or writes, you recall them in ten seconds without digging through documents and emails.

    Preview panel header with contact buttons and the AI summary block
    1AI summary block
    1. AI summary — a short generated overview of the contact, with a refresh button.

    Where AI gets its facts: the customer's documents and deals, the text of the last three emails (without quoted earlier messages and signatures), recent chat messages, the event feed and the planned follow-up. It makes nothing up beyond that — if a call or email isn't linked to the card, it won't get into the summary.

    • When it's generated. The first time you open this customer's panel. After that, the summary is stored in the card and shown right away; AI rewrites it only if the customer has had activity since the last run: a new document, email, chat message or feed event. It doesn't update on its own, on a schedule.
    • The “Refresh summary” button — the arrows icon to the right of the block title — regenerates the summary now, even if nothing new has happened. Below the text you see when it was updated.
    • When the block isn't there. The customer has no activity other than the card being created — there's nothing to tell. Or AI is unavailable: demo access or a service outage. If a summary was generated before, the previous one is shown in that case.
    • Language — the language of your company's administrator, not of each individual employee.

    Below the summary text, a buyer has figures that AI doesn't write but the program calculates itself: “Orders” (count and amount), “Average order”, “Last order”, “Returns” (if any) and “Recent purchases” — up to five products with dates.

    Two more lines, “Interests” and “Pain points and objections”, are extracted by AI from emails and chats together with the summary and updated by the same refresh. These figures are visible even when there's no summary itself: for example, with demo access.

    The same summary is shown in chat — in the “Customer Information” panel, if the chat is linked to a contact. The same people who see the card see it: a customer outside your “Data scope” won't open the summary.

    How many customers and what managers did: analytics

    The chart icon in the window header opens “Contact analytics” — for the same scope currently selected in the list.

    It shows: total, new this month, active (a document in the last 90 days), without an owner and without contact details; inflow of new contacts over twelve months; the “Customer stages” chart, where empty stages show as gaps and records without a stage are a separate number; breakdown by role; owner workload; sources; top 8 by turnover.

    Turnover counts only posted documents, and amounts are converted to the base currency — this is stated right under the panel.

    Below is the “Manager activity” report: calls, meetings, emails and tasks that managers completed over the last 30 days — for each one separately. A row is a manager, the columns are “Call”, “Meet”, “Write an email”, “Task”, then the results “Completed”, “No answer”, “Postponed”, “Refused”, “Total” and “In progress” (planned, not yet closed).

    Only follow-ups closed with a result mark are counted, by actual date, not the planned one. A manager who closed no follow-ups in 30 days isn't in the report, and while nobody has closed follow-ups, the block isn't shown at all. This report doesn't count calls from the telephony log — only follow-ups from cards.

    Scenarios

    A customer is calling — you need to recall who they are in seconds

    What to do. Find the customer in the search box of the “Contacts” list — by name, and type the number the way it's written in the card (search box) — and click the row: “Preview” opens on the right. Read the “AI summary” block at the top of the panel.

    What you get. Three or four lines show what the customer bought and for how much, what the last email or chat was about, and what to do with them — for example, “ready to pay at Nova Poshta after inspecting the goods”. No need to open the card.

    What won't happen. The summary doesn't know what isn't in the card: a conversation that wasn't linked to the customer, or verbal agreements without a note. If you've just added a note and the summary doesn't have it yet, click “Refresh summary”.

    You need to win back buyers who stopped ordering

    What to do. Click the “Dormant customers” tile above the list. To avoid building the selection again next time, open it as the ready-made “Dormant customers” view in the “Views” menu.

    What you get. The list keeps buyers with the “Dormant” stage: they have bought before, but the gap is longer than your business format threshold. The other tiles don't reset their numbers, so you can see how many of all customers are dormant.

    What won't happen. Anyone who has never bought won't be in this tile — the “Idle leads” tile finds them. “Dormant” can appear with a delay of up to 7 days: the program recalculates long-standing buyers once a week.

    What to do when you can't see a customer

    What the program says and what to do about it
    What you seeWhyWhat to do
    Searching by phone number finds nothing, although the customer is in the database search compares text literally, and the number is stored with spaces search by a fragment of the number as it's written (search box)
    “No contacts yet” there are no records in the current scope reset the scope with the cross on the chip above the list, or add a record (selections)
    “Total” in the status bar shows a number, but the list has no rows your user has no saved grid column layout — there's nothing to draw menu → “Set up grid”, tick the columns you need and save (columns and panel)
    “Tick the fields you need with “Show on panel” in the column settings.” no fields are ticked for the preview panel menu → “Set up grid”, tick the checkboxes (columns and panel)
    “Could not change the stage” moving a card in the “Stages” view wasn't saved: no “Edit” right on the stage field, or the connection dropped check the group's right on the “Customer stage” column (who sees what)

    FAQ

    How is the “Dormant customers” tile different from the “Dormant customers” filter?

    The tile selects by customer stage, the filter by buyer segment. The numbers differ only when records without a stage — suppliers and competitors — have purchases: the filter sees them, the tile doesn't (filters).

    Does the system highlight customers who haven't ordered in a long time?

    Yes. A buyer who hasn't bought for a long time gets the “Dormant” stage, and after more than a year — “Lost”. The “Dormant customers” tile selects them in one click. The threshold depends on your business format (stats bar).

    Why are there no telephony calls in the manager report?

    The “Manager activity” report counts only follow-ups from cards that were closed with a result mark. Calls from the telephony log aren't included (analytics).

    Why doesn't the AI summary know about yesterday's call?

    The summary uses only what is linked to the card: documents, deals, emails, chats and feed events. An unlinked call or a verbal agreement without a note won't get into it. Added a note? Click “Refresh summary”.

    Why is there no “AI summary” block in the panel?

    The customer has no activity other than the card being created, or AI is unavailable: demo access or a service outage. The buyer's figures under the summary are visible even then (AI summary).

    Can I save my set of filters for the whole team?

    Yes: “Views” → “Save current view” with the “Available to the whole team” toggle. Only its creator can delete a shared view.

    Where it is and who has access

    Menu
    Directories → Contacts → Contacts
    Analytics
    the chart icon in the header of the “Contacts” window
    Access right
    the “Contacts” window; which records you see — “Data scope”

    Related topics

    Was this article helpful?

    Missing a feature? Tell us.

    We will add it for free if other users need it too.

    If only you need it, we will agree on it separately.

    Article contents

    Suggest an improvement

    Try Elbuz free