Formulas / Expressions for Web Analytics (Brand Configuration)

Avatar

Avatar

davidh2892249

Avatar

davidh2892249

davidh2892249

07-09-2020

Hi All,

 

I would like to be able to output the "event date" in YYYY/MM format for my google analytics links, which are set up in a brand configuration.

 

I've configured like below, using expression ToString(Year(context.eventDate)+'/'+Month(context.eventDate))

davidh2892249_0-1599475581512.png

 

 

However, this returns the following error in the sending logs (with a status failed) when attempting to send a delivery.

Error while compiling script 'DM282[htmldefaultContent]' line 49: Year is not defined.

 

Seems I cannot use the date functions? (this type of expression worked fine on workflow worktable expressions)

 

Has anyone got any ideas as to how I can achieve event date in YYYY/MM for GA tracking?

 

Thanks

 

David

 

Accepted Solutions (0)

Answers (3)

Answers (3)

Avatar

Avatar

denisb91363072

Employee

Avatar

denisb91363072

Employee

denisb91363072
Employee

04-11-2020

Could you try syntax such as below? 

 

context.delivery.messageType.substring(0,2).toLowerCase()+':'+ context.delivery.executionType +':'+context.delivery.campaign.label+context.eventDate.getFullYear().toString().substring(2)+'-'+context.profile.location.countryCode.toLowerCase()+':'+context.cusExternalId + '::'

 

It should work....

Avatar

Avatar

Sukrity_Wadhwa

Employee

Avatar

Sukrity_Wadhwa

Employee

Sukrity_Wadhwa
Employee

16-09-2020

Hi @davidh2892249,

Was the given solution helpful or were you able to resolve this query with some other solution? Do let us know.

Thanks!

Avatar

Avatar

supratim1034

Avatar

supratim1034

supratim1034

09-09-2020

Although I have not tried, however, I have seen JS methods (and not inherent ACS method) working in that brand screen. So instead of Year() or Month() which are native to ACS, can you try something like getFullYear() and getMonth().

Please let me know if this actually works!