Skip to main content
May 12, 2014
Question

Formula Fields in Batch Emails - not allowed?

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.

7 replies

May 12, 2014
Hi Beate,

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

Thanks
Cheryl
Translate
Chris_Willis1
User Group Leader
User Group Leader
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?

Translate
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

Translate
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

Translate
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

Translate
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

Translate