0

I have one dynamic content block that is filtered off a field in a data extension, but another that I want to be a random selection of 2 options.
Sort of an A/B test, if you will.

Is there a way to support this without having to do some kind of filtering based on subscriber_key or email_address starting with 'a-l' and 'm-z'?

The desire is for it to be truly randomized (but with a 50/50 split).

  • Can you utilize the A/B content block? This sounds like a perfect use case. – Gortonington Feb 6 '18 at 20:56
1

I would create two data extensions from the Source DE, and use ampscript (or Dynamic content) to serve the content.

i.e

/* First 50% call this DE1 */ 

SELECT TOP (50) PERCENT
Column1
,Column2
,Column3
, Content1 AS Content

FROM SourceDE

/* Save this as DE 2 */
SELECT 
Column1
,Coulmn2
,Column3
,Content2  AS Content

FROM SourceDE s
LEFT JOIN DE1 d
ON s.Column1 = d.Column1

WHERE d.Column1 IS NULL

Place these two queries in an automation and set it to overwrite.

I would then use DE1 and DE2 in my sends ,

Using the logic in this pseudo code:

if Content == Content1, Send Variation A
If Content == Content 2 , Send Variation B
  • The source data extension is not a static group but grows everyday. It's a welcome journey. Your solution would require two journey's with a similar path, no? – Tom Callahan Feb 6 '18 at 19:54
  • If you refresh the automation every day then it would take a random 50% of the entire population. Have you looked at Random Splits if you are using Journey Builder? – Samuel Dare Feb 6 '18 at 21:22

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.