Adding a unique URL merge from a CDO to an email button
This works best when you take a long URL and splitting out the part that is static within the URL and the part that changes in each link its own column to upload to the CDO. In the example below "https://www.surveymonkey.com/r/YHBT3TF?ID=University%20of%20Wisconsin%20-%20Madison" is the same for every URL, so the shortened part is everything after the word Madison. That is what is in column F below for the SHORT URL.
This is what the input file will look like for the CDO upload:
Once this CDO data is uploaded, the next step is to make a new field merge for the shortened URL. Here is the set-up of that new field merge:
Next we need to set up the button on the email. In your email create a button and paste in the longer part of the URL that is the same for every recipient as the link for the button. In this example, this is:
https://www.surveymonkey.com/r/YHBT3TF?ID=University%20of%20Wisconsin%20-%20Madison
Next, use the "Insert" button and type in the name of the shortened unique URL field merge we created above. In our example, that short name is "Admin SHORT URL". This will append the personalized bit for the URL to the end of the link within the button. But this isn't going to work just yet!
Eloqua adds the tracking snippet to the button as soon as you click the "Insert" button on the last step. Therefore, that bit gets put in before the shortened snippet of the actual URL. The tracking code and the short snippet will have to be flip-flopped in order to function properly. The format needs to be:
Long static URL + Shortened URL snippet + Eloqua Tracking snippet
In the image below we need to move the part in blue BEFORE the Eloqua tracking code. It needs be copied and pasted in after the word "Madison" and before the "&elqTrack" section.
Here is how the URL should look at the end of this:
Long static URL + Shortened URL snippet + Eloqua Tracking snippet
