Customer Data Hub Source Field Formatting

Overview

Reduce integration friction to its minimum and enable streaming customer data into Totango with minimal cost and effort

Totango gives customers the flexibility to connect Totango directly to their raw data, and taking away the burden of ETL process ownership.
The main burden is creating transformation on the customer data side or any other data manipulation which requires data engineers’ involvement.

Simply specify the source field format of your data and Totango will transform it for you to the expected format. Totango supports all common formats for numbers, currency, and dates.

This article includes the following topics:

 

Configure Source Field Format

Customer Data Hub enables you to simply bring your raw data to Totango Customer Data Hub as is and let Totango transform it for you.

  • In the Field Mapping & Formatting section, you can review the existing mapping and hover it to see more information and data preview.
    mceclip2.png
    Click on one of the field cards to edit it.
  • You can tell Totango what is the source field type and format by selecting the type and format from the list. This action will let Totango understand the source format and convert it to the format Totango expects without any data manipulation needed on your end.
    mceclip3.png
  • In case you did not find the right date format, you can create a custom format by using preserved letters and signs.
    mceclip4.png 

    mceclip0.png
  • Once you will save your source field configuration, it will validate your configuration. 

Common Custom Date Formats

These are the common custom date formats you can easily use to describe your source filed formatting:

  • ISO with UTC format: 
    YYYY-MM-DDThh:mm:ssZ
    YYYY-MM-DDThh:mm:ss+00:00
  • ISO with user timezone format
    YYYY-MM-DDThh:mm:ssXXX
  • ISO with UTC timezone format
    YYYY-MM-DDThh:mm:ssX
  • Datetime with dots separation
    DD.MM.YYYY hh:mm:ss
  • Datetime with slash separation and milliseconds
    MM/DD/YYYY hh:mm:ss:SSS
  • Two digits year formats are supported (E.g.: 21 for 2021)
  • Abbreviated months (3 letters) formats are supported (Jan, Feb, Mar, Apr, May, Jun, Jul, Aug, Sep, Oct, Nov, Dec)

Known Limitations

  • Date format does not support formats including AM/PM texts.
  • Key attributes do not support source formatting (only relevant to the "Historical clickstream" integration timestamp key).
  • Date formats without delimiters do not support adding leading zeros - For example, 2020104 is not a supported format as it does not have delimiters and missing leading zeros.
  • Only UTF-8 currency signs are supported for source field formatting

 

FAQs

  • Q: Which data sources support source field formatting? 
    A: Only relevant to Data Files and Data Warehouses data sources as other data sources natively send this info to Totango Customer Data Hub. 

  • Q: Which Integration types support source field formatting? 
    A: All integration types support source field formatting, for example, Account, Users, Usage, Collections, Totango Users, ...

  • Q: Does the source field formatting influencing the Totango attribute formatting? 
    A: the source field formatting only describes the source field, it does not change the Totango attribute.

  • Q: I have a date format with timezone, every row has its own timezone. Is it supported?
    A: Yes. The source field formatting you configure must include the timezone mask. For example, YYYY-MM-DDThh:mm:ssXXX.

  • Q: I have this number for over 1,000 -> 1,234.56 and no comma for values less than 1,000 -> 123.45.
    Which format should I use?

    A: The right format is US format as it handles the comma separation only for numbers over 1,000.

  • Q: I have a currency format that includes decimals but not any thousands separator, for example, $1234.56, which format should I use?
    A: The right format is a decimal currency without a thousand separators.
    mceclip0.png
  • Q: I have a date-time field format in Salesforce, for example, 2021-04-07T12:15:00.000+0000. Which format should I use?
    A: The right format is a Custom Date with the following format: YYYY-MM-DDThh:mm:ss.SSSX
    mceclip0.png

 

 

 

 

 

 

Was this article helpful?

1 out of 1 found this helpful

Have more questions? Submit a request