Ronn_Burner

Got it! Thank you sou much! ... View more

Thanks, Sanford! As usual, it turns out you are spot on as the Developer team seems to agree with you. But one final thing just to be clear, is it a true statement to say that these hooks or changes you suggest can only be added at the application level (website) and not within the Munchkin JavaScript? ... View more

The goal of scanning the Email Sends every 24 hours that will send an email notification if/when the activity for any one of 20 programs has abnormally high or low activity. I've inadvertently gone down a bit of the Developer's JSON rabbit hole trying to figure out the correct version to use for this goal. If the access token only lasts 1 hour how and where is this executed? I assume the paging token serves as an automated mechanism creating a new access token every 24 hours but I'm not sure what JSON script I need to focus on. If so, is this all executed in a single JSON script?   Request GET /rest/v1/activities/pagingtoken.json?sinceDatetime=2014-10-06T13:22:17-08:00 Response { "requestId": "1607c#14884f3e74e", "success": true, "nextPageToken": "GIYDAOBNGEYS2MBWKQYDAORQGA5DAMBOGAYDAKZQGAYDALBQ" } Request GET /rest/v1/activities.json?nextPageToken=GIYDAOBNGEYS2MBWKQYDAORQGA5DAMBOGAYDAKZQGAYDALBQ&activityTypeIds=1&activityTypeIds=12   Do I combine the Get Lead Activities JSON with the paging token script into a single script or are multiple steps required? https://developers.marketo.com/rest-api/endpoint-reference/lead-database-endpoint-reference/#/Activities/getLeadActivitiesUsingGET     ... View more

That's right. And confirmation there is no Marketo UI magic to execute this.   It’s feasible to build an app to do this using the Marketo REST API, periodically downloading activities of a certain type and detecting aberrations. The known details are simple in theory.  Less than 5 email sends (or email sends = 0 would also work if that's easier) for the aggregate to trigger an inactivity flag (email). More than 50 emails sends to trigger a high activity flag (email).   Figuring out how to build the app using Marketo REST API to execute these flags is the part that is beyond my skillset. Would you be able to get me started or point me in the right direction? I have reviewed the https://developers.marketo.com/rest-api/ however even that appears to be specific to individual lead records.     ... View more

That's really smart! This is a very useful method to implement and utilize. That's bigger picture. I'll need to think about creating a program to batch and cohort tag the existing 20 million records. I like it and will definitely look to implementing in the near future.   As for my initial question on this program specific random sample - will my logic work perfectly fine as I have it in the flow?   Thank you so much!   ... View more

Then that answers that. I'm so glad I asked. These will not be used with Velocity - the data will be strictly parsed from Smart Campaigns. I see exactly what you mean and how this would, in fact, work in Velocity but since the Option #1 fields are not binary there is nothing connecting the 2 within a Smart List. Thanks!       ... View more

This worked to perfection! Thanks! I've tested every permutation of Trial / Subscribed / Past 24 hours / over 24 hours ago and it deploys the emails with the appropriate messaging flawlessly.   I did actually attempt this logic block sequence at first but it returned the soft bounce i.e. broken syntax error. Of course, not even knowing if that was the proper way to do it I wasn't sure if it was a minor broken code error or if the entire logic block sequence method was wrong.   In the end - it most likely returned the syntax error simply because I neglected to properly close those blocks with #end   Thank you @SanfordWhiteman for all of your help - our entire onboarding and Welcome Series is in place thanks to you helping me utilize Velocity. I can't tell you how grateful I am.     ... View more

@SanfordWhitemanJust wanted to follow up - I can take it to the community posed as a new post question if you prefer.    Can you help me solve for combining the "Product X Trials" with the "Product X Subscriptions" using "any" or "or" conditions (utilizing the double pipe ||)?   Intellectually, I can see this is an easy function within velocity based on everything else I've done here as well as how seamless the use of the "and" (&&) function was to utilize.   The challenge is writing un-broken code. I assumed that in every line $lead.dMSSubscribedDate and $caldMSSubscribedDate appeared (the first #if and #set lines 9-17) would require the | | followed by the trial fields $lead.dMSTrialDateTime and $caldMSTrialDateTime.   I really appreciate and grateful for the help. Thank you. ... View more

