Update 800 hyperlinks with UTM tracking

[cr06can]

My client would like to add tracking to all their hyperlinks across 7 files, between 800-2200 SKUs each. This is not a batch find and replace situation, UTM was never used up until this new request,  so I don't think IDML option will work.

Is there a way to batch add the UTM tracking to all hyperlinks?

[brianp311 · Accepted solution]

Assuming the UTM needs to be appended to the end of all existing Hyperlink URL Destinations in the document: 

var hlds = app.activeDocument.hyperlinkURLDestinations;
var utm = "?utm=blahblah";
for (var i = 0; i < hlds.length; i++) {
    hlds[i].destinationURL += utm; 
}

[cr06can]

Wow - Brian - brillant. Haven't worked with scripts very much. What/where exactly am I using this beautiful set of instructions?

[brianp311]

The above code is a jsx script. This explains how to install and use it. You'll need to run it on an open document (won't do all docs at once--that costs extra 😉 )

https://creativepro.com/how-to-install-a-script-in-indesign-that-you-found-in-a-forum-or-blog-post/

[cr06can]

Many thanks kind sir!

[cr06can]

Just had to fix a spelling mistake to make this script work. Thank you so very much!

Would this script also work to find and replace if they change the UTM info in the future?

[brianp311]

Sure, just change this line: 

hlds[i].destinationURL += utm; 

To this: 

hlds[i].destinationURL = hlds[i].destinationURL.replace("?=oldutm", "?=newutm");

Keep the double quotes 

[cr06can]

Once Again - thank you very much!