Article summary
Assign column-level provenance, purpose, access and expiry to Spain +34 WhatsApp Full Format instead of importing the entire workbook into CRM.
The risk in Spain +34 WhatsApp Full Format is not the number of Excel columns; it is treating every column as the same type of data. Phone, activity, profile observation and mapping have different provenance, lifetimes and access roles, requiring column lineage.
Build a column-level dictionary
| Family | Record | Main control |
|---|---|---|
| Phone | Raw value and transform rule | No overwrite |
| Activity | checked_at and window | Short expiry |
| Profile | Observation meaning and unknown | Narrow access |
| Mapping | Relationship and conflict | Human confirmation |
Full Format is not the default task
Use a smaller task for registration alone. Select Full Format only when several field families genuinely support one approved decision.
Separate +34 format from customer market
Preserve phone_raw and country evidence. Foreign customers retain their numbering plans, and +34 does not populate residence or language.
Split columns before import
Route results into field-family staging tables rather than give operations the whole workbook. Label source_task, schema_version and owner per column.
Assess necessity column by column in an EU context
The operating organisation evaluates purpose, transparency, access, retention and rights. Remove a column before import when no purpose exists.
Preserve unknown semantics
Profile blank, task unknown and format exception cannot become one false value. Document valid states in the dictionary.
Mapping does not replace the master phone
One-to-many, many-to-one and time conflicts enter relationship review. Even a confirmed mapping appends an event rather than overwriting the source.
Expire by column
Activity may expire first, mapping conflicts need another history period and temporary avatar images may be deleted earlier. The workbook is not permanently current.
Spain acceptance
Every used column answers where it came from, why it is used, who can see it and when it is deleted. A column that cannot answer stays out of production.