@SanfordWhiteman  can you help me solve this?   I have no idea what you were expecting this use of || to do, it’s broken too:   I'm just trying to figure out where the "any" or "or" (| |) belongs so I simply mirrored and added all "Trial" syntax on the lines where the "Subscribed" syntax was present. What I was expecting was the fact I know this works individually and I know this works in this fashion in the (&&) syntax I hoped by simply adding the |  | would result in the same output. I was wrong. That's why I'm here. I'm trying. At least by trying I am discovering what does not work.       Individually I know this is right for DMS Subscribed...     #set( $ISO8601WithSpace = "yyyy-MM-dd HH:mm:ss" ) #set( $defaultTimeZone = $date.getTimeZone().getTimeZone("America/Los_Angeles") ) #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" ) #if( !$lead.dMSSubscribedDate.isEmpty() ) #set( $caldMSSubscribedDate = $convert.toCalendar( $convert.parseDate( $lead.dMSSubscribedDate, $ISO8601WithSpace, $defaultLocale, $defaultTimeZone ) ) ) #if( $date.difference($calNow,$caldMSSubscribedDate).getHours() >= -24 ) You now have access to PRODUCT X! #end #end     And I know this is right for DMS Free Trial...     #set( $ISO8601WithSpace = "yyyy-MM-dd HH:mm:ss" ) #set( $defaultTimeZone = $date.getTimeZone().getTimeZone("America/Los_Angeles") ) #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" ) #if( !$lead.dMSTrialDateTime.isEmpty() ) #set( $caldMSTrialDateTime = $convert.toCalendar( $convert.parseDate( $lead.dMSTrialDateTime, $ISO8601WithSpace, $defaultLocale, $defaultTimeZone ) ) ) #if( $date.difference($calNow,$caldMSTrialDateTime).getHours() >= -24 ) You now have access to PRODUCT X! #end #end     What I wanted to do was utilize the "any" or "or" (| |) syntax so I added the "Trial" after the "Subscribed" and  | | .   This is what my vtl code looks like at the top - as you can see where my confusion lies in that the first #if references "subscribed" only. I would think I would have to include some code also scanning for "Trial" conditions. But where and how does that fit in?     #set( $ISO8601WithSpace = "yyyy-MM-dd HH:mm:ss" ) #set( $defaultTimeZone = $date.getTimeZone().getTimeZone("America/Los_Angeles") ) #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" ) #if( !$lead.dMSSubscribedDate.isEmpty() ) #set( $caldMSSubscribedDate = $convert.toCalendar( $convert.parseDate( $lead.dMSSubscribedDate, $ISO8601WithSpace, $defaultLocale, $defaultTimeZone ) ) ) #if( $date.difference($calNow,$caldMSSubscribedDate).getHours() >= -24 || $date.difference($calNow,$caldMSTrialDateTime).getHours() >= -24 ) You now have access to PRODUCT X! #end #end       Also, there’s no image inserted in your post.       ... View more

@SanfordWhiteman  I have tested this a few different ways but I can't seem to find the proper coding sequence to make it work. Obviously utilizing only this will not work with the #if and #set VTL block for $lead.dMSSubscribedDate.isEmpty()  ) and !$lead.dMSTrialDateTime.isEmpty()  ) written. #if( $date.difference($calNow,$caldMSSubscribedDate).getHours() >= -24 ) || $date.difference($calNow,$caldMSTrialDateTime).getHours() >= -24 ) I also tested using the entire $lead.dMSSubscribedDate.isEmpty()  ) and then followed that with the enitre !$lead.dMSTrialDateTime.isEmpty()  ) VTL block - which did not work. Finally I attempted to combine them into a single block and edited using the || indicated below - which also does not work and returns the error shown in the image below. Can you please correct my missteps?   #if( !$lead.dMSSubscribedDate.isEmpty() || !$lead.dMSTrialDateTime.isEmpty() ) #set( $caldMSSubscribedDate = $convert.toCalendar( || $caldMSTrialDateTime = $convert.toCalendar( $convert.parseDate( $lead.dMSSubscribedDate || $lead.dMSTrialDateTime, $ISO8601WithSpace, $defaultLocale, $defaultTimeZone ) ) )   ... View more

