since ‎02-05-2018
‎10-12-2019
robertw937098
Level 2
MirrorPageURL Social Sharing Tracking Issue robertw937098 - Adobe Campaign Classic
Hi,I am unable to include the MirrorPageURL within my link. I am doing this for social sharing buttons. Please could you tell me how to do this?See below example:Share this link on TwitterThis works perfectly when I disable tracking, however when it is enabled the URL breaks. It turn into:http://r/?id=h6c952269,1136e6f,24674c3c&utm_medium=email&utm_source=trigger&utm_campaign=Rob_Test&utm_content=Rob_Test-1… Many thanks,Rob
856
Views
1
Like
1
Answers and Comments
Re: RestartTask Workflow SOAP Calls Failure robertw937098 - Adobe Campaign Classic
Amazing, thank you for the answer and quick response!That works now using the workflow PK, thought it was odd the error wanted an integer.This must be a mistake in the documentation!
977
Views
0
Likes
0
Answers
RestartTask Workflow SOAP Calls Failure robertw937098 - Adobe Campaign Classic
Hi,I am having an issues getting the below JavaScript to run. It continuously fails. Please could you assist?JavaScript CodeWithin the JavaScript code activity is the below script:xtk.workflow.RestartTask("WKF36072", "fork");Adobe Documentationhttps://docs.campaign.adobe.com/doc/AC/en/jsapi/sm-workflow-RestartTask.html?hl=restarttaskError logs12/12/2018 15:54:42 JavaScript: error while evaluating script 'WKF36344/js'.12/12/2018 15:54:42 Error while executing the method 'RestartTask' of service '...
1221
Views
0
Likes
3
Answers and Comments
Re: DaysDiff function with one date field? robertw937098 - Adobe Campaign Classic
Hi Garima,Thanks for your reply.Though I still have the same issue. My question is, how is it possible to do a DaysDiff(@OUT_DATE_DEP) function on all the data in one date field per recipient?For instance, something like... DaysDiff(row1.@OUT_DATE_DEP,row2.@OUT_DATE_DEP)E.g. The below customer has many out date dep dates.Many Thanks,Rob
2770
Views
0
Likes
1
Replies
Re: queryDef Script Instance Variable Problem! robertw937098 - Adobe Campaign Classic
Hi Nainy,I realised I have implemented this incorrectly as I targeting the date data from recipient level. Whereas, for accurate data I needed to change dimension to Journey level.My question is, how is it possible to do a DaysDiff(@OUT_DATE_DEP) function on all the data in one date field per recipient?E.g. The below customer has many out date dep dates.Many Thanks,Rob
2197
Views
0
Likes
1
Replies
Re: queryDef Script Instance Variable Problem! robertw937098 - Adobe Campaign Classic
I have fixed this, an integer defaults as 0 if there's no data. With the default 0 sums cannot be made. Therefore I used the below condition to insert a numerical 0 for sums.Iif(@difference1='',0,@difference1)
6385
Views
0
Likes
0
Replies
Re: queryDef Script Instance Variable Problem! robertw937098 - Adobe Campaign Classic
I see the cause. It's due to blanks in the journey fields.I am populating the differences fields with the days between the dates:
6385
Views
0
Likes
4
Replies
Re: queryDef Script Instance Variable Problem! robertw937098 - Adobe Campaign Classic
Thanks for checking. The difference fields are all Integer (32 bit) format.
6385
Views
0
Likes
0
Replies
Re: queryDef Script Instance Variable Problem! robertw937098 - Adobe Campaign Classic
Thanks a lot, this is really helpful. One issue left...To troubleshoot, I'm doing the total then average in separate enrichment actives. When I do this total expression (@difference1+@difference2+@difference3+@difference4+@difference5) the total column returns 0 when some of the columns are 0, as you can see in the below data.E.g. 10 + 10 + 0 = 0. Whereas, it should return 20.Do you know how to resolve this?Thanks,Rob
6385
Views
0
Likes
7
Replies
Re: queryDef Script Instance Variable Problem! robertw937098 - Adobe Campaign Classic
Thanks Nainy Jain for responding.I need to calculate the average for three different fields. As far as I'm aware, the aggregate functions only allow one field. This is why I attempted it via JavaScript.Is it possible to work out the average with 3 different fields? What's the syntax?If not, how can I stop the code from overwriting?Many thanks,Rob
6385
Views
0
Likes
9
Replies
queryDef Script Instance Variable Problem! robertw937098 - Adobe Campaign Classic
Hi,Are you able to help with the below script please? I have created an integer instance variable called 'Average'. The problem is that variable is outputting the same value for all rows. Rather than working out the average and giving that value to each recipient.The calculations are correct, but it only outputs the value for one row then gives rows that value. E.g. In the below screenshot all rows are given 110 for Average. This is correct for the bottom customer, but not the top. Hope that mak...
6993
Views
1
Like
11
Replies
Re: How to targetData from QueryDef alias? robertw937098 - Adobe Campaign Standard
Thanks Vipul, that's very helpful.Are you able to help with the below script please? My issue is the 'Average' (integer) instance variable is giving the same value for all rows. Rather than working out the average and giving that value to each recipient.The calculations are correct, but it only outputs the value for one row then gives rows that value. E.g. In the below screenshot all rows are given 110 for Average. This is correct for the bottom customer, but not the top. Hope that makes sense.v...
1529
Views
0
Likes
0
Answers
Re: Workflow instance variables! robertw937098 - Adobe Campaign Standard
Thank you!
1625
Views
0
Likes
0
Answers
Workflow instance variables! robertw937098 - Adobe Campaign Standard
Hi,Using an enrichment, I'm creating a custom instance variable in a workflow. As shown below.However, the issue is that this field defaults to a string. I need it as a number. How can I change the data type to be a number?Thanks,Rob
3706
Views
0
Likes
3
Answers and Comments
Re: How to targetData from QueryDef alias? robertw937098 - Adobe Campaign Standard
Hi Vipul,How can I make an instance variable a number data type?It seems to default to a string.Thanks,RobVipul Raghav​
1541
Views
0
Likes
0
Answers
DaysDiff function with one date field? robertw937098 - Adobe Campaign Classic
Hi,How can I calculate the days difference (using the daysdiff function) on one date field? Preferably for the most recent 3/4 dates in the field.BACKGROUND: I need to know the days between each customers multiple journey dates for a campaign. Then work out the average of this number.Many thanks,Rob
3189
Views
1
Like
3
Replies
Working out average days between date ranges robertw937098 - Adobe Campaign Standard
Hi,I have received a brief which requires me to work out the average number of days between a customers previous 4 journey departure dates.Is this possible using an enrichment? Or is a script required?Please assist.See below screenshot of example date data.Many thanks,Rob
607
Views
0
Likes
0
Answers and Comments
Re: How to targetData from QueryDef alias? robertw937098 - Adobe Campaign Standard
This worked. Thanks a lot!I was hoping the JavaScript would create the targetData field without needing an enrichment.
1541
Views
0
Likes
0
Answers
How to targetData from QueryDef alias? robertw937098 - Adobe Campaign Standard
Hi,I'm attempting to display the result of the 'seasons' alias in a delivery using targetData. However the delivery fails due to 'targetData not defined'.Please can you tell me how it's possible to do this?The workflow appears as below:The JavaScript logs the count correctly:I there a specific way to target an alias from a queryDef in the delivery?Many thanks,RobJAVASCRIPTvar query = xtk.queryDef.create( ).ExecuteQuery();var results = query.query2;logInfo("Count: " +results.seasons);DELIVERYS...
4627
Views
0
Likes
7
Answers and Comments
Likes from