Jayant_Singh
Level 2
Contact Me
| Online Status |
Offline
|
| Date Last Visited |
08-25-2020
08:05 AM
|
27
Posts
0
Likes
0
Solutions
07-19-2020
09:12 PM
Using JSON, it allows 300 records to update but looking for bulk update using CSV.
... View more
07-17-2020
05:39 AM
Our team want to update bulk lead via custom API. what will be correct JSON to update lead based on dedupe field as email address.
... View more
- Tags:
- database
Labels:
06-30-2020
06:04 AM
While data cleanup process, our team focus is to remove the data whom we have not target in last 2 years. And as per https://nation.marketo.com/t5/Knowledgebase/Marketo-Activities-Data-Retention-Policy-Overview-FAQ/ta-p/250750
data retention policy we came to know that it deletes activity after 25 months for Email send.
Problem- In lead activity, we still see email send details in 2016. We found this when setup the filter "Not was sent email" is any.
How can I justify this activity in Marketo?
... View more
- Tags:
Labels:
06-18-2020
07:49 AM
We have created a Marketo landing page with two hidden field in which one field(email) pre-filled is enabled and another field(unsub) is disabled.
Problem: - in database blank lead is being created. What are the possible scenario for this case when blank lead is created and how should it can be fixed?
... View more
- Tags:
- database
Labels:
06-12-2020
06:28 AM
Business need is to track UTM parameter details on non-Marketo landing page and to achieve this we have created one time process mytoken as well as used system campaign token. Now, our stakeholder also want to capture email name in the UTM parameter but they do not like mytoken approach as it is need to update every time when new email or program is created. Does anyone have alternate solution for this use case?
... View more
05-29-2020
03:17 AM
In a loop condition, for each item business need is to sort it twice.
#foreach( $myList_c in $sorter.sort($myList_cList, "date:desc") )
#set( $mySortedList = $sorter.sort( $myList, ["field1"] ) )
Considering, more than 1 millions data sets, will this behavior result into
1. email delivery to be delay more
2. soft bounces and campaign response result affected
... View more
Labels:
05-28-2020
07:11 AM
In CO list, there are total eight field in which one field is date and second field item type. Business requirement is to sort it based on item type first after that again sort it by date field type.
custom objects(default_c) ,
field
Date(date),
Item Type(itemType)
And, counter is running for up to two times. what will be best way to sort it again and again in Velocity script?
... View more
Labels:
05-25-2020
06:22 AM
Hi Sanford,
I was wondering if you have gone through the debug code and please let me know the details.
... View more
05-23-2020
12:32 PM
date class java.lang.String 2020-03-20 08:20:02
leadID class java.lang.String 1
productCTA class java.lang.String https://www.mdg.co.in/product/item.html
productID class java.lang.String 059130d0-b9a5-4691-9f85-4f94afdadffe
productImage class java.lang.String http://ta-sj29.marketo.com/rs/717-ICG-368/images/item.png
productName class java.lang.String item
date class java.lang.String 2020-04-21 08:20:02
leadID class java.lang.String 2
productCTA class java.lang.String https://www.mdg.co.in/product/item2.html
productID class java.lang.String 059130d0-b9a5-4691-9f85-4f94afdadffe
productImage class java.lang.String http://ta-sj29.marketo.com/rs/717-ICG-368/images/item2.png
productName class java.lang.String item1
date class java.lang.String 2020-05-22 08:20:02
leadID class java.lang.String 3
productCTA class java.lang.String https://www.mdg.co.in/product/item3.html
productID class java.lang.String 059130d0-b9a5-4691-9f85-4f94afdadffe
productImage class java.lang.String http://ta-sj29.marketo.com/rs/717-ICG-368/images/item3.png
productName class java.lang.String item2
[{date=2020-03-20 08:20:02, leadID=1, productCTA=https://www.mdg.co.in/product/item.html, productID=059130d0-b9a5-4691-9f85-4f94afdadffe, productImage=http://ta-sj29.marketo.com/rs/717-ICG-368/images/item.png, productName=item}, {date=2020-04-21 08:20:02, leadID=2, productCTA=https://www.mdg.co.in/product/item2.html, productID=059130d0-b9a5-4691-9f85-4f94afdadffe, productImage=http://ta-sj29.marketo.com/rs/717-ICG-368/images/item2.png, productName=item1}, {date=2020-05-22 08:20:02, leadID=3, productCTA=https://www.mdg.co.in/product/item3.html, productID=059130d0-b9a5-4691-9f85-4f94afdadffe, productImage=http://ta-sj29.marketo.com/rs/717-ICG-368/images/item3.png, productName=item2}]
... View more
05-22-2020
11:47 PM
{kv.getKey()} class java.lang.String 2020-03-23 08:20:02 {kv.getKey()} class java.lang.String 4 {kv.getKey()} class java.lang.String https://www.mdg.co.in/product/item4.html {kv.getKey()} class java.lang.String b1c1c49a-1545-3c38-a421-d3af748ac5c1 {kv.getKey()} class java.lang.String http://ta-sj29.marketo.com/rs/717-ICG-368/images/item4.png {kv.getKey()} class java.lang.String item3 {kv.getKey()} class java.lang.String 2020-04-24 08:20:02 {kv.getKey()} class java.lang.String 5 {kv.getKey()} class java.lang.String https://www.mdg.co.in/product/item6.html {kv.getKey()} class java.lang.String b1c1c49a-1545-3c38-a421-d3af748ac5c1 {kv.getKey()} class java.lang.String http://ta-sj29.marketo.com/rs/717-ICG-368/images/item6.png {kv.getKey()} class java.lang.String item4 {kv.getKey()} class java.lang.String 2020-05-20 08:20:02 {kv.getKey()} class java.lang.String 6 {kv.getKey()} class java.lang.String https://www.mdg.co.in/product/item5.html {kv.getKey()} class java.lang.String b1c1c49a-1545-3c38-a421-d3af748ac5c1 {kv.getKey()} class java.lang.String http://ta-sj29.marketo.com/rs/717-ICG-368/images/item5.png {kv.getKey()} class java.lang.String item5 [{date=2020-03-23 08:20:02, leadID=4, productCTA=https://www.mdg.co.in/product/item4.html, productID=b1c1c49a-1545-3c38-a421-d3af748ac5c1, productImage=http://ta-sj29.marketo.com/rs/717-ICG-368/images/item4.png, productName=item3}, {date=2020-04-24 08:20:02, leadID=5, productCTA=https://www.mdg.co.in/product/item6.html, productID=b1c1c49a-1545-3c38-a421-d3af748ac5c1, productImage=http://ta-sj29.marketo.com/rs/717-ICG-368/images/item6.png, productName=item4}, {date=2020-05-20 08:20:02, leadID=6, productCTA=https://www.mdg.co.in/product/item5.html, productID=b1c1c49a-1545-3c38-a421-d3af748ac5c1, productImage=http://ta-sj29.marketo.com/rs/717-ICG-368/images/item5.png, productName=item5}]
... View more
05-22-2020
02:58 PM
I am using only the debug code and removed everything from VTL.
#set( $coList = $pro_cList )
#foreach( $record in $coList )
#foreach( $kv in $record.entrySet() )
{kv.getKey()} ${display.alt($kv.getValue().class,"")} ${display.alt($kv.getValue(),"null")}
#end
#end
${coList}
In the template, I am using {{my.VTL}} to debug it now. is it ok now or need to add code more?
... View more
05-22-2020
01:28 PM
This is the one script product name where I added the code at the top.
<html>
<body>
<table>
#set( $coList = $pro_cList )
#foreach( $record in $coList )
#foreach( $kv in $record.entrySet() )
{kv.getKey()} ${display.alt($kv.getValue().class,"")} ${display.alt($kv.getValue(),"null")}
#end
#end
## start product name select
<tbody>
#set( $DEFAULT_Product = "No item in list." )
<tr>
#if( $pro_cList.isEmpty() )
#set( $outputName = $DEFAULT_Product )
#else
#foreach( $pro_c in $sorter.sort($pro_cList, "date:desc") )
#if( !$display.alt($pro_cList["productName"],"").isEmpty() )
#set( $outputName = $pro_c["productName"] )
#break
#end
#end
#set( $outputName = $display.alt($outputName, $DEFAULT_Product) )
#end
<td>
${outputName}
</td>
</tr>
</tbody>
</table>
</body>
</html>
is code placement is incorrect?
... View more
05-22-2020
12:55 PM
I have added the code in three ways
1. Full code at top after debug no change in previous email design.
2. Both end statement at last after debug nothing display.
3. Putting both end statement before output the ${outputName} and got below design
... View more
05-22-2020
12:28 PM
In the given code,
1. kv and record will be replaced with any property?
2. This code need to add in velocity script in starting
... View more
05-22-2020
11:50 AM
I have already selected that one but not sure why it is evaluating only default output this is the worry part and I am not starting macro unless I am sure that I can get output individually correct.
... View more
05-22-2020
04:18 AM
Hi San,
Before creating macro, I want to fetch the data for each field correctly. So, I am not able to find checked off condition for the script. Can you please suggest more in this?
... View more
05-21-2020
08:14 AM
I have imported a list of records to custom objects which contains data based on user visits in the website. By using this list trying to create email in Marketo. From CO list, selecting only recent visit of the product. In the given list, have product name, image, URL and recent visit date.
Problem- I have created three velocity script and sorting the list based on recent visit date. But, in email output is display incorrect.
Below three velocity script used for sorting the product name, image and URL.
Script-1
<html>
<body>
<table>
## start product image select
<tbody>
#set( $DEFAULT_Product = "No item in list." )
<tr>
#if( $pro_cList.isEmpty() )
#set( $outputItemimage = $DEFAULT_Product )
#else
#foreach( $pro_c in $sorter.sort($pro_cList, "date:desc") )
#if( !$display.alt($pro_cList["productImage"],"").isEmpty() )
#set( $outputItemimage = $pro_c["productImage"] )
#break
#end
#end
#set( $outputItemimage = $display.alt($outputItemimage, $DEFAULT_Product) )
#end
<td>
<img width="189" align="right" src="${outputItemimage}" border="0"/>
</td>
</tr>
</tbody>
</table>
</body>
</html>
Script-2
<html>
<body>
<table>
## start product name select
<tbody>
#set( $DEFAULT_Product = "No item in list." )
<tr>
#if( $pro_cList.isEmpty() )
#set( $outputName = $DEFAULT_Product )
#else
#foreach( $pro_c in $sorter.sort($pro_cList, "date:desc") )
#if( !$display.alt($pro_cList["productName"],"").isEmpty() )
#set( $outputName = $pro_c["productName"] )
#break
#end
#end
#set( $outputName = $display.alt($outputName, $DEFAULT_Product) )
#end
<td>
${outputName}
</td>
</tr>
</tbody>
</table>
</body>
</html>
Script-3
<html>
<body>
<table>
## start product URL select
<tbody>
#set( $DEFAULT_Product = "No item in list." )
<tr>
#if( $pro_cList.isEmpty() )
#set( $outputItemCTA = $DEFAULT_Product )
#else
#foreach( $pro_c in $sorter.sort($pro_cList, "date:desc") )
#if( !$display.alt($pro_cList["productCTA"],"").isEmpty() )
#set( $outputItemCTA = $pro_c["productCTA"] )
#break
#end
#end
#set( $outputItemCTA = $display.alt($outputItemCTA, $DEFAULT_Product) )
#end
<td>
<a href="${outputItemCTA}">Check out</a>
</td>
</tr>
</tbody>
</table>
</body>
</html>
... View more
Labels:
05-19-2020
01:28 AM
Wish you best of luck, Happy to see you in MOPsCON 2020!!! 😊
is the registration link are open now?
I will love to join and read advanced content management method when you published it I will subscribe the blog.
... View more
05-19-2020
12:31 AM
Thanks San! but, it seems to be someone has to be more expertise in VTL. Kindly, share any reference link to understand in depth with similar scenario.
... View more
05-18-2020
10:54 PM
Suggested method to use two velocity variable one in template level that will help to control the output but my purpose is to allow edit the variable value in email level as it offer when we create local variable in email template.
Although, velocity token can control output but not allow to edit variable at email level. To edit velocity variable value need to change the velocity token value each time which I want to avoid this limitations here.
... View more
05-18-2020
08:37 PM
Hi San,
May be my application is wrong. Could you please suggest possible way to achieve this business goal? or it has no options at all.
... View more
05-17-2020
09:10 PM
I have defined a variable within the email template and want to use that variable in velocity script. So, I am not sure about that email variable can be used in velocity or not?
Email Variable -
Email variable name is email_variable <meta class="mktoString" id="email_variable" mktoname="Button Link" default="mylink" mktomodulescope="true" />
Velocity Script code is
#if( $ObjectList.isEmpty() )
<a href="http://www.mywebsite.com?parameter=${email_variable}">read more</a>
#end
Business Goal- To enable email local variable edit section in Email when variable is used in VTL coding.
... View more
- Tags:
Labels:
05-15-2020
11:10 PM
I have found your article https://blog.teknkl.com/multiple-marketo-tracked-links-in-velocity/ but I can see you are not using https:// in VTL token but do you have written any additional blog to strip out url too?
... View more
05-15-2020
10:22 PM
So, If I start using #macro coding with loop conditions after sorting the url based on date filter there would be no issue. For example, as I have html block for three products A, B, C.
1. first I will sort the url for product A and use html block A. I will use only one utm tag i.e. for product link A only.
2. I will repeat same coding for Product B and C and will use one utm tag in each product. So, I will not get any issue in URL.
... View more
05-14-2020
09:48 PM
Hi Sanford,
I am starting my first code in VTL and have been assigned a scenario only. So, I am pretty much new and still learning.
Scenario:
In custom objects list, field-A has value as https://www.abc.com/product.png as a product image and field-B has value https://www.abc.com/productlink.html as product link and field-C has product name and field-D date and time. and other fields are used to store additional data.
Additionally, I have html block to use for field A,B,C
My approach before starting code:
Sorting custom objects list with field-D #set( $sortedList = $sorter.sort($customObjList,"date:desc") )
but after that, I am missing logic to use html block for field A,B,C because I have to add UTM tags as parameter in field-B so that it is traceable in google analytics. ?utm_tag=productlink so I am not sure whether to strip out the URL or not.
So, I am looking for better approach here only.
... View more
05-14-2020
04:42 AM
In custom objects list, capturing the URL as a string data type with https:// but when adding UTM parameters the in the link UTM details are not captured. And I came to know that need to strip out the https:// part from before importing either in custom objects or in email velocity script. Can anyone have the email velocity script implemented to strip out the URL https:// ?
kindly, share the any reference link to use $params
... View more
Labels:
Public Statistics
| Date Registered | 09-24-2019 02:52 AM |
| Date Last Visited | 08-25-2020 08:05 AM |
| Total Messages Posted | 27 |
.png)