There are a few different locations that may require the || in this scenario. I will test but it's always easier to get as much info prior to really messing things up. 🙂 In this first section below do I simply add the entire #if( !$lead.dMSTrialDateTime.isEmpty() ) content block duplicating the Subscribed block below or do I use the double pipe || and add the Trial content mirroring the Subscribed content for lines 1, 2 and 4 below?   #if( !$lead.dMSSubscribedDate.isEmpty() ) #set( $caldMSSubscribedDate = $convert.toCalendar( $convert.parseDate( $lead.dMSSubscribedDate, $ISO8601WithSpace, $defaultLocale, $defaultTimeZone ) ) )   I do believe this portion is correct, right?   #if( $date.difference($calNow,$caldMSSubscribedDate).getHours() >= -24 ) || $date.difference($calNow,$caldMSTrialDateTime).getHours() >= -24 )     ... View more

That worked to perfection! This is amazing stuff. I always make this so much harder than I need to. But, yes, I see. And it worked!   Of course, now that I know I can create AND (&&) conditions, is it just as easy to create ANY or OR conditions? Currently, I have separate programs for Product X Subscribed and Trial - which triggers an email #1 for each - one with theTrialDateTime token and the other with the SubscribedDateTime token. With ANY or OR conditions (in past 24 hrs) I would be able to have only a single program per product and a single email #1 recognizing any new subscription OR trial.   Email #1 - Congratulate all NEW Subscriptions OR Trials (DateTime in past 24 hrs = TRUE) AND promote to all Product X Trial AND Subscription (DateTime is empty) = FALSE Email # 2 - Only promote to all Product X Trial AND Subscription (DateTime is empty) = FALSE   As always, thank you!   ... View more

No, those are just placeholders for the conditions you want to match! Oh, man. Buzzkill. Because literally "something" and "something else" is exactly what I need to identify - but in a DateTime field. Basically, for my use case only (empty field values) "null" and "null" = FALSE (does not have Product X Trial or Subscription) and anything else, any value in either field, would indicate TRUE. FALSE = promote that product because lead does not have product Trial or Subscription TRUE = skip because lead currently has product Trial or Subscription Is there a way to do this based on the information I provided and with DateTime "null" and "null" or "null" and "not null"? If not, I don't think I can do this utilizing VTL as this entire script you and I (you!) created here is based on DateTime.   ... View more

This is great! I understand exactly what you are doing with the script conceptually - but technically I'm not exactly sure how to execute it properly. I have exactly how I interpreted your message below. I did create a token with the below VTL and sent a test send from Lead Record > Marketing > Send Email and it returned no text where Your Product X Subscribed and Trial is false. should be displayed. Yes, I have checked the two corresponding DateTime boxes and used the appropriate system names in the VTL. Please grade my paper, Good Sir.   For example, do I literally use "something" and "something else"? And is ##both conditions are true required VTL - I know ## signifies comment but not sure if that is comment for me or comment text location for consumer and the place I should write the text... Your Product X Subscribed and Trial is false.       #set( $ISO8601WithSpace = "yyyy-MM-dd HH:mm:ss" ) #set( $defaultTimeZone = $date.getTimeZone().getTimeZone("America/Los_Angeles") ) #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" ) #if( $lead.dMSTrialDateTime.equals("something") && $lead.dMSSubscribedDate.equals("something else") ) ## both conditions are true Your Product X Subscribed and Trial is false. #end             ... View more

@SanfordWhiteman  is there a line of VTL or a way to use "AND" conditions in the script?   The reason for this is that a customer can "Subscribe" or begin a "Free Trial" with PRODUCT A (or any of our products). Obviously, the DateTime fields need to be unique for each "PRODUCT X Free Trial" or "PRODUCT X Subscription".   Therefore if I want to send Email #2 (Email #1 populates only Trial/Subscription that are TRUE in past 24 hours) to populate only the FALSE values (products they are currently not subscribed to AND not in a Free Trial.   So if: "Product A Subscription DateTime" is FALSE (empty) AND "Product A Free Trial DateTime" is FALSE (empty) THEN populate with "Product A is FALSE so TRY NOW!" text.   If so, can you please help me with this? ... View more

