Salesforce Asked by CIouz on November 25, 2021
Is there a way in the subscriber data views to pull the QS parameter and tie it to the email address?
My preference page out of the box requires a link that looks like this:
http://click.mycompany.com/subscription_center.aspx?qs=1254d66fa63a4b547cd28f0acc9eb76e91214d6ee1406dbbe50aaebef0a990863543b31083477062c36b7ab7efb89c81facdf867248411da4c4bba974f9fca7ff784f77f3447928f
I am wondering if I can send this QS parameter along with the email address to an outside agency who needs to unsubscribe users to our marketing cloud preference center.
you can find most elements that the QS parameter encrypts individually, but you cannot find the encrypted form anywhere except in the email itself.
Starting from there: what you can do is log the value of the entire rendered link in a data extension at the time of send next to the email address. With some delay (e.g. hourly), you could send that link and the email address to an external system from the send log data extension. Real time during sendout, probably not as you would run into performance and reliability issues in case the connection breaks.
As a quick test: Set up a DE "logDE" with two fields, email and profilecenter. Add this to a message, send a preview out to yourself.
%%[
SET @profileURL = profile_center_url
SET @upsert = UpsertDE("logde",1,"email",emailaddr,"profilecenter",@profileURL)
]%%
Result: your email and your profile center link are in the data extension. Set up an hourly automation to do whatever you want with it.
Your sendout performance will be slowed technically, but not to an alarming extent, depending on the size of your sendouts, maybe not even noticeably so. Be sure to load test in case minutes matter for your sendouts, but generally speaking, this approach should work also for sendouts in the millions.
Answered by Jonas Lamberty on November 25, 2021
Get help from others!
Recent Questions
Recent Answers
© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP