--- title: "Custom Attributes" date: "2024-02-20T10:59:30+00:00" summary: "Enhance data flexibility with custom attributes for seamless integration, improved mapping, and dynamic data management across modules." image: type: "page" url: "/customer-data-platform/custom-attributes" id: "aaf724d7-319c-4552-9526-66887f5951d6" --- The Custom Attributes feature improves data model flexibility and adaptability, simplifying the creation and display of new custom attributes within the application. Customers can integrate new mapping fields using APIs or pre-mapped SFTP connectors, enhancing dynamic data management. ============================================================================================================================================================================================================================================================================================= Features -------- * **Data model extension**: Access up to 330 custom fields that are compatible with data types such as strings, decimals, integers, and dates. These fields integrate with default base and aggregated summary entities and are preset as blank for immediate use. * **Self-service UI**: Modify the display name and description of custom attributes in the **Customer**, **Transition**, **TransactionItem**, **Events**, **Product**, **ProductCategory**, **Organization**, **Message**, **Campaign**, **and Dispatch** tables. * **Surface across module**: View custom attributes in the **Campaign+**, **Metrics**, **Interactive Query**, **Data Export** (**Cloud Export** and **Interactive Query Export**) modules. CDP surfaces the custom attributes across these modules for uniform data representation and across-the-platform usage. * **Integration (API)**: Map new source systems or enhance existing ones with custom attributes for quick adaptation to changing data requirements. Perform mapping exercises with a restricted list of entities and custom fields that are essential for both API and SFTP integrations. * **Auto-population:** Load any existing text into the **Display Name** and **Description** fields. Capabilities ------------ Data engineers and IT professionals can: * Add new fields to the CDP data model to upgrade source systems. This initiative adds fresh data to strategies and enhances reporting and campaign targeting. * Strive for flexibility in choosing the best integration method for business goals, using either API or SFTP to match operational requirements. * Evaluate new sources and metrics to achieve business goals. They design and deploy custom integration pipelines by selecting API or SFTP as required. This method guarantees consistent data flow to the CDP and provides deeper analytical insights. Specifications for surfacing custom attributes ---------------------------------------------- Attribute Specifications **Customer(60 attributes)** * c\_customerstringattribute01 until c\_customerstringattribute30 * c\_customerintegerattribute01 until c\_customerintegerattribute10 * c\_customerdecimalattribute01 until c\_customerdecimalattribute10 * c\_customerdateattribute01 until c\_customerdateattribute10 **Transaction(30 attributes)** * c\_transactionstringattribute01 until c\_transactionstringattribute15 * c\_transactionintegerattribute01 until c\_transactionintegerattribute05 * c\_transactiondecimalattribute01 until c\_transactiondecimalattribute05 * c\_transactiondateattribute01 until c\_transactiondateattribute05 **TransactionItem(30 attributes)** * c\_transactionitemstringattribute01 until c\_transactionitemstringattribute15 * c\_transactionitemintegerattribute01 until c\_transactionitemintegerattribute05 * c\_transactionitemdecimalattribute01 until c\_transactionitemdecimalattribute05 * c\_transactionitemdateattribute01 until c\_transactionitemdateattribute05 **Event(30 attributes)** * c\_eventstringattribute01 until c\_eventstringattribute15 * c\_eventintegerattribute01 until c\_eventintegerattribute05 * c\_eventdecimalattribute01 until c\_eventdecimalattribute05 * c\_eventdateattribute01 until c\_eventdateattribute05 **Product(30 attributes)** * c\_productstringattribute01 until c\_productstringattribute15 * c\_productintegerattribute01 until c\_productintegerattribute05 * c\_productdecimalattribute01 until c\_productdecimalattribute05 * c\_productdateattribute01 until c\_producttdateattribute05 **ProductCategory(30 attributes)** * c\_productcategorystringattribute01 until c\_productcategorystringattribute15 * c\_productcategoryintegerattribute01 until c\_productcategoryintegerattribute05 * c\_productcategorydecimalattribute01 until c\_productcategorydecimalattribute05 * c\_productcategorydateattribute01 until c\_productcategorydateattribute05 **Message(30 attributes)** * c\_messagestringattribute01 until c\_messagestringattribute15 * c\_messageintegerattribute01 until c\_messageintegerattribute05 * c\_messagedecimalattribute01 until c\_messagedecimalattribute05 * c\_messagedateattribute01 until c\_messagedateattribute05 **Dispatch(30 attributes)** * c\_dispatchstringattribute01 until c\_dispatchstringattribute15 * c\_dispatchintegerattribute01 until c\_dispatchintegerattribute05 * c\_dispatchdecimalattribute01 until c\_dispatchdecimalattribute05 * c\_dispatchdateattribute01 until c\_dispatchdateattribute05 **Campaign(30 attributes)** * c\_campaignstringattribute01 until c\_campaignstringattribute15 * c\_campaignintegerattribute01 until c\_campaignintegerattribute05 * c\_campaigndecimalattribute01 until c\_campaigndecimalattribute05 * c\_campaigndateattribute01 until c\_campaigndateattribute05 **Organization(30 attributes)** * c\_organizationstringattribute01 until c\_organizationstringattribute15 * c\_organizationintegerattribute01 until c\_organizationintegerattribute05 * c\_organizationdecimalattribute01 until c\_organizationdecimalattribute05 * c\_organizationdateattribute01 until c\_organizationdateattribute05 Application availability ------------------------ The following entities support data types such as string, date, integer, and decimal to ensure versatile data capture and presentation: Integration Mapping  (API or SFTP) Application Availability \*Data Models Entity Name Data Types Actions Metrics \*\*360 Profiles Interactive Query \*\*\*Data Export **Base Entity** Customer _N/A_ _N/A_ _N/A_ _N/A_ _N/A_ _N/A_ **Summary Entities** Customer Summary String 1Campaign, 2Content, 3Lookup 4Dimension Limitations with certain attribute expectations 6All attributes All attributes Date Campaign, Content Dimension Decimal/Integer Campaign, Content 5Measure **Base Entity** Transaction _N/A_ _N/A_ _N/A_ Transaction _N/A_ _N/A_ **Base Entity** Transaction Item _N/A_ _N/A_ _N/A_ Transaction Item N/A N/A **Summary Entities** Transaction Summary String Campaign, Content, Lookup Dimension Limitations with certain attribute expectations All attributes All attributes Date Campaign, Content Dimension Decimal/Integer Campaign, Content Measure **Base Entity** Product _N/A_ _N/A_ _N/A_ Journey N/A N/A **Summary Entities** Product Summary String Campaign, Content, Lookup Dimension Journey (Product Browsed) All attributes All attributes Date Campaign, Content Dimension Decimal/Integer Campaign, Content Not considered **Summary Entities** Product Category Summary String Campaign, Content, Lookup Not considered Not considered All attributes All attributes Date Campaign, Content Not considered Not considered Decimal/Integer Campaign, Content Not considered Not considered **Base Entity** Event String Campaign, Content, Lookup Dimension Journey All attributes All attributes Date Campaign, Content Dimension Decimal/Integer Campaign, Content Not considered **Base Entity** Message String Campaign, Content, Lookup Dimension Limitations with certain attribute expectations All attributes All attributes Date Campaign, Content Dimension Decimal/Integer Campaign, Content Not considered **Base Entity** Dispatch String Campaign, Content, Lookup Dimension Limitations with certain attribute expectations Not considered Not considered Date Campaign, Content Dimension Decimal/Integer Campaign, Content Not considered **Base Entity** Campaign String Campaign, Content, Lookup Dimension Limitations with certain attribute expectations All attributes All attributes Date Campaign, Content Dimension Decimal/Integer Campaign, Content Not considered **Base Entity** Organization _N/A_ _N/A_ _N/A_ _N/A_ _N/A_ _N/A_ **Summary Entities** Organization Summary String Campaign, Content, Lookup Dimension Limitations with certain attribute expectations All attributes All attributes Date Campaign, Content Dimension Decimal/Integer Campaign, Content Not considered **\***Some CDP data models establish relationships between a Base Entity and Summary Entities, which means they share the same dataset as aggregated summary entities. Typically, Summary Entities permit modifications to display names, which enables preferred attribute naming across all applications. **\*\***Limited Availability of Application. **\*\*\***Exclude the Snowflake Data Share application. **1Campaign** - A targeted marketing initiative that uses personalized communication to engage customers. **2Content** - An export attribute that populates on downstream channels. **3Lookup** - A dynamic function that displays field values. **4Dimension** - A type of descriptive data used for filtering, which typically includes static values such as text, dates, or unaggregated numbers. **5Measure** - A form of data that is calculated or aggregated for filtering, typically involving operations like sums, averages, or counts on numeric values. **6All attributes** - A representation of table availability that includes all field types. Important considerations ------------------------ * **Hardcode name:** The system assigns a non-editable hardcoded name to each custom attribute. When you use Interactive Queries or Snowflake data share, the column containing your new custom attributes adheres to the standard hardcoded naming convention. * **Feature availability:** This feature is supported only in Production (PROD) and User Acceptance Testing (UAT) environments. Clients who do not have a UAT environment must conduct testing in their production environment (PROD). For detailed information about integration methods, see [Custom Attributes API integration](/customer-data-platform/custom-attributes-api-integration "Custom Attributes API integration") or [Custom Attributes SFTP integration](/customer-data-platform/custom-attributes-sftp-integration "Custom Attributes SFTP integration "). * **Self-service UI limitation:** * CDP allows you to select multiple attributes of various types and edit or update them all in data models. * CDP does not support adding new fields to data models. * CDP allows you to only include alphanumeric characters, spaces, and hyphens when you enter the display name or description.  The following is a breakdown of the default category, which includes 41 symbols: * Numbers: 0-9. Passed. * Punctuations: ., ,, ;, :, ?, !, ' ,", -, \_, /, |, {}, () ,\[\], <>. Passed. \\. Failed. * Arithmetic and mathematical symbols: +, -, \*, /, =, %. Passed. * Miscellaneous symbols: @, #, $, ^, &, \*, ~, |. Passed. * The first letter of each word in the Display Name must be capitalized. * For example, Favorite Drinks. Passed. * For example, Favorite drinks. Failed. * **Metrics limitation:** * Custom attributes aggregate measure features in the next release for the following entities: * Customer Summary: data type - decimal or integer _Aggregate=AVG_ * Transaction Summary: data type - decimal or integer for transaction item _Aggregate=SUM_ * Product Summary: data type - decimal, or integer (not supported) * Product category: all data types (not supported) * **360 Profiles:** Not supported.