Hi @SanfordWhiteman I ran into something here and hoped you could help.   We created this VTL for all product subscriptions via lead.DMSSubscribedDate (The value is actually DateTime as I edited those fields) and it works perfectly. All "true" values within past 24 hours reflected and all "false" values data appropriately affected as well. The monkey wrench is all of these products also offer a Free Trial - which is obviously a different status so I duplicated the VTL appropriately and created and lead.DMSTrialDateTime and that VTL token and programs work perfectly as well.   The problem I have created and need to solve for is the fact that it is possible to "Subscribe" to Product01 and begin a "Free Trial" for Product02. The "New Subscriptions Program" will send the Email with the {{RecentlySubscribedProducts}} token only recognizing T or F for "Subscriptions" and therefore populating Product02 as a product you still need - even though you currently have a "Free Trial.  Likewise the "New Free Trials Program" will send the Email for that program with {{NewProductTrials}} token that will acknowledge a "Free Trial" TRUE for Product02 but recognize Product01 "Free Trial" as FALSE even though it's actually a "Subscribed" product. As it should with those 2 separate VTL scripts. Do you know how I can solve for this using Smart Campaigns? The Program looks like this and is duplicated for each Subscribed program and entire sequence duplicated for each Free Trial program: NEW SUBSCRIPTIONS (default program) - 7 of these so 1 for each product subscription Smart Campaign: Data Value Changes (trigger): Attribute: DMS Subscribed DateTime in past 24 hours Flow: Change Program Status: Member SENDER (default program) Smart Campaign #1 to send Email #1 (Welcomes TRUE and Promotes FALSE values) Smart List: (1 or 2 or 3 or 4 or 5 or 6 or 7) 1-Data Value Changed: DMS Subscribed DateTime in past 24 hours --> Flow: Send Subscribed Email #1. repeat for all products   Smart Campaign #2 to send Email #2 (Only promotes FALSE values) Smart List: 1 and (2 or 3 or 4 or 5 or 6 or 7 or 😎 1-Was Sent Email: Email #1 in past 2 days 2-Member of Program: False / Program is Product01 (DMS) repeat for all products   I know this is confusing but hopefully I articulated clearly enough and you know precisely how to solve for this using Smart Campaign logic that would only send Email #1 from "Subscribed" and not from "Free Trial" in the same day. #If so, please share. Thank you so much ... View more

And problem solved. Thank you, Sir! ... View more

