Telegram Active Account Export Guide by Activity Window: CSV Fields and Filtering Methods for Different Activity Cycles
关于作者
KK-DATA 获客数据筛号平台官方内容团队。
Telegram Number Export by Active Window Guide: CSV Fields and Filtering Methods for Different Activity Periods
In overseas customer acquisition and community operations, precisely filtering Telegram users is a key step to improving conversion rates and reducing marketing costs. Many teams have lists of phone numbers, but mass sending without targeting not only risks account bans but also wastes resources. For this reason, exporting Telegram numbers by active window has become a common data operation strategy: by detecting whether a number has been online within a specified number of days, users are graded by activity level, and then targeted outreach is executed for different objectives.
This article will guide you step-by-step through the entire process on the KK-DATA platform, from importing numbers and configuring the active window to downloading CSV results. It also provides an in-depth analysis of the fields in the exported CSV, helping you quickly master the skill of active export and providing reliable data support for subsequent private message campaigns, community recruitment, user activation, and other business activities.
Why Export Telegram Numbers by Active Window?
The status of a Telegram number is far more than just “registered” or “unregistered.” A registered number may not have been logged in for months, or it may be active every day. For overseas operation teams, identifying a number’s activity level is crucial.
The Real Role of Active Windows in Customer Acquisition
- Highly active numbers → High reach rate: Numbers active recently have a higher probability that the user opens Telegram, increasing message delivery and reply rates. These numbers are suitable for core conversions, paid promotions, or important notifications.
- Medium/low activity numbers → Cost optimization: Numbers with lower activity are harder to reach but have relatively lower detection costs. They can be used for non-urgent scenarios such as brand exposure, recall notifications, or event warm-ups, avoiding wasted budget on ineffective numbers.
- Inactive numbers → Data cleaning: Numbers that have never been online or have had no activity for months are often invalid leads. Removing them in time prevents futile marketing efforts.
Common Active Windows (7/15/30 Days) and Use Cases
The table below quickly compares the characteristics and typical uses of the three windows:
| Active Window | Detection Scope | Typical Use Case | Notes |
|---|---|---|---|
| 7 days | Online or messaging behavior within the last 7 days | Daily active reach, paid user activation, high conversion campaigns | Shortest window, highest quality numbers, relatively higher detection cost |
| 15 days | Online or messaging behavior within the last 15 days | Medium-frequency outreach, potential customer screening, community replenishment | Balances quality and coverage, suitable for most medium-to-large projects |
| 30 days | Online or messaging behavior within the last 30 days | Loose active screening, brand exposure, recall of dormant users | Broad coverage, lower cost, suitable for low-cost batch testing |
When choosing a window, adjust flexibly based on budget and goals. If you have sufficient budget and aim for high conversion, prioritize the 7-day window. If you want to cover more potential users at low cost, the 30-day window is a safe choice.
Preparation: KK-DATA Account and Top-Up
Before starting the number screening, ensure you complete the following steps:
- Register/Log in: Visit the KK-DATA App Console and create an account.
- Top up with USDT: After logging in, go to Balance Management and top up using USDT (TRC20). The minimum is about 50 USDT. The balance updates automatically after deposit. The platform has no subscription plans; charges are deducted based on the number of detections—pay as you go.
- Check real-time pricing: Before topping up, visit the Billing page or the real-time price page in the console to confirm the specific unit price for Telegram activity detection. Detection costs may vary slightly for different windows.
If your balance is insufficient, you cannot submit new tasks. It is recommended to make a small test top-up first, test with a small batch of numbers, and confirm the effect before adding more funds.
Step 1: Import the List of Numbers to be Detected
KK-DATA supports three sources of numbers. You can choose the most convenient one based on your existing data:
- Upload a file: Supports CSV and TXT formats. Each line should contain one number, must include the country code (e.g., for China:
8613800138000, for the US:12025551234). - Global number generation: If you don’t have an existing list, use the built-in “Global Number Generation” module to randomly generate valid numbers by country, number segment, and quantity. Generation is free; charges only apply when screening.
- Manual input: Suitable for quickly verifying a small number of numbers.
Number Format Tip
It is recommended to use CSV or TXT files, one number per line, including the country code. When saving in Excel, select “UTF-8 CSV” format to avoid encoding issues with Chinese characters that may cause import failure.
Step 2: Configure the Screening Task – Select TG Activity Detection and Set the Window
After importing the numbers, go to the task creation page:
- Select platform: Check “Telegram”.
- Select detection type: Choose the “Activity” option. If you also need “Registration” detection (confirming whether the number is registered on Telegram), you can check it as well; charges will stack accordingly.
- Set the active window: In the drop-down menu or slider, select the window length (usually 7, 15, or 30 days, as displayed in the console). After selecting the window, the system will automatically show the estimated cost.
Detailed Explanation of Active Window Options
- 7 days: Filters numbers that have been online or sent/received messages within the last 7 days. Shorter windows yield higher accuracy because these numbers have recent usage habits.
- 15 days: The detection range expands to 15 days, covering more occasional users, suitable for medium-activity marketing scenarios.
- 30 days: Detects online behavior within the last 30 days, including many low-frequency users. Suitable for projects that need broader coverage and don’t require high recency.
Why Does Window Length Affect Pricing?
The cost difference between windows is mainly due to the complexity of data acquisition. Shorter windows (e.g., 7 days) require real-time queries of recent interaction records, consuming more system resources and thus potentially having a higher unit price. However, the improved user quality from shorter windows often compensates for the cost through higher conversion rates. Before submitting the task, check the estimated cost shown in the console and make a flexible decision based on your budget.
Step 3: Submit the Task and Wait for Notification
After confirming the task parameters are correct, click Submit. The system will process it asynchronously; you don’t need to stay on the page. Key points:
- Bind Telegram notification: In the console’s “Notification Settings,” bind your Telegram account to automatically receive alerts when the task is completed.
- Do not resubmit: If the same batch of numbers has already been detected before, use the Data Deduplication Warehouse to filter out previously detected records first to avoid wasting balance. When submitting a new task, the system will also prompt if there are duplicates that can be skipped.
- Single task limit: You can submit up to approximately 1 million numbers at once. For large tasks, consider submitting in batches.
Step 4: Download the CSV File Exported by Active Window
After the task is completed, click “Download” on the task details page to get a CSV file containing all screening results. By default, the CSV includes only basic fields such as “number” and “registration status.” To obtain more activity-related dimensions, you must check the corresponding export options in advance when creating the task.
CSV Field Reference Table (Core Fields)
The following lists common CSV fields and their meanings when exporting by active window:
| Field Name | Value Type | Description |
|---|---|---|
phone | string | Complete number with country code |
reg_status | boolean | Whether registered on Telegram (true/false) |
active_status | boolean | Whether passed activity detection (true/false) |
active_window | string | The active window used in this detection, e.g., 7days |
last_active_date | datetime | Specific date and time of last activity (if active_status is true) |
tg_id | integer | Telegram ID of the number |
username | string | Telegram username |
gender | string | Gender identified from avatar (male/female/unknown) |
Field Dependency Note
By default, only “number” and “registration status” are included in the export. To get additional fields such as active window, TG ID, gender, etc., you must check the corresponding export options when creating the task. Unchecked fields will not appear in the CSV.
How to Use CSV Fields for Secondary Cleaning?
After downloading the CSV, it is recommended to perform the following operations in Excel, Google Sheets, or a data processing script:
- Filter active numbers: Filter the
active_statuscolumn fortruevalues. These are the numbers you can prioritize for outreach. - Group by window: Use the
active_windowcolumn to distinguish sources, making it easy to evaluate user quality across different windows. - Further classify by gender or TG ID: If you have specific gender or individual tracking needs, use
genderortg_idfor finer grouping. - Reuse in deduplication warehouse: Import the detected numbers into the Data Deduplication Warehouse so future tasks can skip them directly, avoiding repeated charges.
Frequently Asked Questions
Q: Does the 7-day active window export include numbers active today?
A: Yes. The detection window calculates activity records within the past 7 days from the current time. For example, if you detect today, it includes numbers that have been online or performed any interaction within the last 7 days (including today). Therefore, the exported results will include users active today.
Q: What does it mean if the “last active date” field is empty in the exported CSV?
A: If the number did not pass the activity detection (i.e., it is not valid or not registered), the last active date will be empty. This field has a valid timestamp only for numbers where active_status is true. It is recommended to filter using the active_status column first before analyzing date information.
Q: Can the same number be exported multiple times with different windows?
A: Yes. Each screening task is independent. You can first detect the same batch of numbers using a 7-day window, then a 30-day window, to observe the distribution of activity levels. However, it is recommended to use the platform’s built-in Deduplication Warehouse to filter out already-detected numbers in advance to avoid wasting balance. When submitting a new task, the system will automatically prompt whether to skip already-detected numbers.
Q: What fields are supported in CSV export? Can I customize them?
A: Currently, the export supports fields such as number, TG ID, username, registration status, activity status, active window note, last active date, and gender (avatar recognition). When creating a task, you can check the desired fields in the “Export Fields” section. Fully custom field names are not supported yet. It is recommended to check all potentially needed fields at once to avoid running a second task.
Summary and Best Practices
Exporting Telegram numbers by active window is an essential data processing skill for overseas customer acquisition. By choosing the right window, you can quickly grade your number list by activity level and implement differentiated outreach, thereby improving conversion efficiency and reducing marketing costs. Key points to remember:
- Define your goal: High conversion → choose 7-day window; broad screening → 30-day window; balance → 15-day window.
- Start small, then scale: First submit a few hundred test numbers to verify the process and window effect, then import in large batches after confirming.
- Make good use of deduplication: After each detection, store the numbers in the Deduplication Warehouse to avoid repeated consumption of balance.
- Flexible data processing: After downloading the CSV, use Excel or data processing tools to filter by
active_status, then create secondary groups usinggender,tg_id, etc.
Now, you can log in to the KK-DATA App Console to try your first export by active window. For more detailed field descriptions, please refer to the Documentation. If you encounter any issues, contact Telegram support @kkdata_cc for one-on-one guidance.
Related Articles
Telegram Active Number Detection: 7-Day, 15-Day, 30-Day Window Definition and Selection Guide
Learn the definitions of active Telegram numbers based on 7-day, 15-day, and 30-day windows, and how to choose the best screening strategy for your marketing goals. KK-DATA supports multi-window activity detection to help you efficiently filter high-conversion users and reduce ineffective promotion costs.
How to Filter Telegram Recent Active Users by Specified Days? Complete TG Active Filtering Tutorial
Need to bulk find users active in the last 7, 15, or 30 days from Telegram groups or number lists? This article teaches you how to use the TG active filtering feature, set the active window days, accurately locate recent active users, and improve overseas customer acquisition efficiency. Includes operation steps, fee explanation, and common questions.
TG Active Screening ROI Analysis: How to Improve Reach Conversion and Cost Efficiency via Telegram Active Number Filtering
Want to know how active number screening affects ROI in Telegram marketing? This article builds a TG active screening ROI analysis framework, deconstructing ROI from dimensions such as number cost, reach conversion rate, balance loss, and provides actionable screening strategies and pitfall avoidance guides. Suitable for overseas teams, community operations, and data number selection scenarios.