Update names to follow a new format

Naming Convention Updates - Complete Prompting Guide
Overview: Bring Order to the Naming Chaos
Inconsistent naming is like speaking different languages in the same office—it creates confusion, breaks automation, and makes reporting a nightmare. This guide teaches you how to use Colby AI to implement and enforce naming conventions that scale with your business.
What You'll Learn:
Why naming conventions multiply team efficiency
How to design standards that people actually follow
Bulk update strategies that preserve data integrity
Enforcement techniques that prevent regression
The Compound Cost of Naming Chaos
Poor naming conventions create cascading problems:
Search Failures: Can't find what you're looking for
Duplicate Creation: Same thing, different names
Broken Automation: Rules fail on name variations
Reporting Errors: Grouping and filtering break
Integration Issues: Systems can't match records
Understanding Colby's Naming Intelligence
Colby brings order to chaos through:
Pattern Recognition: Identifies naming variations
Smart Standardization: Suggests optimal formats
Bulk Updates: Executes mass corrections safely
Validation Rules: Enforces standards going forward
Exception Handling: Manages edge cases
Impact Analysis: Shows what changes affect
The Master Naming Convention Framework
"Implement naming standards for [object type]:
Current State Analysis:
- Naming patterns in use
- Variation examples
- Volume by pattern
- Creation sources
Standard Definition:
- Format: [Exact structure]
- Components: [Required elements]
- Separators: [Delimiters used]
- Case: [Capitalization rules]
- Length: [Character limits]
Implementation Plan:
- Bulk update strategy
- Exception handling
- Validation rules
- User training
- Enforcement approach
Impact Assessment:
- Records affected
- Automations impacted
- Reports to update
- Integrations to test
- Training needed
Success Metrics:
- Compliance rate
- Error reduction
- Search improvement
- User adoption"
Naming Convention Examples: From Chaos to Consistency
❌ Poor Naming Update Request:
"Fix opportunity names"
Problems:
No standard defined
No scope specified
No plan provided
Likely to create more chaos
✅ Basic Naming Update Request:
"Update opportunity names to include company name and date"
Better Because:
Components specified
Clear direction
Still lacks detail
✅✅ Good Naming Update Request:
"Standardize opportunity names: [Company] - [Product] - [Month Year]. Update all open opportunities."
Much Better:
Exact format provided
Scope defined
Clear structure
✅✅✅ Exceptional Naming Update Request:
"Implement comprehensive opportunity naming convention:
Current Chaos Examples:
- 'Big Deal with ABC'
- 'ABC Corp/Software/2024'
- 'New Business - ABC - Q4'
- 'ABC renewal'
- '2024 ABC Corporation Expansion'
New Standard:
Format: [Account Name] - [Type] - [Product] - [Amount] - [Close Month Year]
Example: ABC Corp - New Business - Enterprise Plan - $50K - Dec 2024
Components:
- Account Name: Legal name from account record
- Type: New/Upsell/Renewal (picklist values)
- Product: Primary product family
- Amount: Rounded to nearest $1K
- Date: MMM YYYY format
Variations Allowed:
- Multi-product: Use 'Multi' + count in parentheses
- Unknown amount: Use 'TBD'
- Confidential: Use code names per security list
Implementation Phases:
Phase 1: Open Opportunities
- Week 1: Opportunities closing this quarter
- Week 2: All open opportunities
- Week 3: Recently closed (90 days)
Phase 2: Historical Data
- Month 2: Last fiscal year
- Month 3: Prior 2 years
- Archive older as-is
Automation Setup:
- Create naming formula
- Auto-populate on create
- Validation rule for manual entries
- Workflow for updates
- API enforcement
Exception Handling:
- M&A deals: Special format
- Government: Contract numbers
- Partners: Include partner name
- Global: Currency indicators
Training & Adoption:
- Quick reference card
- Email templates
- Team training sessions
- Compliance dashboard
- Monthly reviews"
Why This Is Exceptional:
Clear current state examples
Precise new standard
Thoughtful exception handling
Phased implementation
Automation to maintain standards
Mastering Different Naming Scenarios
1. Account Naming Standardization
Purpose: Consistent company identification Focus: Legal names and variations
Master Prompt:
"Standardize account naming conventions:
Current Variations:
- IBM vs International Business Machines
- ABC, Inc. vs ABC Inc vs ABC Incorporated
- McDonald's vs McDonalds
- AT&T vs AT & T vs ATT
Standardization Rules:
Legal Name Format:
- Use registered business name
- Include legal suffix (Inc., LLC, Ltd.)
- Preserve special characters (&, ')
- Proper capitalization
Common Variations:
- Store DBA in separate field
- Track common abbreviations
- Note regional differences
- Flag brand names
Special Cases:
- Government: Full department names
- Non-profits: Include designation
- International: Native + English
- Franchises: Location identifiers
Hierarchy Handling:
- Parent: Legal name only
- Divisions: Parent - Division
- Subsidiaries: Full legal name
- Locations: Name - City, State
Implementation:
- Data source verification
- Bulk update by confidence
- Manual review queue
- Ongoing maintenance
- Match prevention"
2. Campaign Naming Architecture
Purpose: Enable reporting and analysis Focus: Structured metadata
Master Prompt:
"Design campaign naming taxonomy:
Business Requirements:
- Channel identification
- Date/quarter tracking
- Product alignment
- Region/segment
- Performance tracking
Naming Structure:
[YYYY]_[Q#]_[Channel]_[Type]_[Product]_[Segment]_[Region]_[Version]
Components:
- YYYY: Fiscal year
- Q#: Quarter (Q1-Q4)
- Channel: Email/Web/Event/Social
- Type: Demand/Brand/Product/Partner
- Product: Product line code
- Segment: ENT/MM/SMB
- Region: NA/EMEA/APAC/LATAM
- Version: A/B for tests
Examples:
- 2024_Q4_Email_Demand_CRM_ENT_NA_A
- 2024_Q4_Event_Brand_ALL_MM_EMEA_A
- 2025_Q1_Web_Product_API_SMB_APAC_B
Benefits:
- Filterable reporting
- Period comparisons
- Channel performance
- Product attribution
- Regional analysis
Governance:
- Naming tool/generator
- Validation on save
- Quarterly review
- Exception process
- Training required"
3. Product Naming Modernization
Purpose: Support evolving product portfolio Focus: Scalable structure
Master Prompt:
"Modernize product naming for growth:
Current Problems:
- Legacy version numbers
- Inconsistent editions
- Regional variations
- Bundle confusion
- Feature sprawl
New Architecture:
[Product Family]_[Edition]_[Version]_[Deployment]
Structure:
Product Family:
- CRM (Customer Relationship Management)
- ERP (Enterprise Resource Planning)
- API (Integration Platform)
Edition:
- Starter/Professional/Enterprise
- Basic/Plus/Premium
- Core/Advanced/Ultimate
Version:
- Year-based (2024.1, 2024.2)
- Semantic (v3.2.1)
- Named releases (Phoenix, Quantum)
Deployment:
- Cloud/OnPrem/Hybrid
- SaaS/License/Subscription
Migration Map:
Old → New:
- 'CRM Pro v5' → 'CRM_Professional_2024.1_Cloud'
- 'Basic Package' → 'CRM_Starter_2024.1_SaaS'
- 'Enterprise Plus' → 'CRM_Enterprise_2024.1_Hybrid'
Bundle Handling:
- Parent bundle name
- Component list
- Discount structure
- Upgrade paths"
4. Document Naming Standards
Purpose: Enable findability and version control Focus: Metadata-rich naming
Master Prompt:
"Implement document naming standards:
Document Categories:
- Contracts
- Proposals
- Presentations
- Reports
- Communications
Naming Format:
[YYYY-MM-DD]_[Type]_[Account]_[Description]_[Version]
Components:
- Date: ISO format for sorting
- Type: Contract/Proposal/Preso/Report
- Account: Short name or code
- Description: Brief, no spaces
- Version: v1, v2, FINAL, SIGNED
Examples:
- 2024-11-15_Contract_ABCCorp_MSA_SIGNED
- 2024-11-14_Proposal_XYZInc_Security_v3
- 2024-11-13_Preso_Tech_QBR_FINAL
Special Rules:
- No special characters except dash/underscore
- 50 character maximum
- Use camelCase for descriptions
- Archive old versions
- Lock signed documents
Folder Structure:
/[Year]/[Quarter]/[Type]/[Account]/
Benefits:
- Chronological sorting
- Easy searching
- Version tracking
- Audit compliance
- Team consistency"
Advanced Naming Techniques
Technique 1: Smart Abbreviation Management
"Create intelligent abbreviation system:
Standard Abbreviations:
- Corporation → Corp
- International → Intl
- Technology → Tech
- Management → Mgmt
- Development → Dev
Industry-Specific:
- Manufacturing → Mfg
- Healthcare → HC
- Financial Services → FinServ
- Software as a Service → SaaS
Rules:
- Max 4-5 characters
- No periods
- Consistent case
- Document all
- Train users"
Technique 2: Naming Validation Automation
"Build naming enforcement:
Validation Rules:
- Format check on save
- Component verification
- Length limits
- Character restrictions
- Duplicate prevention
User Experience:
- Real-time format preview
- Dropdown selections
- Auto-population
- Error messages
- Suggestions
Monitoring:
- Compliance dashboard
- Exception reports
- Trend analysis
- User feedback
- Continuous improvement"
Technique 3: International Naming Support
"Handle global naming requirements:
Challenges:
- Character sets (Unicode)
- Right-to-left languages
- Cultural sensitivities
- Legal requirements
- Time zones
Solutions:
- UTF-8 encoding
- Parallel names (Local/English)
- Cultural training
- Legal review
- UTC timestamps
Implementation:
- System capabilities
- Display options
- Search functionality
- Reporting needs
- User preferences"
Common Naming Mistakes
Mistake 1: Over-Complex Standards
❌ 20-component naming schemes ✅ "5-7 meaningful components maximum"
Mistake 2: No Migration Plan
❌ Change everything immediately ✅ "Phase by priority, maintain old name reference"
Mistake 3: Ignoring Exceptions
❌ Force everything to fit ✅ "Design for 90%, handle 10% as exceptions"
Mistake 4: No Enforcement
❌ Hope people follow standards ✅ "Automate validation and generation"
Measuring Naming Success
Compliance Metrics:
Standard adherence rate
Error frequency
Time to find records
Duplicate creation rate
User satisfaction
Business Impact:
Search efficiency
Report accuracy
Integration success
Automation reliability
Training time
Pro Tips for Naming Excellence
The Naming Generator Tool
The Grandfather Clause
The Living Standard
The Training Investment
Explore other Prompting Guides
Search...
⌘K