📌 Overview

Once your mappings are created, maintaining them effectively ensures ongoing data accuracy and consistency.

Good mapping hygiene prevents duplicated categories, broken filters, or inconsistent dashboard results — especially as new data sources are added over time.

This article outlines the best practices for organizing, maintaining, and governing mappings across your cofi.ai workspace.

1. Keep One Mapping Table per Dimension

Maintain a single mapping table for each type of dimension (e.g., Region, Department, Product).

Why it matters:

Example:

Instead of creating separate tables like Department_Mapping_Q1 and Department_Mapping_2025, keep one active table — MAP_Department — and update it as needed.

💡 Tip: Prefix mapping tables with “MAP_” to keep them visually distinct from other data sources.

2. Standardize Naming Conventions

Use clear, descriptive, and consistent names for your mapping tables and standardized values.

Type Example Notes
Table Name MAP_Region Identifies it as a mapping source
Column Names Original Value, Mapped Value Keeps structure predictable
Mapped Values “United States” Avoids abbreviations or inconsistent capitalization

Why it matters:

Consistent naming conventions make mappings easier to locate, update, and document — especially in large workspaces.