tg US data source acceptance score sheet: format completeness, repetition rate, activation rate and data freshness, teach you step by step how to judge the quality of TG US number data

When it comes to gaining customers overseas, Telegram’s US market is an unavoidable battlefield. Whether you are doing cross-border e-commerce, B2B inquiry, or community fission, the quality of tg US data directly determines your cost efficiency and final conversion. Many teams spent thousands or even tens of thousands of dollars to buy large packages of “high-quality US TG data”. As a result, once they were screened, the activation rate was appalling and the duplication rate was ridiculously high. Not only wasting the recharge balance, but also wasting the precious time of business colleagues.

The essence of tg US data is a collection of numbers with the US area code (+1) that have been registered on the Telegram platform. However, data from different sources vary greatly in format specifications, duplication ratios, real activation rates, and recent activity. If you don’t do acceptance checks, you’re throwing your marketing budget into the water.

This article provides an implementable tg US data source acceptance score sheet, from the four dimensions of format completeness, repetition rate, activation rate and data freshness, and teaches you step by step how to independently verify the quality of the channel’s Telegram US data. At the end of the article, there is also a checklist and scoring form that can be directly applied. It is recommended to save it for future use.

---

What is tg US data? Why do we need to check the source quality when acquiring customers overseas?

Simply put, tg US data is a list of numbers under the US area code (+1) that have opened Telegram. This type of data is often used for:

• Customer access for B2B overseas companies (the United States is the core market)
• Drainage traffic and repurchase awakening of cross-border e-commerce independent stations
• Accurate fan addition through TG community operation
• Introduction of target groups for private domain promotion activities

If you do not accept the quality of the source, you may face three major losses:

1. Duplicate deductions: 30% of a batch of data are duplicate numbers. You can only buy 700 valid data for 1,000 items.
2. Low activation rate: A lot of time was spent making outbound calls or private messages. As a result, 40% of the numbers were not registered with Telegram at all, all in vain.
3. Obsolete data: Although the number has been activated, the user has not been online for 180 days, no one has read the private messages sent, and the conversion rate is close to zero.

Therefore, learning to accept tgUS data quality is a basic skill for you to build a team of overseas customers. Enter the acceptance process directly below.

---

The first step in accepting tg US data: format integrity and number specifications

The first step in the acceptance of all numbers is to check whether the file meets the telecommunications standard format. For the US number segment, the international standard is E.164 format, which is expressed as: +1xxxxxxxxxx (a total of 12 characters, the 10 digits after +1 are the area code).

How to quickly verify formats in batches?

If you get a CSV or TXT file, it is recommended to do a three-step quick format cleaning:

1. Check the number of digits in Excel: Create a new LEN(A2) formula column and filter out the cells whose length is not equal to 12. If the US number is missing the country code “+1” or has extra spaces or brackets, the length will be abnormal.
2. Batch matching with regular expressions: Search for ^\+\d{11}$ in a text editor (such as VS Code, Notepad++). Lines that do not match are malformed lines.
3. Cleaning with the platform’s built-in module: You can directly log in to the KK-DATA Console, import the file into the “Global Number Generation” module, and select “Filter format abnormal numbers”, and the system will automatically remove non-compliant lines. This step is free and does not consume your balance.

Common symptoms of unqualified format and their impact

Error types	Typical examples	Impact on subsequent screen numbers
Missing country code	1xxxyyyy, xxxyyyy	The filter number system cannot identify the country, filter directly, and the data is unavailable
Contains spaces or brackets	+1 (xxx) yyy-zzzz	The format is not standard, most detection tools need to be cleaned first, otherwise an error will be reported
The number is too short/too long	+1xxx, +1xxxxxyyyyyy	It is an invalid number, and no results can be selected by filtering the number
Contains non-numeric characters	+1-xxx-yyy-zzzz	High cleaning cost and easy to cause import failure

If the format error rate of a batch of tg US data exceeds 30%, it is recommended to directly request the channel party for replacement or refund. Because this batch of data is most likely generated in batches from randomly spliced ​​number segments, and is not a real user number at all.

---

The second level: Repetition rate detection - how much “moisture” is there in your tg US data?

After the format check passes, the next step is to remove duplicates. Duplicate data is a subtle but direct drain on your budget.

How to use tools to quickly count repetition rates?

You can directly use Excel’s “Conditional Formatting → Highlight Duplicate Values” function, or import the data into KK-DATA’s Data Deduplication Warehouse. The deduplication warehouse will automatically identify whether all numbers are duplicated and provide a comparison of the total number before and after deduplication.

