Segmentation

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 list

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

Smartico runs your SQL query on your own database at every rebuild. Use it when the data lives only in your systems.

MCP Server

Beta

Ask Claude, ChatGPT or Cursor to build the segment in plain language, or to turn a data query into a list.

AI Assistant

Beta

The 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.
One file, three jobs
Make a segmentThe players in the file become a segment you can use in any campaign or feature.
Fix profile dataFill in values your platform did not send, such as a missed last deposit date.
RewardAdd, 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 or SQL query?
CSV uploadSQL query
UpdatesOnly when you upload a new fileAt every rebuild
DataAny list you haveYour own database
Set-upNoneActivation and a read-only user
ExtrasUpdates profile fields and pointsOnly 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

How do I import a list of players into Smartico?
Can I add more players to an uploaded segment later?
Can a CSV upload update player data or give points?
Can Smartico build a segment from our own database?
Can I create a player segment with AI?
Is it safe to let an AI assistant change segments?