Formula Fields in Batch Emails - not allowed? | Community
Skip to main content
May 12, 2014
Question

Formula Fields in Batch Emails - not allowed?

  • May 12, 2014
  • 5 replies
  • 3588 views
I created a formula field to help differentiate the salutation in Emails. However if I use this formula field as token in an batch Email the system would not allow me to send the email as I am using a formula field.
Marketo would not allow to use formula fields as tokes in batch emails, is this true?
Is there a way to allow this or a smart work around?
I hope somebody can help me on this.

Thanks

Beate
This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

5 replies

May 12, 2014
Hi Beate,

Yes, this is true.  You can use the Formula Field in a Trigger campaign only.

Thanks
Cheryl
Chris_Willis1
Adobe Champion
Adobe Champion
March 3, 2016

Cheryl Chavez​ I just created an admin formula field to use in lead diagnostics.  Unfortunately, I can't see it now in my RCA custom field sync.  Are formula fields not able to be used in RCA reports?

Chris Willis - Fractional GTM Operations Consultant
March 3, 2016

Here's my idea to for more functionality to Formula Fields: Please add comments there for more functionality with Formulas

March 3, 2016

No, Marketo Formula Fields cannot be sync'd over to RCA.  RCA only allows sync'ing over of "native" fields/attributes.  That said, if the underlying Formula Field is derived from native fields/attributes that are sync'd over into RCA, you can always create (i.e., recreate) this as a calculated metric within Revenue Explorer.

-Brian

April 6, 2016

Hello Beate,

not sure if you would call this a smart workaround...

I am taking care of a large German (and other languages) database. Our system is set up in a way that we have custom fields for the different language salutations and those fields we can use with tokens.

I am interested what other sollutions people have.

Kathrin

Grégoire_Miche2
Level 10
April 6, 2016

Hi All,

Various possibilities here :

  1. You make your campaign a triggered campaign with the trigger "campaign is requested", the you create another batch one that calls the first one. Drawback : overload on this instance and this will no longer be a priority job, so the email may not start on time.
  2. You replace formula fields with string fields that you compute ahead with data management campaigns.

-Greg