Hi Alistair,I am sure you are counting unique clicks from you tracking logs, please double check if you are counting unique or all?Consoldated logs count all clciks not just uniue clcoks. i.e.,Sum of all @totalClicks with a URL type equal to "Email click"(sum(Iif([url/@type]=1, @totalClicks, 0))).Mo...

Hi Abhijit,you can use below script to get your labels in a given delivery.var linkList = delivery.content.html.source.match(new RegExp('<a(.*)>', "g")); for(var link in linkList){ var linkLabel = "" ;    if(link.match(new RegExp('_label="[^"]+"', "g"))){      linkLabel = link.match(new RegExp('_lab...

hi Saikat,data-nl-* are data attributes used by out of the box js library to map personalization data from your schema to form. data-nl-ismandatory: represent if you are using the required file in your schema or form(Form will take priority)data-nl-label: Represent value of your schema fields label ...

Hi Priyanka,nms:deliveryLogStats is an aggregate built on top of all deliveries sent from Adobe campaign, you can use this to query per delivery basis or more than one delivery basis."Deliveries" Link from "nms:deliveryLogStats" mentioned above, will be used for filtering for your purpose.You can us...

Hi Priyanka,Schema Name: nms:deliveryLogStatsrefer to its columns for more information, write a workflow to fetch the data from this table and process the format as per your requirements.TablesNmsDeliveryLogStatsLabelDescriptionAmountAmountItemItemCanceledCanceledMessages that were clickedMessages t...

Hi Priyal,I am not sure if you can solve your problem with J-Serge's response, but if you are still looking for the same, please refer to below list of the variables you can use in context in your script fro standard reports.    Name of a variableDescriptionExample of a value_reportContextInternal n...

Hi Erik,Use this: var schemaName = vars.targetSchema.substr(vars.targetSchema.indexOf(":") + 1);    logInfo(schemaName);      var query = xtk.queryDef.create(      <queryDef schema={vars.targetSchema} operation="select">        <select>          <node expr="@id"/>          <node expr="@description"/...

Hi Nidhi,it's not clear from the question can you please share the screenshot to support what you want?Regards,Amit

Hi Alistair,I did a bit of research about the end of line chars, I didn't test my solution with UTF-8 or latin encoding though but as per this ticket in StackOverflow it should work with both system with CRLF option as CR is supported in windows and LF in Unix so as per definition CRLF should transl...

Hi Sourabh,build your workflow like this:use above instance variables to update final update for success and rejected.You can add your remaining code success js and use in an update.Regards,Amit