chriszeng

Hello! I'm trying to use Opportunity level data within my emails to let my contacts know who their Account Owner is. The trigger for the email campaign is based on if the Opportunity is updated to a new stage and the Account Owner information is not empty.    For the email script, I only have the below right now by pulling in the fields and checking them off. I don't really need anything other than the info from the fields for the specific triggered opp. When previewing a sample record with this info populated (even those with just one opp), I'm not seeing anything come through. Sample view of what I'm seeing in Marketo:   Edit Script Token 1 ${OpportunityList.get(0).Account_Owner_Name} 2 ${OpportunityList.get(0).Account_Owner_Email} 3 ${OpportunityList.get(0).Account_Owner_Phone}   In an ideal state, I'd love to show it in this format for only the opp related to the trigger event which would be the latest opp: Account Owner Name: [Account Owner Name field from the Opp level] and if empty, show nothing Account Owner Email: [Account Owner Email field from the Opp level] and if empty, show nothing Account Owner Phone: [Account Owner Phone field from the Opp level] and if empty, show nothing   Appreciate any eyes or help on this. Thank you! ... View more

Hi there,    We are receiving data in a string field that includes longitude and latitude information similar to the example below. As I'm new to scripting, I'm looking to understand how would I be able to pull out the x and y data to separate fields.   Additionally, the next step after would be to create a webhook with the Google Maps Geocoding API (or Reverse Geocoding) to spit out the Country of these coordinates: https://developers.marketo.com/webhooks/examples/   Field Name: Lead Data Field Value: {"company":"TEST" ,"description":"TEST DESCRIPTION" ,"x":-83.223971,"y":44.9009925,"Industry_Name":"Electronics","experiments":[]}   If anyone has advice on either the scripting or the geocoding webhook portion, I'd greatly appreciate it! ... View more