The formula for calculating the deduplication rate:

去重率 = 去重后的号码数 ÷ 原始号码数 × 100%

For example: after purchasing 100,000 items, there are only 78,000 items after deduplication, so the deduplication rate is 78% and the duplication rate is 22%.

Data sources with a deduplication rate below 80% (that is, a duplication rate greater than 20%) are recommended to be directly marked as “unqualified”. Each screen number balance you recharge is real money and should not be spent on duplicate numbers.

---

The third level: activation rate - which numbers are actually registered on Telegram?

After passing the format and deduplication inspection, you enter the most core link: Opening Rate Test. This step directly tells you how many of these numbers have actually registered accounts on Telegram. The detection method is to use the platform’s tg activation detection (also called registration detection).

What is the opening rate considered qualified? What situations warrant vigilance?

According to industry best practices, it is recommended to use the following thresholds as judgment criteria:

• ≥ 85%: High-quality data source. The representative source is the real user registration list, which can be safely expanded on a large scale.
• 70% - 85%: Acceptable level. It should be noted that some number segments may be mixed into the generated data. It is recommended to test on a small scale before increasing the volume.
• < 70%: unqualified data source. It means that more than half of the numbers are empty or unregistered, and they are likely to come from old number ranges or purely random generators.

How to estimate the overall launch rate using only a small number of samples?

You don’t need to submit all the data at once, that would be too expensive. It is recommended to use the method of stratified random sampling + batch submission:

1. Stratified Sampling: Divide the file into 10 - 20 equal parts according to line numbers, and randomly select 50 entries from each part, for a total of 500 - 1000 entries.
2. Submit in batches: Create a new “tg activation detection” task in KK-DATA Console, and submit 100 - 500 items each time. Each test is billed on a per-item basis. Please see the real-time price on the console for details. The cost of sampling is extremely low, but the information gained is enough to help you decide whether to buy the entire batch of data.
3. Calculate activation rate: After the task is completed, export the results. The number whose activation field is “True” is divided by the total number of samples to get the activation rate.

---

The fourth level: data freshness and activity - is this just a “live” TG account?

A qualified activation rate only means that the user has registered before, but it is not sure whether he is still using it recently. If an account is not logged in for more than 90 days, the marketing information you send out will basically be lost.

How to evaluate activity?

On the basis of the enabled test, submit another tg active test for the sample that has been enabled. You can specify an active window: select “Last 7 days,” “Last 30 days,” or “Last 90 days online.” According to your customer acquisition scenario:

• Short-term promotion or social recruitment → It is recommended to filter accounts that have been active in the past 7 days**.
• Regular B2B reach or information push → Accept accounts that have been active in the last 30 days**.

If the activity rate in the same batch of samples in the past 30 days is less than 50%, it means that this batch of data is not fresh enough. Even if the activation rate reaches 90%, the actual number of active users is greatly reduced.

---

How to independently verify the quality of Telegram US data from source channels? An actionable checklist

The following is summarized into a tg US data source acceptance scoring checklist that can be directly used. It is recommended to copy it to your project management tool or document, and check each item one by one each time you accept a new source.

tgUS Data Source Acceptance Scoring Checklist

• Step 1: Format Acceptance Randomly select 1,000 numbers and use Excel or regular expression to check whether the formats are all E.164 standards (+1xxxxxxxxxx). Record format error ratio.
  Threshold: Error rate ≥ 5% → downgrade; error rate ≥ 30% → direct elimination.

• Step 2: Deduplication rate statistics Import the entire batch of data or large samples into the deduplication tool, and calculate the effective number of items after deduplication (actual number of measurable items/number of purchased items).
  Threshold: Duplication rate > 20% → data source downgrade; duplication rate > 30% → direct elimination.

• Step 3: Opening Rate Sampling Randomly select 500 items from the deduplicated data and submit them to “tg activation test”.
  Threshold: Opening rate ≥ 85% → high quality; 70%~85% → acceptable; < 70% → direct elimination.

• Step 4: Activity Assessment Randomly select 200 items from the activation sample and submit “active detection in the past 30 days”.
  Threshold: Activity rate ≥ 50% → the freshness is qualified; < 50% → the freshness is not enough, and it is recommended to change the source.

---

tg US data source acceptance score sheet: How to score the data if you understand it with one picture

Summarize the above inspection items into a scoring table with a total score of 100 points:

