I have a DE that holds all of the subscribers to our email newsletter. What I need is a filter that will randomly take one subscriber from the DE and move it to a different DE. Most importantly, I need this filter to be automated to run and update once a week.
I know that there is the option to create a 'random data extension' and that works for the first part, but I cannot seem to find a way to do the automation part.
You can certainly use two Query Activities to select a random subscriber from a Data Extension and then exclude that subscriber from the final audience.
Something like this should work:
Random Sample
select top 1
s.emailAddress
from s.NewsletterSubscribers
order by newID()
/* target: NewsletterSubscribersControl */
/* action: overwrite */
Everyone else
select
s.emailAddress
from NewsletterSubscribers s
left join NewsletterSubscribersControl c on (c.emailAddress = s.emailAddress)
where c.emailAddress is null
/* target: NewsletterSubscribersDaily */
/* action: overwrite */
In order to automate, You need to change your approach. You can write query that can populate one row from source DE to target DE. This query can then scheduled using Automation Studio
