Loading...

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 attributes in Campaigns+Verifying the newly surfaced custom attributes in Campaigns+
5Verify the newly surfaced custom attributes in MetricsVerifying the newly surfaced custom attributes in Metrics
6Verify the newly surfaced custom attributes in IQVerifying the newly surfaced custom attributes in IQ
7Verify the newly surfaced custom attributes in Cloud Data ExportVerifying Cloud Data Export

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_customerstringattribute01.
  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 in Campaign+

  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.

    The system displays Loyalty Enrollment Source filter along with other Loyalty filters.

    The Custom Attribute Event serves as a refine filter for the StoreVisit event type, and provides a detailed filter within the event data.

  9. Search the Performed an event filter.

  10. Select StoreVisit.

  11. Click Add Refinements to existing Rule.

  12. Search the Loyalty filter.

  13. Locate and apply the Loyalty Program Status filter from the search results.

Verifying the newly surfaced custom attributes in Metrics

  1. Sign in to your CDP user interface.
  2. Navigate to Analytics > Metrics.
  3. Click New.
  4. Select New Look.
  5. Search for the Loyalty dimension and measure.
    The system displays Loyalty Enrolment Source dimension along with other Loyalty filters.

  6. To finalize the Look:
    1. Filter Loyalty Enrollment Source to In-Store Promo.
    2. Add dimensions and measures to your Look by using drag and drop or by clicking.

Verifying the newly surfaced custom attributes in Interactive Queries

  1. Sign in to your CDP user interface.

  2. Click Interactive Queries.

  3. Click Create.
  4. Select Query.

    If the display name contains a space, enclose your new and renamed attribute in double quotation marks.

  5. In the query editor, search for all newly renamed attributes.
    For example, Loyalty Enrollment Source, Loyalty Current Points, Loyalty Enrollment Date, Loyalty Remaining, and Points to Next Tier

    This example illustrates the renaming of customerstringattribute01 to Loyalty Enrollment Source.

    Before renaming:

    After renaming:

Important considerations for migration

  • To prevent confusion in user experience, a new entity schema is duplicated and migrated with a presentation prefix, such as presentation.customersummary. This helps to differentiate between the legacy and new entity schemas.
  • Queries on custom attributes from the legacy entity are ineffective. Always use aggregate summary entities to query your custom attributes.

    For example, build queries with the new CustomerSummary entity.

    Current Query (Legacy):

    SELECT *
    FROM customersummary;
    Updated Query (New Entity):
    SELECT *
    FROM presentation.customersummary;
  • The IQ Export feature reflects the display names surfaced from the Custom Attributes (CDP Studio) application and exports the renamed custom attributes to your Service Cloud accordingly.

Verifying Data Export

Data ExportAvailableFlow guide
Interactive Queries ExportYesThe process follows the same flow as Interactive Queries.
Cloud Data ExportYesThe process follows the standard export procedure as described.
Snowflake Data ShareNoNot offered
  1. Navigate to Cloud Data Export.
  2. Create a new Data Export file or open an existing one.

    If required, provide a name for your export file.

  3. Select the tables and Loyalty custom attributes that must be extracted to a cloud service.

  4. Navigate to the Customer folder.
  5. Search for the Loyalty Custom Attributes columns.
  6. Click the Add (+) icon to select the Loyalty Custom Attributes columns for export.

  7. Set your delivery preferences by selecting the cloud service destination.
  8. Review the Summary to ensure accuracy.

  9. To finalize the export, choose between Schedule and Save for Later or Send Now as an ad-hoc export.

For more information, see Using Custom Attributes API integration and Using Custom Attributes SFTP integration.

Did not find what you were looking for?

If this content did not answer your questions, try searching or contacting our support team for further assistance.

Back to Section navigation