Hello, everyone,
I have been following the tutorial on WordFly's website (https://support.wordfly.com/hc/en-us/articles/204768604-How-do-I-build-an-Abandoned-Cart-Triggered-Campaign-list-) regarding an automated campaign identifying individuals who have left items in their cart. If you follow it, it has you create some tables and procedures which I have done and are working well. If then gives you the following code to test:
select distinct customer.customer_no
from t_customer customer (NOLOCK)
join dbo.T_WEB_ORDER cart (NOLOCK)
on customer.customer_no = cart.customer_no
left outer join dbo.T_ORDER cart_order (NOLOCK)
on cart.order_no = cart_order.order_no
left outer join dbo.T_ORDER customer_order (NOLOCK)
on customer.customer_no = customer_order.customer_no and customer_order.order_dt > cart.order_dt
where (cart_order.order_no is null)
and (customer_order.order_no is null)
and (cart.order_dt >= DateAdd(dd,-1,Convert(varchar,GetDate(),112)+' 23:59:59'))
My question is this: Why not just create a dynamic list that contains the following code instead of writing to a table on a daily (for example) basis?
Would this not function just the same?
I use a list and it works fine for us. We've been doing it that way for a few years.
Thanks Melissa! Great to hear you have been doing it this way for a while.