Acquia CDP

Using Custom Attributes

This page provides information about how to use custom attributes for the following scenario: 

 

Data engineers and IT professionals want to streamline the integration of source systems by adding new columns to the data models. Following the integration of the ERP system with a loyalty program, they must be able to include specific fields from the new columns into the existing CDP integration.

Checklist for using custom attributes

Complete the following tasks to use custom attributes for the given scenario:

S.No.TaskAdditional information
1Choose a mapping integration method

The chosen method must align with your requirements for existing and new upstream source systems:

  • Use the Tracker API (DW Tracker) for backend or server-side requests.
  • Implement preconfigured SFTP.
2Define and configure custom attributesUse the CDP Studio Apps UI to complete this task.
3Surface custom attributesSurfacing custom attributes.
4Verify the newly surfaced custom attributesVerifying the newly surfaced custom attributes.

Surfacing custom attributes

  1. Sign in to your CDP user interface.

  2. Click CDP Studio.

    The CDP Studio landing page only displays the features that you can access.

  3. Click Launch Custom Attributes.

    The application displays the Surface Custom Attributes page.

  4. In the Please select the table for which custom attributes need to be surfaced dropdown, select customer.
  5. In the Please select the custom attribute that you want to surface dropdown, select c_cutomerstringgattribute01.
  6. For the Please enter the display name for the custom attribute and Please enter a description for the custom attribute fields, do one of the following:

    • If system auto-populates the display name and description for the custom attribute, click Surface.

      For example, the system auto-populates the display name as Loyalty Enrollment Source.

    • If system does not auto-populate the display name and description for the custom attribute:

      1. In the Please enter the display name for the custom attribute field, enter a display name ensuring that first letter of each word is capitalized.

        Enter only alphanumeric characters, numbers, spaces, and hyphens for display names or descriptions. 41 symbols are classified into the following categories:

        • Numbers: 0-9 are allowed.

        • Punctuations: ., ,, ;, :, ?, !, ' ,", -, _, /, |, {}, () ,[], <> are allowed and \ is not allowed.

        • Arithmetic and Mathematical Symbols: +, -, *, /, =, % are allowed.

        • Miscellaneous Symbols: @, #, $, ^, &, *, ~, | are allowed.

      2. In the Please enter a description for the custom attribute field, enter a description.

      3. Click Surface.

        The system displays the following notifications on completion of surfacing.

  7. Repeat the same steps to surface more custom attributes.

Verifying the newly surfaced custom attributes

  1. Sign in to your CDP user interface.
  2. Navigate to Actions > Campaigns.
  3. Click New Campaign.
  4. On the Setup page, provide a name and description (optional) for your campaign.
  5. Click Next.

  6. In Include customers who, click the Add Group icon.

    The system displays the Add Rule page.

  7. Click Customer Attributes.

  8. Verify the newly surfaced custom attribute Loyalty Enrollment Source business filter.