You created a DLL link that imports the destination URL from a relational table.

For example:

http://recp.yourdomain.com/ctt?m=%%MAILING_ID%%&rj=%%REPORT_ID_CODE%%&r=%%RECIPIENT_ID%%&b=0&j=%%JOB_ID_CODE%%&k=Link_Name&kx=1&kt=12&kd=%%1url%%?utm_source=SilverpopMailing&utm_medium=email&utm_campaign=%%MAILING_NAME%%&utm_content=%%WA_MAILINGLEVEL_CODE%%

The URL produced in the sent email is as follows (note the redacted data):

http://recp.yourdomain.com/ctt?m=0123456&r=xxRedactedxxS0&b=0&j=xxRedactedxxS0&k=Link_Name&kx=1&kt=12&kd=http://www.yourdomain.com/somefolder/anotherfolder?utm_source=SilverpopMailing&utm_medium=email&utm_campaign=your%20campaign%20Email(1)&utm_content=%%WA_MAILINGLEVEL_CODE%%

The URL resolves correctly but the append string from the end is missing:

http://www.yourdomain.com/somefolder/anotherfolder?utm_source=SilverpopMailing

It is missing the rest of the append string data:

&utm_medium=email&utm_campaign=your%20campaign%20Email(1)&utm_content=%%WA_MAILINGLEVEL_CODE%%

There are a number of possible causes for this issue. Try to URL encode the & where the append string breaks. The & symbol is %26. So your DLL constructed link in your template looks like:

http://recp.yourdomain.com/ctt?m=%%MAILING_ID%%&rj=%%REPORT_ID_CODE%%&r=%%RECIPIENT_ID%%&b=0&j=%%JOB_ID_CODE%%&k=Link_Name&kx=1&kt=12&kd=%%1url%%?utm_source=SilverpopMailing%26utm_medium=email%26utm_campaign=%%MAILING_NAME%%%26utm_content=%%WA_MAILINGLEVEL_CODE%%

You might find it necessary to URL Encode the & for all of the remaining instances after the initial break point. Test this solution by adding yourself to the database and creating a query to target your address, after which perform a live send by using the query as a contact source.

Note: When using Dynamic Link Leaders (DLLs), we encourage teams to follow security best practices. In order to minimize the risk of phishing attacks through manipulation of URL parameters, we advise teams to enable DLL Whitelisting for any domains used in URL redirects. Organization administrators can add domains to the DLL whitelisting from within the organization settings.