Custom Segments: Upload a List, Query Your Data or Ask AI
Your best audiences do not always live in Smartico: guests your VIP team invited, players flagged in your own bonus system, a list from a partner. Bring them in as a CSV file, straight from your own database, or by describing them in plain words to an AI assistant.
Four ways to bring your own audience
A custom segment starts on your side: a list you upload, a query on your own database, or a request in plain words to an AI assistant. Pick the way that matches where your audience lives.
Upload a CSV
Fixed listA file of player IDs from any tool. Use it for one-off audiences: event guests, a partner's list, players your support team picked.
Query your database
On requestSmartico runs your SQL query on your own database at every rebuild. Use it when the data lives only in your systems.
MCP Server
BetaAsk Claude, ChatGPT or Cursor to build the segment in plain language, or to turn a data query into a list.
AI Assistant
BetaThe AI button in your back office builds or changes segments and asks for your approval first.
Upload a CSV file
In Segments, click Create and choose Import segment. Download the template, fill in a column with your player IDs, and upload the file.
- A plain CSV file in UTF-8, up to 50 MB. There is no row limit: large files are processed in batches.
- Smartico checks the first 20 rows before the import starts. Bad rows further down are skipped and counted. IDs that match no player are listed as "No matching users". An upload never creates new players.
- Extra columns can update the same players: profile fields that are not sent by your normal integration, and points, gems or diamonds (add, deduct or set).
- A new file replaces the list. You cannot add rows to an existing list.
| Make a segment | The players in the file become a segment you can use in any campaign or feature. |
|---|---|
| Fix profile data | Fill in values your platform did not send, such as a missed last deposit date. |
| Reward | Add, take away or set points, gems and diamonds for each player. |
SQL segments from your own database
When the data you need is only in your systems, Smartico can read it from there. For example: players who used only part of a bonus in your own bonus system.
- Works with PostgreSQL, MySQL and Microsoft SQL Server. You give Smartico a separate database user that can only read the tables you choose.
- Your query returns two columns: the player ID and the brand ID you already send to Smartico.
- Smartico runs the query at every rebuild, on your schedule or when you click Rebuild Segment, so the list stays fresh. Rows that match no player are skipped. If the query fails, the rebuild fails until you fix it.
- It is not on by default: ask Smartico to switch on SQL Segments. In the back office you then find it among the ready-made templates.
| CSV upload | SQL query | |
|---|---|---|
| Updates | Only when you upload a new file | At every rebuild |
| Data | Any list you have | Your own database |
| Set-up | None | Activation and a read-only user |
| Extras | Updates profile fields and points | Only the list |
Ask AI to build the segment
Connect Claude, ChatGPT or Cursor to Smartico through the MCP Server and say who you want to reach. The assistant can list, create, change, size and archive segments.
- It builds real-time, behavioral and uploaded segments. An uploaded list can be a set of player IDs or the result of a query on your Smartico data warehouse.
- Before it saves, it can check the segment without saving anything and tell you how many players it holds.
- It works with your own back-office permissions, and the result is an ordinary segment you can open and edit in the back office.
- The AI Assistant inside the back office can also create and change segments, and shows each change on a card for your approval.
- Both AI tools are in Beta. Ready-made segments are still created in the back office.
More examples in MCP Server use cases.
You ask
Build a segment of high-value players whose total deposits are over 1,000 and whose last deposit was more than 30 days ago. Estimate its size first; do not save it yet.
The assistant answers
A real-time segment with two conditions: total deposits over 1,000, last deposit more than 30 days ago. About 2,300 players today. Shall I save it?
FAQ
Create an imported segment and upload a CSV file with a column of your player IDs. Download the template from the back office to get the right columns. The file must be UTF-8 and at most 50 MB. Smartico checks the first rows, imports the rest in batches and shows any IDs that match no player as "No matching users".
No, a new file replaces the whole list; you cannot append rows to an existing uploaded segment. To add players, upload a file with the full new list. If the audience should update by itself, build a real-time or behavioral segment instead, or use an SQL segment that re-reads your database.
Yes. Besides the player ID, the file can have columns that update profile fields your platform did not send, and columns that add, deduct or set points, gems and diamonds for each player. Some profile fields cannot be changed by upload; the check before the import tells you which columns it cannot accept.
Yes, with SQL-based segments. You give Smartico read-only access to your PostgreSQL, MySQL or Microsoft SQL Server database and write a query that returns the player ID and brand ID. Smartico runs the query at every rebuild, so the list stays up to date. Keep the query fast, because it runs on your own database.
Yes. Through the Smartico MCP Server, an AI assistant such as Claude, ChatGPT or Cursor can create real-time, behavioral and uploaded segments from a plain-language request, check them and estimate their size before saving. The AI Assistant in the back office can create and change segments after your approval. Both tools are in Beta.
The assistant works with your own back-office permissions and goes through the same checks as a person in the back office. It can check a segment without saving it and tell you its size first. In the back office, the AI Assistant shows every change on a card and waits for your approval before it saves.








