US active WS number source acceptance score sheet: format completeness, duplication rate, activation rate and data freshness
关于作者
KK-DATA 获客数据筛号平台官方内容团队。
US active WS number source acceptance score sheet: format completeness, duplication rate, activation rate and data freshness
In overseas marketing, US active ws number (i.e. US active WhatsApp number) is the core resource for many teams to do private domain reach, community operations or B2C promotion. However, the sources of numbers circulating on the market are uneven: some are in confusing formats, some have an alarmingly high repetition rate, and some have long since expired. If you only rely on “feeling” for acceptance, it will often lead to soaring screening costs and plummeting reach rates. This article provides a standardized acceptance score sheet, starting from the four dimensions of format completeness, repetition rate, activation rate and data freshness, to help you systematically evaluate each batch of US WS active data, so that the acceptance is well-founded and customer acquisition is more efficient.
What is the Source Quality Rating Scale for US Active WS Numbers?
The Source Quality Rating Scale is a set of quantitative evaluation criteria used to measure the overall quality of US Active WS Numbers obtained from different sources. It usually contains several dimensions, with weights and scoring ranges set for each dimension, and finally summarized into a total score (for example, a full score of 100 points). Using the rubric, you can:
- Compare data from different suppliers or different batches based on unified standards to avoid subjective bias.
- Let the team have a clear passing line for internal acceptance to reduce disputes.
- In the subsequent screening process (such as passing the KK-DATA per-item deduction test), estimate the cost and output ratio in advance.
Why is a standardized acceptance score sheet needed?
Relying on “experience” or “eye observation” to accept data is risky:
- Format problem hidden: The number does not have an international area code, there are spaces inserted in the middle, there are not enough digits, etc., it is easy to be recognized as an invalid number by the system when filtering the number, which wastes the detection fee.
- Bottomless pit of repetition rate: The repetition rate in a batch of data exceeds 20%, which means that if you spend 100 yuan on testing, only 80 yuan is effective detection, and the remaining 20 yuan is wasted.
- Misjudgment of activation rate: For a number pool that has not undergone actual testing, the “activation” rate may be only 30%~40%, and the reach after actual launch is extremely low.
- Lack of freshness: For numbers collected a year ago, a large number of users have logged out or changed their numbers. Even if they were activated before, they have now become “dead numbers”.
The standardized scoring form is like a quality inspection SOP, making the data acceptance process replicable and traceable.
Four core dimensions of the rating scale
It is recommended to use the following four key dimensions, each with a full score of 25 points, and a total score of 100 points (the weight can be customized):
| Dimensions | Rating content | Weight suggestions |
|---|---|---|
| Format integrity | Whether the number contains the correct international area code, digits, and no confusing symbols | 20~25 points |
| Repetition rate | Internal repetition rate + repetition rate with historical pool | 20~25 points |
| Actual measured activation rate | Proportion of activation verified by real testing | 30 points (maximum) |
| Data freshness | How long ago was the data collection or last verification | 20~25 minutes |
How to systematically check the format integrity of active WhatsApp numbers in the United States?
The first step in acceptance: check whether the number format complies with international standards. WhatsApp requires that the number must contain an international area code (such as US +1) and have a fixed length (US numbers are 11 digits long, including the area code). Common formatting issues include:
- The number is missing (e.g. 10 or 9 digits).
- Extra spaces, dashes, and brackets.
- Mix in the country code prefix (e.g. 001-234-567-8901).
- Non-numeric characters (such as brackets and spaces in “+1 (555) 123-4567”).
Practical method:
- Batch check in Excel/CSV: Use the
=LEN()function to check the length, and use=ISTEXT()or=ISNUMBER()to check whether it is a pure number (pay attention to the processing of area code + number). It is recommended to unify all numbers into the “+1XXXXXXXXXX” format first, and then check whether the length is equal to 12 (including the + sign) or 13 (including the + sign and 1). - Use a script or online tool: A simple regular expression
^\+1\d{10}$can quickly filter out US standard numbers. - Manual sampling: Randomly select 100~200 items, manually check the format, and record the proportion of non-compliance.
Tip: Format detection tool recommendations
Number formats can be verified in batches using formulas/functions in Excel or CSV. Filter out invalid entries with inconsistent lengths, missing characters, spaces or special symbols. The tool can be reused in different batches, and it is recommended to make it into a template.
Within what range is the repetition rate control of active US ws data considered qualified?
The repetition rate directly affects the screen size cost. On platforms that charge fees by item (such as KK-DATA), the balance will be deducted once each number is detected. If duplicate numbers are detected repeatedly, the budget is wasted.
The impact of repetition rate on screening costs
Suppose you select a batch with an “internal duplication rate” as high as 30% and a total of 10,000 numbers, then there are only 7,000 actual valid numbers. When screening, you still need to pay for 10,000 tests, which is equivalent to paying 30% more cost. What’s more hidden is the “replication rate with the historical pool” - if you have tested similar numbers before, and a large number of tested numbers are mixed into the new batch, you will still be charged for testing again.
Recommended standards:
- Internal Repetition Rate ≤ 5% (ideal ≤ 2%).
- Duplication rate with the history pool ≤ 10% (the larger the history pool, the tolerance of the repetition rate can be relaxed appropriately, but it is best to clean it first through the deduplication warehouse).
How to record and quantify repetition rate
- Internal duplication rate: In Excel or database, use the deduplication function on the “Number” column to count the number of items before and after deduplication.
- Duplication rate with historical pool: If you have a historical number database (such as all previously filtered numbers), merge the new batch with the historical database to remove duplicates. You can use hash comparison, or integrate a deduplication warehouse (for example, KK-DATA provides cross-task deduplication function), and directly view the deduplication warehouse report during acceptance.
How to verify the “activation rate” of active US WS numbers to be considered valid acceptance?
“Open” and “active” are two concepts:
- Activated: Whether the number is registered with WhatsApp (i.e. able to receive messages).
- Active: Whether the number has had online behavior (such as status updates, sending messages, etc.) in the past period of time.
During acceptance, it is recommended to at least verify the activation rate, and it would be better if the activity rate can be verified. Because for customer acquisition scenarios, active numbers have better reach effects.
Practical Steps:
- Sample extraction: Randomly select 200~500 numbers from each batch (the larger the batch, the sample size can be increased appropriately, but at least 200 numbers).
- Use real detection: Submit the sample to the WhatsApp screening module of the screening platform (such as KK-DATA), and select the “activated” or “active” detection type.
- Statistical calculation of activation rate: After the detection is completed, look at the proportion of “activated” or “active” marks. For example, 160 out of 200 are opened, the opening rate = 80%.
Ideal range:
- The activation rate of US WS numbers (that is, the proportion of WhatsApp registered) should usually be above 70%. If it is less than 50%, it is recommended to abandon it no matter how low the price is.
- The activity rate (such as online behavior within 7 days) is recommended to be above 50%, and higher-end scenarios (such as private message promotion) require above 60%.
Note: Label sources and recall records
During acceptance, the supplier is required to mark the time of data collection or last elimination. If there is no explanation, it will be regarded as “no source indicated”, and it is recommended to lower the score. It is recommended that before importing data into the screening platform, you first try to verify a small sample and estimate the time precipitation.
Data freshness: How to determine whether the active US WS number is out of date?
WhatsApp user behavior changes rapidly, and the “valid life cycle” of a number may only be a few months. Numbers that have been inactive for a long time may be recycled by WhatsApp or the user may be logged out. The core indicator of the data freshness dimension is data collection time or last verification time.
Rating Suggestions:
- Level A (full score): collection/verification time within 30 days.
- Level B (80% score): 30~90 days.
- C level (50% points): 90~180 days.
- Grade D (low score or rejection): more than 180 days.
Acceptance method:
- Require suppliers to mark the generation timestamp of each batch of data. If the other party cannot provide it, it will be directly regarded as D level.
- If you have historical detection records, you can take out some numbers from the same source and do a second detection to compare changes in the activation rate. For example, if the test opening rate was 85% six months ago and now drops to 50%, it means that the freshness is insufficient.
Acceptance Checklist for US Active WS Numbers: Five Steps
The following is a checklist that can be printed directly as an SOP and is suitable for each new batch acceptance:
- Format Check: Use regular expressions or Excel formulas to check the format of all numbers. If the proportion of unqualified items is ≤ 5%, it is considered qualified.
- Duplication calculation: Statistics of internal repetition rate (≤5%) and historical pool repetition rate (≤10%). If it exceeds the limit, it must be cleaned before acceptance.
- Spot check on activation rate: randomly select 200~500 items, and detect the true activation (or + active) ratio through the screening platform. Qualifying line: opening rate ≥70%, activity rate ≥50%.
- Freshness Marking: Confirm the collection/verification time marked by the supplier. If it exceeds 90 days, it will be downgraded or a new batch will be requested.
- Comprehensive scoring: Weighted by four dimensions (format 20%, duplication rate 20%, opening rate 35%, freshness 25%), output a total score. If the total score is less than 60 points, it is recommended to reject it; if the score is between 60 and 80 points, a reissue or discount must be negotiated; if the score is above 80 points, it is acceptable.
Generation + Screening: How to quickly use it to acquire overseas customers after passing the acceptance test?
After accepting qualified data, the next step is to invest in actual customer acquisition. If you rely on manual processing, the cycle is long and error-prone. Recommended standard process:
Standard process: number storage → multi-platform screening number → export and delivery
- Number storage: Import the CSV/TXT file that has passed the acceptance into the screening platform (such as the console of KK-DATA). Supports global number generation and custom number upload.
- Multi-platform screening: Select the target country (United States) and select the WhatsApp screening task type (activation, active, gender, etc.). KK-DATA provides billing by item, and the balance will be automatically deducted after the task is completed.
- Export delivery: Screening results can be exported to CSV/TXT, including fields such as activation/active status, gender, TGID/WSID, etc. Import these target numbers into CRM or outbound calling tools for private message promotion.
Through this process, it usually only takes a few minutes to configure from completion of acceptance to official launch.
FAQ
Q: What scoring dimensions are included in the source quality rating table for active US WS numbers?
Answer: It is recommended to comprehensively score from four dimensions: format completeness, internal repetition rate and historical repetition rate, actual measurement activation rate, and data freshness (collection or verification time). The weight can be set for each dimension, and the final total score is output. The full score is 100 points, 60 points is the passing line, and 80 points or more is a high-quality batch.
Question: During the acceptance process, which indicator has the greatest impact on the final customer acquisition success rate?
Answer: Generally speaking, the actually measured opening rate has the most direct impact. No matter how complete the format and deduplication are, the number itself has expired (not activated or has been inactive for a long time) and cannot reach users. It is recommended to conduct a real test on at least 200 to 500 items from each batch, and use the screening platform to verify the opening rate and activity rate.
Question: How long does the data freshness last to be considered qualified?
Answer: It is recommended that “data collection/last verification time is within 30 days” as level A, within 90 days as level B, and if it is more than 6 months old, it is recommended to actively downgrade or reject it. The active status of numbers on platforms such as WhatsApp and Telegram changes rapidly, and the more freshly acquired the user is, the higher the probability of being active.
Question: What should I do if it is found that the duplication rate of a batch of active US WS numbers is as high as 20%?
Answer: First ask the supplier to reissue or replace it. If you have already purchased, it is recommended to remove duplicates before screening. Numbers can be imported into a deduplication warehouse (such as KK-DATA’s deduplication function) to eliminate internal duplications and overlaps with the historical pool. For batches with a repetition rate higher than 15%, the actual customer acquisition cost will increase significantly. It is recommended to lower the score or reject the batch.
Question: The opening rate of the acceptance and random inspection reached 90%, but the actual delivery effect is very poor. What may be the reason?
Answer: Possible reasons include: ① The sampling sample is too small or the sampling is not random, resulting in statistical deviation; ② The detection is only activated and the active status is not synchronized (a large number of numbers may be marked as registered but inactive for a long time); ③ The target population and the product are not well matched. It is recommended to increase the active detection dimension and conduct short-term delivery testing on a sample basis.
Call to action
👉 Log in to the console https://app.kkdata.cc/ to start screening numbers Two-way contact customer service https://t.me/kkdata_robot For more documentation, please visit https://docs.kkdata.cc/
Whether it is your first time to accept US Active WS Number, or you want to optimize the existing process, the scoring table and five-step acceptance checklist provided in this article can help you significantly improve data quality. From format to deduplication, from activation rate to freshness, every step has quantitative standards. With the KK-DATA platform’s global number generation, cross-platform number screening, and deduplication warehouse, you can quickly convert qualified numbers into reachable overseas users, reduce customer acquisition costs, and increase ROI.
Related Articles
US Active WS Number Delivery Acceptance Checklist: 5 Key Criteria Ensure Data Availability
How to accept the active US WhatsApp number data after receiving it? This article provides a complete acceptance list of active WS numbers in the United States, covering the number of files, field integrity, repetition rate, timestamps and detection types, to help overseas teams avoid budget waste and ensure that the data is truly usable.
US Data Source Acceptance Rating: The Ultimate Guide to Format Completeness, Duplication Rate, Opening Rate and Data Freshness
Acquisition of customers overseas is inseparable from high-quality U.S. data, but how to check and accept it once it is obtained? This article provides a practical scoring table - from format completeness, repetition rate, activation rate to data freshness, the item-by-item scoring will help you screen out high-value U.S. number data and avoid wasting detection costs. Suitable for customer acquisition scenarios on Telegram/WhatsApp/Line and other platforms, with answers to frequently asked questions and recommendations for practical tools.
US WhatsApp number source acceptance score sheet: format completeness, duplication rate, activation rate and data freshness
Obtaining high-quality US WhatsApp numbers is crucial in overseas marketing, but the data quality varies. This article provides a set of source acceptance scoring tables to systematically evaluate data quality from four dimensions: number format completeness, repetition rate, activation rate, and data freshness. It can help you avoid pitfalls in advance, reduce costs, and improve customer acquisition efficiency. It also includes practical detection steps and tool recommendations.