What are the excel formulas for Excel question #2-4 (Bordered in RED)?

A B D E F G 1 J K L M N 0 Q R S T U V W 1 Male Female Total 2 Email ID Time of Day Offer S1 S2 S3 Delivered Opened Open Rate Clicks Click Rate Delivered Opened Open Rate Clicks Click Rate Total Recipients Bounced Unopened Opened Open Rate Clicks Click Rate 3 1 4 5 3 1 6 89 5 5.6% 1 1.1% 148 32 21.6% 5 3.4% 250 13 200 37 27.2% 6 4.5% 4 2 4 3 8 4 7 89 15 16.9% 1 1.1% 148 15 10.1% 7 4.7% 250 13 207 30 27.0% 8 5.9% 5 3 2 2 7 2. 9 89 21 23.6% 5 5.6% 148 11 7.4% 3 2.0% 250 13 205 32 31.0% 8 7.6% 6 4 3 6 2 10 8 88 6 6.8% 2. 2.3% 148 30 20.3% 7 4.7% 250 14 200 36 27.1% 9 7.0% 7 5 1 4 4 1 3 87 6 6.9% 0 0.0% 148 32 21.6% 9 6.1% 250 15 197 38 28.5% 9 6.1% 8 6 2 1 10 3 5 86 25 29.1% 4 4.7% 147 17 11.6% 2. 1.4% 250 17 191 42 40.6% 6 6.0% 9 7 3 1 8 7 10 86 25 29.1% 4 4.7% 147 21 14.3% 9 6.1% 250 17 187 46 43.4% 13 10.8% 10 8 1 5 1 8 3 84 3 3.6% 1 1.2% 147 24 16.3% 5 3.4% 250 19 204 27 19.9% 6 4.6% 11 9 3 4 6 9 1 84 5 6.0% 1 1.2% 147 54 36.7% 11 7.5% 250 19 172 59 42.7% 12 8.7% 12 10 2 2. 9 3 8 84 18 21.4% 7 8.3% 147 10 6.8% 3 2.0% 250 19 203 28 28.2% 10 10.4% 13 11 3 5 7 9 5 84 26 31.0% 3 3.6% 147 15 10.2% 2 1.4% 250 19 190 41 41.2% 5 4.9% 14 o 12 3 5 2 10 1 84 5 6.0% 1 1.2% 146 23 15.8% 6 4.1% 250 20 202 28 21.7% 7 5.3% 15 13 2 3 4 w 3 6 84 4 4.8% 0 0.0%) 146 28 19.2% 6 4.1% 250 20 198 32 23.9% 6 4.1% 16 14 3 2. 5 6 10 84 3 3.6% 1 1.2% 146 30 20.5% 8 5.5% 250 20 197 33 24.1% 9 6.7% 17 15 4 2 2 5 7 84 2 2.4% 0 0.0% 146 39 26.7% 8 5.5% 250 20 189 41 29.1% 8 5.5% 18 16 1 6 1 3 84 2 2.4% 1 1.2% 146 27 18.5% 6 4.1% 250 20 201 29 20.9% 7 5.3% 19 20 21 Offer 22 BOGO Coding Key Time of Day 1 Early Morning 2 Late Morning 3 Afternoon 4 Evening 5 23 Participating Group Members: Alex Mongkhonvilay, Ben lannazzo, Kimberly Reusch, Alize Tyler Question 1 Which recipients should be removed from the email list? Hard bounces: 6, 27, 69, 78, 81, 93, 108, 110, 145, 160, 191, 209 230 Multiple soft bounces in a row: 14, 21, 24, 32, 135, 139, 244 No response for two months: 22, 33, 58, 99, 107, 127, 128, 146, 148, 164, 172, 184, 195, 216, 224, 231, 237 Section Women's athletic shoes Women's dress flats Women's high heels Women's sandals Women's slippers 20% off 30% of 50% off New 24 25 26 Question 2 What is the best time of day to send emails? G G H L M N N P R S U U V 84 2 1 146 27 6 250 20 201 29 7 Question 1 Which recipients should be removed from the nail list? Hard bounce Multiple salt bounces in a row No response for two months Why do you think that is? Question 2 What is the best time of day to send emails? Time of Day Open Rate Click Rata Early Maming Late Morning Afternoon Evening A B D E E F 18 16 1 6 1 3 19 20 Codine Key 21 Time of Day oller Section 22 1 Early Morning BOGO Women's athletic shoes 23 Zlate Morning 20% oll Women's dresses 241 3 3 Alternoon 30% oll Women's high heels 25 4 Evening 50% off Women's sandals 26 New Women's slippers 27 Free shippir Women's boots 28 7 Men's athletic shoes 29 8 Men's Sandals 30 9 Men's dress shoes 31 10 Men's boots 32 33 34 Response Key Gender 35 O Delivered, unopened Oferrale 35 1 Hard bounce 1 Male 37 2 2 Soft bounce 38 3 Delivered, opened 39 4 Section 1 clicked 40 5 Section 2 clicked 41 6 Section 3 clicked 42 43 44 45 46 47 48 49 50 51 52 which offers generate the best response? Open Rate Click Rate Why do you think that is? Question 3 Offer BOGO 20% off 30% off Sos. aff New products Free shipping Question 4 Snappas is looking to segment this email list. Should they put men in one segment and women in the other and only send emails featuring the proper gendered shoe ta those lists? Open Rates Explain why gender gender Females Males Click Rate gender gender Females Males A F G H J K L M N 0 R S T T P Q Email 12 Email 13 1 Email 2 Email 3 Email 4 Email 5 Email 6 Email 7 Email 8 Email 9 Email 10 Email 11 Email 14 Email 15 Email 16 2 0 0 0 B C D E Gender Opens Clicks Clicks Email 1 0 3 1 1 1 0 0 2 2 0 3 2 3 4 Recipients 1 2 2 3 0 0 0 0 0 0 3 0 0 0 0 0 0 0 0 0 0 0 0 0 3 0 0 3 0 0 4 0 0 0 4 0 0 4 0 0 0 0 0 0 0 0 0 0 0 0 0 0 5 4 3 0 0 0 0 0 0 0 4 0 0 6 0 3 5 0 6 3 0 0 4 3 . 1 0 0 0 . 1 5 4 4 0 0 0 1 4 0 0 . 1 3 1 . 7 6 0 0 0 1 1 0 . 1 0 1 1 1 1 1 1 1 1 3 8 7 4 0 0 0 0 0 0 0 0 3 0 0 3 3 9 8 1 0 0 0 0 0 U 0 0 0 0 0 0 0 0 0 0 0 0 1 1 . 1 .. 0 0 0 0 3 0 0 U 0 10 9 2 0 0 0 0 0 0 3 0 0 0 0 0 10 4 0 3 0 0 0 0 0 3 U 0 0 3 11 40 12 13 0 . 3 11 0 0 1 0 0 0 3 0 0 0 0 0 0 0 0 0 0 0 0 . 1 . 1 0 0 0 0 0 0 0 3 0 0 0 0 0 3 3 3 0 0 0 0 0 0 4 14 3 1 0 3 0 0 0 0 0 0 0 3 0 0 0 0 0 15 1 1 1 0 0 0 0 0 0 2 2 2 2 z Z 12 13 14 15 16 . 17 18 2 0 2 0 2 0 0 0 2 0 0 0 0 0 0 3 0 0 0 0 0 0 16 - 17 0 3 0 0 1 0 0 0 0 0 0 3 0 3 0 0 0 0 3 0 . 1 0 0 3 0 3 1 0 0 3 0 0 0 0 0 0 0 0 18 10 19 3 0 0 0 0 0 1 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 3 0 0 20 19 1 2 0 0 0 0 0 0 0 0 3 0 0 3 0 0 0 0 0 21 20 0 4 0 0 0 3 3 0 3 0 0 0 0 3 0 0 0 0 21 1 1 0 2 2. 2 2 2 2 2 2 22 23 0 0 3 0 0 1 0 2 0 0 0 0 0 0 0 0 0 0 0 0 0 2 2 0 0 2 22 23 0 0 0 0 0 2 2 0 2 U 0 2 0 0 0 0 0 0 24 1 0 0 0 3 0 0 0 3 3 2 2 0 0 24 1 0 0 0 0 2 2 2 2 2 0 2 2 0 2 2 o 2 2 2 0 0 25 1 0 0 0 0 0 0 0 3 0 0 0 3 4 3 0 0 3 0 0 0 0 3 25 26 27 28 29 30 0 1 1 0 0 0 0 3 0 1 3 0 0 0 0 0 0 1 0 3 1 1 26 0 27 0 28 1 1 29 1 30 1 1 0 1 0 0 0 0 0 0 0 1 1 1 3 3 1 1 3 3 0 1 1 0 0 0 1 0 0 0 0 1 3 3 0 1 1 0 1 0 1 0 0 4 0 0 0 0 0 0 0 0 0 2 0 0 0 0 0 0 3 0 0 0 0 0 0 0 31 1 1 0 0 5 0 0 0 0 0 0 0 0 0 0 32 31 1 1 1 1 0 0 0 0 0 0 0 5 0 0 0 0 0 0 0 33 1 0 0 0 0 0 0 0 2 2 2 2. 2 2 32 33 31 2 0 0 0 0 0 U 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 0 1 0 0 0 0 0 0 0 0 3 3 1 0 34 35 36 37 38 3 0 1 1 0 0 0 0 0 3 3 2 0 0 0 0 0 0 0 0 0 3 3 o 0 "! 4 0 0 0 0 0 0 0 3 3 3 0 35 36 0 1 0 0 3 3 3 0 0 0 0 0 0 0 0 0 o 0 3 3 0 0 0 0 0 3 0 0 0 0 0 1 3 2 0 4 0 0 0 0 0 0 3 0 0 0 6 37 38 39 1 1 0 0 0 0 0 0 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 40 39 0 4 0 3 0 0 3 0 0 0 3 3 0 0 0 3 0 0 0 3 3 41 3 0 0 3 0 0 0 0 0 3 0 0 0 0 42 0 0 0 0 0 0 0 0 0 0 0 0 40 1 41 1 1 42 0 43 0 0 0 0 0 4 0 0 0 4 0 0 0 0 0 0 0 0 0 0 0 43 5 0 0 0 0 0 0 0 3 0 0 0 0 0 0 4 0 0 4 0 0 0 0 0 0 4 4 0 0 44 1 0 0 0 0 0 0 0 3 0 + Email Cryin Deliverability Insights Questions TEST - U1 A B C D C G H 1 J K L M M N P 0 R T 1 Recipients Gender Opens Clicks Email 1 Email 2 Email 3 Email 4 Email 5 Email 6 Email 7 Email 8 Email 9 Email 10 Email 11 Email 12 Email 13 Email 14 Email 15 Email 16 44 1 0 0 0 0 0 0 0 0 0 0 0 0 0 43 44 45 0 0 0 0 0 0 0 0 1 3 0 0 0 0 0 0 0 0 0 0 0 45 46 3 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 2 1 0 0 0 3 0 0 4 0 0 47 0 0 0 46 0 4 0 0 0 0 0 0 0 3 0 0 0 0 3 0 3 0 3 0 48 47 1 3 0 0 0 0 0 3 0 0 3 0 0 0 0 3 3 0 0 49 0 4 3 3 0 0 0 0 3 0 4 0 0 0 0 0 4 48 49 50 50 0 0 0 0 0 0 0 4 1 0 0 0 0 0 3 3 4 0 0 0 3 0 0 0 0 0 0 0 0 0 0 0 0 3 3 3 0 0 3 0 3 3 3 51 0 2 0 0 0 0 0 0 0 0 51 0 2 0 0 0 0 0 0 0 0 0 0 0 0 3 0 0 52 53 54 52 1 3 1 0 0 0 0 0 0 0 0 0 0 0 0 0 3 0 3 0 4 4 0 0 0 0 53 1 0 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 4 0 0 55 0 3 0 0 5 0 0 0 0 54 55 2 0 0 0 0 0 6 3 3 3 0 56 0 0 0 0 3 3 0 1 0 0 2 2 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 3 3 0 0 57 56 0 0 0 0 0 0 0 0 0 0 3 0 0 5 0 0 0 0 0 0 0 0 3 0 0 0 0 0 58 57 1 1 0 0 0 0 0 0 0 0 0 0 59 58 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 60 59 0 3 1 0 0 0 0 0 0 3 0 0 0 0 0 0 0 4 0 0 0 3 0 61 60 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 62 61 0 3 1 0 3 0 0 4 4 0 0 0 63 0 0 0 62 1 0 0 0 0 4 0 0 0 0 3 0 0 0 3 0 0 0 0 3 0 0 3 4 3 3 0 0 0 0 3 0 3 0 0 0 0 0 0 64 G3 1 1 0 0 0 0 0 0 0 65 64 1 3 5 3 3 2 0 0 0 0 3 3 5 0 0 0 0 0 0 3 4 0 0 0 0 66 65 0 1 0 0 0 0 3 0 0 0 0 0 0 0 0 0 3 67 66 0 3 1 0 0 0 4 0 0 0 0 0 0 3 0 3 0 0 0 0 0 68 5 0 0 0 67 0 3 0 0 0 3 0 0 0 3 0 3 0 0 0 69 68 0 1 1 1 0 0 0 4 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 70 69 1 0 0 0 1 1 1 1 1 1 1 1 1 1 1 1 1 0 0 71 1 1 0 0 3 0 0 0 0 0 0 1 1 0 0 0 0 0 0 0 0 0 0 72 0 0 0 0 1 1 0 0 0 0 0 0 0 0 0 70 71 72 73 74 1 1 0 0 0 0 0 0 0 0 0 0 0 73 2 0 0 0 0 0 3 0 0 0 3 0 0 0 0 74 0 0 0 0 0 0 0 0 0 0 0 3 3 0 0 0 0 1 4 75 1 0 0 3 0 0 0 0 0 0 3 3 0 Gmail 0 0 3 0 0 0 76 75 0 0 0 0 0 0 3 3 3 3 0 0 0 3 3 3 0 0 0 77 2 0 0 0 3 0 0 0 0 0 0 0 0 76 77 0 0 1 1 0 78 0 0 0 0 0 0 0 1 0 0 0 0 3 3 3 3 1 0 2 0 0 0 0 0 3 1 0 0 1 0 0 0 1 1 0 0 0 1 0 0 0 1 79 78 0 1 1 1 1 1 1 1 1 1 80 1 0 0 79 0 5 3 3 3 0 0 4 6 4 3 0 0 0 0 0 0 0 81 80 0 2 0 0 3 0 0 0 0 0 0 3 3 0 0 0 0 0 0 0 0 0 1 82 81 1 0 0 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 83 82 1 1 0 0 0 0 0 0 0 0 0 84 0 0 0 0 0 0 0 3 0 0 0 0 3 83 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 0 0 1 2 0 0 0 3 0 0 0 0 0 0 0 0 0 85 84 1 0 0 4 0 0 0 0 0 + = Email Overview - Deliverability Insights - Questions - TEST - f A B D E F F G G H H 1 K L M N 0 P 0 R S T 1 Recipients Gender Email 2 Email 3 Email 4 Email 5 Email 6 Email 7 Email 8 Email 9 Email 10 Email 11 Email 12 Email 13 Email 14 Email 15 Email 16 Opens Clicks Email 1 2 2 1 85 84 0 0 0 0 0 0 4 0 3 0 0 0 0 0 0 0 0 86 85 0 3 0 3 0 0 3 0 0 0 3 0 0 0 0 0 0 0 0 0 0 0 0 87 86 1 2 2 0 0 5 0 0 0 0 0 0 4 0 0 0 0 0 88 87 0 5 4 4 0 4 0 0 0 0 3 4 0 0 0 0 89 1 6 2 1 0 0 0 0 5 0 0 0 88 89 0 4 1 1 0 0 3 4 4 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 90 1 0 0 0 0 0 91 90 0 6 0 0 0 3 3 3 0 3 3 0 0 0 0 0 0 0 0 3 92 91 0 3 0 0 0 0 0 0 3 0 3 0 0 U 0 0 93 92 0 3 3. 0 0 0 0 0 0 0 0 0 0 3 0 0 0 0 1 1 0 3 1 0 1 3 1 94 93 0 0 0 1 1 1 1 1 0 1 1 0 1 1 1 1 1 0 1 95 1 1 1 1 0 0 0 0 0 4. 0 0 0 96 4 0 0 0 0 3 0 0 0 0 0 0 0 0 0 3 3 0 94 95 96 97 0 0 0 0 0 0 1 3 0 0 0 0 0 3 3 0 0 0 0 3 3 0 0 0 0 3 0 0 4 4 0 0 0 0 0 97 90 4 0 0 0 1 2 0 0 0 0 0 0 0 0 3 0 0 0 0 0 0 0 99 98 0 3 0 0 0 0 0 0 0 0 0 0 0 0 0 3 0 0 3 3 3 0 100 99 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 100 1 0 0 0 3 0 0 0 0 3 0 0 3 0 0 0 0 101 102 0 3 3 101 0 0 3 0 0 0 0 0 3 0 0 0 0 3 0 103 102 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 3 3 3 104 103 0 2 0 0 3 0 0 0 0 105 104 0 3 2 4 4 0 0 0 0 0 0 0 0 0 0 0 0 3 0 106 105 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 3 0 0 1 3 107 106 0 0 0 0 0 3 0 3 0 0 0 0 0 0 3 0 108 0 0 0 0 0 107 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 109 108 0 0 0 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 0 1 0 110 109 1 2 0 0 3 0 0 3 0 0 0 0 0 0 0 0 0 0 0 110 0 0 0 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 111 112 111 0 2 4 0 0 0 0 0 0 0 0 0 0 3 0 4 3 0 113 1 4 3 3 0 3 0 0 0 0 0 112 113 0 0 0 0 0 0 0 0 0 2 0 3 3 0 0 0 0 114 3 0 0 0 3 0 0 0 0 0 0 0 0 0 0 3 0 0 115 0 0 0 114 0 2 4 0 0 4 0 0 0 0 0 0 0 0 0 o 116 115 0 2 0 0 0 3 3 3 5 5 0 5 0 4 0 0 0 0 0 0 0 0 0 3 5 0 117 116 0 0 0 0 3 3 0 0 3 0 0 0 0 3 0 118 117 1 3 1 0 0 3 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 119 118 0 3 0 3 0 0 0 0 0 0 3 0 0 3 0 0 0 120 1 6 0 4 0 0 0 3 0 0 0 0 119 120 0 0 0 3 3 0 0 3 0 121 1 1 D 0 0 0 0 0 0 0 0 2 2 0 0 0 0 0 0 0 0 3 0 0 0 0 3 3 0 3 0 0 0 0 0 0 122 0 3 121 0 0 0 0 3 0 0 0 0 123 122 0 4. 0 3 0 0 0 0 3 0 0 0 0 3 0 0 0 3 0 124 123 0 4 1 0 0 0 0 0 5 0 0 0 3 3 0 0 0 0 125 124 0 4 3 3 0 0 0 3 0 0 4 4 0 0 3 3 0 0 0 0 4. 0 0 126 125 1 1 0 0 0 0 0 0 0 0 3 0 0 0 0 0 0 0 0 0 = Emall Overview Dellverability Insights Questions - TEST A B C D E F G H j L M N P R S T 1 1 Recipients Gender Opens Clicks Email 1 Email 2 Emall 3 Email 4 Email 5 Email 6 Ema|l7 Email 8 Emall 9 Email 10 Emall 11 Email 12 Email 13 Email 14 Email 15 Email 16 1 1 0 0 0 0 0 0 3 0 0 0 0 0 0 0 0. 126 127 125 126 0 0 0 0 0 1 0 0 0 0 0 0 3 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 128 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 127 128 0 0 0 0 0 0 0 0 129 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 o 130 129 1 2 0 0 0 0 0 3 0 0 0 0 0 0 0 0 0 3 3 0 0 0 131 130 1 2 1 0 0 0 0 0 3 5 0 0 0 0 0 0 0 0 0 1 1 3 3 0 3 0 0 0 0 0 0 0 0 0 3 0 0 1 U 0 0 U U 0 U 3 3 0 132 133 134 135 0 0 0 0 0 0 0 U 0 0 0 0 0 0 0 1 0 0 0 0 0 131 132 133 134 135 136 137 0 0 0 0 1 2 2 0 0 0 0 3 0 0 0 0 0 0 U 0 0 3 0 0 0 U 0 0 0 2 2 0 0 0 3 3 0 0 0 0 0 0 0 0 0 136 0 0 0 0 0 0 0 0 0 2 2 2 2 2 0 0 0 2 0 2 2 0 0 2 0 2 0 0 137 2 0 1 0 0 0 0 0 0 0 3 0 0 0 0 0 0 0 0 0 138 3 3 0 0 1 0 4 0 0 0 0 0 0 0 0 0 4 139 0 0 0 138 4 0 0 0 0 0 3 3 0 0 0 0 3 0 0 0 3 0 0 140 0 0 0 0 0 0 0 0 0 2 2 2 2 139 140 141 0 0 0 0 1 1 2 2 0 0 0 0 0 0 0 0 0 3 0 0 141 142 0 0 0 0 0 0 3 3 0 0 0 U 0 5 0 3 0 3 0 3 3 0 0 3 0 3 3 3 0 4 0 3 143 142 0 6 2 4 0 0 0 0 3 0 0 0 0 0 0 3 144 143 0 3 2 0 0 4 0 0 0 0 0 6 0 0 0 3 0 144 1 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 0 0 0 0 0 0 0 0 0 0 1 1 0 145 0 0 0 1 1 1 1 1 1 1 145 145 147 148 149 1 1 0 0 1 1 0 0 116 0 0 0 0 0 0 0 0 0 1 1 0 0 0 1 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 3 3 1 0 0 0 0 0 0 1 0 0 0 147 0 4 3 3 0 0 0 0 5 1 0 0 0 0 0 3 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 148 149 150 0 0 0 150 0 0 0 0 0 0 3 3 3 3 0 0 0 0 0 0 151 3 0 0 0 0 0 0 0 0 0 0 3 0 0 3 3 3 3 0 0 0 3 0 0 0 0 0 0 0 0 152 151 0 0 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 153 152 1 2 0 0 0 0 0 0 3 0 3 3 0 0 0 0 3 0 0 0 0 0 154 153 1 2 0 0 0 0 0 0 0 0 0 0 3 0 0 154 0 2 1 0 0 U 0 U 3 0 0 U 0 U 4 0 155 156 U 0 0 0 1 1 3 3 0 0 0 0 0 3 0 0 3 0 0 155 156 157 3 3 0 2 0 0 0 0 4 157 158 0 0 0 0 1 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 3 0 0 0 0 0 0 0 0 0 0 0 0 4 2 0 0 0 0 0 4 0 158 1 3 2 0 4 5 0 0 3 0 0 0 0 0 0 159 160 0 0 0 U 0 0 0 0 159 0 3 0 0 3 0 0 0 0 3 0 3 3 0 0 0 0 0 1 0 161 160 1 0 0 1 1 1 1 1 1 1 1 1 1 1 1 1 1 162 161 0 0 3 1 0 1 0 0 0 0 0 0 0 0 3 0 0 0 3 0 0 163 162 2 2 1 0 0 0 0 0 4 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 164 163 1 0 0 0 0 0 4 4 0 0 0 0 0 0 0 0 0 0 3 3 3 0 0 165 164 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 166 165 0 4 0 0 0 3 0 0 0 0 3 0 0 3 3 167 166 1 3 0 0 3 3 0 0 0 0 0 0 3 0 0 0 0 0 0 11 1. X A B C D E G H J K 1 M M N 0 0 P R S S 1 Recipients Gender Opens Clicks Email 1 Email 2 Email 3 Email 4 Email 5 Email 6 Email 7 Email 8 Email 9 Email 10 Email 11 Email 12 Email 13 Email 14 Email 15 Email 16 168 167 0 5 0 0 0 0 0 4 0 0 0 4 4 0 0 0 3 4 5 5 0 0 4 4 0 0 0 0 0 0 169 0 2 0 0 3 0 0 0 0 0 0 0 0 0 0 0 0 168 169 170 3 3 170 0 4 0 0 0 0 0 0 0 0 0 3 0 0 0 0 0 3 3 0 3 0 171 0 3 0 0 0 3 0 0 0 0 0 0 3 0 3 0 0 0 172 0 3 0 0 0 0 0 0 0 0 0 0 0 0 171 172 0 0 0 173 0 3 3 0 0 0 3 0 0 0 0 0 0 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 174 173 1 2 0 0 3 0 0 0 0 0 3 0 0 3 3 0 0 175 174 0 3 1 0 0 0 0 3 0 0 0 0 0 0 0 0 0 0 0 0 4 0 176 175 0 3 0 0 0 3 0 0 0 0 0 0 0 0 0 0 0 3 0 176 0 3 0 0 0 0 0 3 0 0 0 0 3 3 0 0 0 0 0 0 177 178 0 0 0 3 3 0 3 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 179 3 0 0 3 0 3 0 0 0 3 0 177 178 179 180 0 0 0 3 0 0 0 0 0 0 0 0 0 3 0 0 0 0 3 0 0 0 0 3 3 180 0 4 0 0 0 3 0 0 0 0 0 0 181 0 4 0 0 0 0 0 0 0 3 0 3 0 0 0 3 3 0 0 0 0 182 0 2 2 0 0 0 0 0 0 0 3 0 0 3 0 0 0 0 181 182 183 0 2 2 0 0 0 0 0 0 0 0 0 0 0 3 0 0 0 0 0 3 0 0 0 184 183 0 6 3 0 0 4 0 3 0 0 4 0 3 2 2 0 0 0 0 0 0 0 0 0 3 3 0 185 184 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 186 185 0 1 0 0 0 0 3 0 0 0 0 0 0 0 0 0 0 0 0 0 187 186 0 1 0 0 0 0 0 0 0 0 3 0 0 0 0 0 0 0 0 0 183 187 0 3 0 0 0 0 0 0 0 0 0 0 0 0 3 0 3 0 0 3 3 0 189 188 0 3 0 0 0 0 0 3 3 0 0 0 0 0 0 0 0 0 0 0 0 3 0 0 0 0 0 0 0 0 0 0 0 0 0 190 189 0 1 0 0 0 0 0 0 0 0 3 3 0 0 191 1 2 0 0 0 0 0 3 0 0 0 0 0 0 0 0 0 190 191 0 1 192 1 0 0 1 1 1 1 1 1 3 1 4 1 1 1 1 1 1 1 193 1 0 0 192 1 1 0 0 0 3 3 0 0 0 1 0 0 3 3 0 0 0 1 1 2 0 0 0 0 3 3 1 0 0 194 193 0 6 0 0 3 0 0 3 0 3 0 4 4 0 195 194 1 3 1 0 0 3 0 0 0 3 0 0 0 4 0 0 0 0 0 196 195 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 197 196 0 3 0 3 0 0 3 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 5 198 2 0 0 0 0 0 0 0 2 3 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 4 4 0 3 199 2 0 0 0 197 198 199 200 200 0 3 0 0 0 3 0 0 0 0 0 0 0 0 0 0 3 4 1 2 1 0 0 0 3 0 0 0 3 0 0 0 0 0 0 0 201 202 0 0 0 0 0 201 1 3 0 3 0 0 0 0 0 0 3 3 0 0 0 0 0 203 202 0 4 0 0 0 3 0 0 0 0 0 3 0 0 0 0 0 3 3 0 3 0 0 0 0 0 0 0 204 203 1 3 3 0 0 o 0 4 0 0 0 3 0 0 0 0 0 0 3 3 0 0 0 0 205 0 0 1 0 0 204 1 2 0 0 0 0 0 0 3 0 0 0 0 206 0 0 205 0 3 3 0 0 3 0 0 0 0 0 0 0 0 3 0 207 1 2 1 0 0 0 0 0 5 0 0 0 3 0 0 0 0 206 207 208 0 5 3 0 0 4 0 0 4 0 0 0 0 0 0 0 0 4 3 3 3 0 0 0 0 0 0 0 209 208 0 2 0 0 0 0 0 0 0 0 3 0 0 0 0 0 0 0 L. A B C D E F G H 1 J M N 0 P R S 1 1 Recipients Gender Opens Clicks Email 1 Email 2 Email 3 Email 4 Email 5 Email 6 Email 7 Emails Email 9 Email 10 Email 11 Email 12 Email 13 Email 14 Email 15 Email 16 209 0 2. 0 3 0 0 0 0 0 0 3 0 0 0 208 209 0 1 0 0 1 1 0 1 0 1 0 1 1 210 0 0 0 0 1 1 1 1 1 1 1 1 1 1 1 1 1 1 4 211 0 4 3 4 0 0 4 0 0 0 0 3 0 0 0 0 0 210 211 0 0 0 0 212 0 4 0 0 0 3 3 0 0 0 0 0 0 3 3 0 0 212 1 2 0 0 0 0 0 3 0 0 0 0 0 0 0 0 213 214 215 0 3 3 3 0 0 3 3 213 0 0 0 0 0 0 0 0 0 0 0 0 2 4 3 0 0 0 0 0 0 3 0 0 5 0 0 0 2 2 5 0 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 216 0 2 0 0 0 0 0 0 0 0 0 0 0 4 0 0 0 0 4 4 3 0 217 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 3 216 1 1 0 0 0 0 0 0 0 0 0 0 214 215 216 217 218 219 220 221 3 3 3 0 0 3 0 0 219 0 4 0 4 0 0 0 0 2 0 0 0 5 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 2 1 1 0 0 0 0 0 0 0 0 0 0 0 4 3 0 220 221 222 0 0 0 0 0 0 1 2. 1 0 0 0 0 0 3 4 0 0 0 0 0 0 0 0 0 1 1 0 0 0 0 0 0 4 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 3 0 0 0 0 0 0 0 0 223 224 222 223 2 6 0 3 0 0 0 0 0 0 3 0 0 3 3 0 0 0 0 3 3 3 0 0 3 225 224 1 0 0 0 0 0 0 0 0 0 0 0 3 0 0 0 0 0 0 0 0 0 0 0 0 0 226 225 0 0 0 0 0 0 3 0 0 0 0 0 2. 3 227 226 1 1 0 3 0 0 3 0 0 0 0 0 0 0 0 6 0 0 0 228 227 0 2 0 0 0 0 0 0 0 0 0 0 0 0 0 3 3 0 0 229 228 1 2 0 0 3 0 0 3 3 0 0 0 0 0 0 0 0 0 3 0 0 0 0 0 1 0 0 0 0 0 0 0 230 0 0 0 0 229 0 3 3 0 0 0 0 0 0 0 3 0 0 0 0 0 1 3 3 0 0 1 0 1 231 230 1 0 0 1 1 1 1 1 1 1 1 1 1 1 1 1 1 232 0 0 0 0 0 0 0 0 0 0 231 232 0 2 0 0 0 0 0 0 0 0 0 0 0 4 0 0 0 0 0 0 0 0 233 0 0 0 0 0 0 0 0 0 0 0 4 0 2 0 0 233 1 1 0 0 0 0 0 3 0 0 0 0 0 0 0 0 0 0 234 235 236 234 1 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 3 0 0 0 0 0 0 4. 1 3 3 3 0 0 0 6 0 3 0 0 0 0 0 0 0 237 235 236 237 1 3 0 3 0 0 0 0 0 3 0 0 0 0 0 0 0 0 0 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 238 0 0 0 0 0 0 0 0 0 0 0 0 0 239 0 6 1 0 0 0 3 3 0 3 0 0 3 0 0 3 4 0 238 239 240 0 1 0 0 0 0 3 0 0 0 0 0 0 0 0 0 0 0 0 241 240 0 5 1 0 0 0 0 5 0 3 0 0 3 3 0 3 0 241 3 0 0 0 2 0 0 3 0 0 0 3 3 0 0 0 242 243 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 242 1 1 0 3 3 4 0 0 0 0 0 0 0 0 0 0 0 0 244 243 1 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 245 0 2 244 1 0 0 0 0 0 2 2 2 2 2 2 2 2 2 2 2 2 0 246 245 1 1 0 0 0 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 246 1 0 3 0 0 0 0 0 0 0 0 0 0 247 248 0 0 1 0 o 0 0 0 0 0 0 0 0 247 2 1 0 0 0 3 0 0 0 6 0 0 0 0 0 0 0 248 0 0 0 0 0 0 0 3 1 0 0 0 0 0 0 249 250 0 5 0 0 3 0 3 3 0 0 0 0 0 249 2 2 1 1 0 4 0 0 0 0 0 0 0 3 0 0 0 0 0 0 + = Email Overview - Deliverability Insights- - Questions - - TEST - A B D E F G 1 J K L M N 0 Q R S T U V W 1 Male Female Total 2 Email ID Time of Day Offer S1 S2 S3 Delivered Opened Open Rate Clicks Click Rate Delivered Opened Open Rate Clicks Click Rate Total Recipients Bounced Unopened Opened Open Rate Clicks Click Rate 3 1 4 5 3 1 6 89 5 5.6% 1 1.1% 148 32 21.6% 5 3.4% 250 13 200 37 27.2% 6 4.5% 4 2 4 3 8 4 7 89 15 16.9% 1 1.1% 148 15 10.1% 7 4.7% 250 13 207 30 27.0% 8 5.9% 5 3 2 2 7 2. 9 89 21 23.6% 5 5.6% 148 11 7.4% 3 2.0% 250 13 205 32 31.0% 8 7.6% 6 4 3 6 2 10 8 88 6 6.8% 2. 2.3% 148 30 20.3% 7 4.7% 250 14 200 36 27.1% 9 7.0% 7 5 1 4 4 1 3 87 6 6.9% 0 0.0% 148 32 21.6% 9 6.1% 250 15 197 38 28.5% 9 6.1% 8 6 2 1 10 3 5 86 25 29.1% 4 4.7% 147 17 11.6% 2. 1.4% 250 17 191 42 40.6% 6 6.0% 9 7 3 1 8 7 10 86 25 29.1% 4 4.7% 147 21 14.3% 9 6.1% 250 17 187 46 43.4% 13 10.8% 10 8 1 5 1 8 3 84 3 3.6% 1 1.2% 147 24 16.3% 5 3.4% 250 19 204 27 19.9% 6 4.6% 11 9 3 4 6 9 1 84 5 6.0% 1 1.2% 147 54 36.7% 11 7.5% 250 19 172 59 42.7% 12 8.7% 12 10 2 2. 9 3 8 84 18 21.4% 7 8.3% 147 10 6.8% 3 2.0% 250 19 203 28 28.2% 10 10.4% 13 11 3 5 7 9 5 84 26 31.0% 3 3.6% 147 15 10.2% 2 1.4% 250 19 190 41 41.2% 5 4.9% 14 o 12 3 5 2 10 1 84 5 6.0% 1 1.2% 146 23 15.8% 6 4.1% 250 20 202 28 21.7% 7 5.3% 15 13 2 3 4 w 3 6 84 4 4.8% 0 0.0%) 146 28 19.2% 6 4.1% 250 20 198 32 23.9% 6 4.1% 16 14 3 2. 5 6 10 84 3 3.6% 1 1.2% 146 30 20.5% 8 5.5% 250 20 197 33 24.1% 9 6.7% 17 15 4 2 2 5 7 84 2 2.4% 0 0.0% 146 39 26.7% 8 5.5% 250 20 189 41 29.1% 8 5.5% 18 16 1 6 1 3 84 2 2.4% 1 1.2% 146 27 18.5% 6 4.1% 250 20 201 29 20.9% 7 5.3% 19 20 21 Offer 22 BOGO Coding Key Time of Day 1 Early Morning 2 Late Morning 3 Afternoon 4 Evening 5 23 Participating Group Members: Alex Mongkhonvilay, Ben lannazzo, Kimberly Reusch, Alize Tyler Question 1 Which recipients should be removed from the email list? Hard bounces: 6, 27, 69, 78, 81, 93, 108, 110, 145, 160, 191, 209 230 Multiple soft bounces in a row: 14, 21, 24, 32, 135, 139, 244 No response for two months: 22, 33, 58, 99, 107, 127, 128, 146, 148, 164, 172, 184, 195, 216, 224, 231, 237 Section Women's athletic shoes Women's dress flats Women's high heels Women's sandals Women's slippers 20% off 30% of 50% off New 24 25 26 Question 2 What is the best time of day to send emails? G G H L M N N P R S U U V 84 2 1 146 27 6 250 20 201 29 7 Question 1 Which recipients should be removed from the nail list? Hard bounce Multiple salt bounces in a row No response for two months Why do you think that is? Question 2 What is the best time of day to send emails? Time of Day Open Rate Click Rata Early Maming Late Morning Afternoon Evening A B D E E F 18 16 1 6 1 3 19 20 Codine Key 21 Time of Day oller Section 22 1 Early Morning BOGO Women's athletic shoes 23 Zlate Morning 20% oll Women's dresses 241 3 3 Alternoon 30% oll Women's high heels 25 4 Evening 50% off Women's sandals 26 New Women's slippers 27 Free shippir Women's boots 28 7 Men's athletic shoes 29 8 Men's Sandals 30 9 Men's dress shoes 31 10 Men's boots 32 33 34 Response Key Gender 35 O Delivered, unopened Oferrale 35 1 Hard bounce 1 Male 37 2 2 Soft bounce 38 3 Delivered, opened 39 4 Section 1 clicked 40 5 Section 2 clicked 41 6 Section 3 clicked 42 43 44 45 46 47 48 49 50 51 52 which offers generate the best response? Open Rate Click Rate Why do you think that is? Question 3 Offer BOGO 20% off 30% off Sos. aff New products Free shipping Question 4 Snappas is looking to segment this email list. Should they put men in one segment and women in the other and only send emails featuring the proper gendered shoe ta those lists? Open Rates Explain why gender gender Females Males Click Rate gender gender Females Males A F G H J K L M N 0 R S T T P Q Email 12 Email 13 1 Email 2 Email 3 Email 4 Email 5 Email 6 Email 7 Email 8 Email 9 Email 10 Email 11 Email 14 Email 15 Email 16 2 0 0 0 B C D E Gender Opens Clicks Clicks Email 1 0 3 1 1 1 0 0 2 2 0 3 2 3 4 Recipients 1 2 2 3 0 0 0 0 0 0 3 0 0 0 0 0 0 0 0 0 0 0 0 0 3 0 0 3 0 0 4 0 0 0 4 0 0 4 0 0 0 0 0 0 0 0 0 0 0 0 0 0 5 4 3 0 0 0 0 0 0 0 4 0 0 6 0 3 5 0 6 3 0 0 4 3 . 1 0 0 0 . 1 5 4 4 0 0 0 1 4 0 0 . 1 3 1 . 7 6 0 0 0 1 1 0 . 1 0 1 1 1 1 1 1 1 1 3 8 7 4 0 0 0 0 0 0 0 0 3 0 0 3 3 9 8 1 0 0 0 0 0 U 0 0 0 0 0 0 0 0 0 0 0 0 1 1 . 1 .. 0 0 0 0 3 0 0 U 0 10 9 2 0 0 0 0 0 0 3 0 0 0 0 0 10 4 0 3 0 0 0 0 0 3 U 0 0 3 11 40 12 13 0 . 3 11 0 0 1 0 0 0 3 0 0 0 0 0 0 0 0 0 0 0 0 . 1 . 1 0 0 0 0 0 0 0 3 0 0 0 0 0 3 3 3 0 0 0 0 0 0 4 14 3 1 0 3 0 0 0 0 0 0 0 3 0 0 0 0 0 15 1 1 1 0 0 0 0 0 0 2 2 2 2 z Z 12 13 14 15 16 . 17 18 2 0 2 0 2 0 0 0 2 0 0 0 0 0 0 3 0 0 0 0 0 0 16 - 17 0 3 0 0 1 0 0 0 0 0 0 3 0 3 0 0 0 0 3 0 . 1 0 0 3 0 3 1 0 0 3 0 0 0 0 0 0 0 0 18 10 19 3 0 0 0 0 0 1 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 3 0 0 20 19 1 2 0 0 0 0 0 0 0 0 3 0 0 3 0 0 0 0 0 21 20 0 4 0 0 0 3 3 0 3 0 0 0 0 3 0 0 0 0 21 1 1 0 2 2. 2 2 2 2 2 2 22 23 0 0 3 0 0 1 0 2 0 0 0 0 0 0 0 0 0 0 0 0 0 2 2 0 0 2 22 23 0 0 0 0 0 2 2 0 2 U 0 2 0 0 0 0 0 0 24 1 0 0 0 3 0 0 0 3 3 2 2 0 0 24 1 0 0 0 0 2 2 2 2 2 0 2 2 0 2 2 o 2 2 2 0 0 25 1 0 0 0 0 0 0 0 3 0 0 0 3 4 3 0 0 3 0 0 0 0 3 25 26 27 28 29 30 0 1 1 0 0 0 0 3 0 1 3 0 0 0 0 0 0 1 0 3 1 1 26 0 27 0 28 1 1 29 1 30 1 1 0 1 0 0 0 0 0 0 0 1 1 1 3 3 1 1 3 3 0 1 1 0 0 0 1 0 0 0 0 1 3 3 0 1 1 0 1 0 1 0 0 4 0 0 0 0 0 0 0 0 0 2 0 0 0 0 0 0 3 0 0 0 0 0 0 0 31 1 1 0 0 5 0 0 0 0 0 0 0 0 0 0 32 31 1 1 1 1 0 0 0 0 0 0 0 5 0 0 0 0 0 0 0 33 1 0 0 0 0 0 0 0 2 2 2 2. 2 2 32 33 31 2 0 0 0 0 0 U 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 0 1 0 0 0 0 0 0 0 0 3 3 1 0 34 35 36 37 38 3 0 1 1 0 0 0 0 0 3 3 2 0 0 0 0 0 0 0 0 0 3 3 o 0 "! 4 0 0 0 0 0 0 0 3 3 3 0 35 36 0 1 0 0 3 3 3 0 0 0 0 0 0 0 0 0 o 0 3 3 0 0 0 0 0 3 0 0 0 0 0 1 3 2 0 4 0 0 0 0 0 0 3 0 0 0 6 37 38 39 1 1 0 0 0 0 0 0 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 40 39 0 4 0 3 0 0 3 0 0 0 3 3 0 0 0 3 0 0 0 3 3 41 3 0 0 3 0 0 0 0 0 3 0 0 0 0 42 0 0 0 0 0 0 0 0 0 0 0 0 40 1 41 1 1 42 0 43 0 0 0 0 0 4 0 0 0 4 0 0 0 0 0 0 0 0 0 0 0 43 5 0 0 0 0 0 0 0 3 0 0 0 0 0 0 4 0 0 4 0 0 0 0 0 0 4 4 0 0 44 1 0 0 0 0 0 0 0 3 0 + Email Cryin Deliverability Insights Questions TEST - U1 A B C D C G H 1 J K L M M N P 0 R T 1 Recipients Gender Opens Clicks Email 1 Email 2 Email 3 Email 4 Email 5 Email 6 Email 7 Email 8 Email 9 Email 10 Email 11 Email 12 Email 13 Email 14 Email 15 Email 16 44 1 0 0 0 0 0 0 0 0 0 0 0 0 0 43 44 45 0 0 0 0 0 0 0 0 1 3 0 0 0 0 0 0 0 0 0 0 0 45 46 3 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 2 1 0 0 0 3 0 0 4 0 0 47 0 0 0 46 0 4 0 0 0 0 0 0 0 3 0 0 0 0 3 0 3 0 3 0 48 47 1 3 0 0 0 0 0 3 0 0 3 0 0 0 0 3 3 0 0 49 0 4 3 3 0 0 0 0 3 0 4 0 0 0 0 0 4 48 49 50 50 0 0 0 0 0 0 0 4 1 0 0 0 0 0 3 3 4 0 0 0 3 0 0 0 0 0 0 0 0 0 0 0 0 3 3 3 0 0 3 0 3 3 3 51 0 2 0 0 0 0 0 0 0 0 51 0 2 0 0 0 0 0 0 0 0 0 0 0 0 3 0 0 52 53 54 52 1 3 1 0 0 0 0 0 0 0 0 0 0 0 0 0 3 0 3 0 4 4 0 0 0 0 53 1 0 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 4 0 0 55 0 3 0 0 5 0 0 0 0 54 55 2 0 0 0 0 0 6 3 3 3 0 56 0 0 0 0 3 3 0 1 0 0 2 2 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 3 3 0 0 57 56 0 0 0 0 0 0 0 0 0 0 3 0 0 5 0 0 0 0 0 0 0 0 3 0 0 0 0 0 58 57 1 1 0 0 0 0 0 0 0 0 0 0 59 58 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 60 59 0 3 1 0 0 0 0 0 0 3 0 0 0 0 0 0 0 4 0 0 0 3 0 61 60 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 62 61 0 3 1 0 3 0 0 4 4 0 0 0 63 0 0 0 62 1 0 0 0 0 4 0 0 0 0 3 0 0 0 3 0 0 0 0 3 0 0 3 4 3 3 0 0 0 0 3 0 3 0 0 0 0 0 0 64 G3 1 1 0 0 0 0 0 0 0 65 64 1 3 5 3 3 2 0 0 0 0 3 3 5 0 0 0 0 0 0 3 4 0 0 0 0 66 65 0 1 0 0 0 0 3 0 0 0 0 0 0 0 0 0 3 67 66 0 3 1 0 0 0 4 0 0 0 0 0 0 3 0 3 0 0 0 0 0 68 5 0 0 0 67 0 3 0 0 0 3 0 0 0 3 0 3 0 0 0 69 68 0 1 1 1 0 0 0 4 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 70 69 1 0 0 0 1 1 1 1 1 1 1 1 1 1 1 1 1 0 0 71 1 1 0 0 3 0 0 0 0 0 0 1 1 0 0 0 0 0 0 0 0 0 0 72 0 0 0 0 1 1 0 0 0 0 0 0 0 0 0 70 71 72 73 74 1 1 0 0 0 0 0 0 0 0 0 0 0 73 2 0 0 0 0 0 3 0 0 0 3 0 0 0 0 74 0 0 0 0 0 0 0 0 0 0 0 3 3 0 0 0 0 1 4 75 1 0 0 3 0 0 0 0 0 0 3 3 0 Gmail 0 0 3 0 0 0 76 75 0 0 0 0 0 0 3 3 3 3 0 0 0 3 3 3 0 0 0 77 2 0 0 0 3 0 0 0 0 0 0 0 0 76 77 0 0 1 1 0 78 0 0 0 0 0 0 0 1 0 0 0 0 3 3 3 3 1 0 2 0 0 0 0 0 3 1 0 0 1 0 0 0 1 1 0 0 0 1 0 0 0 1 79 78 0 1 1 1 1 1 1 1 1 1 80 1 0 0 79 0 5 3 3 3 0 0 4 6 4 3 0 0 0 0 0 0 0 81 80 0 2 0 0 3 0 0 0 0 0 0 3 3 0 0 0 0 0 0 0 0 0 1 82 81 1 0 0 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 83 82 1 1 0 0 0 0 0 0 0 0 0 84 0 0 0 0 0 0 0 3 0 0 0 0 3 83 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 0 0 1 2 0 0 0 3 0 0 0 0 0 0 0 0 0 85 84 1 0 0 4 0 0 0 0 0 + = Email Overview - Deliverability Insights - Questions - TEST - f A B D E F F G G H H 1 K L M N 0 P 0 R S T 1 Recipients Gender Email 2 Email 3 Email 4 Email 5 Email 6 Email 7 Email 8 Email 9 Email 10 Email 11 Email 12 Email 13 Email 14 Email 15 Email 16 Opens Clicks Email 1 2 2 1 85 84 0 0 0 0 0 0 4 0 3 0 0 0 0 0 0 0 0 86 85 0 3 0 3 0 0 3 0 0 0 3 0 0 0 0 0 0 0 0 0 0 0 0 87 86 1 2 2 0 0 5 0 0 0 0 0 0 4 0 0 0 0 0 88 87 0 5 4 4 0 4 0 0 0 0 3 4 0 0 0 0 89 1 6 2 1 0 0 0 0 5 0 0 0 88 89 0 4 1 1 0 0 3 4 4 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 90 1 0 0 0 0 0 91 90 0 6 0 0 0 3 3 3 0 3 3 0 0 0 0 0 0 0 0 3 92 91 0 3 0 0 0 0 0 0 3 0 3 0 0 U 0 0 93 92 0 3 3. 0 0 0 0 0 0 0 0 0 0 3 0 0 0 0 1 1 0 3 1 0 1 3 1 94 93 0 0 0 1 1 1 1 1 0 1 1 0 1 1 1 1 1 0 1 95 1 1 1 1 0 0 0 0 0 4. 0 0 0 96 4 0 0 0 0 3 0 0 0 0 0 0 0 0 0 3 3 0 94 95 96 97 0 0 0 0 0 0 1 3 0 0 0 0 0 3 3 0 0 0 0 3 3 0 0 0 0 3 0 0 4 4 0 0 0 0 0 97 90 4 0 0 0 1 2 0 0 0 0 0 0 0 0 3 0 0 0 0 0 0 0 99 98 0 3 0 0 0 0 0 0 0 0 0 0 0 0 0 3 0 0 3 3 3 0 100 99 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 100 1 0 0 0 3 0 0 0 0 3 0 0 3 0 0 0 0 101 102 0 3 3 101 0 0 3 0 0 0 0 0 3 0 0 0 0 3 0 103 102 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 3 3 3 104 103 0 2 0 0 3 0 0 0 0 105 104 0 3 2 4 4 0 0 0 0 0 0 0 0 0 0 0 0 3 0 106 105 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 3 0 0 1 3 107 106 0 0 0 0 0 3 0 3 0 0 0 0 0 0 3 0 108 0 0 0 0 0 107 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 109 108 0 0 0 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 0 1 0 110 109 1 2 0 0 3 0 0 3 0 0 0 0 0 0 0 0 0 0 0 110 0 0 0 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 111 112 111 0 2 4 0 0 0 0 0 0 0 0 0 0 3 0 4 3 0 113 1 4 3 3 0 3 0 0 0 0 0 112 113 0 0 0 0 0 0 0 0 0 2 0 3 3 0 0 0 0 114 3 0 0 0 3 0 0 0 0 0 0 0 0 0 0 3 0 0 115 0 0 0 114 0 2 4 0 0 4 0 0 0 0 0 0 0 0 0 o 116 115 0 2 0 0 0 3 3 3 5 5 0 5 0 4 0 0 0 0 0 0 0 0 0 3 5 0 117 116 0 0 0 0 3 3 0 0 3 0 0 0 0 3 0 118 117 1 3 1 0 0 3 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 119 118 0 3 0 3 0 0 0 0 0 0 3 0 0 3 0 0 0 120 1 6 0 4 0 0 0 3 0 0 0 0 119 120 0 0 0 3 3 0 0 3 0 121 1 1 D 0 0 0 0 0 0 0 0 2 2 0 0 0 0 0 0 0 0 3 0 0 0 0 3 3 0 3 0 0 0 0 0 0 122 0 3 121 0 0 0 0 3 0 0 0 0 123 122 0 4. 0 3 0 0 0 0 3 0 0 0 0 3 0 0 0 3 0 124 123 0 4 1 0 0 0 0 0 5 0 0 0 3 3 0 0 0 0 125 124 0 4 3 3 0 0 0 3 0 0 4 4 0 0 3 3 0 0 0 0 4. 0 0 126 125 1 1 0 0 0 0 0 0 0 0 3 0 0 0 0 0 0 0 0 0 = Emall Overview Dellverability Insights Questions - TEST A B C D E F G H j L M N P R S T 1 1 Recipients Gender Opens Clicks Email 1 Email 2 Emall 3 Email 4 Email 5 Email 6 Ema|l7 Email 8 Emall 9 Email 10 Emall 11 Email 12 Email 13 Email 14 Email 15 Email 16 1 1 0 0 0 0 0 0 3 0 0 0 0 0 0 0 0. 126 127 125 126 0 0 0 0 0 1 0 0 0 0 0 0 3 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 128 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 127 128 0 0 0 0 0 0 0 0 129 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 o 130 129 1 2 0 0 0 0 0 3 0 0 0 0 0 0 0 0 0 3 3 0 0 0 131 130 1 2 1 0 0 0 0 0 3 5 0 0 0 0 0 0 0 0 0 1 1 3 3 0 3 0 0 0 0 0 0 0 0 0 3 0 0 1 U 0 0 U U 0 U 3 3 0 132 133 134 135 0 0 0 0 0 0 0 U 0 0 0 0 0 0 0 1 0 0 0 0 0 131 132 133 134 135 136 137 0 0 0 0 1 2 2 0 0 0 0 3 0 0 0 0 0 0 U 0 0 3 0 0 0 U 0 0 0 2 2 0 0 0 3 3 0 0 0 0 0 0 0 0 0 136 0 0 0 0 0 0 0 0 0 2 2 2 2 2 0 0 0 2 0 2 2 0 0 2 0 2 0 0 137 2 0 1 0 0 0 0 0 0 0 3 0 0 0 0 0 0 0 0 0 138 3 3 0 0 1 0 4 0 0 0 0 0 0 0 0 0 4 139 0 0 0 138 4 0 0 0 0 0 3 3 0 0 0 0 3 0 0 0 3 0 0 140 0 0 0 0 0 0 0 0 0 2 2 2 2 139 140 141 0 0 0 0 1 1 2 2 0 0 0 0 0 0 0 0 0 3 0 0 141 142 0 0 0 0 0 0 3 3 0 0 0 U 0 5 0 3 0 3 0 3 3 0 0 3 0 3 3 3 0 4 0 3 143 142 0 6 2 4 0 0 0 0 3 0 0 0 0 0 0 3 144 143 0 3 2 0 0 4 0 0 0 0 0 6 0 0 0 3 0 144 1 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 0 0 0 0 0 0 0 0 0 0 1 1 0 145 0 0 0 1 1 1 1 1 1 1 145 145 147 148 149 1 1 0 0 1 1 0 0 116 0 0 0 0 0 0 0 0 0 1 1 0 0 0 1 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 3 3 1 0 0 0 0 0 0 1 0 0 0 147 0 4 3 3 0 0 0 0 5 1 0 0 0 0 0 3 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 148 149 150 0 0 0 150 0 0 0 0 0 0 3 3 3 3 0 0 0 0 0 0 151 3 0 0 0 0 0 0 0 0 0 0 3 0 0 3 3 3 3 0 0 0 3 0 0 0 0 0 0 0 0 152 151 0 0 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 153 152 1 2 0 0 0 0 0 0 3 0 3 3 0 0 0 0 3 0 0 0 0 0 154 153 1 2 0 0 0 0 0 0 0 0 0 0 3 0 0 154 0 2 1 0 0 U 0 U 3 0 0 U 0 U 4 0 155 156 U 0 0 0 1 1 3 3 0 0 0 0 0 3 0 0 3 0 0 155 156 157 3 3 0 2 0 0 0 0 4 157 158 0 0 0 0 1 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 3 0 0 0 0 0 0 0 0 0 0 0 0 4 2 0 0 0 0 0 4 0 158 1 3 2 0 4 5 0 0 3 0 0 0 0 0 0 159 160 0 0 0 U 0 0 0 0 159 0 3 0 0 3 0 0 0 0 3 0 3 3 0 0 0 0 0 1 0 161 160 1 0 0 1 1 1 1 1 1 1 1 1 1 1 1 1 1 162 161 0 0 3 1 0 1 0 0 0 0 0 0 0 0 3 0 0 0 3 0 0 163 162 2 2 1 0 0 0 0 0 4 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 164 163 1 0 0 0 0 0 4 4 0 0 0 0 0 0 0 0 0 0 3 3 3 0 0 165 164 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 166 165 0 4 0 0 0 3 0 0 0 0 3 0 0 3 3 167 166 1 3 0 0 3 3 0 0 0 0 0 0 3 0 0 0 0 0 0 11 1. X A B C D E G H J K 1 M M N 0 0 P R S S 1 Recipients Gender Opens Clicks Email 1 Email 2 Email 3 Email 4 Email 5 Email 6 Email 7 Email 8 Email 9 Email 10 Email 11 Email 12 Email 13 Email 14 Email 15 Email 16 168 167 0 5 0 0 0 0 0 4 0 0 0 4 4 0 0 0 3 4 5 5 0 0 4 4 0 0 0 0 0 0 169 0 2 0 0 3 0 0 0 0 0 0 0 0 0 0 0 0 168 169 170 3 3 170 0 4 0 0 0 0 0 0 0 0 0 3 0 0 0 0 0 3 3 0 3 0 171 0 3 0 0 0 3 0 0 0 0 0 0 3 0 3 0 0 0 172 0 3 0 0 0 0 0 0 0 0 0 0 0 0 171 172 0 0 0 173 0 3 3 0 0 0 3 0 0 0 0 0 0 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 174 173 1 2 0 0 3 0 0 0 0 0 3 0 0 3 3 0 0 175 174 0 3 1 0 0 0 0 3 0 0 0 0 0 0 0 0 0 0 0 0 4 0 176 175 0 3 0 0 0 3 0 0 0 0 0 0 0 0 0 0 0 3 0 176 0 3 0 0 0 0 0 3 0 0 0 0 3 3 0 0 0 0 0 0 177 178 0 0 0 3 3 0 3 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 179 3 0 0 3 0 3 0 0 0 3 0 177 178 179 180 0 0 0 3 0 0 0 0 0 0 0 0 0 3 0 0 0 0 3 0 0 0 0 3 3 180 0 4 0 0 0 3 0 0 0 0 0 0 181 0 4 0 0 0 0 0 0 0 3 0 3 0 0 0 3 3 0 0 0 0 182 0 2 2 0 0 0 0 0 0 0 3 0 0 3 0 0 0 0 181 182 183 0 2 2 0 0 0 0 0 0 0 0 0 0 0 3 0 0 0 0 0 3 0 0 0 184 183 0 6 3 0 0 4 0 3 0 0 4 0 3 2 2 0 0 0 0 0 0 0 0 0 3 3 0 185 184 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 186 185 0 1 0 0 0 0 3 0 0 0 0 0 0 0 0 0 0 0 0 0 187 186 0 1 0 0 0 0 0 0 0 0 3 0 0 0 0 0 0 0 0 0 183 187 0 3 0 0 0 0 0 0 0 0 0 0 0 0 3 0 3 0 0 3 3 0 189 188 0 3 0 0 0 0 0 3 3 0 0 0 0 0 0 0 0 0 0 0 0 3 0 0 0 0 0 0 0 0 0 0 0 0 0 190 189 0 1 0 0 0 0 0 0 0 0 3 3 0 0 191 1 2 0 0 0 0 0 3 0 0 0 0 0 0 0 0 0 190 191 0 1 192 1 0 0 1 1 1 1 1 1 3 1 4 1 1 1 1 1 1 1 193 1 0 0 192 1 1 0 0 0 3 3 0 0 0 1 0 0 3 3 0 0 0 1 1 2 0 0 0 0 3 3 1 0 0 194 193 0 6 0 0 3 0 0 3 0 3 0 4 4 0 195 194 1 3 1 0 0 3 0 0 0 3 0 0 0 4 0 0 0 0 0 196 195 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 197 196 0 3 0 3 0 0 3 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 5 198 2 0 0 0 0 0 0 0 2 3 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 4 4 0 3 199 2 0 0 0 197 198 199 200 200 0 3 0 0 0 3 0 0 0 0 0 0 0 0 0 0 3 4 1 2 1 0 0 0 3 0 0 0 3 0 0 0 0 0 0 0 201 202 0 0 0 0 0 201 1 3 0 3 0 0 0 0 0 0 3 3 0 0 0 0 0 203 202 0 4 0 0 0 3 0 0 0 0 0 3 0 0 0 0 0 3 3 0 3 0 0 0 0 0 0 0 204 203 1 3 3 0 0 o 0 4 0 0 0 3 0 0 0 0 0 0 3 3 0 0 0 0 205 0 0 1 0 0 204 1 2 0 0 0 0 0 0 3 0 0 0 0 206 0 0 205 0 3 3 0 0 3 0 0 0 0 0 0 0 0 3 0 207 1 2 1 0 0 0 0 0 5 0 0 0 3 0 0 0 0 206 207 208 0 5 3 0 0 4 0 0 4 0 0 0 0 0 0 0 0 4 3 3 3 0 0 0 0 0 0 0 209 208 0 2 0 0 0 0 0 0 0 0 3 0 0 0 0 0 0 0 L. A B C D E F G H 1 J M N 0 P R S 1 1 Recipients Gender Opens Clicks Email 1 Email 2 Email 3 Email 4 Email 5 Email 6 Email 7 Emails Email 9 Email 10 Email 11 Email 12 Email 13 Email 14 Email 15 Email 16 209 0 2. 0 3 0 0 0 0 0 0 3 0 0 0 208 209 0 1 0 0 1 1 0 1 0 1 0 1 1 210 0 0 0 0 1 1 1 1 1 1 1 1 1 1 1 1 1 1 4 211 0 4 3 4 0 0 4 0 0 0 0 3 0 0 0 0 0 210 211 0 0 0 0 212 0 4 0 0 0 3 3 0 0 0 0 0 0 3 3 0 0 212 1 2 0 0 0 0 0 3 0 0 0 0 0 0 0 0 213 214 215 0 3 3 3 0 0 3 3 213 0 0 0 0 0 0 0 0 0 0 0 0 2 4 3 0 0 0 0 0 0 3 0 0 5 0 0 0 2 2 5 0 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 216 0 2 0 0 0 0 0 0 0 0 0 0 0 4 0 0 0 0 4 4 3 0 217 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 3 216 1 1 0 0 0 0 0 0 0 0 0 0 214 215 216 217 218 219 220 221 3 3 3 0 0 3 0 0 219 0 4 0 4 0 0 0 0 2 0 0 0 5 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 2 1 1 0 0 0 0 0 0 0 0 0 0 0 4 3 0 220 221 222 0 0 0 0 0 0 1 2. 1 0 0 0 0 0 3 4 0 0 0 0 0 0 0 0 0 1 1 0 0 0 0 0 0 4 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 3 0 0 0 0 0 0 0 0 223 224 222 223 2 6 0 3 0 0 0 0 0 0 3 0 0 3 3 0 0 0 0 3 3 3 0 0 3 225 224 1 0 0 0 0 0 0 0 0 0 0 0 3 0 0 0 0 0 0 0 0 0 0 0 0 0 226 225 0 0 0 0 0 0 3 0 0 0 0 0 2. 3 227 226 1 1 0 3 0 0 3 0 0 0 0 0 0 0 0 6 0 0 0 228 227 0 2 0 0 0 0 0 0 0 0 0 0 0 0 0 3 3 0 0 229 228 1 2 0 0 3 0 0 3 3 0 0 0 0 0 0 0 0 0 3 0 0 0 0 0 1 0 0 0 0 0 0 0 230 0 0 0 0 229 0 3 3 0 0 0 0 0 0 0 3 0 0 0 0 0 1 3 3 0 0 1 0 1 231 230 1 0 0 1 1 1 1 1 1 1 1 1 1 1 1 1 1 232 0 0 0 0 0 0 0 0 0 0 231 232 0 2 0 0 0 0 0 0 0 0 0 0 0 4 0 0 0 0 0 0 0 0 233 0 0 0 0 0 0 0 0 0 0 0 4 0 2 0 0 233 1 1 0 0 0 0 0 3 0 0 0 0 0 0 0 0 0 0 234 235 236 234 1 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 3 0 0 0 0 0 0 4. 1 3 3 3 0 0 0 6 0 3 0 0 0 0 0 0 0 237 235 236 237 1 3 0 3 0 0 0 0 0 3 0 0 0 0 0 0 0 0 0 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 238 0 0 0 0 0 0 0 0 0 0 0 0 0 239 0 6 1 0 0 0 3 3 0 3 0 0 3 0 0 3 4 0 238 239 240 0 1 0 0 0 0 3 0 0 0 0 0 0 0 0 0 0 0 0 241 240 0 5 1 0 0 0 0 5 0 3 0 0 3 3 0 3 0 241 3 0 0 0 2 0 0 3 0 0 0 3 3 0 0 0 242 243 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 242 1 1 0 3 3 4 0 0 0 0 0 0 0 0 0 0 0 0 244 243 1 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 245 0 2 244 1 0 0 0 0 0 2 2 2 2 2 2 2 2 2 2 2 2 0 246 245 1 1 0 0 0 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 246 1 0 3 0 0 0 0 0 0 0 0 0 0 247 248 0 0 1 0 o 0 0 0 0 0 0 0 0 247 2 1 0 0 0 3 0 0 0 6 0 0 0 0 0 0 0 248 0 0 0 0 0 0 0 3 1 0 0 0 0 0 0 249 250 0 5 0 0 3 0 3 3 0 0 0 0 0 249 2 2 1 1 0 4 0 0 0 0 0 0 0 3 0 0 0 0 0 0 + = Email Overview - Deliverability Insights- - Questions - - TEST