Elsa_Man3

Elsa_Man3

Hi Maen, You can just use inactivity filters - or was there a reason you didn't want to use them? It'd look something like the screenshot below. For the sales emails, I assume they are sales emails tracked/sent in SFDC? If so, you can sync that activity over to Marketo in your CRM sync setup. Or you can also just use the field you've created and replace the 'not opened sales email / not clicked sales email' with ' Last Sales Email Engagement Date is in past before 52 weeks or Last Sales Email Engagement Date is empty'

Elsa_Man3

Hi Patrick, 1. By default the munchkin cookie expires after 2 years. There are new changes if people use Safari - it may only last 7 days https://nation.marketo.com/t5/knowledgebase/browser-cookie-updates-how-marketo-munchkin-is-affected/ta-p/251524 2. It will last 2 years even if the person no longer clicks on email or visits the website. But if they do engage again, then the counter starts up again. 3. Yes, if the customer ends their session/time on your site, comes back the same day, the cookie will know and continue logging the activity under the same Marketo person. Not directly related to the Munchkin cookie expiry but all the above is not to be confused with how long activity data is retained in Marketo - i.e. how long does Marketo save a "Clicked on email" activity data for a person. For those activity data retention timeframes, you can refer to Marketo's data retention table: https://nation.marketo.com/t5/knowledgebase/marketo-activities-data-retention-policy/ta-p/251480

Elsa_Man3 · ‎04-29-2020

Hi @SanfordWhiteman I came across your solution to this post challenge, which is similar to mine - I'm trying to pull a list of all the Order Names associated with a Contact, if certain conditions for those orders apply (i.e. Status is Processed, and the Program the order came in under matches its SFDC ID). Applying as best I could from your sample code I came up with the below, but in Marketo when I render the email with a test person, it displays empty. Did I apply your sample incorrectly? Let me know if you prefer I create a new post for this question. Thanks as always! #set( $processedOrders = [] ) #foreach ($Program_Order in $Program_Order__cList.get(0).Order_Line_Item__cList) #if( $Program_Order.ProgramOrderStatus.equals("Processed") && $Program_Order.Program.equals("a0A4t0000001YO5EAM")) #set( $void = $processedOrders.add($Program_Order) ) #end #end #foreach( $Program_Order.Name in $processedOrders ) ${Program_Order.Name} #end

Elsa_Man3 · ‎04-28-2020

thank you (again!) 😊

Elsa_Man3 · ‎04-28-2020

it works great now, thank you!!

Elsa_Man3 · ‎04-28-2020

thanks! I've edited the original post with the syntax highlighter, also below: <ul> #foreach ($Program_Order in $Program_Order__cList) <li>${Program_Order__cList.get(0).CreatedDate}</li> #end </ul>

Elsa_Man3 · ‎04-28-2020

We're trying to use the foreach directive in Velocity to list all the Order Dates that a contact had have, over time. For example, Joe Smith placed an order today and one yesterday, so in the email I want it to list out both dates. I've used this script: <ul> #foreach ($Program_Order in $Program_Order__cList) <li>${Program_Order__cList.get(0).CreatedDate}</li> #end </ul> But in the email outputs, it just lists out yesterday's date, twice. So it's recognizing that Joe has 2 order records attached to it, but only populating it with the first order's created date in the list. What am I missing in the script? Thanks!

Elsa_Man3 · ‎04-28-2020

thanks Sanford! I should note that the Contact --> Order is a Lookup relationship too, but we are able to successfully pull in fields from the Order object. Does the anti-lookup rule not apply here because it's directly tied to the Contact?

Elsa_Man3 · ‎04-28-2020

We have data stored in a SFDC custom object that is 2 levels down to the Contact record (Contact --> Purchaser Profile --> Ticket) and according to Marketo, that SHOULD pull through in Velocity Scripting (it's only 3 levels down that's a no-go). But we aren't able to for some reason. But if we go try to pull 2 levels down through a different route (Contact --> Order --> Order Line Item) we are successful. The only difference I can see from pulling data from Ticket vs Order Line Item, is that the Ticket is a Look-up relationship to Purchaser Profile, whereas Order Line Item is a Master-Detail relationship to Order. Does anyone know if that makes a difference? Thanks in advance!

Elsa_Man3 · ‎04-03-2020

Just came upon this discussion as I'm trying to solve for that exact issue in our email reporting, to easily track by email what the actual unsubscribe numbers are when we only use custom unsub fields. The solution to pass Email ID in as a query parameter thru the custom unsub form is great, but I got lost when you mentioned passing that info back into SFDC too and into a custom object. Can you explain why we would need that data in a custom object pls? If i just housed the field "Unsubscribed from Email ID" as a regular field on the Person/Contact object, could I not pull that into reports or smart lists the same way?

Online Status	Offline
Date Last Visited	5 hours ago

Date Registered	‎12-02-2019 08:12 PM
Date Last Visited	5 hours ago
Total Messages Posted	10
Likes Received	1

Top Badges Earned

Re: Tracking Unengaged Leads

Re: Munchkin code expiry

Re: Custom values using Velocity Scripting

Re: Pulling Custom Object data using Velocity Scri...

Re: Foreach velocity outputting the same values

Re: Foreach velocity outputting the same values

Foreach velocity outputting the same values

Re: Pulling Custom Object data using Velocity Scri...

Pulling Custom Object data using Velocity Script n...

Re: The global unsubscribe with multiple brands