glitch: rules are reaching again the same lead / How to A/B testing?

[leandrosardi]

[leandrosardi]

Query to find them

select l.first_name, l.last_name, p.name, o.create_time, o.done_time, o.direction, o.body 
--select count(distinct i.id) as instances, count(distinct l.id) as leads, count(distinct o.id) as outreaches
from "lead" l 
join "outreach" o on l.id=o.id_lead
join "profile" p on p.id=o.id_profile 
order by l.first_name, l.last_name, o.create_time

[leandrosardi]

Research Query

select o.create_time, o.status, o.direction, r.name, r.delete_time, o.body
from "lead" l
join "outreach" o on l.id=o.id_lead
left join rule_instance i on i.id=o.id_rule_instance 
left join "rule" r on r.id=i.id_rule 
join "profile" p on (
    p.id=o.id_profile and
    p.id='81b95798-85cd-4c7f-ab42-76067b71a229'
)
where l.id='4afe62b2-2f7a-451f-ac39-53377ad2ace5' -- Shaun Coe
order by o.create_time

[leandrosardi]

Diagnosis

Two rules were created for sending the first cold emails, to manage 2 versions of messages.

This is not a glitch, but a feature request: "How to manage A/B testing".