Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

robertw937098
Community profile robertw937098 Level 2
Job title here
Location here
3 BADGES
Level 2

Level 2

Learn more
Joined the community 02-05-2018 3:08:08 AM
Offline
Top badges earned by robertw937098
Customize the badges you want to showcase on your profile
MirrorPageURL Social Sharing Tracking Issue
Avatar
Validate 1
Level 2
robertw937098
Level 2

Likes

3 likes

Total Posts

19 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 3
Boost 1
View profile
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

Views

984

Like

1

Replies

1
Re: RestartTask Workflow SOAP Calls Failure
Avatar
Validate 1
Level 2
robertw937098
Level 2

Likes

3 likes

Total Posts

19 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 3
Boost 1
View profile
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!

Views

1.1K

Likes

0

Replies

0
RestartTask Workflow SOAP Calls Failure
Avatar
Validate 1
Level 2
robertw937098
Level 2

Likes

3 likes

Total Posts

19 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 3
Boost 1
View profile
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 '...

Views

1.4K

Likes

0

Replies

3
Re: DaysDiff function with one date field?
Avatar
Validate 1
Level 2
robertw937098
Level 2

Likes

3 likes

Total Posts

19 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 3
Boost 1
View profile
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

Views

3.0K

Likes

0

Replies

1
Re: queryDef Script Instance Variable Problem!
Avatar
Validate 1
Level 2
robertw937098
Level 2

Likes

3 likes

Total Posts

19 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 3
Boost 1
View profile
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

Views

2.3K

Likes

0

Replies

1
Re: queryDef Script Instance Variable Problem!
Avatar
Validate 1
Level 2
robertw937098
Level 2

Likes

3 likes

Total Posts

19 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 3
Boost 1
View profile
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)

Views

6.8K

Likes

0

Replies

0
Re: queryDef Script Instance Variable Problem!
Avatar
Validate 1
Level 2
robertw937098
Level 2

Likes

3 likes

Total Posts

19 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 3
Boost 1
View profile
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:

Views

6.8K

Likes

0

Replies

4
Re: queryDef Script Instance Variable Problem!
Avatar
Validate 1
Level 2
robertw937098
Level 2

Likes

3 likes

Total Posts

19 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 3
Boost 1
View profile
robertw937098
- Adobe Campaign Classic
Thanks for checking. The difference fields are all Integer (32 bit) format.

Views

6.8K

Likes

0

Replies

0
Re: queryDef Script Instance Variable Problem!
Avatar
Validate 1
Level 2
robertw937098
Level 2

Likes

3 likes

Total Posts

19 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 3
Boost 1
View profile
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

Views

6.8K

Likes

0

Replies

7
Re: queryDef Script Instance Variable Problem!
Avatar
Validate 1
Level 2
robertw937098
Level 2

Likes

3 likes

Total Posts

19 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 3
Boost 1
View profile
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

Views

6.8K

Likes

0

Replies

9
queryDef Script Instance Variable Problem!
Avatar
Validate 1
Level 2
robertw937098
Level 2

Likes

3 likes

Total Posts

19 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 3
Boost 1
View profile
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...

Views

7.4K

Like

1

Replies

11
Re: How to targetData from QueryDef alias?
Avatar
Validate 1
Level 2
robertw937098
Level 2

Likes

3 likes

Total Posts

19 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 3
Boost 1
View profile
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...

Views

1.8K

Likes

0

Replies

0
Re: Workflow instance variables!
Avatar
Validate 1
Level 2
robertw937098
Level 2

Likes

3 likes

Total Posts

19 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 3
Boost 1
View profile
robertw937098
- Adobe Campaign Standard
Thank you!

Views

2.2K

Likes

0

Replies

0
Workflow instance variables!
Avatar
Validate 1
Level 2
robertw937098
Level 2

Likes

3 likes

Total Posts

19 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 3
Boost 1
View profile
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

Views

4.3K

Likes

0

Replies

3
Re: How to targetData from QueryDef alias?
Avatar
Validate 1
Level 2
robertw937098
Level 2

Likes

3 likes

Total Posts

19 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 3
Boost 1
View profile
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​

Views

1.8K

Likes

0

Replies

0
DaysDiff function with one date field?
Avatar
Validate 1
Level 2
robertw937098
Level 2

Likes

3 likes

Total Posts

19 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 3
Boost 1
View profile
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

Views

3.4K

Like

1

Replies

3
Working out average days between date ranges
Avatar
Validate 1
Level 2
robertw937098
Level 2

Likes

3 likes

Total Posts

19 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 3
Boost 1
View profile
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

Views

746

Likes

0

Replies

0
Re: How to targetData from QueryDef alias?
Avatar
Validate 1
Level 2
robertw937098
Level 2

Likes

3 likes

Total Posts

19 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 3
Boost 1
View profile
robertw937098
- Adobe Campaign Standard
This worked. Thanks a lot!I was hoping the JavaScript would create the targetData field without needing an enrichment.

Views

1.8K

Likes

0

Replies

0
How to targetData from QueryDef alias?
Avatar
Validate 1
Level 2
robertw937098
Level 2

Likes

3 likes

Total Posts

19 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 3
Boost 1
View profile
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...

Views

5.0K

Likes

0

Replies

7
Likes from