Mark_Price

Email Scripting in Marketo is really Apache Velocity and it's quite powerful once you get the syntax down.  1. Should be fine, but you should store the URL without the https://  OR strip it in Velocity.  In order for the links to work you need to output <a href="https://${var}?param=etc">Velocity Link</a> 2. This is a good example for using Email Scripting.  There isn't another way to merge in the Custom Object data. 3. I usually make a larger complicated script that is setting variables and doing all the transforms then reference those variables where it should appear in the email.  This topic should describe the technique:  https://nation.marketo.com/t5/Product-Discussions/Default-Value-for-Velocity-Token/m-p/122046#M80311  hope it helps ... View more

Not natively but you can with the API.  If you're storing Order Data/Status It sounds like you may want a custom object to store the data.  (unless a record only ever has 1 order) After the data is on the lead record or in a custom object you can merge it into emails. Hope it helps!  ... View more

Hello there are a few ways to do what you would like.  My suggestion is based on providing some new options to get even more out of Velocity: Basically, you could set a default value and then override it if they have a confirmed training session. This technique would let you have a dynamic message or one in certain scenarios.  On line 11 there's a default set. Note: you can set a variable to a block of HTML if encapsulated in single quotes.  ##date defaults # set ( $defaultTimeZone = $date . getTimeZone ( ) . getTimeZone ( "America/New_York" ) ) # set ( $defaultLocale = $date . getLocale ( ) ) # set ( $calNow = $date . getCalendar ( ) ) # set ( $ret = $calNow . setTimeZone ( $defaultTimeZone ) ) # set ( $calConst = $field . in ( $calNow ) ) # set ( $ISO8601 = "yyyy-MM-dd'T'HH:mm:ss" ) # set ( $ISO8601DateOnly = "yyyy-MM-dd" ) # set ( $Calendar = $date . getCalendar ( ) ) ##other detaults # set ( $scheduleMessage = '<span style="font-size:14px;"><p>HTML for default message here</p></span>' ) # foreach ( $event in $training_Record_cList ) # if ( $event . trainingStatus . equalsIgnoreCase ( "confirmed" ) ) # set ( $latestEventDate = $event . trainingScheduledStartDate ) # set ( $origDate = $convert . parseDate ( $latestEventDate , $ISO8601DateOnly , $defaultLocale , $defaultTimeZone ) ) # set ( $formattedDate = $date . format ( 'full_date' , $origDate , $defaultLocale , $defaultTimeZone ) ) # set ( $trainingType = $event . trainingType ) # set ( $trainingTypeSimple = $trainingType . replaceAll ( "\s*\(.*\)\s*$" , "" ) ) < ul style = "margin-bottom: 0px;" > < li style = "margin-bottom: 0px;" > < span style = "font-style: italic;" > $ ! trainingTypeSimple < / span > on $ ! formattedDate < / li > < / ul > #end #end ##override schedule message # if ( $trainingTypeSimple ) # set ( $scheduleMessage = '<span style="font-size:14px;"><p>Hope to see you soon!</p></span>' ) #end‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ ‍ ‍ ‍ ‍ ‍ ‍ ‍ ‍ ‍ ‍ ‍ ‍ ‍ ‍ ‍ ‍ ‍ ‍ ‍ ‍ ‍ ‍ ‍ ‍ ‍ ‍ ‍ Here's the tricky/cool part:  You can make a 2nd email script token to output your HTML where you would like your message to appear.  *Beware, it needs to be underneath the main token to work. For example, make an email script token:  {{my.scheduleMessage}} within {{my.scheduleMessage}} enter your velocity variable: $scheduleMessage Now you can edit your email in the UI and place the {{my.scheduleMessage}} token wherever you want the default message HTML to appear. **Again,  it needs to be underneath the main token setting the variable to work. For complicated builds I'll make a huge mega-token that sets all my variables and put it at the top of the email or even as the subject line.  Then I'll have a set of 'simple email script' tokens that are just 1 variable each.  It seems to make the scripting a little easier having it all in one place and it's also easier to make changes or do highly dynamic emails.  Disclaimer: haven't tested the above code so be sure to do so if you go this direction.  hope it helps!  I frequent: https://blog.teknkl.com/tag/velocity/ quite often  ... View more

Pretty sure that filter is only for the Lead Extract: https://developers.marketo.com/rest-api/bulk-extract/bulk-lead-extract/#filters  Bulk Activity will let you filter by activityId but that will give you all 'Added to List' activities. You could filter this further in your code but seems like this strategy would extract more data than what's needed.  ... View more

If you have tokens as URL parameters within an email, Marketo will render the link at time of send with the parameters hardcoded behind the link tracking url.  This means if a token value changes in Marketo, your link that was previously sent to the client will not update.   If you want the link to update with the newest set of parameters upon click, you can setup a landing page in Marketo that is nothing more than a script to add the URL parameters and redirect to your destination page.  That will result in this flow:   Link Click -> Redirector LP (that builds the link) -> Destination Page Note: This can add a tiny bit of loading time to get to the destination page but is generally unrecognizable in the user experience.  ... View more