Article summary
Separate numbering plan, customer provenance and service market when a Cape Verde list mixes +238 and overseas phones.
A list serving customers in Cape Verde does not necessarily contain only +238 phones. People living abroad, cross-border orders and long-retained numbers can make phone country different from service market. Full Format screening must not collapse the two.
Start with three independent dimensions
| Dimension | Evidence | It does not prove |
|---|---|---|
| Numbering plan | Country code and raw format | Current residence |
| Customer provenance | Form, store or event | Nationality |
| Service market | Order or contract | Phone assignment |
Do not prepend +238 to every national-looking string
Create a candidate only when provenance identifies Cape Verde and the format is explainable. Put weak evidence in country_unknown instead of buying a higher processing rate with a guess.
Queue by numbering plan
Normalise +238 and phones from Portugal, the United States or other plans separately, then aggregate at the business layer. Cross-border customers stay visible and clustered format failures become easier to find.
Interpret Full Format by field family
Registration, activity, avatar, business status and account relationship have different observation boundaries. A foreign phone is not an exception and does not deserve an automatic customer label.
Use a provenance matrix to locate quality
Compare usable, unknown and conflict rates across stores, partners, events and legacy CRM sources. Repair the weak collection path rather than blame a country-code group.
A mapped phone does not change the market
Store relationship_type and observed_at when a related number appears. It may use another numbering plan, while service market still follows business evidence.
How the AppShai files connect
The TXT upload contains one phone per line and only execution data. After Excel returns, an internal row key reconnects provenance, order and permission; do not upload the complete customer table.
Prioritise cross-border review
Work first on recent business records with clear permission and strong phone provenance. Repair weak, stale or conflict-heavy batches before screening.
What this Cape Verde page actually solves
It does not teach readers to convert every phone into +238. It keeps format evidence and business-market evidence separate so Full Format output remains explainable.
