How to Query a Data Extension and Update the Subscriber list at the Child Business Unit Level without using landing pages?
2
-
What code set have you tried so far?– Kelly J AndrewsCommented Jun 11, 2014 at 2:23
-
I've only been able to update the subscribers table from landing pages that have ampscript in them. I this scenario I don't have any landing pages. I have a data extension that I need to query periodically and update the subscribers table w/o a landing page. How can I achieve this?– user8755Commented Jun 11, 2014 at 14:06
Add a comment
|
1 Answer
I know how I would do it, but the answer is what you would call "hacktastic". You will need to set up (within the email application):
- A query activity to get the data out of the data extension, and put it into a new results data extension.
- Data Extract Activity to get the data out of the results data extension and put it into the ET holding "tank".
- A File Transfer to get the file from the holding tank and move it to a more accessible folder.
- Another File Transfer activity to move it to the Import Folder (this may be optional depending on how #3 goes, but FT activites also deal with decrypting, unzipping, etc.).
- An Import Activity to import the subscribers list.
After all that is set up, you would toggle over to the automation studio application and set all these steps up in order there, as well as schedule the automation.
That should work. I hope this helps!
-
When the data extension was initially loaded with data the subscriber key was not available. I would like to update all rows in that data extension with the subscriber key (which will obviously be different for each row by reading the email addr). Can this be done using server side javascript activity?– user8755Commented Jun 17, 2014 at 13:57
-
-
When creating an import activity to update the Subscriber table, there is no option to update the unsubscribe date. You can only update Email Address (required), DONOTUSE, Status, HTML Email, Subscriber Key (required). Is there another way to update the unsubscribe date?– user8755Commented Jun 19, 2014 at 16:54
-
-