Watson Campaign Automation Ideas

Submit new product ideas for Watson Campaign Automation, Watson Real-time Personalization, Watson Content Hub and Universal Behavior Exchange. Before you submit, please review existing ideas; if an idea close to yours already exists, it's better to add comments or vote on the existing idea. We will review your ideas and use them to help prioritize our product development. Best of all, the portal will automatically update you when the status of your idea has been changed.

Connect with your peers and IBM experts on the Watson Marketing and Commerce Community

Submit ideas for other Watson Customer Engagement Products:

•  Other Watson Marketing solutions
Watson Commerce
Watson Supply Chain

Give a format field into personalization

Currently the there is possible to user "format field" olny in english format, i mean Dates and some numeric format. But it is necesary to add international currency format. Today all that use ###.###,## need to have 2 fields. One numerci currency to filter or personalization criteria and other one to use like personalization field (PE: limit of the Credit Card or Max Loan offer)

  • Avatar32.5fb70cce7410889e661286fd7f1897de Guest
  • Jun 25 2018
  • Needs More Information
How will this idea be used?

It used to create emails, SMS and Push without necesary to upload more fields for personalization only (duplpicate field)

What is your industry? Professional Services
What is the idea priority? High
DeveloperWorks ID
Link to original RFE
  • Attach files
  • Admin
    Beth White commented
    July 02, 2018 20:00

    Can you clarify what you mean? You want to add personalization, but not tie it to a database field?

  • Avatar40.8f183f721a2c86cd98fddbbe6dc46ec9
    Guest commented
    July 03, 2018 14:18

    WCA allow to add personalization into a template: https://www.ibm.com/support/knowledgecenter/en/SSWU4L/Email/imc_Email/Using_Personalization_in_an_Email.html

    This allow to personalize Dates and Numbers (as Currency), but only work with dot as decimal separator (and period as thousands)

    As you can see in Countries using Arabic numerals with decimal comma in https://en.wikipedia.org/wiki/Decimal_separator there are many countries that use a comma as decimal separator (and point for thousands).

    Into the first URL: For example, if your database has a custom column "RAND", you can add %%format(RAND, "#,###.00")%% to get the correct currency format in the email body. But this example only work with this format, IF I try "#.###,00" I get an error.

    Because that, today, all countries that use a comma as Decimal Separator, we need to upload 2 fields that represent a currency. First one to use as critera from Query or Rule Builder (to use numerical criteria like "between") and other as Text with the local currency format to use to personalize a loan offer for example.

  • Admin
    Beth White commented
    July 03, 2018 15:13

    Thank you for the clarification. Yes- date and currency personalization can happen so you can have a comma separator.  You can change the format of the dates and  currency to display as you see fit.

    This exists today.  For example if I store in the database a USD currency $1,000.00 and I want it displayed as $1,000,00 - you can transform the data format in the email body only.

    You create a new database field with the date/currency format that you contact prefers- then you reference both fields to personalize the date/ currency as you see fit.

    See this article for initial guidance:


  • Avatar40.8f183f721a2c86cd98fddbbe6dc46ec9
    Guest commented
    July 03, 2018 15:24


    Thanks, but I think that is not working well
    As I told you when I try #.###,00 I get an error.
    Maybe the problem is not the decimal comma separator, but that the point on thousands separator.
    If you wan I can try trough technical support.

    ■ Diego de Arriandiaga
    Preventa de Soluciones

    Smart Business Solutions S.A.
    Montañeses 2180, 4º piso • C1428AQH • Ciudad de Buenos Aires • Argentina.
    dda@besmart.com.ar • www.besmart.com.ar • +54 (11) 4784-2001 Int. 20
    En BeSmart cuidamos el medio ambiente, te pedimos que pienses antes de imprimir este email.
    De: IBM Watson Customer Engagement <8b023a9c2d253c18d711d8f4@mailer.aha.io>
    Enviado el: martes, 3 de julio de 2018 12:15
    Para: Diego de Arriandiaga
    Asunto: Beth White responded to idea WCAIDEAS-I-50 Give a format field into personalization

  • Admin
    Beth White commented
    July 03, 2018 15:32

    If you have the data field present with the correct format- and referencing both fields in the email body-  format should work.  I would escalate this with customer support.

  • Avatar40.8f183f721a2c86cd98fddbbe6dc46ec9
    Guest commented
    July 04, 2018 00:43

    Yes please, I open a case a ong time ago 00617173 in this, representative told me that this functionallity is only for dates.... I discuss with him, but no have any response. As I told you, when I try to format like #.###.###,00 I get an error into the test view and get the "formula" if I sent the email