Hello Sanford - The VTL script we created here is working flawlessly - with the exception of one minor display error in the screenshot below. User error, no doubt. All the velocity script displays properly following this block of text - I just didn't show all of the rest as it's perfect. I have included the relevant top portion of the code below and hopefully, you are able to easily see why this is happening. Can you please tell me what I need to do so that does not happen and/or appear? Thanks! #set( $ISO8601WithSpace = "yyyy-MM-dd HH:mm:ss" ) #set( $defaultTimeZone = $date.getTimeZone().getTimeZone("America/Los_Angeles") ) #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" ) ${display.list( $lead.entrySet(), "\u000a" )} #if( !$lead.dMSSubscribedDate.isEmpty() ) #set( $caldMSSubscribedDate = $convert.toCalendar( $convert.parseDate( $lead.dMSSubscribedDate, $ISO8601WithSpace, $defaultLocale, $defaultTimeZone ) ) ) #if( $date.difference($calNow,$caldMSSubscribedDate).getHours() >= -24 ) <tbody> <tr> <td colspan="3" style="line-height: 1px; font-size: 1px;" height="${FreeText2Col-top-space}">&nbsp;</td> </tr> <tr> <td class="block" width="290" valign="top" style="vertical-align:top;width:290px;"> <table cellpadding="0" cellspacing="0" width="100%" border="0"> <tbody> <tr> <td style="font-size:14px; color:${TextColor}; font-family:${TextFontFamily}; mso-line-height-rule: exactly; line-height:20px;text-align:left;" valign="top"> <div id="FreeText2ColLContent71732c78-1779-4a8b-a26b-7f22327f6ca2" class="mktoText" mktoname="FreeText2ColLContent"> <div> <strong><span style="font-size: 18px;"><span style="font-family: arial,helvetica neue,helvetica,sans-serif;"></span></span></strong> <strong><span style="font-size: 18px;"><span style="font-family: arial,helvetica neue,helvetica,sans-serif;"></span></span></strong> <strong><span style="font-size: 18px;"><span style="font-family: arial,helvetica neue,helvetica,sans-serif;"></span></span></strong> <strong><span style="font-size: 18px;"><span style="font-family: arial,helvetica neue,helvetica,sans-serif;"></span></span></strong> <p><strong><span style="font-size: 18px;"><span style="font-family: arial,helvetica neue,helvetica,sans-serif;"></span></span></strong><br /></p> <p><strong><span style="font-size: 18px;"><span style="font-family: arial,helvetica neue,helvetica,sans-serif;"></span></span></strong><strong><span style="font-size: 18px;"><span style="font-family: arial,helvetica neue,helvetica,sans-serif;"></span></span></strong><strong><span style="font-size: 18px;"><span style="font-family: arial,helvetica neue,helvetica,sans-serif;">Dealertrack and RouteOne Applications</span></span></strong><span style="font-size: 14px;"><span style="font-family: arial,helvetica neue,helvetica,sans-serif;"><a href="https://{{my.LM1}}?utm_source={{my.UTMSource}}&amp;utm_medium=email&amp;utm_campaign={{my.UTMCampaign}}&amp;utm_content={{my.UTMcontentW1CTA2}}" style="-ms-text-size-adjust: 100%; -webkit-text-size-adjust: 100%; color: #007c89; text-decoration: underline;"><span style="color: #0000ff;"><em><strong></strong></em></span></a></span></span></p> <p><span style="font-size: 14px; font-family: arial, helvetica, sans-serif;">No other system gives you access to more lenders. Simply structure all your finance deals and submit to your lenders and receive lender decisions without ever leaving <em><strong>DealerCenter</strong></em>.&nbsp;<span style="color: #0000ff;"><em><strong><a href="https://{{my.LM1}}?utm_source={{my.UTMSource}}&amp;utm_medium=email&amp;utm_campaign={{my.UTMCampaign}}&amp;utm_content={{my.UTMcontentW1CTA1}}" target="_blank" id="" style="color: #0000ff;">See how it works in this video!</a></strong></em></span></span></p> <span style="font-size: 14px;"><span style="font-family: arial,helvetica neue,helvetica,sans-serif;"><a href="https://{{my.LM1}}?utm_source={{my.UTMSource}}&amp;utm_medium=email&amp;utm_campaign={{my.UTMCampaign}}&amp;utm_content={{my.UTMcontentW1CTA2}}" style="-ms-text-size-adjust: 100%; -webkit-text-size-adjust: 100%; color: #007c89; text-decoration: underline;"><span style="color: #0000ff;"><em><strong></strong></em></span></a></span></span> </div> </div> </td> </tr> </tbody> </table> </td> <td class="block" width="20" style="font-size:1px;line-height:1px;">&nbsp; </td> <td class="block padding_top" width="290" valign="top" style="vertical-align:top;width:290px;"> <table cellpadding="0" cellspacing="0" width="100%" border="0"> <tbody> <tr> <td style="font-size:14px; color:${TextColor}; font-family:${TextFontFamily}; mso-line-height-rule: exactly; line-height:20px;text-align:left;" valign="top"> <div id="FreeText2ColRContent71732c78-1779-4a8b-a26b-7f22327f6ca2" class="mktoText" mktoname="FreeText2ColRContent"> <table style="width: 67px; height: 29px; margin-left: auto; margin-right: auto;"> <tbody> <tr> <td><img src="https://gallery.mailchimp.com/f60eb80b4f12731362cb001a7/images/9529e54f-4754-4ac4-ae2b-ab817bcbf026.png" alt="" constrain="true" imagepreview="false" width="280" height="202" border="" align="top" /><br /></td> </tr> </tbody> </table> <p></p> </div> </td> </tr> </tbody> </table> </td> </tr> #end #end‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ ... View more