Rating items	Points	Excellent (full score)	Good (80%)	Unsatisfactory (0 points)
Format Completeness	20 points	Error rate < 2%	Error rate 2%~5%	Error rate ≥ 5%
Duplication rate	20 points	Repetition rate < 10%	Repetition rate 10%~20%	Repetition rate ≥ 20%
Opening rate	35 points	≥ 85%	70%~85%	< 70%
Activity rate in the past 30 days	25 points	≥ 70%	50%~70%	< 50%

Total Score Judgment:

• 90 points or above: high-quality data source, which can directly amplify the purchase volume.
• 70 - 89 points: Qualified data source, it is recommended to test in small batches before increasing the volume.
• Score below 70: Unqualified data sources, it is recommended to give up and find new channels.

---

How to use the accepted tg US data for efficient customer acquisition?

After passing the above four steps of acceptance, you have obtained a batch of tg US data with standard format, no duplication, over 85% activation rate and good activity rate in the past 30 days. The next standard actions are:

1. Cross-platform screening: Submit the cleaned tg user data in KK-DATA for WhatsApp detection, Line detection or iOS/iMessage detection to see what other platforms these users have opened. The value of cross-platform users is much higher than that of single-platform users.
2. Import private domain operation process: Export the filtered high-quality numbers, group them by active windows (such as active in the past 7 days), and push them to communities or private messages for targeted contact.
3. Continuous monitoring of data freshness: Retest the activity of existing data every 1-3 months, eliminate accounts that have been inactive for a long time, and maintain the freshness of the customer pool.

Remember, tgUS data is not a raw material that can be used directly after buying it, but an intermediate product that needs to be cleaned, verified, and re-screened to be valuable. By mastering this set of acceptance score sheets, you will not only save budget, but also greatly improve your team’s customer acquisition efficiency.

---

FAQ

Question: How to judge whether the source of tg US data is reliable?

Answer: The most direct way is to do the source acceptance yourself. When you are unable to identify whether the original data sent to you by the merchant is authentic, use the four-step acceptance process in this article: first randomly select 1,000 items to check the format, then import them into the deduplication warehouse to calculate the repetition rate, then submit 500 items for activation testing, and finally measure the activity. If the activation rate is lower than 70% or the duplication rate is higher than 20%, it can be basically judged that the quality of the data source is poor, and it is recommended to stop purchasing immediately.

Question: What is the difference between “activity” and “opening rate” in tg US data?

Answer: The activation rate refers to whether the number has registered a Telegram account (a number can only register one tg account). Activity refers to whether the account has been logged in or used recently (such as whether there has been online behavior in the past 7 days, 30 days, or 90 days). The activation rate is high but the activity is low, indicating that this batch of data is likely to be old registration numbers, and users have long abandoned or switched platforms. For marketing activities, the value of activity data is much higher than the simple activation status.

Question: After deduplication of TG US data, why is the actual number of available items so different from the purchased number?

Answer: If the data source is confusing (multiple channels are spliced, the number segment generator exports multiple times, and contains duplicate files that are not thoroughly cleaned), the duplication rate can easily reach 30% or even higher. The number of purchases is often a “virtual” number. Healthy US tg data The deduplication rate should be no less than 80%, that is, the duplication rate should not exceed 20%. If this line is exceeded, it is recommended to change suppliers.

Question: Can a small sample be used to estimate the activation rate of the entire batch of tg US number data?

Answer: Yes, and this is also the lowest-cost acceptance method. It is recommended to use stratified sampling: divide the document into 10 - 20 equal parts, and randomly select 50 items from each part, for a total sample of 500 - 1000 items. Submit the tg activation test in the KK-DATA console. Each test will be deducted based on the actual number of tests, and the balance will be charged per test. For details, see the console’s real-time price. The quality of the entire batch of data can be judged for just a few dozen items, which is much more cost-effective than uploading all the data before discovering the problem.

Question: How can I use the tg US data that has passed the acceptance test?

Answer: After passing the acceptance test, you will get a group of high-quality active tg users. You can further perform cross-platform screening, such as submitting these numbers to WhatsApp detection, Line detection or iOS/iMessage detection to determine which users have opened accounts on other platforms. Cross-platform users are very high-value customer acquisition targets because they are active in different channels and are more likely to receive conversions.

---

If you want to immediately start verifying the quality of the Telegram US data at hand, you can directly log in to the console for sampling testing:

👉Log in to the console to start screening numbers

If you have any questions about the detection process or platform functions, you can contact customer service in both directions and get help directly through Telegram:

Two-way contact customer service https://t.me/kkdata_robot

For more detailed platform usage guidelines, please refer to the official documentation: https://docs.kkdata.cc/