How to Exclude Already Processed Users from a Telegram Expert Database

When collecting an audience in Telegram again, you may get users you have already worked with. For example, you collected members from several niche chats, sent them messages, and a week later prepared a new database. Some users appeared in both selections.

To remove these users, you need to compare the new audience with the results of previous operations. Telegram Soft Expert has a dedicated “Database Exclusion” module for this. It lets you remove from the main selection users who are present in another database or in a separate username list.

Both tasks can be handled in Telegram Expert. The software combines audience collection, database preparation, mailings, invitations, and statistics. This makes it possible to use the results of previous operations when preparing the next selection.

• Done. The operation completed successfully. For a mailing, the message was sent; for an invitation, the user was added to the chat.

• Ready. The record is ready to be processed and can be picked up by the program.

• Taken. The record has been taken into processing.

• Error statuses. These indicate why a specific action could not be completed. For example, ForbiddenError when sending a private message is related to restrictions on receiving messages.

The Ready status may also appear after manual data changes or after resetting working statuses. Therefore, to restore the history of a previous run, it is better to use the saved results database.

By default, working data is stored in the additives directory.

• send in a folder name refers to mailings;

• invite refers to invitations;

• db_exclude is used for database exclusion results.

To prepare an exclusion after a successful mailing, you need information about users with the Done status.

1. Open the “Report Generator” module.

2. In the statistics database field, select the result of the required mailing or invitation.

3. For a mailing, use the “Filter by Successful Mailings” option. Invitations have a separate filter for successful invites.

4. Generate the report and open the resulting database.

After filtering, only operations with the Done status will remain.

Keep the original databases and work with copies so that the processing history can be restored if necessary.

Step 1. Prepare the Main Database

Open the new database and check what data it contains.

If the audience was collected from several chats, perform the required cleaning first. Also check that the database contains the user identifiers you will need for the next steps.

When preparing a username list, it matters whether the corresponding field is filled in for each user.

Step 2. Add the Database to Exclude

Open the “Database Exclusion” module in the audience tools section.

In the “Main Database” field, select the prepared new selection.

After the operation is completed, the program will create a new database with matching records removed.

Step 3. Use a Username List If You Do Not Have a Separate Database

Telegram Soft Expert also supports exclusion using a list of public usernames.

This is useful if you still have a list of usernames from a previously processed audience but do not have a suitable exclusion database.

To do this:

1. Prepare a text list of the usernames you want to remove.

2. Make sure those usernames are present in the main database.

3. In the “Database Exclusion” module, enable “Use Username List.”

4. Add the prepared list and run the exclusion.

This mode removes the specified usernames from the main database.

When working with lists, keep in mind that a Telegram user can change or remove their username. If the saved public username differs from the current one, verify that the record still corresponds to the same user before excluding it.

Numeric User_ID values and usernames are different types of data. In username-list mode, use public usernames specifically.

Step 4. Save the Result

After the exclusion, open the resulting database.

If the next operation requires a regular text list, use the “Create a TXT File with Usernames” option.

Telegram Expert can generate a TXT file containing the unique usernames of the remaining users.

If you plan to continue working with the database itself, keep it in its original format so that other fields remain available.

Open the result of the previous mailing, find records with the Done status, and check whether they are present in the new database. Users who were included in the exclusion list and matched by the data used for comparison should be absent.

Then check several users from the main database who were not part of the exclusion. They should still be present.

Processed Users Are Still in the Database

First, open the prepared exclusion set and find the specific user in it.

If the user is not there, check the results of the previous operation and the filtering conditions. It is possible that only successful sends were included in the exclusion while the user in question had a different status.

When excluding by username, check the spelling of the public username in both lists.

Users You Wanted to Keep Disappeared from the Database

Check which file was used as the exclusion database.

For example, in a repeat mailing, the message should be sent to people who did not successfully receive it during the previous run. If you load the entire original audience from the previous run into the exclusion, users with errors or unfinished operations that are present in that database will be excluded together with successful sends.

To select only successful results, filter by Done.

The Number of Rows Is Lower Than Expected

When viewing a database in SQLiteStudio, the number of displayed rows depends on the interface settings.

Open the display settings and check the configured limit. For example, a database containing 20,000 records may show only the first 1,000 rows on screen.

Also check the applied filters and open the other pages of the table.

Users with Ready Status Reappeared After Cleaning

Check whether the “Reset Working Statuses in Database” function was used.

It is located in the “Database Cleaning” module and resets mailing and invitation statuses to Ready. After such a reset, the program can process those records again.

To exclude an audience that has already been processed, use the saved results of the previous operation and then build a new selection.

After collecting users, save the original database. When running a mailing or invitation, save the statistics database with the results. Before the next run, select processed users through the “Report Generator” and use the resulting data in the exclusion module.

For convenience, use clear file names with the date and purpose, for example audience_october, send_done_october, and audience_next.

As a result, for the next mailing or invitation you will have a separate database containing the remaining users. You can use it in the appropriate Telegram Expert module while keeping the previous results for future audience updates.