Of course. Because that refers to the true contents of the URL at the moment the Forms 2.0 library has loaded (note: not at the moment the form is submitted, when the library loads it caches this information). So the Default Value will not populate the Query parameters in the Activity Log. That's good to know. For sanity sake. Your description of the triggered action still doesn't make sense. I totally agree. It makes no sense. That's the mystery I need to solve and prove. I'm forced to go "snipe" hunting. I'm just trouble-shooting and the facts that I know are the hidden fields in the form are customized and were clearly created for this purpose alone. When it does not work... I don't know why and I deduced it must have something to do with the "Query parameters" in the Activity Log. That could be completely false. I don't know. Once I know the precise mechanism taking place in the CRM I can easily remedy any issues. Nobody seems to know. 1500 employees and I'm the only marketer and Marketo guy that inherited these things I've never seen before. If Marketo "does not push data to our CRM" then the CRM can't know about the parameters of the Filled Out Form activity. Someone is making up a ghost story to explain (or avoid looking into) what is a certain fact. It is 100% certain that the Filled Out Form activity is syncing to your CRM. I consider this to be amazing news actually! Especially coming from you because I totally agree but I'm being told that's not happening and they are blaming Marketo i.e. me. And since I'm not a know it all I then assume I'm doing something wrong or there is something I'mn just not familiar with. I keep saying that "IF" it's a one-way street (which our Lead Developers assure me is the case) then how is our CRM getting Marketo data - manually via export/import or sync? That's the only possibilities. I checked the Marketo webhooks and nothing is active there. ... View more

Yes. The activity is being captured and the LP is approved. I even tried editing and re-approving to see if that made a difference. The "Query Parameter" in the activity log remains empty except when I test using an email with utm parameters on the link. I would love a call. How and when are you available to do so? ... View more

This is all very helpful. Thank you for assisting me in problem-solving. I can tell you a few things that may add insight and be helpful. The key missing element in my mind is... how and/or what information exactly is being scanned and extracted or pushed to the CRM that triggers these alerts? I do know this pre-dated me here and the result does work and looks likes this in the Activity Log: With the form set up like this: 'For Import' is a custom boolean field. I am just deducing by the fact that this alert email was triggered in the CRM previously by working through a Marketo form submission that the key to this functionality must lie in this 'For Import' "Query Parameter". Now, I did edit the Autofill: For Import as advised.... and I had done this previously as well but that method did not create a "Query Parameter" in the Activity Log. I also tried Get Value From: Use Default Value / Default Value: ?Program=Email&ForImport=True which did not write to the Activity Log. This is so frustrating. Seems like such a simple thing. Through an email/Banner Ad UTM it works perfectly... without that it seems nothing works. ... View more

OK, that means your Smart Campaign wasn't in the right place in the MA hierarchy and didn't have the token available. Make sure the Program w/the SC can see the token (as is the case w/all tokens). Oh my goodness. *slams face onto keyboard* You're absolutely right and such a rookie mistake! I obviously know that. I utilize dynamic tokens for utm parameters extensively throughout my dynamic programs. I cannot believe I didn't catch that. It's so obvious. Ugh! That was paralysis by analysis resulting from fear and pressure of trying to do VTL from a clean slate. Yes, you can add HTML where you currently have plain text. Velocity just outputs what you tell it to, it doesn't think about whether it has HTML tags or not. I just tested this is a couple spots and it rendered perfectly! Thank you, Sanford! Truly. This entire lesson was invaluable and I will take it and the code with me and utilize it as much as possible. This is high level and super cool stuff! I cannot thank you enough for your time, patience and help. You're my hero! ... View more

That worked - and is the below image. Progress! Obviously, it can't display like this. I will play with this and test until I get to the desired result (2nd image below) but please let me know what you see clearly needs to be corrected and/or just any tips. Ideally, I'd like to have a sentence or two accompanied by an image as seen below for each unit of code (product section) which comes from my original unique emails. Can I just cut and add the HTML to the "You subscribed to DMS within the past 24 hours." section? Which should work but is that the way to do it? If you say, yes, am I crazy or does this mean this framework is 100% completed and ready to go? PRODUCT 01 = True PRODUCT 02 = False ... View more

Thank you so much! That helped. So I tested meticulously, unit of code by unit of code, and then collectively a whole and in the preview-by-list mode it reflected all "true's" appropriately as well as all the "false's". That's a huge win as it clearly appears to be working perfectly. That said, when I run a smart campaign and actually send that same email - it's blank. So not exactly working perfectly. Does this make sense to you and/or what can I do from here? ... View more