Burger King Portugal: Email & Push Opt In Segments
- Fisher, Luke
Totals
Users have been exported from Braze on 19.08 and the data analysed. A script has been prepared to bulk update all impacted users based on the conditions below. Please see the totals and conclusions below.
Condition CA = Custom Attribute NA = Native Attribute | # of Users | Status | Update | # of Users after update |
where CA marketingEmail = "False" or "false" and NA email_subscribe = "opted_in" | 9244 | UPDATE | NA email_subscribe = "unsubscribed" | 0 |
where CA marketingEmail = "False" or "false" and NA email_subscribe = "subscribed" | 767 | UPDATE | NA email_subscribe = "unsubscribed" | 0 |
where CA marketingEmail = "False" or "false" and NA email_subscribe = "unsubscribed" | 151313 | NO UPDATE |
| 161324 |
where CA marketingEmail = "True" or "true" and NA email_subscribe = "opted_in" | 1180451 | NO UPDATE |
| 1197795 |
where CA marketingEmail = "True" or "true" and NA email_subscribe = "subscribed" | 453 | UPDATE | NA email_subscribe = "opted_in" | 0 |
where CA marketingEmail = "True" or "true" and NA email_subscribe = "unsubscribed" | 16891 | UPDATE | NA email_subscribe = "opted_in" | 0 |
where CA marketingEmail = "on" and NA email_subscribe = "opted_in" | 3 | UPDATE | NA email_subscribe = "opted_in" | 3 |
where CA marketingEmail = "on" and NA email_subscribe = "subscribed" | 0 | UPDATE | NA email_subscribe = "opted_in" | 0 |
where CA marketingEmail = "on" and NA email_subscribe = "unsubscribed" | 1 |
|
| 1 |
where CA marketingEmail = "NULL" and NA email_subscribe = "opted_in" | 2404 | NO UPDATE |
| 2404 |
where CA marketingEmail = "NULL" and NA email_subscribe = "subscribed" | 866 | UPDATE | NA email_subscribe = "unsubscribed" | 0 |
where CA marketingEmail = "NULL" and NA email_subscribe = "unsubscribed" | 81 | NO UPDATE |
| 947 |
where CA marketingEmail = "True" or "true" | 1197795 |
| where NA email_subscribe = "opted_in" | 1197795 |
where CA marketingPush = "False" or "false" and NA push_subscribe = "opted_in" | 25258 | UPDATE | NA push_subscribe = "unsubscribed" | 0 |
where CA marketingPush = "False" or "false" and NA push_subscribe = "subscribed" | 4861 | NO UPDATE |
| 4861 |
where CA marketingPush = "False" or "false" and NA push_subscribe = "unsubscribed" | 1018589 | NO UPDATE |
| 1043847 |
where CA marketingPush = "True" or "true" and NA push_subscribe = "opted_in" | 304789 | NO UPDATE |
| 310411 |
where CA marketingPush = "True" or "true" and NA push_subscribe = "subscribed" | 2365 | UPDATE | NA push_subscribe = "opted_in" | 0 |
where CA marketingPush = "True" or "true" and NA push_subscribe = "unsubscribed" | 3257 | UPDATE | NA push_subscribe = "opted_in" | 0 |
where CA marketingPush = "on" and NA push_subscribe = "opted_in" | 3 |
|
| 3 |
where CA marketingPush = "on" and NA push_subscribe = "subscribed" | 0 |
|
| 0 |
where CA marketingPush = "on" and NA push_subscribe = "unsubscribed" | 0 |
|
| 0 |
where CA marketingPush = "NULL" and NA push_subscribe = "opted_in" | 30 | NO UPDATE |
| 30 |
where CA marketingPush = "NULL" and NA push_subscribe = "subscribed" | 3317 | UPDATE | NA push_subscribe = "unsubscribed" | 0 |
where CA marketingPush = "NULL" and NA push_subscribe = "unsubscribed" | 5 | NO UPDATE |
| 3322 |
where CA marketingPush = "True" or "true" | 310411 |
| NA push_subscribe = "opted_in" | 310411 |
Conclusion
The total number of users opted in to email will not decrease, we have 1,184,039 when checking in Braze directly as of 23.08
The total number of users opted in to push will not decrease, we have 312,975 users when checking in Braze directly as of 23.08